Large retailers like The Home Depot and Wal-Mart typically use gross margin ratio (gross margin ÷ sales), inventory turnover (sometimes referred to as inventory turns), and gross margin return on...




Large retailers like The Home Depot and Wal-Mart typically use gross margin ratio (gross margin ÷ sales), inventory turnover (sometimes referred to as inventory turns), and gross margin return on investment (GMROI) to evaluate how well inventory has been managed. The goal is to maximize profits while minimizing the investment in inventory. Below are data for four scenarios, a base scenario (# 1) followed by three modifications (#s 2, 3, & 4) to the base scenario.










































Scenario A




Scenario B




Scenario C




Scenario D



Sales



$ 10,000



$ 20,000



$ 12,000



$ 10,000



Cost of goods sold



6,000



12,000



6,000



6,000



Gross profit



$ 4,000



$ 8,000



$ 6,000



$ 4,000



Average inventory



$ 6,000



$ 6,000



$ 6,000



$ 5,000






For each scenario calculate the gross margin percent, the inventory turnover, and GMROI.


Round your answers to one decimal place. (Example for % answers -- 99.9%)

















































Scenario 1




Scenario 2




Scenario 3




Scenario 4



Gross Margin %



Answer



%



Answer



%



Answer



%



Answer



%



Inventory Turnover



Answer



Answer



Answer



Answer



GMROI



Answer



%



Answer



%



Answer



%



Answer



%





May 19, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here