Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The manager in the local store of a national home improvement chain is studying their inventory system. He has chosen one high volume product as

The manager in the local store of a national home improvement chain is studying their inventory system. He has chosen one high volume product as the first product to examine. The historical supply and demand data for this item has indicated a constant lead time of 16 days. Demand per day (d) is normally distributed with a mean demand of 1000 per day and standard deviation of 240 per day. He plans to set the in-stock probability (or service level) for this item at 90% during lead time. The ordering cost for this item is $500 per order. The product cost is $10 per unit. The annual inventory carrying cost is 30% of the item cost per year. The store operates 250 days a year. The manager decides to use the fixed quantity system (reorder point and economic order quantity). Based on the information provided, answer the following questions.

1. Use "NORMSINV" function in Excel to find the accurate z value. Based on the z value found, what is the safety stock level for this item? Round your answer to the nearest integer. Your answer (the safety stock level) is Blank 1

. (1 point)

2. What is reorder point? Round your answer to the nearest integer. Your answer is Blank 2

. (1 point)

3. What is the economic order quantity? Round your answer to the nearest integer. Your answer is Blank 3

. (1 point)

4. Using your answer in 3 (for example, if your answer for question 3 is 1231 after rounding, use 1231 here), how many orders will be placed per year under the policy you find? Round your answer to the nearest integer. Your answer isBlank 4

. (1 point)

5. Using your answers of safety stock in question 1 and EOQ in question 3, what is the average inventory level under the order policy you find (including cycle inventory and safety inventory)? Round your answer to the nearest integer. Your answer isBlank 5

. (1 point)

6. What is the annual ordering cost? Note: use your answer from question 4. Round your answer to the nearest integer. Your answer isBlank 6

. (1 point)

7. Using your answer from question 5, what is the annual inventory carrying cost including both cycle inventory and safety inventory? Round your answer to the nearest integer. Your answer isBlank 7

. (1 point)

8. Based on your answers to question 6 and 7, what is the total annual inventory cost? Round your answer to the nearest integer. Your answer isBlank 8

. (1 point)

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_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

Fundamental Managerial Accounting Concepts

Authors: Thomas Edmonds

6th Edition

78110890, 978-0078110894

More Books

Students also viewed these Accounting questions

Question

2. Develop a good and lasting relationship

Answered: 1 week ago

Question

1. Avoid conflicts in the relationship

Answered: 1 week ago