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

Given data: Review period R = 5 daysLead time LT=2 days Average demand =100 mealsThe standard…

Answered: 2. Mountain Mouse makes freeze-dried…

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

Golden Crust Bakery buys flour in 25-pound bags. The bakery uses an average of 1,215 bags a year. 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 to receive the order from the flour factory. The bakery operates 350 days per year. Calculate the following: Economic Order Quantity Expected number of orders (Order Frequency) Average inventory The annual holding cost The annual ordering cost The total annual cost of inventory management Reorder point If holding costs were to increase by $9 per year, how much would that affect the minimum total annual cost?
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.
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?
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?
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%?
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 days for the sheets to be delivered. Standard deviation of demand for the sheets is five per day. There are currently 170 sheets on hand. How many sheets should you order?
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.
Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 112, 500 units per year, an ordering cost of $3 per order, and carrying costs of $1.20 per unit. a. What is the economic ordering quantity? b. How many orders will be placed during the year? c. What will the average inventory be? d. What is the total cost of ordering and carrying inventory?
University Drug Pharmaceuticals orders its antibiotics every two weeks (14 days) when a salesperson visits from one of the pharmaceutical companies. Tetracycline is one of its most prescribed antibiotics, with average daily demand of 2,000 capsules. The standard deviation of daily demand was derived from examining prescriptions filled over the past three months and was found to be 800 capsules. It takes f ive days for the order to arrive. University Drug would like to satisfy 99 percent of the prescriptions. The salesperson just arrived, and there are currently 25,000 capsules in stock.How many capsules should be ordered?
As the Manager of Branson’s Department Store, you are responsible for ensuring that reorder quantities for the various items have been correctly established. You decide to test one item and choose product Z. A continuous review inventory policy has been used, so you examine this as well as other records and come up with the following data: Cost per unit $35 Holding cost 20 percent of unit cost Average daily demand 10 units Ordering cost $30 per order Standard deviation of daily demand 3 units Delivery lead time 4 days Because customers generally do not wait but go elsewhere, you decide on a service probability of 90 percent. Assume that Branson’s Department Store operates 320 days per year. [What is the annual demand (D)? Determine the optimal order quantity, Q*. Determine the reorder point (R) if demand is constant. Determine the reorder point (R) if demand is varies.
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.
KVS Pharmacy stocks a popular brand of over the counter flu and cold medicine. The average demand for the medicine is six packages per day, with a standard deviation of 1.2 packages. A vendor for the pharmaceutical company checks KVS’s stock every 60 days. During one visit, the store had eight packages in stock. The lead time to receive an order is five days. Determine the order size for this order period that will enable KVS to maintain a 95% service level.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS