This problem contains three parts. In Part A, you areasked to determine the parameters of the profit function - thecontribution margin and the fixed costs. You should not move on toParts B and C until you get Part A correct, or until you use up allof your tries. The correct profit function parameters will be givento you after you have completed Part A - you should use theseparameters in Parts B and C.
The problem is worth 20 points. Parts A and B are worth eightpoints each; Part C is worth four points. To get the eight pointsfor Part A, you must answer both questions correctly; to get theeight points for Part B, you must all four questions correctly. Youget six tries on Part A, eight on Part B, and four on PartC.
______________________________________________________
CableVision has been approached by the City of Mirada to run itscable operations in 2016. After negotiating with key parties,CableVision has made the following agreements:
It will offer Mirada residents a basic set of 25 cabletelevision stations at a rate of $33.99 per month.
CableVision will pay the city $1,300,000 per year plus $3.00 percable subscriber per month to maintain the physical facilities.
CableVision will actually pay another company a monthly fixedfee of $60,000 plus $7.50 per cable subscriber per month tobroadcast the 25 channels.
CableVision estimates that operating costs for billing, programnews mailings, etc. will be $110,000 per month plus 9% of monthlyrevenue.
CableVision has several questions about its monthly revenues,costs, and profits in 2016.
REQUIRED [ROUND YOUR ANSWER TO PART A, QUESTION 1 TO THE NEARESTCENT; ROUND ALL OTHER ANSWERS TO THE NEAREST UNIT OR NEARESTDOLLAR.]
Part A (6 tries; 8 points)
1. What is the estimated monthly contribution margin per cablesubscriber for CableVision in 2016?
2. What are the estimated total monthly fixed costs for CableVisionin 2016?
Tries 0/6
Part B (8 tries; 8 points)
1. What is CableVision's estimated monthly operating income in 2016if 17,000 residents subscribe?
2. How many monthly subscribers would be required for CableVisionto break even in 2016?
3. How many monthly subscribers would be required for CableVisionto earn $21,000 per month in 2016?
4. Assuming a tax rate of 35%, what must revenue be in order forCableVision to earn $21,000 per month in2016?
Tries 0/8
Part C (4 tries; 4 points)
Some of CableVision's managers are uncertain about their estimateof monthly fixed operating costs. Assuming that 22,000 residentssubscribe, how large can monthly fixed operating costs be forCableVision to still earn $21,000 per month in 2016 (ignoretaxes)?
This problem contains three parts. In Part A, you areasked to determine the parameters of the profit function - thecontribution margin and the fixed costs. You should not move on toParts B and C until you get Part A correct, or until you use up allof your tries. The correct profit function parameters will be givento you after you have completed Part A - you should use theseparameters in Parts B and C.
The problem is worth 20 points. Parts A and B are worth eightpoints each; Part C is worth four points. To get the eight pointsfor Part A, you must answer both questions correctly; to get theeight points for Part B, you must all four questions correctly. Youget six tries on Part A, eight on Part B, and four on PartC.
______________________________________________________
CableVision has been approached by the City of Mirada to run itscable operations in 2016. After negotiating with key parties,CableVision has made the following agreements:
It will offer Mirada residents a basic set of 25 cabletelevision stations at a rate of $33.99 per month.
CableVision will pay the city $1,300,000 per year plus $3.00 percable subscriber per month to maintain the physical facilities.
CableVision will actually pay another company a monthly fixedfee of $60,000 plus $7.50 per cable subscriber per month tobroadcast the 25 channels.
CableVision estimates that operating costs for billing, programnews mailings, etc. will be $110,000 per month plus 9% of monthlyrevenue.
CableVision has several questions about its monthly revenues,costs, and profits in 2016.
REQUIRED [ROUND YOUR ANSWER TO PART A, QUESTION 1 TO THE NEARESTCENT; ROUND ALL OTHER ANSWERS TO THE NEAREST UNIT OR NEARESTDOLLAR.]
Part A (6 tries; 8 points)
1. What is the estimated monthly contribution margin per cablesubscriber for CableVision in 2016?
2. What are the estimated total monthly fixed costs for CableVisionin 2016?
| Tries 0/6 |
Part B (8 tries; 8 points)
1. What is CableVision's estimated monthly operating income in 2016if 17,000 residents subscribe?
2. How many monthly subscribers would be required for CableVisionto break even in 2016?
3. How many monthly subscribers would be required for CableVisionto earn $21,000 per month in 2016?
4. Assuming a tax rate of 35%, what must revenue be in order forCableVision to earn $21,000 per month in2016?
| Tries 0/8 |
Part C (4 tries; 4 points)
Some of CableVision's managers are uncertain about their estimateof monthly fixed operating costs. Assuming that 22,000 residentssubscribe, how large can monthly fixed operating costs be forCableVision to still earn $21,000 per month in 2016 (ignoretaxes)?
Related questions
i only need help with questions : 12, 14, 16,17c, 17d
1. (5 points) Make a list of materials needed tomanufacture one finished good. Include the following criteria:material (including block size), color, number required, cost perblock, and total cost per type of block. Determine the totalmaterial cost to manufacture one finished good. Include packagingfor the finished product.
2. (4 points) Determine how many direct labor employeesare necessary to meet demand. You do not intend to pay overtime.Laborers work eight hours a day Monday through Friday, which doesnot include time for lunch since it is not paid. They receive twoweeks of paid vacation, but six paid holidays. If your calculationresults in a partial person, remember that you will have to roundup to a whole number. You do not intend to hire any part-timelabor.
3. (3 points) Determine the annual cost fordirect labor (including benefits). Do notround.
4. (2 points) What is the direct labor costper finished product? Do not round.
5. Cost identification.
The following accounts are to be used in 5a-5e:
Account Name | Annual Amount |
Office Supplies | $500 |
Factory Utilities | $2400 |
Sales Commissions | $40000 |
Factory Equipment Depreciation | $500 |
Factory Rent | $5000 |
Advertising | $12000 |
Factory Managerâs Salary | $35000* |
Indirect Labor | $35000 |
Office Utilities | $600 |
Factory Insurance | $3600 |
Office Maintenance (Annual Contract) | $200 |
Sales Salaries | $60000* |
Office Equipment Depreciation | $1200 |
Indirect Materials | $5000 |
Freight-Out | $200000 |
Factory Equipment Repairs (based on expected quarterlyservice calls) | $800 |
*Includes medical benefits.
- (4 points) From the above list, select four variablemanufacturing overhead accounts.
- (4 points) From the above list, select four variableselling expense or administrative expense accounts.
- (4 points) From the above list, select four fixed sellingexpense or administrative expense accounts.
- (4 points) From the above list, select four fixedmanufacturing overhead accounts.
- (4 points) Fill out the attached spreadsheet with theinformation given in 5a-5d. That means you will have to keepreading these discussion areas.
Make sure your answers for the following questions reflectall of the costs on the 5e spreadsheet.
6. (3 points) What is the total manufacturingoverhead?
7. (5 points) Create a Cost of Goods ManufacturedSchedule. Do not round.
8. (4 points) What is the predetermined overhead ratebased on direct labor cost? Round to two decimal places and makesure your answer is in the correct format.
9. (4 points) What is the total manufacturing cost perunit? Do not round.
10. (5 points) Calculate the projected net income/(loss)for the first year. This should be in the form of an simple incomestatement including captions for revenue, cost of goods sold (donot round.), gross profit, operating expenses, and netincome/(loss). All operating expenses must be listed individually.Do not round.
11. Cost Identification
a. (2 points) What is the total variable cost?
b. (1 point) What is the total fixed cost?
- (5 points) How many finished units will you have to sellannually to break even? Do not round variable costs or contributionmargin. You will have to round the number of units to break even,since you cannot sell a partial unit. Remember to always round upfor break even, no matter what the decimal.
- ( 7 points) Using the break even or contribution marginequations, compute how many units need to be sold to earn a netincome of $60000. Create a C-V-P income statement to prove yourcalculations. Show all of your work to get the C-V-P incomestatement. Do not round variable costs or contribution margin. Youwill have to round the number of units to break even, since youcannot sell a partial unit. Remember to always round up for breakeven, no matter what the decimal.
- (4 points) Create a flexible manufacturing overheadbudget at a level of 110,000 finished units.
- (5 points) Prepare a flexible budget report given thatactual production was 110,000 finished units.
Actual overhead for the year included:
Factory Repairs $950
Factory Utilities $2430
Indirect Labor $36750
Indirect Materials $5700
Freight-Out $215000
Office Supplies $510
Commissions $43000
Office Utilities $750
Advertising $12000
Office Maintenance $300
Sales Salaries $60000
Office Depreciation $1200
Factory Depreciation $500
Factory Rent $5100
Manager's Salary $ 35000
Factory Insurance $3800
- (3 points) Sales per quarter are expected to be 10,000units, 30,000 units, 40,000 units, and 20,000 units, respectively.Prepare a correctly formatted sales budget.
- There is a shortage of large rectangular blocks! (None atall.)
a. (3 points) What is the new total product cost per unitif two small rectangular blocks are substituted for every largerectangular block? Do not round.
b. (5 points) Prepare an income statement to show the newnet income/(loss) with sales totaling 100,000 units. Use the newtotal product cost in Q17a. Do not round.
c. (5 points) How many finished units need to be soldannually to break even? Do not round variable costs or contributionmargin. You will have to round the number of units to break even,since you cannot sell a partial unit. Remember to always round upfor break even, no matter what the decimal. Use the new totalproduct cost in Q17a.
d. (5 points) Create a C-V-P income statement to proveyour break-even. Do not round variable costs or contributionmargin. You will have to round the number of units to break even,since you cannot sell a partial unit. Remember to always round upfor break even, no matter what the decimal. Use the new totalproduct cost in Q17a.
