Question

Dunstreets Department store would like to develop an inventory ordering policy of 95% probability of not...

Dunstreets Department store would like to develop an inventory ordering policy of 95% probability of not stocking. To illustrate your recommended procedure, use as an example the ordering policy for white percale sheets Demand for white percale sheets is 5,000 per uear. The store is open 365 days per year. Every 2 weeks (14 days) inventory is counted and a new order is placed. It takes 10 days for the sheet to be delivered. Standard deviation of demand for the sheets is 5 per day. There is currently 150 sheets on hand. How many sheets should you order

0 0
Add a comment Improve this question Transcribed image text
Answer #1

The first step would be to find the z-value for a service probability of 0.95.

use Excel's NORM.S.INV for this purpose:

z=NORM.S.INV(0.95)=1.64z=NORM.S.INV(0.95)=1.64

Next we find the target inventory level:

Target = Daily Demand×(Lead Time+Review Time)+z×Standard Deviation of Daily Demand×√Lead Time+Review Time

=5,000/365×(10+14)+1.64∗5∗√10+14 ≈369 sheets

The store has 150 sheets available. Hence, the store should order 369−150=219 sheets

Add a comment
Know the answer?
Add Answer to:
Dunstreets Department store would like to develop an inventory ordering policy of 95% probability of not...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT