Question

Project 1: CVP Income Statement (10 points) Instructions: Prepare your solutions in Excel, and upload your Excel file to Moodle by the deadline specified by your instructor. Do NOT email your file! The following information pertains to Fun in the Sun, Inc., a jet ski manufacturer: $ Budgeted production costs for the coming year: Direct materials per ski Direct labor per ski Variable overhead per ski Total fixed overhead 575 280 70 44,750 Budgeted selling and administrative costs for the coming year: Fixed selling & admin expense $ 102,000 Sales commission per ski 75 In the coming year, Fun in the Sun plans to produce and sell 1,280 skis at a price of $1,230 each. Instructions for Project 1: 1. Prepare a CVP income statement. 2. Calculate the breakeven point in units and sales dollars. 3. Calculate the margin of safety. 4. Calculate the margin of safety ratio. 5. If Fun in the Sun wants to earn net income of $260,000, how many units must it sell?

Answer 1

Sun Inc Income Statement 1574400 736000 358400 896001 96000 A.Sales (1280*1230) Less: Variable cost: Direct Material(1280*575) Direct Labour(1280*280) Variable manufacturig overhead cost(1280*70) Sales commission(1280*75) B.Total variable Cost C.Contribution Margin (A-B) Less: Fixed Cost Fixed manufacturing overhead cost Fixed Selling and administrative expenses D.Total Fixed Cost Net Operating Income(C-D) 1280000 294400 447501 102000 146750 147650 638.0434783 1 Break even Units Fixed cost /contribution margin per unit 146750/(294400/1280) Break even Dollar (fixed Cost/contribution margin ratio) (146750/(294400/1574400) 784793.4783

789606.5 Margin of safety (actual sales- Breakeven sales) 1574400-784793 50.15% 4 Margin of safety ratio (margin of safety/Actual sales) 789606.5/1574400 5 Target unit sales 1768.478 {(Fixed Costs+Desired Profit) / Contribution Magin per unit) (146750+260000)/(294400/1280)