Question

Given the following information, formulate a continuous-review inventory management system. The item is demanded 50 weeks a year. 2. Item cost Order cost Annual holding cost (%) Annual demand Average demand $20 $250 10% df item cost 25,000 500 per week Standard deviation of weekly demand Lead time Service probability 25 per week 1 week 95% Compute the order quantity and reorder point. For the order quantity, please provide at least one step of calculation and the correct answer for full credit. For the reorder point, please provide the formula, at least one step of calculation, and the correct answer for full credit. (10 points)

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

Annual Demand (D) = 25000

Order cost (S) = 250

Holding cost (H) = 10%*Item cost = 10%*20 = 2

Average weekly demand (d) = 500

Standard deviation (SD) = 25 per week

Lead time (LT) = 1 week

Service probability is 95%. Z value for 95% is 1.645

Order quantity = sqrt(2*D*S/H) = sqrt(2*25000*250/2) = 2500

Reorder point = d*LT + z*SD*sqrt(LT) = 500*1 + 1.645*25*sqrt(1) = 541.125


answered by: ANURANJAN SARSAM
Add a comment
Know the answer?
Add Answer to:
Given the following information, formulate a continuous-review inventory management system. The item is demanded 50 weeks...
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
  • Problem 11-15 (Algo) Given the following information, formulate an inventory management system. The item is demanded...

    Problem 11-15 (Algo) Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year. PARAMETER VALUE PARAMETER VALUE Item cost $ 11.00 Standard deviation of weekly demand 30 per week Order cost $ 277.00 Lead time 1 week Annual holding cost 32 % of item cost Service probability 90 % Annual demand 26,900 Average weekly demand 538 per week a. Determine the order quantity and reorder point. (Use Excel's NORM.S.INV() function to find the...

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

  • Given the following information, formulate an inventory management system

    Problem 1. Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year.Last YearItem cost$10.00Order cost$250.00annual hold cost (%)33% of item costAnnual demand25,750average demand515per weekStandard deviation of weekly demand25per weeklead time1weekservice probability95%

  • Problem 5. Use EOQ model to solve following problem. The item is demanded 50 weeks a year. Item c...

    Problem 5. Use EOQ model to solve following problem. The item is demanded 50 weeks a year. Item cost: $10 Fixed Order cost: $250 Annual holding cost: 33% of item cost Average demand: 515 per week, constant rate a. Calculate the optimal order quantity and the total inventory cost. b. If your purchase quantity is equal to or above 2000, the fixed ordering cost is reduced to $200. Would you take advantage of it? How much would you save annually?

  • ​Sam's Cat Hotel operates 52 weeks per​ year and uses a continuous review inventory system. It...

    ​Sam's Cat Hotel operates 52 weeks per​ year and uses a continuous review inventory system. It purchases kitty litter for ​$10.75 per bag. The following information is available about these bags. Demand = 85 bags/week Order cost = $57/order Annual holding cost = 26% of cost per bag Desired cycle-service level = 90% Lead-time = 2 weeks Standard deviation of weekly demand = 18 bags What is the economic order quantity (EOQ) for kitty litter? What would be the average...

  • HELP! PLEASE Petromax Enterprises uses a continuous review inventory control system for one of its SKUs....

    HELP! PLEASE Petromax Enterprises uses a continuous review inventory control system for one of its SKUs. The following information is available on the item. The firm operates 52 weeks in a year. Demand = 91,000units/year Ordering cost​ = $32.50 ​Holding cost​ = $3.50/unit/year Average lead time​ = 4 Weeks Standard deviation of weekly demand​ = 250 units a. The economic order quantity for this item is ____units. (Enter your response rounded to the nearest whole​ number.) b. If Petromax wants...

  • Given the following information, formulate an inventory management system and determine the annual order cost: Item...

    Given the following information, formulate an inventory management system and determine the annual order cost: Item cost $5.00 Order cost $315.00 Annual holding cost (per unit per year)        $5.00 Annual demand 26,500 A. $3,290.74 B. $4,568.23 C. $4,615.40 D. $4,543.45 E. $3,730.89

  • Petty House operates 52 weeks per year, 6 days per week, and uses a continuous review inventory

    Petty House operates 52 weeks per year, 6 days per week, and uses a continuous review inventory system (i.e. Q system). It purchases kitty litter for $ 10 per bag. The following information is available about these bags. Demand = 102 bags/ week Order cost = $ 49/ order Annual holding cost = 25 percent of cogs Desired cycle service level = 80 percent Lead time = 3 weeks Standard deviation of weekly demand = 15 bags Current on-hand inventory...

  • Item Cost: $8.00 Order Cost: $287 Annual Holding Cost: 33% of item cost Annual Demand: 27,400...

    Item Cost: $8.00 Order Cost: $287 Annual Holding Cost: 33% of item cost Annual Demand: 27,400 Average Weekly Demand: 548 Std. Dev. of Weekly Demand: 20/week Lead Time: 3 weeks Service Probability: 99% Previously found Info: Optimal order quantity = 2441 units. Reorder point = 1725 units. Annual Holding Cost: $3222.12. Annual Order Cost: $3221.55. Assume a price break of $55 per order was offered for purchase quantities of 2,500 or more units per order. If you took advantage of...

  • Sam's Cat Hotel operates 52 weeks per year, 7 days per week, and uses a continuous...

    Sam's Cat Hotel operates 52 weeks per year, 7 days per week, and uses a continuous review inventory system. It purchases kitty litter for $11.25 per bag. The following information is available about these bags. Refer to the standard normal table for z-values. Demand 96 bags/week Order cost- $58/order >Annual holding cost 26 percent of cost > Desired cycle-service level 90 percent > Lead time 1 week(s) (7 working days) > Standard deviation of weekly demand 13 bags >Current on-hand...

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