Advertising $50,000 Travel $15,000 Miscellaneous selling expense $10,000 $2 Administrative Expenses: Office and officers' salaries $140,000 Supplies $10,000 $5 Miscellaneous administrative expense $10,000 $2 Total $510,000 $130 It is expected that 22,175 units will be sold at a price of $170 a unit. Maximum sales within the relevant range are 27,500 units. INSTRUCTIONS: Using formulas/functions wherever possible, complete the following on the Input Tab 1) Prepare an estimated income statement for 20Y5. 2) What is the expected contribution margin ratio? 3) Determine the break-even sales in units and dollars. 4) Construct a cost-volume-profit chart indicating the break-even sales. 5) What is the expected margin of safety in dollars and as a percentage of sales? 6) Determine the operating leverage.EXCEL 3 Contribution Margin, Break-Even Sales, Cost-Volume-Profit Chart, Margin of Safety, and Operating Leverage Youngsville Industries Inc. expects to maintain the same inventories at the end of 2015 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 Estimated Variable Fixed Cost Cost (per unit sold) Production Costs: Direct Materials $48 Direct Labor $38 Factory Overhead $150,000 $25 Selling Expenses: Sales salaries and commissions $125,000 $10 Advertising $50,000 Travel $15,000 Miscellaneous selling expense $10,000 $2 Administrative Expenses: Office and officers' salaries $140,000 Supplies $10,000 $5 Miscellaneous administrative expense $10,000 $2 Total $510,000 $130 It is expected that 22,175 units will be sold at a price of $170 a unit. Maximum sales within the relevant range are 27,500 units