Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Inventory Management Metrics Large retailers like Costco and Target typically use gross margin ratio (gross margin = sales), inventory turnover (sometimes referred to as inventory

image text in transcribed

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, and D) to the base scenario. Sales Cost of goods sold Gross profit Average inventory Scenario A Scenario B Scenario C Scenario D $ 50,000 $ 75,000 $ 60,000 $ 50,000 35,000 35,000 30,000 35,000 $ 15,000 $ 40,000 $ 30,000 $ 15,000 $ 6,000 $ 6,000 $ 6,000 $4,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 A Scenario B Scenario C Scenario D 30 % 53.3 % 50 % 30 % Gross Margin % Inventory Turnover GMROI 5.83 x 5.83 x 5 8.75 2.5 X % 6.66 X % 5 * % 3.75 X %

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting Information for Decision-Making and Strategy Execution

Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young

6th Edition

137024975, 978-0137024971

More Books

Students also viewed these Accounting questions