e Home Insert Page Layout Formulas Data Review XOANI MT12 JAAR LCopy - BLU- A Format Painter Clipboard Font View Help Wrap Test Merge & Center - Alignment General $ -% % Data Section Fixed V ariable $2.30 4.70 3.00 $225,000 0.75 Production costs Direct materials Direct labor Factory overhead Selling expenses Sales salaries & commissions Advertising Miscellaneous selling expense General expenses Office salaries Supplies Miscellaneous general expense 97,000 47,500 16.200 0.25 92,000 12,300 15.000 $505,000 $11.00 Projected unit sales 3 Selling price per unit 120.000 $16.00 Target net income $250,000 7 The selling price of Poleski's single product is $16. In recent years, profits have fallen and Poleski's 3 management is now considering a number of alternatives Poleski wants to have a new income next 9 year of $250,000, but expects to sell on 120,000 units unless some changes are made. 0 Complete the answer section to calculate the company's projected net income (assuming 120,000 units are sold) 1 and the sales needed to achieve the company's net income objective for next year. UN Answer Section 5 Contribution margin per unit 36 Contribution margin ratio FORMULA1 FORMULA2 88 Break even point in units 39 Units needed to achieve target net income FORMULA FORMULA4 FORMULAS FORMULA 1 Break even point in dollars 42 Sales dollars needed to achieve target net income 43 44 Net income based on projected unit sales (cell C22) FORMULA7 46 48 49