8. Weekly demand for detergent at a Walmart store is normally distributed, with a mean of 3,000 and a standard deviation of 700. The store manager continuously monitors detergent inventory and places a replenishment order for 10,000 units when there are 7,000 units in inventory. The supplier takes two weeks to supply a Walmart order. What CSL does the store achieve? What fill rate does the store achieve?

8. Weekly demand for detergent at a Walmart store is normally distributed, with a mean of 3,000 and a standard deviation of 700. The store manager continuously monitors detergent inventory and places a replenishment order for 10,000 units when there are 7,000 units in inventory. The supplier takes two weeks to supply a Walmart order. What CSL does the store achieve? What fill rate does the store achieve?

Name: How do I do question 8? 13. Magazineprovide a CSL of 95 percent? How d
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: How do I do question 8? 13. Magazineprovide a CSL of 95 percent? How does the required safetyinventory change as the standard deviation of lead time istronics. THreduced from 1.5 weeks to zero in intervals of 0.5 weeks?across Bra:8. Weekly demand for

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 40P

See similar textbooks

Similar questions

Annual demand for number 2 pencils at the campus store is normallydistributed with mean 1,000 and standard deviation 250. The store purchases thepencils for 6 cents each and sells them for 20 cents each. There is a two-monthlead time from the initiation to the receipt of an order. The store accountantestimates that the cost in employee time for performing the necessary paperworkto initiate and receive an order is $20, and recommends a 22 percent annual interest rate for determining holding cost. The cost of a stock-out is the cost of lostprofit plus an additional 20 cents per pencil, which represents the cost of loss ofgoodwill.d. What is the safety stock for this item at the optimal solution?
Annual demand for number 2 pencils at the campus store is normallydistributed with mean 1,000 and standard deviation 250. The store purchases thepencils for 6 cents each and sells them for 20 cents each. There is a two-monthlead time from the initiation to the receipt of an order. The store accountantestimates that the cost in employee time for performing the necessary paperworkto initiate and receive an order is $20, and recommends a 22 percent annual interest rate for determining holding cost. The cost of a stock-out is the cost of lostprofit plus an additional 20 cents per pencil, which represents the cost of loss ofgoodwill.b. Find the simultaneous optimal values of Q and R.
Motorama TV estimates the annual demand for its TVsis (and will be in the future) normally distributed, with amean of 6,000 and standard deviation of 2,000. Motorama must determine how much production capacity it shouldhave. The cost of building enough production capacity tomake 1,000 sets per year is $1,000,000 (equivalent in presentvalue terms to a cost of $100,000 per year forever). Exclusiveof the cost of building capacity, each set sold contributes$250 to profits. How much production capacity shouldMotorama have?
3. A pastry shop is considering how much hot chocolate to prepare each morning. Hot chocolate costs $0.10 per oz to make and sells for $0.40 per oz. Customers can buy hot chocolate in any number of ounces that they wish. Any hot chocolate not sold by the end of the day is discarded. The daily demand for hot chocolate is normally distributed with a mean of 1,200 oz and a standard deviation of 150 oz. How much hot chocolate should the pastry shop make each morning? You may use a z-table for this question.
Annual demand for number 2 pencils at the campus store is normallydistributed with mean 1,000 and standard deviation 250. The store purchases the pencils for 6 cents each and sells them for 20 cents each. There is a two-month lead time from the initiation to the receipt of an order. The store accountant estimates that the cost in employee time for performing the necessary paperwork to initiate and receive an order is $20, and recommends a 22 percent annual interest rate for determining holding cost. The cost of a stock-out is the cost of lost profit plus an additional 20 cents per pencil, which represents the cost of loss of goodwill.a. Find the optimal value of the reorder point R assuming that the lot size used is the EOQ.b. Find the simultaneous optimal values of Q and R.c. Compare the average annual holding, setup, and stock-out costs of the policies determined in parts (a) and (b).d. What is the safety stock for this item at the optimal solution?
1. The demand for a product of Carolina Industries varies greatly from month to month. Based on the past three years of data, the following shows the monthly demand at Carolina Industries. Unit Demand # Months 300 6 400 8 500 12 600 10 A.If the company places monthly orders equal to the expected value of the monthly demand, what should Carolina’s monthly order quantity be for this product? B. What are the variance and the standard deviation for the number of units demanded?
13 Pam’s demand for hats is normally distributed with mean 500 and standard deviation 100. She sells her hats for $50 each and buys hats for $10 each, and anything she can't sell by the end of the year, the wholesaler will buy for $5 each. How many hats should she order for next year to maximize profit?
Annual demand for number 2 pencils at the campus store is normally distributed with mean 1,000 and standard deviation 250. The store purchases the pencils for 6 cents each and sells them for 20 cents each. There is a two-month lead time from the initiation to the receipt of an order. The store accountant estimates that the cost in employee time for performing the necessary paperwork to initiate and receive an order is $20, and recommends a 22 percent annual interest rate for determining holding cost. The cost of a stock-out is the cost of lost profit plus an additional 20 cents per pencil, which represents the cost of loss of goodwill. Consider the problem of satisfying the demand for number 2 pencils faced by the campus store mentioned above.a. Re-solve the problem, substituting a Type 1 service level criterion of 95 percent for the stock-out cost.b. Re-solve the problem, substituting a Type 2 service level criterion of 95 percent for the stock-out cost. Assume that Q is given by the…
Suppose that the manager of a construction supply house determined from historical recordsthat demand for sand during lead time averages 50 tons. In addition, suppose the managerdetermined that demand during lead time could be described by a normal distribution thathas a mean of 50 tons and a standard deviation of 5 tons. Answer these questions, assumingthat the manager is willing to accept a stockout risk of no more than 3 percent:a. What value of z is appropriate?
Aboloway Company stocks a part that has a daily demand represented by the empirical distribution (shown in the table below). When restocking this part, the average lead time from the supplier is 3 days with a standard deviation of 0.5 days. The plant manager wants to determine how much safety stock to maintain for this part to ensure that stock-outs will not be incurred in more than 5.5% of the order cycles. Daily demand (d) in units Frequency 5 10 10 35 15 65 20 32 25 8 Total Observations = 150 3a. Find the mean and standard deviation for demand. 3b. Based on the information in problems 3 and 3a, what is the mean and standard deviation of demand during the lead time? 3c. Based on the information in problems 3, 3a, and 3b, how much safety stock should the plant manager maintain to ensure that stock-out will not be incurred in more than 5.5% of the order cycles?
Henrique Correa's bakery prepares all its cakesbetween 4 A.M. and 6 A.M. so they will be fresh when customersarrive. Day-old cakes are virtually always sold, but at a 50% discountofT the regular $ 10 price. The cost of baking a cake is $6, anddemand is estimated to be normally distributed, with a mean of25and a standard deviation of 4. What is the optimal stocking level?
Forrest and Dan make boxes of chocolates for which the demand is uncertain. Forrest says, “That’s life.” On the other hand, Dan believes that some demand patterns exist that could be useful for planning the purchase of sugar, chocolate, and shrimp. Forrest insists on placing a surprise chocolatecovered shrimp in some boxes so that “You never know what you’ll get.” Quarterly demand (in boxes of chocolates) for the last 3 years follows: Quarter Year 1 Year 2 Year 3 1 2 3 4 3,000 1,700 900 4,400 3,300 2,100 1,500 5,100 3,502 2,448 1,768 5,882 Total 10,000 12,000 13,600 a. Use intuition and judgment to estimate quarterly demand for the fourth year.b. If the expected sales for chocolates are 14,800 cases for year 4, use the multiplicative seasonal method to prepare a forecast for each quarter of the year. Are any of the quarterly forecasts different from what you thought you would get in part (a)?