Check for Updates 1 K L L M N P R T Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. BZ fx 9000 A [ F 5 G 2 3 5 6 Last Year Contribution margin $ 144.4505 502428 $ $ 255,000 $ 468.000 $ 56.9255 729,000 $ 74,100 $ - Fbedeceres Netageretingiram 4 7 8 11 12 15 Total 10 261.000 $ 13 94.800 $ 14 213,12 5 Weighted Average M per Unit 28.15 343,650 $ 347,760 $ 352,800 54,000 $ 225,040 33.04 4.223,070 300,000 1,221,070 $ Projections for This Year: Last years Change in unt sale: Change in seing prices Change in variable expenses Change in fed expenses ON 03 08 2 3 5 7 8 10 11 12 13 14 15 Total Wrighted-AERAH CM per Unit 100% 150,DCO $ Unitsaks Swing rice per urit Variable experceperunt Curtiliur targe aunt 16 9.000 29.00 $ 12.95 $ 16.05 $ 11% 16500 99.00 S 68.569 30.45 $ 48 5,000 R5.00 $ 42.50 $ 42.505 11%. 19,500 109.00 S $ 85.00 24.00 $ 4.500 19.00 $ G.35 $ 12.65 $ 18% 27,000 110.00 92.00 $ 27.00 2% 3.000 399.00 $ 14.30 $ 24.70 S 56 7.500 79.00 $ 33.15$ 45.82 $ ht 9,000 69.00 $ 30.36 $ 38.646 104 15.000 95.00 $ 77.00 $ 17.40 $ 10.500 59.00 $ 25.40 33.60 $ 1% 1,500 65.00 5 29.00 $ 35.00 $ 24 3.000 44.00 $ 12.40 $ 31.50 $ 48 6.000 49.00 $ $ 13.45 $ 35.52 % 12, DCO R9.00 6183 27.17 $ $ 251.000 $ 116.550 Se Variable experces Cartrition margir Fbedeceres Net operating come 1,633.500 5 1,131,075 502425 $ $10,000 $2,125.500 $ 255,000 1,607500 255,000 $ 468.000 5 8,500 $ 2,213,000 $117.000 117.000 $ 2A, 42900 56,925 $ 720,000 $ 74,100 5 592,500 $ 20 343,650 $ 621,000 $1,425.000 $ 273,240 1,164000 347,7605 261 261.000 5 619,500 $ 20.700 352,800 $ 97,500 $132.000 $ 6 43,500 37200 54,000 $ 948 5 94.800 $ 100.0% 670 33.0% $ $ 204,000 $1,068,000 5 12,795,000 0.90 741,900 8.571,930 219,120 3250410 4,223,070 3.000.000 $ 1.223,070 144,450 $ 28.15 Check my Lonardina niortinne tar thic voar accumo that total init calas incroaca huru and avanthinn alco halderonctant thint. Tha 4 Required information Part 2 of 4 a. What would be the projected net operating income for this year? b. How are the projected unit sales in cells B22 and Q22 calculated? c. Why are the percentages in cells R28 and R29 the same as the corresponding percentages in cells R8 and R9 even though the projected sales of 165,000 units is 15,000 units greater than last year's sales of 150,0000 units? d. What is the percent increase in total contribution margin (as shown in cell Q29) compared to last year's total contribution margin (as shown in cell Q9)? e. What is the percent increase in net operating income (as shown in cell Q31) compared to last year's net operating income (as shown in cell Q11)? Is your answer greater than, less than or equal to your answer in requirement 2d? 2.5 points X 01:17:20 Complete this question by entering your answers in the tabs below. eBook References Req 2A Req 2B Req 2c Reg 2D Req 21 Req 2E2 What would be the projected net operating income for this year? Projected net operating income Req 2A Req 2B > Check my What in the narrantineranninnat naratin inamalarhau in call 01311AMAD to larrienat narating in amalar 4 Required information Complete this question by entering your answers in the tabs below. Part 2 of 4 Req 2A Req 2B Req 2c Reg 2D Req 2E1 Reg 2E2 2.5 points How are the projected unit sales in cells B22 and Q22 calculated? X 01:17:05 26-1. How are the projected unit sales in cell B22 calculated? Total unit sales (cell Q22) - Product 1's sales mix percentage (cell B21) Total unit sales (cell Q22) + Product 1's sales mix percentage (cell B21) Total unit sales (cell Q22) Product 1's sales mix percentage (cell B21) Total unit sales (cell Q22) + Product 1's sales mix percentage (cell B21) eBook References 2b-2. How are the projected unit sales in cell Q22 calculated? Last year's unit sales - (Last year's unit sales * Change in unit sales) Last year's unit sales + (Last year's unit sales * Change in unit sales) Last year's unit sales * (Last year's unit sales Change in unit sales) OLast year's unit sales - (Last year's unit sales * Change in unit sales) 4 Required information (as shown in cell Q9)? e. What is the percent increase in net operating income (as shown in cell Q31) compared to last year's net operating income (as shown in cell Q11)? Is your answer greater than, less than or equal to your answer in requirement 2d? Part 2 of 4 Complete this question by entering your answers in the tabs below. 2.5 points X 01:16:43 Reg 2A Req 2B Req 2c Req 2D Req 2E1 Reg 2E2 eBook What is the percent increase in total contribution margin (as shown in cell Q29) compared to last year's total contribution margin (as shown in cell 09)? References Percent increase in total contribution margin Req 21 > This is a numeric cell, so please enter numbers only. 4 Required information (as shown in cell Q9)? e. What is the percent increase in net operating income (as shown in cell Q31) compared to last year's net operating income (as shown in cell Q11)? Is your answer greater than, less than or equal to your answer in requirement 2d? art 2 of 4 Complete this question by entering your answers in the tabs below. 5 nts 01:16:33 Req 2A Req 2B Req 20 Req 2D Reg 2E1 Req 2E2 eBook What is the percent increase in net operating income (as shown in cell Q31) compared to last year's net operating income (as shown in cell Q11)? (Round percentage answer to 1 decimal place.) Ceferences Percent increase in net operating income 4 Required information JHUYVIRLEI VIV: 13 yvui unici yi Cuci LITUIT, CU CIUIT, VI Equur LU yvui UITSYYETTEYul CITICIL Zui Part 2 of 4 Complete this question by entering your answers in the tabs below. 2.5 points Req 2A Req 2B Req 2c Req 2D Req 2E1 Req 2E2 & 01:15:43 Which of the following statements is true? The percent increase in net operating income is greater than the percent increase in contribution margin because total fixed expenses do not change as the unit sales increase. eBook References