What is the safety stock level for this item

Assignment Help Operation Management

Reference no: EM131681344

The manager of 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 12 days. Demand per day (d) is normally distributed with a mean demand of 2000 per day and standard deviation of 250 per day. He plans to set the in-stock probability (or service level) for this item at 80% 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 25% of the item cost per year. The store operates 300 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. What is the safety stock level for this item? Round your answer to the nearest integer. Your answer is. Note: use “NORMSINV” function in Excel to find the accurate z value.

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

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

4. Using your rounded answer from last question (question 3), how many orders will be placed per year under the policy you find? Round your answer to the nearest integer. Your answer is.

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

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

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

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

Reference no: EM131681344

Questions Cloud

Design a query-a set of sql statements that returns all rows : Two SQL Statements that return a subset of columns and a subset of rows using the WHERE clause.

Current event or issue in the field of him : Identify a current event or issue in the field of HIM and outline how you would structure a systematic research review process around such issues?

How would you design the federal governments cybersecurity : How would you reduce weaknesses? How would you design the federal government's cybersecurity management integration across agencies?

Find the cost of the puchased item : Suppose you are purchasing something online on the Internet. At the website, you get a 10% discount if you are a member.

What is the safety stock level for this item : What is the safety stock level for this item? Round your answer to the nearest integer. What is the economic order quantity?

What is the company that you have chosen : Consider an example of a type of company that could be helped by running an MRP system. Answer the following questions about such a company:

Write a functon for the leap year : A leap year in the Gregorian calendar system is a year that's divisible by 4 but not by 100, unless it is also divisible by 400. For example, 1896, 1904.

Define scope and produce a scope management plan : Determine the timeframe for achieving the MOV - ask yourselves, when do we want to achieve this target metric?

Type of process management activities : The State university experience. What type of process management activities should State University undertake?

User Account

All Pages