Question: * Show work in excel please* The manager at Goodstone Tires, a distributor of tires in Illinois, uses a continuous review policy to manage their

* Show work in excel please*

The manager at Goodstone Tires, a distributor of tires in Illinois, uses a continuous review policy to manage their inventory. The manager currently orders 10,000 tires when the inventory of tires drops to 6,000. Weekly demand for tires is normally distributed with a mean of 2,000 and a standard deviation of 500. The replenishment lead for tires is two weeks. Each tire costs Goodstone $40 and the company sells each tire for $80. Goodstone incurs a holding cost of 25 percent.

How much safety inventory does Goodstone currently carry?

How much safety inventory should Goodstone carry if the cost of understocking is $80 per tire in lost current and future margin?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

*Show work in Excel please* The manager at Goodstone Tires, a distributor of tires in Illinois, uses a continuous review policy to manage their inventory. The manager currently orders 10,000 tires...

please write your answer by explaining. not as an excel functs. Q3. The manager at Goodstone Tires, a distributor of tires in Illinois, uses a continuous review policy to manage inventory. The...

Exercise 13.1 Green Thumb, a manufacturer of lawn care equipment, has introduced a new product. Each unit costs $150 to manufacture, and the introductory price is $200. At this price, the anticipated...

Q3. The manager at Goodstone Tires, a distributor of tires in Illinois, uses a continuous review policy to manage inventory. The manager currently orders 10,000 tires when the inventory of tires...

The manager at Goodstone Tires, a distributor of tires in Illinois, uses a continuous review policy to manage inventory. The manager currently orders 10,000 tires when the inventory of tires drops to...

Q3. The manager at Goodstone Tires, a distributor of tires in Illinois, uses a continuous review policy to manage inventory. The manager currently orders 10,000 tires when the inventory of tires...

Q. The manager at Goodstone Tires, a distributor of tires in Illinois, uses a continuous review policy to manage inventory. The manager currently orders 10,000 tires when the inventory of tires drops...

Overview The purpose of this exercise is for students to learn how to identify those factors affecting the optimal level of product availability, associate these with managerial levers to improve...

3: The manager at Goodstone Tires, a distributor of tires in Illinois, uses a continuous review policy to manage their inventory. The manager currently orders 10,000 tires when the inventory of tires...

For each of the lenses in the figure, list whether the lens is converging or diverging. (a) (b) (c) (d)

What are the two big approaches to thinking about fairness?

Group of answer choices sinx sinx 1 sinx cosx 1 cosx

Kelsey, a senior accountant at a multi-office CPA firm, is assigned to the audit of Compo Corporation. Compo is a closely held corporation and a major client of the firm. During the audit, Kelsey...