Excel File Edit View Insert Format Tools Data Window Help 77% 0 Thu 8:34 PM Q AutoSave OFF HEU Book1 Home Insert Draw Page Layout Formulas Data Review View Tell me Share a Comments 12 Calibri (Body) "Ai General Insert DA WE 49- O 5 DX Delete Paste B I U Av E == $ % ) 28 Ideas Conditional Format Cell Formatting as Table Styles Sort & Filter Sensitivity Format Find & Select C34 A C E H 1 N o P Q R S T U His for Home Ru Bachella fx B 1 CVP Home Run Practice: Three Product Example: The SHIM's Fancy Company sells 3 different belts: Gold, Silver and Leather. Dan Shim foresees sales of 200,000 units s in the coming period consisting of 20,000 units of Gold, 9 100,000 units of Silver and 80,000 units of Leather. The 11 company common fixed costs for the period are $2,550,000 12 which can't be separated to any belt. The followings are 13 additional information: Silver Leather Total Required: O 1) What is the sales mix and unit contribution margin for each product? o 2) Prepare contribution margin income statement and how much are Shim's current total contribution margin and operating income? 3) What are Shim's breakeven in units and in Sales dollars? 4) If Shim wants to make $7,650,000 income before taxes, how many units of each product must be sold and how much sales dollars should be generated for each product? 5) If Shim wants to make $15,000,000 income after taxes when tax rate is 25%, how many units of each product must be sold and how much sales dollars should be generated for each product? (newly added) 100,000 80,000 15 Gold 16 17 Unit 18 1 Total Unit 20,000 Cost 20 Sales $ 150 100% 4.Var. exp. 120 ###### 23 Contrib. 24 margin ###### 25 26 Fixed exp. 27 Net * income 29 Unit Cost $ 65 100% 45 ##### Unit Cost $ 50 $ 40 #VALUE! #VALUE! #VALUE! 2,550,000 #VALUE! su 31 32 33 34 54 35 36 27 Sheet1 Sheet2 + Ready 100% OCT 8 W A tv