Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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... 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_2

Step: 3

blur-text-image_3

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

Retailing Management

Authors: Michael Levy, Barton Weitz, Dhruv Grewal

10th edition

1259573087, 978-1259573088

More Books

Students also viewed these Accounting questions

Question

Are there diff erent kinds of memory?

Answered: 1 week ago