Formatting as lable Styles Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates E11 A 9 E 11 1 2 K 1 1 N D P D H 5 1 1 2 2 3 7 5 6 7 3 9 19 11 13 15 Total Weighted CM per un Last Year Unidos 000's 6.000 DITS ) DOTS X2 SP 26.500 91% 99.00 $ 65.55 5 Sethcare prin 29.00 $ $ 1295 > 19,500 139 109.00 5 ES.00 > 350 LCD 100% % 350 $ S 4250 $ 4,500 13 19 19.00 S 6.35 23,000 119 119.00 $ $ 92.00 $ 3,000 39 39.00 1430 $ 12 15 1 65.00 S 29.00 $ 2,500 54 79.00 $ 33.15$ 9,000 CS 6900 S 30 35 S S 15.000 10 950 $ $ 23.60 $ 10.SDO 7 59.00 $ 25.40 S 12 DOO % 89.00 61.43 2x 44.00 $ 12.40 S 13.48 $ $ 5 100.0% 261,000 115,950 244450 1111 1,633 500S 510.00 $ 2,125,500 5 85,500 $3,211,000 $ 592,500 $ 621.00 $ 1425,00 3.219.00 3,957500 255,000 21,975 2,4111,000 42,000 241,150 271,240 1.15-1.900 502425 $ 255,000 46000 56.25 725,000 34,300 343,550 $347,760 261.000 $ 69.500 ZEG.700 $ 3:2.800 97.500 $ 495 13500 $ 07.0% S S 132.000 $ 292000 1,068 020 5 12.795,000 17200 30 7.41 900 1,371,000 9480 2:3120 $ 325 1140 4,223,00 3.000.000 $ 1,221,00 SISE Custralian As perse Netopering home 29.95 350.000 HO Projections for This Year: utput sales Charpeinunk sales Charpein saling prices Change in weaponses China 3 11 12 23 15 X Weighed Average CM per una SC 2 19 2.500 I 1500 2 3.000 10A 150,000 NA 9,000 29.90 12.45 er 16.05 S $ SP 0009 OIT SR 5 $05 CP 3 WA Unitsa dan water or inh Como bation marg prunk Sve -6500 90.00 GL55 30.45 10 10% 15.000 95 DO $ 77 $ 1743 1% 4,500 | $ GA 3 12.655 3 19.500 10.00 > 5. 24.00 $ LES 27,000 119.00 $ 52.00 5 27.00 $ $ 5 . GS 9.000 49.DOS an $ 38 64 $ 9,000 19.00 $ 14.30 $ 24.70 24.70 $ 7 10.500 59.00 S $ 33.60 $ > 6000 20.00 11.12 SEN 35.52 5 $ 12.000 1.00 61.13 27.17 S S S 12. $ 4537 45.825 13.40 $ 31.60 $ 200 $ 36.00 $ $ 4250 $ > 5 $ : 361.000 5 216 550 144450 16 1.611500 11:10 502425 51005 255,000 255.00 $ 3.12 con 3.650500 465.000 As son 5 2,311.000 5 25525 2,484,00D 56925 729,200 119,000 $ 599,00 $ 2170 62100 $ TASAS $ 1 ASSADO $ 619,00 42.300 244,850 233,240 1.114.000 256.00 24,100 30.5 342.260 $261.000 $352.800 17200 975 48.500 54,000 $ 21 1000% SUS 330% $ 5 09876 292 na 1068 0 5 19.795.00 BURU 741950 3 2.3120 $ 226 040 4,223,070 9.000,00 5 7,321,020 Corbation margin Rendepenses Netaping income 28.15 Projet Crapt Information Pet Das Palah 250 CVP Graph Anyaman Sir Ford Expense Total Expenses 3.000.000 2,000,000 300,000 1,172 Darts Paint 250 LOU DOSTOT Charts Conditional Formatting Requirement 1 Requirement 2 Requirement a Requirement 4 Requirements 5 and 6 + Ready + %98 " II. ----------- 111:........ 6 Required information art 4 of 4 year? How does this amount compare to the sales from last year? b. If the company's sales mix shifts as just described and it sells a total of 150,000 units, what net operating income will it earn this year? How does the projected net operating income for this year compare to the sales from last year? c. Why does the contribution margin ratio shown in cell R29 differ from the contribution margin ratio shown in cell R9? 5 ints Complete this question by entering your answers in the tabs below. 3 00:58:53 Reg 6A1 Req 6A2 Reg 6B1 Reg 6B2 Reg 6C eBook If the company's sales mix shifts as just described and it sells a total of 150,000 units, what would be the projected sales for this year? eferences Projected sales for this year Check my work 6 Required information art 4 of 4 year? How does this amount compare to the sales from last year? b. If the company's sales mix shifts as just described and it sells a total of 150,000 units, what net operating income will it earn this year? How does the projected net operating income for this year compare to the sales from last year? c. Why does the contribution margin ratio shown in cell R29 differ from the contribution margin ratio shown in cell R9? 5 ints Complete this question by entering your answers in the tabs below. 2 00:57:50 Reg 6A1 Req 6A2 Req6B1 Reg 6B2 Req 6C eBook If the company's sales mix shifts as just described and it sells a total of 150,000 units, what net operating income will it earn this year? References Net operating income Required information 4 of 4 year? How does this amount compare to the sales from last year? b. If the company's sales mix shifts as just described and it sells a total of 150,000 units, what net operating income will it earn this year? How does the projected net operating income for this year compare to the sales from last year? c. Why does the contribution margin ratio shown in cell R29 differ from the contribution margin ratio shown in cell R9? Complete this question by entering your answers in the tabs below. 5 00:56:49 Req 6A1 Req 6A2 Req 6B1 Req 6B2 Req 6C Book Why does the contribution margin ratio shown in cell R29 differ from the contribution margin ratio shown in cell R9? erences The sales mix has shifted to products with the highest selling prices per unit. The sales mix has shifted to products with the highest contribution margins per unit. Formatting as lable Styles Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates E11 A 9 E 11 1 2 K 1 1 N D P D H 5 1 1 2 2 3 7 5 6 7 3 9 19 11 13 15 Total Weighted CM per un Last Year Unidos 000's 6.000 DITS ) DOTS X2 SP 26.500 91% 99.00 $ 65.55 5 Sethcare prin 29.00 $ $ 1295 > 19,500 139 109.00 5 ES.00 > 350 LCD 100% % 350 $ S 4250 $ 4,500 13 19 19.00 S 6.35 23,000 119 119.00 $ $ 92.00 $ 3,000 39 39.00 1430 $ 12 15 1 65.00 S 29.00 $ 2,500 54 79.00 $ 33.15$ 9,000 CS 6900 S 30 35 S S 15.000 10 950 $ $ 23.60 $ 10.SDO 7 59.00 $ 25.40 S 12 DOO % 89.00 61.43 2x 44.00 $ 12.40 S 13.48 $ $ 5 100.0% 261,000 115,950 244450 1111 1,633 500S 510.00 $ 2,125,500 5 85,500 $3,211,000 $ 592,500 $ 621.00 $ 1425,00 3.219.00 3,957500 255,000 21,975 2,4111,000 42,000 241,150 271,240 1.15-1.900 502425 $ 255,000 46000 56.25 725,000 34,300 343,550 $347,760 261.000 $ 69.500 ZEG.700 $ 3:2.800 97.500 $ 495 13500 $ 07.0% S S 132.000 $ 292000 1,068 020 5 12.795,000 17200 30 7.41 900 1,371,000 9480 2:3120 $ 325 1140 4,223,00 3.000.000 $ 1,221,00 SISE Custralian As perse Netopering home 29.95 350.000 HO Projections for This Year: utput sales Charpeinunk sales Charpein saling prices Change in weaponses China 3 11 12 23 15 X Weighed Average CM per una SC 2 19 2.500 I 1500 2 3.000 10A 150,000 NA 9,000 29.90 12.45 er 16.05 S $ SP 0009 OIT SR 5 $05 CP 3 WA Unitsa dan water or inh Como bation marg prunk Sve -6500 90.00 GL55 30.45 10 10% 15.000 95 DO $ 77 $ 1743 1% 4,500 | $ GA 3 12.655 3 19.500 10.00 > 5. 24.00 $ LES 27,000 119.00 $ 52.00 5 27.00 $ $ 5 . GS 9.000 49.DOS an $ 38 64 $ 9,000 19.00 $ 14.30 $ 24.70 24.70 $ 7 10.500 59.00 S $ 33.60 $ > 6000 20.00 11.12 SEN 35.52 5 $ 12.000 1.00 61.13 27.17 S S S 12. $ 4537 45.825 13.40 $ 31.60 $ 200 $ 36.00 $ $ 4250 $ > 5 $ : 361.000 5 216 550 144450 16 1.611500 11:10 502425 51005 255,000 255.00 $ 3.12 con 3.650500 465.000 As son 5 2,311.000 5 25525 2,484,00D 56925 729,200 119,000 $ 599,00 $ 2170 62100 $ TASAS $ 1 ASSADO $ 619,00 42.300 244,850 233,240 1.114.000 256.00 24,100 30.5 342.260 $261.000 $352.800 17200 975 48.500 54,000 $ 21 1000% SUS 330% $ 5 09876 292 na 1068 0 5 19.795.00 BURU 741950 3 2.3120 $ 226 040 4,223,070 9.000,00 5 7,321,020 Corbation margin Rendepenses Netaping income 28.15 Projet Crapt Information Pet Das Palah 250 CVP Graph Anyaman Sir Ford Expense Total Expenses 3.000.000 2,000,000 300,000 1,172 Darts Paint 250 LOU DOSTOT Charts Conditional Formatting Requirement 1 Requirement 2 Requirement a Requirement 4 Requirements 5 and 6 + Ready + %98 " II. ----------- 111:........ 6 Required information art 4 of 4 year? How does this amount compare to the sales from last year? b. If the company's sales mix shifts as just described and it sells a total of 150,000 units, what net operating income will it earn this year? How does the projected net operating income for this year compare to the sales from last year? c. Why does the contribution margin ratio shown in cell R29 differ from the contribution margin ratio shown in cell R9? 5 ints Complete this question by entering your answers in the tabs below. 3 00:58:53 Reg 6A1 Req 6A2 Reg 6B1 Reg 6B2 Reg 6C eBook If the company's sales mix shifts as just described and it sells a total of 150,000 units, what would be the projected sales for this year? eferences Projected sales for this year Check my work 6 Required information art 4 of 4 year? How does this amount compare to the sales from last year? b. If the company's sales mix shifts as just described and it sells a total of 150,000 units, what net operating income will it earn this year? How does the projected net operating income for this year compare to the sales from last year? c. Why does the contribution margin ratio shown in cell R29 differ from the contribution margin ratio shown in cell R9? 5 ints Complete this question by entering your answers in the tabs below. 2 00:57:50 Reg 6A1 Req 6A2 Req6B1 Reg 6B2 Req 6C eBook If the company's sales mix shifts as just described and it sells a total of 150,000 units, what net operating income will it earn this year? References Net operating income Required information 4 of 4 year? How does this amount compare to the sales from last year? b. If the company's sales mix shifts as just described and it sells a total of 150,000 units, what net operating income will it earn this year? How does the projected net operating income for this year compare to the sales from last year? c. Why does the contribution margin ratio shown in cell R29 differ from the contribution margin ratio shown in cell R9? Complete this question by entering your answers in the tabs below. 5 00:56:49 Req 6A1 Req 6A2 Req 6B1 Req 6B2 Req 6C Book Why does the contribution margin ratio shown in cell R29 differ from the contribution margin ratio shown in cell R9? erences The sales mix has shifted to products with the highest selling prices per unit. The sales mix has shifted to products with the highest contribution margins per unit.