Question Details

(solution) The manager of the local store of a national home improvement


  1. 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 . (1 point) 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 . (1 point)


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

    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 . (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 is . (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 is . (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 is . (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 is . (1 point)


The manager of the local store of a national home improvement chain is studying their inventory system. He has c

 

demand data for this item has indicated a constant lead time of 12 days. Demand per...

 


Solution details:

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 13, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now