help with accounting excel - Cost Volume Profit
K25 X A B E F G H J L M - N 0 P 1 7 8 10 16 2 22278 Camole ay piname statement compoule break-even painoatidan marain ravia 3 marais osalevalia and salesia tarpeidet inom 4 All Frute Company bottles and distributes Frute Ade, a fruit drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers. 5 who charge customers 70 cents per bottle. For the year 2014, management estimates the following revenues and costs. 6 Sales 2,500,000 Direct materials $ 360,000 Direct labor $ 450,000 Manufacturing overhead $ 270,000 Variable Manufacturing overhead $ 380,000 Fixed 11 Selling expenses $ 80,000 Variable 12 Selling expenses 250,000 Fixed 13 Administrative expenses 40,000 Variable 14 Administrative expenses 150,000 Fixed 15 Instruotas (a) Prepare a CVP income statement for 2014 based on management's estimates. (Show column for total amounts only.) 17 (b) Compute the break-even point in (1) units and (2) dollars. 18 (c) Compute the contribution margin ratio and the margin of safety ratio. (Round to nearest full percent.) 19 (d) Determine the sales dollars required to earn net income of $624,000. 20 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". 21 22 23 24 (a) 25 ALL FRUTE COMPANY 26 CVP Income Statement (Estimated) 27 For the Year Ending December 31, 2014 28 Sales Revenue Value 29 Variable Expenses 30 Cost of Goods Sold ? 31 Selling Expenses Value Administrative Expenses Value 33 Total Variable Expenses ? 34 Contribution Margin ? 35 Fixed Expenses 36 Cost of Goods Sold Value 37 Selling Expenses Value 38 Administrative Expenses Value 39 Total Fixed Expenses ? 40 Net Income ? 41 42 (b) (1) 43 Unit Selling Price Value 44 Unit Variable Costs ? 45 Contribution Margin per unit ? 46 On Your Own - HW Ex and Answers 1 Ex and Answers 2 + ir Type here to search O e a K25 E F G H J K L M - N ? ? ? Value B C 34 Contribution Margin 35 Fixed Expenses 36 Cost of Goods Sold Value 37 Selling Expenses Value Administrative Expenses Value Total Fixed Expenses 40 Net Income 41 42 (b) (1) 43 Unit Selling Price Value 44 Unit Variable Costs ? 45 Contribution Margin per unit ? 46 47 Fixed Costs ? 48 Contribution Margin per unit ? 49 Break-even point (units) ? 50 51 (b) (2) 52 Break-even point in units ? 53 Unit selling price 54 Break-even point (dollars) ? 55 56 OR 57 58 Fixed Costs 59 Contribution Margin Ratio 60 Contribution margin per ur ? 61 Unit selling price Value 62 Break-even point (dollars) 63 64 (c) 65 Contribution Margin Ratio 66 Contribution margin per ur? 67 Unit selling price Value 68 69 Margin of Safety Ratio 70 Sales Value 71 Break-even point (dollars? 72 Excess over break-even? 73 Sales ? 74 75 (d) 76 Total fixed expenses ? 77 Desired net income Value 78 Contribution margin ratio 79 Required sales ? ? ? ? ? ? ? ? On Your Own - HW Ex and Answers 1 Ex and Answers 2 + Type here to search i e
