Connelly Inc., a manufacturer of quality electric ice cream makers, has experienced a steady growth in sales over the past few years. Because her business has grown, Jan De Janey, the president, believes she needs an aggressive advertising campaign next year to maintain the company's growth. To prepare for the growth, the accountant prepared the following data for the current year: $ 15.00 18.50 7.50 41.00 $ Variable costs per ice cream maker Direct labor Direct materials Variable overhead Total variable costs Fixed costs Manufacturing Selling Administrative Total fixed costs Selling price per unit Expected sales (units) $ 95,500 55,500 548,000 $ 699,000 75 41,000 Required: 1. If the costs and sales price remain the same, what is the projected operating profit for the coming year? 2. What is the breakeven point in units for the coming year? 3. Jan has set the sales target for 45,400 ice cream makers, which she thinks she can achieve by an additional fixed selling expense of $234,165 for advertising. All other costs remain as per the data in the above table. What will be the operating profit if the additional $234,165 is spent on advertising and sales rise to 45,400 units? 4-a. What will be the new breakeven point if the additional $234,165 is spent on advertising? 4-b. Prepare a contribution income statement at the new breakeven point. 4-c. What is the percentage change in both fixed costs and in the breakeven point? 5. If the additional $234,165 is spent for advertising in the next year, what is the sales level (in units) needed to equal the current year's operating profit at 41,000 units? Req 1 Reg 2 Reg 3 Reg 4A Reg 4B Req 4C Reg 5 If the costs and sales price remain the same, what is the projected operating profit for the coming year? Projected operating profit 695,000 Req 1 Reg 2 Reg 3 Reg 4A Reg 4B Reg 4C Reg 5 What is the breakeven point in units for the coming year? (Round your answer up to the nearest whole number.) Breakeven point 20,559 units Req 1 Reg 2 Reg 3 Req 4A Req 4B Reg 4C Reg 5 Jan has set the sales target for 45,400 ice cream makers, which she thinks she can achieve by an additional fixed selling expense of $234,165 for advertising. All other costs remain as per the data in the above table. What will be the operating profit if the additional $234,165 is spent on advertising and sales rise to 45,400 units? Operating profit $ 610.435 Reg 1 Reg 2 Reg 3 Reg 4A Req 4B Reg 4C Req 5 What will be the new breakeven point if the additional $234,165 is spent on advertising? (Round your answer up to the nearest whole number.) New breakeven point 27,446 units Req 1 Reg 2 Req3 Reg 4A Reg 4B Reg 4C Reg 5 Prepare a contribution income statement at the new breakeven point. CONNELLY, INC. Contribution Income Statement $ 3,405,000 1,861,400 X $ 1,543,600 Sales revenue Less: Variable costs Contribution margin Less: Fixed costs Original amount Incremental amount $ 699,000 234,165 933,165 610,435 Operating profit Req 1 Reg 2 Reg 3 Req 4A Req 4B Reg 4C Reg 5 What is the percentage change in both fixed costs and in the breakeven point? (Input your answers as percentages rounded to 2 decimal places (i.e., .1567 = 15.67%.).) Percentage change in fixed cost Percentage change in breakeven point 33.50% 33.50% Req 1 Reg 2 Reg 3 Req 4A Reg 4B Reg 4C Reg 5 If the additional $234,165 is spent for advertising in the next year, what is the sales level (in units) needed to equal the current year's operating profit at 41,000 units? (Round your answer up to the nearest whole number.) Sales level units I need help with question 4-B and question 5
