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
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?
Step by Step Solution
3.51 Rating (154 Votes )
There are 3 Steps involved in it
Step: 1
1GMROI Gross Margin Average Inventory at Cost 045 20000 4000 225 Inventory Turnover Cost of Goods So...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