Question

Week5 Saved Help Save & Exit Submi Lieutenant Commander Data is planning to make his monthly (every 30 days) trek to Gamma Hy
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Daily Demand d = 5

SD of Demand = 2

Review Period P = 30

Lead Time LT = 5 days

Service Level = 95%

Z = 1.64

a)

On Hand Inventory I = 25

Optimal Order Quantity Q = d*(P+LT) + Z*Sd of Demand*(P+LT)^(1/2) - I

Q = 5*(30+5) + 1.64*2*(30+5)^(1/2) - 25

Q = 169.40 units

Q = 169 units

b)

Order quantity will be max when on hand inventory will be 0.

Q = 5*(30+5) + 1.64*2*(30+5)^(1/2) - 0

Q = 194.40

Q = 194 units

Add a comment
Know the answer?
Add Answer to:
Week5 Saved Help Save & Exit Submi Lieutenant Commander Data is planning to make his monthly...
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
  • Sarved Help Save & Exit Submit Week5 The local supermarket buys lettuce each day to ensure...

    Sarved Help Save & Exit Submit Week5 The local supermarket buys lettuce each day to ensure really fresh produce. Each morning, any lettuce that is left from the previous day is sold to a dealer that resells it to farmers who use it to feed their animals. This week, the supermarket can buy fresh lettuce for $700 a box. The lettuce is sold for $16.00 a box and the dealer that sells old lettuce is willing to pay $4.00 a...

  • nt Week5 Saved Help Save & Exit Subm The annual demand for a product is 14,800...

    nt Week5 Saved Help Save & Exit Subm The annual demand for a product is 14,800 units. The weekly demand is 285 units with a standard deviation of 95 units. The cost to place an order is $31.00, and the time from ordering to receipt is two weeks. The annual inventory carrying cost is $0.20 per unit. a. Find the reorder point necessary to provide a 90 percent service probability. (Use Excel's NORM.S.INVO) function to find the z value. Round...

  • nt Weeks Served Help Save & Exit Submit 5 days Daily demand for a products 90...

    nt Weeks Served Help Save & Exit Submit 5 days Daily demand for a products 90 units, with a standard deviation of 30 units. The review period is 20 days and the lead time At the time of review, there are 20 units in stock. If 98 percent service probability is desired, how many units should be ordered? (Use Excel's NORM.S.INV() function to find the z value. Round z value to 2 decimal places and final answer to the nearest...

  • Week5 Saved Help Save & Exit Sub Item X is a standard item stocked in a...

    Week5 Saved Help Save & Exit Sub Item X is a standard item stocked in a company's inventory of component parts. Each year the firm, on a random basis, uses about 2,600 of item X, which costs $25 each. Storage costs, which include insurance and cost of capital, amount to $7 per unit of average inventory. Every time an order is placed for more of item X, it costs $26. a. Whenever item X is ordered, what should the order...

  • Dunstreet's Department Store would like to develop an inventory ordering policy with a 99 percent probability...

    Dunstreet's Department Store would like to develop an inventory ordering policy with a 99 percent probability of not stocking out. To illustrate your recommended procedure, use as an example the ordering policy for white percale sheets. Demand for white percale sheets is 4,300 per year. The store is open 365 days per year. Every four weeks (28 days) inventory is counted and a new order is placed. It takes 12 days for the sheets to be delivered. Standard deviation of...

  • Gentle Ben's Bar and Restaurant uses 5,000 quart bottles of an imported wine each year. The...

    Gentle Ben's Bar and Restaurant uses 5,000 quart bottles of an imported wine each year. The effervescent wine costs $3 per bottle and is served only in whole bottles because it loses its bubbles quickly. Ben figures that it costs $10 each time an order is placed, and holding costs are 20 percent of the purchase price. It takes three weeks for an order to arrive. Weekly demand is 100 bottles (closed two weeks per year) with a standard deviation...

  • Problem 11-23 (Static) Gentle Ben's Bar and Restaurant uses 5,000 quart bottles of an imported wine each year. The...

    Problem 11-23 (Static) Gentle Ben's Bar and Restaurant uses 5,000 quart bottles of an imported wine each year. The effervescent wine costs $3 per bottle and Is served only in whole bottles because it loses its bubbles quickly. Ben figures that it costs $10 each time an order is placed, and holding costs are 20 percent of the purchase price. It takes three weeks for an order to arrive. Weekly demand is 100 bottles (closed two weeks per year) with...

  • Problem 20-13 "periodic review system - similar to Alt-Cat 20.4* Dunstreet's Department Store would like to...

    Problem 20-13 "periodic review system - similar to Alt-Cat 20.4* Dunstreet's Department Store would like to develop an inventory ordering policy of a 90 percent probability of not stocking out. To illustrate your recommended procedure, use as an example the ordering policy for white percale sheets. Demand for white percale sheets is 3,400 per year. The store is open 365 days per year. Every two weeks (14 days) inventory is counted and a new order is placed. It takes 12...

  • Surved Help Sove & Exit Given the following information, formulate an inventory management system. The item...

    Surved Help Sove & Exit Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year. PARAMETER Item cost Order cost Annual holding cost Annual deland Average Keekly demand VALUE $ 7.00 $283.ee 32% of item cost 22,100 442 per week PARAMETER Standard deviation of weekly demand Lead time Service probability VALUE 20 per week 1 week 95% a. Determine the order quantity and reorder point (Use Excel's NORM.S.INV() function to find the z...

  • Dunstreet's Department Store would like to develop an inventory ordering policy of a 90 percent probability...

    Dunstreet's Department Store would like to develop an inventory ordering policy of a 90 percent probability of not stocking out. To Wustrate your recommended procedure, use as an example the ordering policy for white percale sheets. Demand for white percale sheets is 3.400 per year. The store is open 365 days per year. Every two weeks (14 days) inventory is counted and a new order is placed. It takes 12 days for the sheets to be delivered. Standard deviation of...

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