2. Mountain Mouse makes freeze-dried meals for hikers. One of Mountain Mouse's biggest customers is a sporting goods superstore. Every 5 days, Mountain Mouse checks the inventory level at the superstore and places an order to restock the meals. These meals are delivered by UPS in 2 days. Average demand during the reorder period and order lead time is 100 meals, and the standard deviation of demand during this same time period is about 20 meals. CHAPTER 11 MAN a. (**) Calculate the restocking level for Mountain Mouse. Assume that the superstore wants a 90% service level. What happens to the restocking level if the superstore wants a higher level of service-say, 95%? b. (*) Suppose there are 20 meals in the superstore when Mountain Mouse checks inventory levels. How many meals should be ordered, assuming a 90% service level?

2. Mountain Mouse makes freeze-dried meals for hikers. One of Mountain Mouse's biggest customers is a sporting goods superstore. Every 5 days, Mountain Mouse checks the inventory level at the superstore and places an order to restock the meals. These meals are delivered by UPS in 2 days. Average demand during the reorder period and order lead time is 100 meals, and the standard deviation of demand during this same time period is about 20 meals. CHAPTER 11 MAN a. (**) Calculate the restocking level for Mountain Mouse. Assume that the superstore wants a 90% service level. What happens to the restocking level if the superstore wants a higher level of service-say, 95%? b. (*) Suppose there are 20 meals in the superstore when Mountain Mouse checks inventory levels. How many meals should be ordered, assuming a 90% service level?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Green Grass Industries Limited (GGIL) has used a fixed-time period inventory system that involved taking a complete inventory count of all items each month. However, increasing labor costs, are forcing GGIL, to examine alternative ways to reduce the amount of labor involved in inventory stockrooms, yet without increasing other costs, such a shortage costs. Table 10 is a random sample of 20 GGIL's items. Table 10. Annual Usage by Value of a sample of GGIL's Inventory Item Number Annual Usage ($) Item Number Annual Usage ($) 1 10,600 11 2,750 2 14,000 12 1,400 3 4,000 13 3,200 4 16,000 14 2,500 5 8,100 15 110,000 1,800 16 14,800 7 84,000 17 9,500 8. 890 18 1,700 9 940 19 3,700 10 94,000 20 12,500 a) What would you recommend GGIL to do to cut back its labor cost? (Illustrate using an ABC plan). b) Item 18 is critical to continued operations at GGIL. i. How would you recommend it be classified? ii. Give the reason(s) for your answer.
Gentle Ben’s Bar and Restaurant uses 5,000-quart bottles of 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 of 30 bottles. Ben would like to use an inventory system that minimizes inventory cost and will providea 95 percent service probability.a. What is the economic quantity for Ben to order?b. At what inventory level should he place an order?
weekly demand for hamleys (a famous toy brand) at a toy store is normally disrtibuted with a mean of 250 and a standrd devaiton of 150.Ther toy store is opened 7 days a week.The toy store owner continoulsy monitors the inventory .Hamleys takes 2 weeks to fill an order with a standard devaiton of 4 days. 1] how much inventory should the sotre carry at the reorder point. 2] how much inventory would that be at the reorder point if the cycle service was increased to 98%?
40 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 of 30 bottles. Ben would like to use an inventory system that minimizes inventory cost and will provide a 95 percent service probability. a. What is the economic quantity for Ben to order? Note: Round your answer to the nearest whole number.
Dalia, the office manager of a desktop publishing outfit, stocks replacement toner cartridges for laser printers. Demand for cartridges is approximately 30 per year and is quite variable (Le., can be represented using the Poisson distribution). Cartridges cost $100 each and require three weeks to obtain from the vendor. Dalia uses a (Q, r) approach to control stock levels (a). If Dalia wants to restrict replenishment orders to twice per year on average, what batch size Q should she use? If she wants to ensure a service level (i.e., probability of having the cartridge in stock when 2 out of 2 needed) of at least 98 percent, what reorder point r should she use? (Hint: Use Table 2.6.(b). If Dalia is willing to increase the number of replenishment orders per year to six, how do Q and r change? Explain the difference in r.
Palin's Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to manage inventory of this standard muffler. Use the information in the following table to determine the optimal inventory target level (or order-up-to level). $ 35 Ordering cost Service probability Lead time per order 2,970 6. mufflers Annual demand Standard deviation of daily demand mufflers per working day 89 % working days per muffler * of item value working days $21.00 4 Item cost 36 Working days 270 per year Annual holding cost Review period 22 a. What is the optimal target level (order-up-to level)? (Use Excel's NORMSINV) function to find the correct critical value for the given a-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.) Optimal target level b. If the service probability requirement is 90 percent, the optimal target level will: O Increase O Decrease O Stay…
Gentle Ben's Bar and Restaurant uses 7,200 quart bottles of an imported wine each year. The effervescent wine costs $9 per bottle and is served only in whole bottles because it loses its bubbles quickly. Ben figures that it costs $25 each time an order is placed, and holding costs are 40 percent of the purchase price. It takes six weeks for an order to arrive. Weekly demand is 144 bottles (closed two weeks per year) with a standard deviation of 40 bottles. Ben would like to use an inventory system that minimizes inventory cost and will provide a 99 percent service probability. a. What is the economic quantity for Ben to order? b. At what inventory level should he place an order?
Palin’s Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to manage inventory of this standard muffler. Use the information in the following table to determine the optimal inventory target level (or order-up-to level). Annual demand 2,750 mufflers Ordering cost $ 35 per order Standard deviation of daily demand 6 mufflers per working day Service probability 76 % Item cost $ 28.00 per muffler Lead time 4 working days Annual holding cost 22 % of item value Working days 275 per year Review period 21 working days a. What is the optimal target level (order-up-to level)? If the service probability requirement is 93 percent, the optimal target level will: Increase Decrease Stay the same
Saud Bhawan creates a demand of 10800 tires in a year. The company’s inventory carrying (holding) cost is estimated to be OMR 3 per unit per year and the ordering (setup) cost is OMR 50 per order. Calculate the Economic Order Quantity (EOQ). What is the number of orders per year? Compute the average annual setup (ordering) cost. Compute the annual average inventory. What is the average annual holding (carrying) cost? Compute the annual total cost.
Flamingo purchases 8,000 litres of ink each year for its production processes. The unit cost per litre is GH¢10, and the cost of carrying one litre of ink in inventory is GH¢3 per annum. Ordering cost is GH¢30 per order. Assuming that the firm operates on a 252-day working year, compute:(i). Expected number of orders placed each year(ii). Expected time between orders
Golden Crust Bakery buys flour in 25-pound bags. The bakery uses an average of 1,215 bags ayear. Preparing an order and receiving a shipment of flour involves a cost of $10 per order.Annual holding costs are $75 per bag. Once an order for flour is placed, it takes six (6) days toreceive the order from the flour factory. The bakery operates 350 days per year.Calculate the following:(i) Economic Order Quantity(ii) Expected number of orders (Order Frequency)(iii) Average inventory(iv) The annual holding cost(v) The annual ordering cost(vi) The total annual cost of inventory management(vii) Reorder point(viii) If holding costs were to increase by $9 per year, how much would thataffect the minimum total annual cost?
KVS Pharmacy fills prescriptions for a popular children’santibiotic, Amoxycilin. The daily demand for Amoxycilinis normally distributed with a mean of 200 ounces and a standard deviation of 80 ounces. The vendor for the phar-maceutical firm that supplies the drug calls the drug-store’s pharmacist every 30 days and checks the inventory of Amoxycilin. During a call the druggist indicated thestore had 60 ounces of the antibiotic in stock. The leadtime to receive an order is four days. Determine the order size that will enable the drugstore to maintain a 99% ser-vice level.