(1) Cost Data Table :-
450 Units |
910 Units |
1628 Unts |
|
Total Costs |
|||
Variable cost |
144000 |
(910 * 320) = 291200 |
(1628 * 320) = 520960 |
Fixed cost per year |
198380** |
198380** |
198380** |
Total Costs |
342380 |
489580 |
719340 |
Cost per unit |
|||
Variable cost pu |
320* |
320* |
320* |
Fixed cost pu |
440.84 |
218 |
121.86 |
Total cost pu |
760.84 |
538 |
441.86 |
*Variable cost per unit = $144000/450 units = $320
VC per unit will remain same
**Fixed Cost :-
In 910 Units:-
Cost pu = $538
Total Cost = $538 * 910 units = $489580
Variable cost for 910 units = 910 units * $320 = $291200
Fixed Cost = Total cost – Variable cost
= 489580 – 291200 = 198380
Fixed cost will remain same in all the above cases irrespective of the no of units produced & sell
(2) Contribution Margin Ratio & its Total contribution Margin :-
450 Units |
910 Units |
1628 Units |
|
Total contribution Margin |
144000 |
291200 |
520960 |
Contribution Margin Ratio |
50% |
50% |
50% |
SP pu = $640
Contribution Margin = Sale Value – Variable cost
Contribution Margin Ratio = (Contribution Margin / Sale Value) * 100
450 Units |
910 Units |
1628 Units |
|
Sale value (A) |
(450 * $640) =288000 |
(910 * $640) =582400 |
(1628 * $640) =1041920 |
(-) Variable Cost |
144000 |
291200 |
520960 |
Contribution Margin (B) |
144000 |
291200 |
520960 |
Contribution Margin Ratio (B/A) |
(144000/288000) * 100 =50% |
(291200/582400) * 100 =50% |
(520960/1041920)*100 =50% |
(3) Net Operating Income (Loss) :-
Net Operating Income (Loss) = Sals value – VC – Fixed cost
450 Units |
910 Units |
1628 Units |
|
Sale value |
(450 * $640) =288000 |
(910 * $640) =582400 |
(1628 * $640) =1041920 |
(-) Variable Cost |
144000 |
291200 |
520960 |
Contribution Margin |
144000 |
291200 |
520960 |
(-) Fixed Cost |
198380 |
198380 |
198380 |
Net Operating Income (Loss) |
(54380) |
92820 |
322580 |
Presidio, Inc. produces one model of mountain bike. Partial information for the company follows: Required: 1....
Presidio, Inc., produces one model of mountain bike. Partial information for the company follows: Required: 1. Complete Presidio’s cost data table. 2. Calculate Presidio’s contribution margin ratio and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $640. 3. Calculate net operating income (loss) at each of the sales levels assuming a sales price of $640. Required 1 Required 2 Required 3 Complete Presidio's cost data table. (Round...
Presidio, Inc., produces one model of mountain bike. Partial information for the company follows: Required: 1. Complete Presidio's cost data table. 2. Calculate Presidio's contribution margin ratio and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $630. 3. Calculate net operating income (loss) at each of the sales levels assuming a sales price of $630. Complete this question by entering your answers in the tabs below. Required...
Check Presidio, Inc., produces one model of mountain bike. Partial information for the company follows: Required: 1. Complete Presidio's cost data table. 2. Calculate Presidio's contribution margin ratio and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $640. 3. Calculate net operating income (loss) at each of the sales levels assuming a sales price of $640. points eBook Complete this question by entering your answers in the...
Presidio, Inc., produces one model of mountain bike. Partial Information for the company follows: Required: 1. Complete Presidio's Cost data table 2. Calculate Presidio's contribution margin ratio and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $620 3. Calculate net operating income (loss) at each of the sales levels assuming a sales price of $620. Complete this question by entering your answers in the tabs below. Required...
Presidio, Inc. produces one model of mountain bike. Partial information for the company follows: Required: 1. Complete Presidio's cost data table. (Round your Cost per Unit answers to 2 decimal places.) Bikes Produced and Sold 510 Units 890 Units 1862 Units Total costs Variable costs $ 147,900 Fixed costs per year Total costs Cost per unit $ 147,900 $ 0 $ Variable cost per unit Fixed cost per unit Total cost per unit $ 0.00 $ 553.00 $ 0.00 2....
Presidio, Inc., produces one model of mountain bike. Partial information for the company follows: Required: 1. Complete Presidio's cost data table. 2. Calculate Presidio's contribution margin ratio and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $650. 3. Calculate net operating income at each of the sales levels assuming a sales price of $650. Complete this question by entering your answers in the tabs below. Required 1...
Presidio, Inc. produces one model of mountain bike. Partial Information for the company follows: Required: 1. Complete Presidio's cost data table. 2. Calculate Presidio's contribution margin ratlo and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $640. 3. Calculate net operating Income (loss) at each of the sales levels assuming a sales price of $640. Complete this question by entering your answers the tabs below. Required 1...
Presidio, Inc., produces one model of mountain bike. Partial information for the company follows: Required: 1. Complete Presidio's cost data table. 2. Calculate Presidio's contribution margin ratio and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $620. 3. Calculate net operating income (loss) at each of the sales levels assuming a sales price of $620. Complete this question by entering your answers in the tabs below. Required...
Presidio, Inc., produces one model of mountain bike. Partial information for the company follows: Required: 1. Complete Presidio's cost data table. 2. Calculate Presidio's contribution margin ratio and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $620. 3. Calculate net operating income (loss) at each of the sales levels assuming a sales price of $620. Complete this question by entering your answers in the tabs below. Required...
Presidio, Inc., produces one model of a mountain bike. Partial information for the company follows: Required: 1. Complete Presidio’s cost data table. 2. Calculate Presidio’s contribution margin ratio and its total contribution margin at each sales level indicated in the cost data table assuming the company sells each bike for $630. 3. Calculate net operating income (loss) at each of the sales levels assuming a sales price of $630. Complete Presidio’s cost data table. (Round your Cost per Unit answers...