QUESTION (ONLY NEED QUESTION #4 EXCEL LINE 31 ANSWERED):

DATA FOR QUESTION (THE INFORMATION BELOW IS FOR REFERENCE ONLY):

31 4. For Scenarios 2 through 4, explain what change occurred relative to Scenario 1 to cause the gross margin return on inventory (GMROI) to change. You need to specifically discuss each scenario change separately in comparison to scenario 1 by discussing the changes in the gross margin percent and 32 inventory turnover. 33 Type your response into the text box below: 34 1 Part 2 3 Below are data for four scenarios. Scenario 1 is the base scenario and the other 3 scenarios are modifications to the base scenario. 6 Sales 7 Cost of Goods Sold 8 Gross Profit Scenario 1 Scenario 2 Scenario 3 Scenario 4 $10,000 $20,000 $10,000 $10,000 8.000 10.000 6,000 8,000 $2,000 $10,000 $4,000 $2,000 $ 5,000 $5,000 $ 5.000 $ 4.000 10 Average Inventory 11 19 2. Compute the inventory turnover for each scenario. 20 21 Scenario 1 Scenario 2 Scenario 3 Scenario 4 22 Inventory Turnover 23 24 25 3. Compute the gross margin return on inventory investment percent for each scenario. 27 Scenario 1 Scenario 2 Scenario 3 Scenario 4 Gross margin return on inventory 28 investment 29