Problem #4 cost-value-profit chart

PR 5-6A Contribution margin, break-even sales, cost-volume-profit chart, margin of safety, and operating leverage Obj. 2, 3, 4, 5 V 2.25% Wolsey Industries Inc. expects to maintain the same inventories at the end of 20Y3 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: EXCEL TEMPLATE Estimated Fixed Cost Estimated Variable Cost (per unit sold) Production costs: Direct labor . . . . Factory overhead... S 46 40 20 $200,000 Selling expenses: 110,000 40,000 12,000 7,600 Miscellaneous selling expense Office and officers' salaries... Miscellaneous administrative expense Administrative expenses: 132,000 10,000 3,400 $525.000 $120 It is expected that 21,875 units wll be sold at a price of $160 a unit. Maximum sales within the relevant range are 27,000 units. Instructions 1. Prepare an estimated income statement for 20Y3 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