Question
Inventory Management Metrics Large retailers like Costco and Target typically use gross margin ratio (gross margin sales), inventory turnover (sometimes referred to as inventory turns),
Inventory Management Metrics Large retailers like Costco and Target 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 (A) followed by three modifications (B, C, & D) to the base scenario.
Scenario A | Scenario B | Scenario C | Scenario D | |
---|---|---|---|---|
Sales | $ 30,000 | $ 60,000 | $ 36,000 | $ 30,000 |
Cost of goods sold | 18,000 | 30,000 | 15,000 | 15,000 |
Gross profit | $ 12,000 | $ 30,000 | $ 21,000 | $ 15,000 |
Average inventory | $ 9,000 | $ 9,000 | $ 9,000 | $ 7,500 |
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 A | Scenario B | Scenario C | Scenario D | |||||
---|---|---|---|---|---|---|---|---|
Gross Margin % | Answer | % | Answer | % | Answer | % | Answer | % |
Inventory Turnover | Answer | Answer | Answer | Answer | ||||
GMROI | Answer | % | Answer | % | Answer | % | Answer | % |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started