1) Calculate the GMROI and inventory turnover Given $20,000 in annual sales, $4,000 in average inventory (at...
Question:
1) Calculate the GMROI and inventory turnover
Given $20,000 in annual sales, $4,000 in average inventory (at cost) and a 45% gross margin.
2) Calculate the additions to the stock using the following information:
Sales | 26.000 $ |
EOM stock | 100.000 $ |
bill of materials stock | 88.000 $ |
3) Calculate the average BOM stock-to-sales ratio for the six-month merchandise budget plan, using the following information:
YGROI %130
Gross Margin 46%
4) Today is July 19th. Buyers in two different stores are trying to assess the current open-to-buy situation based on the following information:
Store A: Actual bill of materials stock | 50.000 $ |
Monthly additions are real | 25.000 $ |
Products to be delivered on order | 10.000 $ |
Planned monthly sales Planned discounts | 30.000 $ 5.000 $ |
Planned SGM stock | 65.000 $ |
Store B: Actual bill of materials stock | 75.000 $ |
Monthly additions are real | 30.000 $ |
Products to be delivered on order | 12.000 $ |
Planned monthly sales Planned discounts | 40.000 $ $6,000 |
Planned SGM stock | 75.000 $ |
What is the status open for purchase on July 19? What does this number mean for you for each store?
5) If a food retailer has a product with a 7-day lead time, a 10-day inspection period, and a daily demand of 8 units, what is the order point and how many units must be reordered? Suppose 70 units are ready and the retailer must maintain a reserve stock of 20 units to maintain a 98 percent service level?
6) A retailer expects a good month and adjusts its sales forecast upwards of $750. Calculate the March open value using the following information: (1 point).
Planned purchases (March) | 32.000 $ |
Monthly additions are real | 21.000 |
Made-to-order items (March) | 8.000 |
Unused available for purchase (February) | 2.000 |
7) The Sports Store's starting inventory is $12,000 and the planned ending inventory is $13,400. Planned sales for the period are $5,800. Calculate what is open to purchase for the month.
8) If a retailer has a product with a lead time of 10 days, a review period of 15 days, a daily demand of 18 units, and 82 units on hand, what is the reorder point and how many units must be reordered? and should the retailer maintain a reserve stock of 27 units to maintain the 95% service level?
Retailing Management
ISBN: 978-1259573088
10th edition
Authors: Michael Levy, Barton Weitz, Dhruv Grewal