Question

Mountain Mouse makes freeze-dried meals for hikers. One of Mountain Mouses 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. Click the icon to view the table of z values. 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 The restocking level for the 90% service level is 126 meals. (Enter your response rounded up to the next whole number.) The restocking level for the 95% service level is 133 meals. (Enter your response rounded up to the next whole number.) 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? The number of meals to order isEnter your response as a whole number) say 95%?

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

SEE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. HAPPY TO HELP YOU. THUMBS UP PLEASE.THANK YOU

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text ta copy. в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard BX20 BS Alignment Number Cells BU BV BW BX BZ CA CB CD CE CF CG 4 RESTOCKING LEVEL AVERAGE DEMAND z STANDARD DEVIATION 100 20 6 AVERAGE DEMAND STANDARD DEVIATION 9 RESTOCKING LEVEL AT 9096 SERVICE LEVEL = 100 + 1.28*20 10 125.6 126 ROUNDED UP 12 13 14 15 16 17 18 19 20 21 RESTOCKING LEVEL AT 95% SERVICE LEVEL = 100 + 1.65*20 133 NO OF MEALS TO BE ORDERED NO OF MEALS TO BE ORDERED = RESTOCKING LEVEL AT 9096 SERVICE LEVEL-STOCK AVAILABLE 126-20 106 LINE OF CREDIT miler Sheet3 BANKER ACCEPTANC FACTOR erences: AR18 11-01-2019

Add a comment
Know the answer?
Add Answer to:
Mountain Mouse makes freeze-dried meals for hikers. One of Mountain Mouse's biggest customers is a sporting...
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 2 - Bookmatch Question Help * Mountain Mouse makes freeze-dried meals for hikers. One of...

    Problem 2 - Bookmatch Question Help * 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...

  • More Info Resulting service level (%) 90 95 z value 1.28 1.65 2.33 3.08 99.9 PrintDone...

    More Info Resulting service level (%) 90 95 z value 1.28 1.65 2.33 3.08 99.9 PrintDone Problem 2 - Bookmatch Question Help * 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...

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

  • 13.38. Kelly's Tavern serves Shamrock draft beer to its customers The daily demand for beer is normally distrib...

    13.38. Kelly's Tavern serves Shamrock draft beer to its customers The daily demand for beer is normally distributed, with an average of 20 gallons and a standard deviation of 4 gallons. The lead time re- quired to receive an order of beer from the local distributor is 12 days. Determine the safety stock and reorder point if the restaurant wants to maintain a 90% service level. What would be the increase in the safety stock if a 95% service level...

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

  • A company manages its inventory for a specific item using the periodic review inventory model with...

    A company manages its inventory for a specific item using the periodic review inventory model with 10 days between orders. It is currently time to place an order, and the company notes that there are 140 items on hand. The item to be replenished has a lead time of 6 days with a daily demand of 440 units. The standard deviation of demand during the uncertainty period has been calculated to be 65. If the company wants to have at...

  • PLEASE be sure to label answers. Thank you. A drugstore uses fixed-order cycles for many of...

    PLEASE be sure to label answers. Thank you. A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a service level of 90. The order interval is 11 days, and lead time is 1 days. Average demand for one item is 76 units per day, and the standard deviation of demand is 4 units per day. Given the on-hand inventory at the reorder time for each order cycle shown in the following table. Use Table...

  • High Tech Inc. is a virtual store that stocks a variety of calculators in its warehouse. Customer orders are placed; the orders are picked and packaged; and then orders are shipped to the customers. A...

    High Tech Inc. is a virtual store that stocks a variety of calculators in its warehouse. Customer orders are placed; the orders are picked and packaged; and then orders are shipped to the customers. A fixed-order-quantity inventory control system (FQS) helps monitor and control these SKUs. The following information is for one of the calculators that High Tech stocks, sells, and ships. Average demand 9.5 calculators per week Lead time 5 weeks Order cost $15/order Unit cost $10.00 Carrying charge...

  • Meena Distributors has an annual demand for an airport metal detector of 1,360 units. The cost...

    Meena Distributors has an annual demand for an airport metal detector of 1,360 units. The cost of a typical detector to Meena is $400. Carrying cost is estimated to be 18% of the unit cost, and the ordering cost is $27 per order. If Purushottama Meena, the owner, orders in quantities of 300 or more, he can get a 5% discount on the cost of the detectors. Should Meena take the quantity discount? What is the EOQ without the discount?...

  • Problem 6- Fixed Order Interval (FOI) Demand for walnut fudge ice cream at the Sweet Cream...

    Problem 6- Fixed Order Interval (FOI) Demand for walnut fudge ice cream at the Sweet Cream Dairy can be approximated by a normal distribution with a mean of 21 gallons per week and a standard deviation of 3.2 gallons per week. The new manager desires a service level of 90 percent. Lead time is two days, and the dairy is open seven days a week. (Hint: Work in terms of weeks.) Use Table B and Table B1. a-1. If an...

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