product mix

N 3 Product Mix Worksheet o 5 Complete the following worksheet and questions listed below it. 6 %Margin = Margin/ Sales ROI = Margin/ Assets 7 8 9 10 Company 11 Total Product A Product B 12 13 Sales 5,500,000 4,300,000 1,200,000 14 15 Margin 1,300,000 1,700,000 (400,000) 16 17 % Margin 24% 18 19 Assets 7,000,000 4,000,000 3,000,000 20 + Tacos Turkey & Chips 1,000,000 400,000 21 ROI 19% 22 23 If my corporate goal is to earn a return at the margin line and ROI of greater than or equal to 40% can I do it? 24 25 26 27 Sandwich 28 Shop 29 30 Shop Hamburger & Tuna & Ruben & PBJ Sausage & 31 Total Fries Chips Chips beans 32 33 Sales 5,500,000 1,400,000 900,000 500,000 750,000 550,000 34 1,300,000 550,000 35 Margin 300.000 150,000 (50,000) 75,000 36 37 % Margin 24% 38 500,000 400,000 500,000 450.000 39 Assets 7,000,000 40 41 ROI 19% 42 43 44 Can the Sandwich Shop earn more than 24% at the margin line and 19% ROI? HOW? 45 46 This is really a random problem I made up and is only significant as an example, 250,000 25.000 750,000 400,000 4,000,000