Please help me find answers for the highlighted cells, I am also trying to create what-if-analyst to create a graph for the highlighted schedule.
I would greatly appreciate the feedback.
C Total Cost $1,091,325 Total Revenue $ mt no 00 A B Units Produced Fixed Cost $1,091,325 50,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000 450,000 500,000 what if analysis + CVP graph 12 13 Q27 C O E F G H I J K L M N O P Q R S T B Wedgewood Candle Co. Container Candle Division Operating Results for Quarter 3 Note to students: Use the information on this tab when answering questions 1-9 Variable 40% Fixed 60% 10% 90% 5 Revenues $ 2,596,750 6 Cost of Goods Sold: 7 DM $ 630,700 8 DL $ 202,300 9 MOH $ 431,375 $ 1,264,375 10 Gross Margin $ 172,550 $ 1,332,375 11 Selling and Admin $ 925,000 12 Division Operating Income $ 407,375 13 14 Units sold 325,000 15 16 Wedgewood Candle Co. 17 Container Candle Division 18 Operating Results for Quarter 3 19 20 Revenue $ 2,596,750 21 Variable Costs $ 1,098,050 22 Contribution Margin $ 1,498,700 23 Fixed Costs $ 1,091,325 24 Operating Income $ 407,375 Percentage Change in Sales: 15% $/Unit % of Sales $ 7.99 100.00% $ 3.38 42.29% $ 4.61 57.71% Wedgewood Candle Co. Container Candle Division Operating Results for Quarter 3 1 $/Unit % of Sales Revenue $ 1,890,904 $ 7.99 | 100.00% Variable Costs $ 799,579 $ 3.38 42.29% Contribution Margin $ 1,091,325 $ 4.61 57.71% Fixed Costs $ 1,091,325 Operating Income $ - Wedgewood Candle Co. Container Candle Division Operating Results for Quarter 3 $/Unit % of Sales Revenue $ 2,986,263 $ 7.99 100.00% Variable Costs $ 1,262,758 $ 3.38 42.29% Contribution Margin $ 1,723,505 $ 4.61 57.71% Fixed Costs $ 1,091,325 Operating Income $ 632,180 Breakeven Units 236,659 Per Income Statement: Percentage Increaes in Operating Income Margin of Safety in Dollars Margin of Safety Percentage Degree of operating Leverage $ 705,846 27.18% 3.68 Per Degree of Operating Leverage Percentage Increaes in Operating Income C Total Cost $1,091,325 Total Revenue $ mt no 00 A B Units Produced Fixed Cost $1,091,325 50,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000 450,000 500,000 what if analysis + CVP graph 12 13 Q27 C O E F G H I J K L M N O P Q R S T B Wedgewood Candle Co. Container Candle Division Operating Results for Quarter 3 Note to students: Use the information on this tab when answering questions 1-9 Variable 40% Fixed 60% 10% 90% 5 Revenues $ 2,596,750 6 Cost of Goods Sold: 7 DM $ 630,700 8 DL $ 202,300 9 MOH $ 431,375 $ 1,264,375 10 Gross Margin $ 172,550 $ 1,332,375 11 Selling and Admin $ 925,000 12 Division Operating Income $ 407,375 13 14 Units sold 325,000 15 16 Wedgewood Candle Co. 17 Container Candle Division 18 Operating Results for Quarter 3 19 20 Revenue $ 2,596,750 21 Variable Costs $ 1,098,050 22 Contribution Margin $ 1,498,700 23 Fixed Costs $ 1,091,325 24 Operating Income $ 407,375 Percentage Change in Sales: 15% $/Unit % of Sales $ 7.99 100.00% $ 3.38 42.29% $ 4.61 57.71% Wedgewood Candle Co. Container Candle Division Operating Results for Quarter 3 1 $/Unit % of Sales Revenue $ 1,890,904 $ 7.99 | 100.00% Variable Costs $ 799,579 $ 3.38 42.29% Contribution Margin $ 1,091,325 $ 4.61 57.71% Fixed Costs $ 1,091,325 Operating Income $ - Wedgewood Candle Co. Container Candle Division Operating Results for Quarter 3 $/Unit % of Sales Revenue $ 2,986,263 $ 7.99 100.00% Variable Costs $ 1,262,758 $ 3.38 42.29% Contribution Margin $ 1,723,505 $ 4.61 57.71% Fixed Costs $ 1,091,325 Operating Income $ 632,180 Breakeven Units 236,659 Per Income Statement: Percentage Increaes in Operating Income Margin of Safety in Dollars Margin of Safety Percentage Degree of operating Leverage $ 705,846 27.18% 3.68 Per Degree of Operating Leverage Percentage Increaes in Operating Income
