Variable cost per unit remains same and total variable cost changes with the changes in output while total fixed costs remain same and per unit cost changes with change in output.
Total variable cost at 625 units = $125,000
Variable cost per unit = 125,000/625 = $200
Total cost per unit = 543.75
Fixed cost per unit at 800 units = 543.75-200 = $343.75
Total Fixed Costs = $343.75*800 = $275,000
Hence, table is completed as follows:
625 |
800 |
1,050 |
|
Total Costs: |
|||
Total Variable Costs |
125,000 |
160,000 |
210,000 |
Total Fixed Costs |
275,000 |
275,000 |
275,000 |
Total Costs |
400,000 |
435,000 |
485,000 |
Cost per Unit: |
|||
Variable cost per unit |
200 |
200 |
200 |
Fixed Cost per Unit |
440 |
343.75 |
261.90 |
Total Cost per Unit |
640 |
543.75 |
461.90 |
Total Revenue |
406,250 |
520,000 |
682,500 |
Variable costs |
125,000 |
160,000 |
210,000 |
Contribution Margin |
281,250 |
360,000 |
472,500 |
Fixed Costs |
275,000 |
275,000 |
275,000 |
Net Operating Income |
6,250 |
85,000 |
197,500 |
CM Ratio = CM/Sales |
69.23% |
69.23% |
69.23% |
Net Operating Income/Total Revenue |
1.54% |
16.35% |
28.94% |
Cost data Number of Bikes Produced and Sold 625 800 1,050 Total costs: Total variable costs...
Number of Canoes Produced and Sold 450 650 800 Total costs Variable costs $ 63,000 $ 91,000 $112,000 Fixed costs 187,200 187,200 187,200 Total costs $250,200 $278,200 $299,200 Cost per unit Variable cost per unit $ 140.00 $ 140.00 $ 140.00 Fixed cost per unit 416.00 288.00 234.00 Total cost per unit $ 556.00 $ 428.00 S 374.00 Riverside sells its canoes for $700 each. Next year Riverside expects to sell 1,000 canoes. Required: Complete the Riverside's contribution margin income...
400 600 750 Number of Canoes Produced and Sold Total costs Variable costs Fixed costs Total costs Cost per unit Variable cost per unit Fixed cost per unit Total cost per unit $ 54,000 60,000 $114,000 $ 81,000 60,000 $ 141,000 $ 101,250 60,000 $ 161,250 $ 135.00 150.00 $ 285.00 $ 135.00 $ 135.00 100.00 80.00 $ 235.00 $ 215.00 Riverside sells its canoes for $370 each. Next year Riverside expects to sell 1,000 canoes. Required: Complete the Riverside's...
400 600 750 Number of Canoes Produced and sold Total costs Variable costs Fixed costs Total costs Cost per unit Variable cost per unit Fixed cost per unit Total cost per unit $ 54,000 60,000 $114,000 $81,000 60,000 $ 141,000 $101,250 60,000 $161,250 $ 135.00 150.00 $ 285.00 $135.00 100.00 $ 235.00 $135.00 80.00 $ 215.00 Riverside sells its canoes for $370 each. Next year Riverside expects to sell 1,000 canoes. Required: Complete the Riverside's contribution margin income statement for...
PA5-4 Predicting predicting Cost Behavior, Calculating Contribution Marain and Contribution Margin Ratio, Calculating Profit asidio, Inc. produces one model of mountain bike. Partial information for the company LO follows: Cost Data Number of Bikes Produced and Sold 625 800 1,050 $125,000 Total costs Variable costs Fixed costs per year Total costs Cost per unit Variable cost per unit Fixed cost per unit Total cost per unit $581.25 Required: 1. Complete Presidio's cost data table. 2. Calculate Presidio's contribution margin ratio...
Number of Canoes Produced and sold 485 635 785 Total costs Variable costs $ 71,780 Fixed costs 150,000 Total costs $221,780 Cost per unit Variable cost per unit Fixed cost per unit Total cost per unit Required: 1. Complete the table. 3. Suppose Riverside sells its canoes for $518 each. Calculate the contribution margin per canoe and the contribution margin ratio. 4. Next year Riverside expects to sell 835 canoes. Complete the contribution margin income statement for the company Complete...
please include excel formulas Presidio, Inc., produces one model of mountain bike. Partial information for the company follows: CostData Number of Bikes Produced and so 625 800 1,050 Total costs Variable costs $125,000 $? $ Fixed costs per year ? Total costs Cost per unit Variable cost per unit Fixed cost per unit Total cost per unit $543.75 Required: 1. Complete Presidio's cost data table. 2. Calculate Presidio's contribution margin ratio and its total contribution margin at each sales level...
32 0.33 Doints Number of Canoes Produced and sold 540 620 780 Total costs Variable costs $ 67,500 2 ? Fixed costs 150,000 7 2 Total costa $217,500 2 7 Cost per unit Variable cost per unit 2 2 7. Fixed cost per unit 2 7 2 Total cost per unit 2 2 2 eBook Required: 1. Complete the table. Hint 3. Suppose Riverside sells its canoes for $500 each. Calculate the contribution margin per canoe and the contribution margin...
Number of Canoes Produced and Sold 515 665 815 Total costs Variable costs $ 70,040 2 2 Fixed costs 149,900 2 2 Total costa $219,940 2 2 Cost per unit Variable cost per unit 2 2 2 Fixed cost per unit 2 2 Total cost per unit 2 2 2 Required: 1. Complete the table. 3. Suppose Riverside sells its canoes for $519 each. Calculate the contribution margin per canoe and the contribution margin ratio, 4. Next year Riverside expects...
Homework 5 0 Help 780 9.09 points Number of Canoes Produced and Sold 548 Total costs Variable costs $ 67,500 $ 77,500 $ 97,500 Fixed costs 150,080 150,000 150,000 Total costs $217,500 $227,500 $247,500 Cost per unit Variable cost per unit $ 125.00 $125.00 $125.00 Fixed cost per unit 272.78241.94192.31 Total cost per unit $ 402.78 $ 366.94 $317.31 Riverside sells its canoes for $500 each. Next year Riverside expects to sell 700 canoes. Required: Complete the Riverside's contribution margin...
7) Total Variable cost = Number of units sold x variable cost per unit 8) Operating Leverage = Contribution Margin / Net Income Complete the below table: Sales Variable Cost Total Contribution Margin Fixed Costs Operating Income Break-even Sales Revenue 150,000 125,000 50,000 B 85,000 35,000 15,000 75,000 65,000 113,750 D 180,000 50,000 144,000 Remember: 1) Variable costs rise and fall with an increase or decrease in revenue 2) Fixed costs do not rise and fall with an increase or...