..ll Verizon 6:31 PM 67% 4 Done Excel 3(1).xlsx Info Input EXCEL 3 Contribution Margis, Break Eve Sales, Cost-Volume-Profit Chart. Margin of Safety, and Operating Leverage Wake Tech Industries Inc. expects to maintain the same inventories at the end of 2072 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind the various department heads were asked to submit estimates of the costs for their departments during the year. A summary Report of these estimates is as follows: Estimated Fised Estimated Variable Ces per la 46 $40 $20 $200.000 Production Costs Dr Male Direct Factory Overhead Selling Expenses Sales salaries and commissions Ad Travel Miscellaneouslingene Administrative Expenses Odlice and offices Supplies Miscellaneous administratives Toti $110.000 540,000 S12.000 $7.00 $1 $132.000 SI $1.400 SS2000 SI $120 It is expected that 21.875 units will be sold at a price of 5160 a unit. Maximum sales within the relevant range 25,000 unit. INSTRUCTIONS: Using formulas functions wherever possible complete the following on the Input Tab 1) Prepare an estimated income statement for 20Y2 2) What is the expected combustion margin ratio? 3) Determine the break-even sales in units and dollars. 4) Construct a co-volume-profit chart indicating the break-even als 5) What is the expected margin of safety in dollars and as a percentage of 6) Determine the operating leverage Info Input formulas functions wherever possible, complete the following Wein in Estimated Income met For the Year Ended December 31, 2 Sales Cost of goods sold Direct material De Factory overhead Cost of goods sold Crossro Selling expenses Adring Adve expenses office and officers'salaries Supplies care expense Total dave exper Operating income Un recent Variable costs Contributionary Contrato Fred costs Une Cont Un man Break-even dollars) hun level of sales, enter the total sales dollars and total costs. The chart right will be ploted as you enter the amounts al points are planted, grab and move the labels provided at the left to identity each area. Costa 3,000 000 15.00 Bros Faedo Sale Price Unit Variable Cost unit contain marin Break even sale units Sale pre Breakevendors 4. For each unit level of sales, enter the total sales dollars and total costs. The chart at right will be pled as you enter the amounts After all points are plotted grab and move the labels provided at the left to identify ach area Units Sales Costs 15.000 18.000 21000 27.000 Expected sales Break-even point Margin of all tyndtas) Expected sales Margin of salty as a percentage of sales . Operleverage Unit CMS Contribution margin Operating income Operating leverage