Please calculate numbers for the green spots at the table Sh

Please calculate numbers for the green spots at the table

Shift Auto Unit Units Inven & mation Capacity Primary Pfmn Size Material Labor Cont. Over- Next Next Plant Utiliz 11/21/2010 4.0 5.0 3.0 3.0 3.0 1,800 66% 1,400 129% 900 45% 600 73% 600 63% Trad Able Acre AdamHigh Aft Agape Size 999 189 ,763 39 40 78 62 3.1 17500 5.5 14.5 $28.00 $11.59 $7.49 29% 0% $7.81 $7.12 27% 30% 1.723000 8.0 12.0 $38.00 $15.98 $8.57 33% 0% 2.5 25000 9.4 15.5 $33.00 $15.87 $8.57 23% 0% 26 19000 4.0 11.0 $33.00 $13.62 $8.57 30% 0% 46 14000 3.0 7.0 $21.00 366 358 314 4/18/2012 6/30/2011 5/25/2011 *The above product details are for example only. Your product names and data may differ, but the process to calculate margins is identical Useful formulas Contribution Margin($) = Price-(Material Cost + Labor Cost) Margin Percentage (%)-Contribution Margin/Price Calculating Margin Activity In the table below enter each product\'s price, material cost, and labor cost found in your report, and note whether or not a second shift was used (Y/N). Then, use the values you entered to calculate the Contribution Margin and the Margin Percentage Incomplete Current Margin Product Traditional Able Low End High End Performance Aft Size Name Price Material Cost Labor Cost Second Shift(Y/N) Contribution Margin Contribution Margin (%) Acre Adam Agape

Solution

$28 $11.59 $7.49 N $8.92 31.86%

$21 $7.81 $7.12 Y $6.07 28.90%

Calculations:

Contribution Margin=28-(11.59+7.49)= 28-19.08=$8.92

Margin %= (8.92÷28)*100=31.86%

Contribution Margin=21-(7.81+7.12)=21-14.93=$6.07

Margin %= (6.07÷21)*100=28.90%