Check my work Q Search Sheet on f AutoSave OFF Don Insert Page Layout Formulas ExcelAnalytics_CVPRelationships2_Template Review View Home Data Share X Insert AA- General Calibri (Body) 11 B 1 v Q 1. Conditional Formatting Format as Table Cell Styles * Delete Paste $ % ) 4.0 .00 .00 0 Editing Format Check for Updates Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. G15 fx A D E F H K 1 M N P 0 R T 1 2 5 7 10 12 13 14 15 Total Weighted-AYER CM per Unit 148.850 116,590 $ 144,450 1,131,074 502,425 195.000 255,000 1.657,500 468,000 28,575 56,928 2,414 000 729.000 74.100 271,240 347,760 1,164,000 261,000 266,700 352,800 43,900 54,000 37.200 94,800 RD, 213,120 741 066 326,040 143,650 33.0% 28.15 R$71.980 4,223,070 3.000.000 $ 1,123,070 1 Last Year: & Varuhlapa 9 Contribution murgin 10 Pined expenses 11 Nel penslingum 1 Projections for This Year: 14 Last year un 13 Change in sales 16 Change in selling prices 17 Chainele na 18 Change in fixed expenses 150,000 0% 0% 1 2 3 4 5 6 7 9 10 11 12 13 IS Total Wighted Average CM per l'ult V 3,000 150.000 100 20 21 Sales mex percentages 22 Thales 23 Selling price per unit 24 25 Contribution rentinarini - Lyr za vamable expense perunt 5 $ S 02 9,000 29.00 $ 12.99 $ 16.01S 16,500 99.00 S 68.53 5 30.49 $ 6.000 35.00 S 42.503 42.50 S 19,500 109.00 S 33.00 S S 34 00S 4.500 19.00 S 6.333 12.64 18% 17 000 119.00 92.00 22.00 S 7.500 79.00 33.18 45.RS 9,000 69.00 5 10.365 1364 IS 15,000 95.00 77.00 $ 10.500 59.00 5 25.40 13.50 1,500 65.00 5 29.00 $ 3.000 44.00 $ 12.40 L : 6,000 49.00 5 13:48 S 14 525 12,000 89.00 61. 27.11 14.JOS - WO 26 $ 261,000S 1.435,500 116,550 1.131,075 144,450 $ 502,425 S 510,000 S 2,125.500S 85,500 $ 3,213,000 S 117,000 $ 192,500 S 621.000 52.425,000 S 619.300S 195.000 1.657.500 28,575 2,414000 42,900 948,850 273,840 1.164,000 365.2011 255,000 468,000 5 56,925 729.000 74,100 $ 143,650 $ 347,760 S 261,008 352.8005 97,500 3132,000 97.500 43,500 37,200 54,000 94,800 LO0.0% 67.0% 33.0% $ 294.000 5 1,068,000 12,795,000 R6,80 741,050 R.571.000 $ 211,120 5 326,040 4,223,070 3,000,000 $ 1,123.070 $ 27 Sales 28 Varles e to 2 Cabihingin 30 Pined expenses 31 Nel peninginn 32 e foss e fo e foi Charts Conditional Formatting Requirement 1 Requirement 2 Requirement 3 Requirement 4 Requirements 5 and 6 + Ready + 61% e. How are the percentages in cells R8 and R9 calculated? f. How is the amount in cell S9 calculated? Complete this question by entering your answers in the tabs below. Req 1A Req 1B Req 10 Req 1D Req 1E Req 1F How is the percentage in cell B3 calculated? Why do you think specifying the sales mix percentages for all products is important? 1a-1. O Product 1's unit sales (cell B2) Total unit sales (cell Q2) O Product 1's unit sales (cell B2) + Total unit sales (cell Q2) Product 1's unit sales (cell B2) * Total unit sales (cell Q2) Product 1's unit sales (cell B2) - Total unit sales (cell Q2) 1a-2. Why do you think specifying the sales mix percentages for all products is important? They are held constant when performing break-even and target profit calculations. OThey are allowed to vary when performing break-even and target profit calculations. 3 Required information Complete this question by entering your answers in the tabs below. 1 of 4 Req 1A Req 1B Req 1C Req 1D Req 1E Reg 1F How are the percentages in cells R8 and R9 calculated? 01:26:54 1b-1. Book How is the percentage in cell R8 calculated? Total variable expenses (cell Q8) - Total sales (cell Q7) Total variable expenses (cell Q8) + Total sales (cell Q7) Total variable expenses (cell Q8) * Total sales (cell 07) Total variable expenses (cell Q8) + Total sales (cell Q7) erences 1b-2. How is the percentage in cell R9 calculated? Total contribution margin (cell 09) - Total sales (cell Q7) Total contribution margin (cell Q9) + Total sales (cell Q7) Total contribution margin (cell Q9) * Total sales (cell Q7) Total contribution margin (cell Q9) - Total sales (cell Q7) Che 3 Required information art 1 of 4 Complete this question by entering your answers in the tabs below. 5 ints Reg 1A Reg 1B Reg 1C Reg 1D Reg 1E Reg 1F 01:26:45 How is the amount in cell 59 calculated? eBook Total contribution margin (cell Q9) - Total unit sales (cell Q2) Total contribution margin (cell Q9) + Total unit sales (cell (2) Total contribution margin (cell Q9) * Total unit sales (cell Q2) Total contribution margin (cell Q9) + Total unit sales (cell Q2) References e. How are the percentages in cells R8 and R9 calculated? f. How is the amount in cell S9 calculated? Complete this question by entering your answers in the tabs below. Req 1A Req 1B Req 10 Req 1D Req 1E Req 1F How is the percentage in cell B3 calculated? Why do you think specifying the sales mix percentages for all products is important? 1a-1. O Product 1's unit sales (cell B2) Total unit sales (cell Q2) O Product 1's unit sales (cell B2) + Total unit sales (cell Q2) Product 1's unit sales (cell B2) * Total unit sales (cell Q2) Product 1's unit sales (cell B2) - Total unit sales (cell Q2) 1a-2. Why do you think specifying the sales mix percentages for all products is important? They are held constant when performing break-even and target profit calculations. OThey are allowed to vary when performing break-even and target profit calculations. 3 Required information Complete this question by entering your answers in the tabs below. 1 of 4 Req 1A Req 1B Req 1C Req 1D Req 1E Reg 1F How are the percentages in cells R8 and R9 calculated? 01:26:54 1b-1. Book How is the percentage in cell R8 calculated? Total variable expenses (cell Q8) - Total sales (cell Q7) Total variable expenses (cell Q8) + Total sales (cell Q7) Total variable expenses (cell Q8) * Total sales (cell 07) Total variable expenses (cell Q8) + Total sales (cell Q7) erences 1b-2. How is the percentage in cell R9 calculated? Total contribution margin (cell 09) - Total sales (cell Q7) Total contribution margin (cell Q9) + Total sales (cell Q7) Total contribution margin (cell Q9) * Total sales (cell Q7) Total contribution margin (cell Q9) - Total sales (cell Q7) Che 3 Required information art 1 of 4 Complete this question by entering your answers in the tabs below. 5 ints Reg 1A Reg 1B Reg 1C Reg 1D Reg 1E Reg 1F 01:26:45 How is the amount in cell 59 calculated? eBook Total contribution margin (cell Q9) - Total unit sales (cell Q2) Total contribution margin (cell Q9) + Total unit sales (cell (2) Total contribution margin (cell Q9) * Total unit sales (cell Q2) Total contribution margin (cell Q9) + Total unit sales (cell Q2) References