Don's Hardware uses a Periodic Order System to place once monthly orders for the majority of the products he sells in his store. One product using this system is the 32 oz Roundup Concentrated Weed and Grass Killer - a product that is extremely popular in the residential areas that Don serves. Don closely tracks the demand of all products sold in his hardware store and knows that 32oz Roundup Concentrate follows a normal distribution of demand that has a mean of 375 bottles with a standard deviation of 100. This month, prior to placing the order, Don had 72 bottles in stock. Using a periodic ordering method, how many bottles of the 32 oz Concentrate should Don order? To answer this question assume that for this product Don wants be be in stock at least 90% of the time. A) 509 B) 432 C) 581 D) 504 E) 375

Don's Hardware uses a Periodic Order System to place once monthly orders for the majority of the products he sells in his store. One product using this system is the 32 oz Roundup Concentrated Weed and Grass Killer - a product that is extremely popular in the residential areas that Don serves. Don closely tracks the demand of all products sold in his hardware store and knows that 32oz Roundup Concentrate follows a normal distribution of demand that has a mean of 375 bottles with a standard deviation of 100. This month, prior to placing the order, Don had 72 bottles in stock. Using a periodic ordering method, how many bottles of the 32 oz Concentrate should Don order? To answer this question assume that for this product Don wants be be in stock at least 90% of the time. A) 509 B) 432 C) 581 D) 504 E) 375

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section10.5: Introduction To @risk

Problem 20P: Use @RISK to analyze the sweatshirt situation in Problem 14 of the previous section. Do this for the...

See similar textbooks

Similar questions

The annual demand for Prizdol, a prescription drug manufactured and marketed by the NuFeel Company, is normally distributed with mean 50,000 and standard deviation 12,000. Assume that demand during each of the next 10 years is an independent random number from this distribution. NuFeel needs to determine how large a Prizdol plant to build to maximize its expected profit over the next 10 years. If the company builds a plant that can produce x units of Prizdol per year, it will cost 16 for each of these x units. NuFeel will produce only the amount demanded each year, and each unit of Prizdol produced will sell for 3.70. Each unit of Prizdol produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. a. Among the capacity levels of 30,000, 35,000, 40,000, 45,000, 50,000, 55,000, and 60,000 units per year, which level maximizes expected profit? Use simulation to answer this question. b. Using the capacity from your answer to part a, NuFeel can be 95% certain that actual profit for the 10-year period will be between what two values?
Dilberts Department Store is trying to determine how many Hanson T-shirts to order. Currently the shirts are sold for 21, but at later dates the shirts will be offered at a 10% discount, then a 20% discount, then a 40% discount, then a 50% discount, and finally a 60% discount. Demand at the full price of 21 is believed to be normally distributed with mean 1800 and standard deviation 360. Demand at various discounts is assumed to be a multiple of full-price demand. These multiples, for discounts of 10%, 20%, 40%, 50%, and 60% are, respectively, 0.4, 0.7, 1.1, 2, and 50. For example, if full-price demand is 2500, then at a 10% discount customers would be willing to buy 1000 T-shirts. The unit cost of purchasing T-shirts depends on the number of T-shirts ordered, as shown in the file P10_36.xlsx. Use simulation to determine how many T-shirts the company should order. Model the problem so that the company first orders some quantity of T-shirts, then discounts deeper and deeper, as necessary, to sell all of the shirts.
Use @RISK to analyze the sweatshirt situation in Problem 14 of the previous section. Do this for the discrete distributions given in the problem. Then do it for normal distributions. For the normal case, assume that the regular demand is normally distributed with mean 9800 and standard deviation 1300 and that the demand at the reduced price is normally distributed with mean 3800 and standard deviation 1400.
Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
Lemingtons is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemingtons works as follows. At the beginning of the season, Lemingtons reserves x units of capacity. Lemingtons must take delivery for at least 0.8x dresses and can, if desired, take delivery on up to x dresses. Each dress sells for 160 and Hudson charges 50 per dress. If Lemingtons does not take delivery on all x dresses, it owes Hudson a 5 penalty for each unit of reserved capacity that is unused. For example, if Lemingtons orders 450 dresses and demand is for 400 dresses, Lemingtons will receive 400 dresses and owe Jean 400(50) + 50(5). How many units of capacity should Lemingtons reserve to maximize its expected profit?
Six months before its annual convention, the American Medical Association must determine how many rooms to reserve. At this time, the AMA can reserve rooms at a cost of 150 per room. The AMA believes the number of doctors attending the convention will be normally distributed with a mean of 5000 and a standard deviation of 1000. If the number of people attending the convention exceeds the number of rooms reserved, extra rooms must be reserved at a cost of 250 per room. a. Use simulation with @RISK to determine the number of rooms that should be reserved to minimize the expected cost to the AMA. Try possible values from 4100 to 4900 in increments of 100. b. Redo part a for the case where the number attending has a triangular distribution with minimum value 2000, maximum value 7000, and most likely value 5000. Does this change the substantive results from part a?
Company C sells semiconductors that are used in handheld consumer electronics. The company has been extremely successful recording an increase in earnings each of the past four quarters. At the end of the current quarter, Larry Gomez, the company’s accountant, calculated the ending inventory for the semiconductors and was surprised to find that the quantity of the Z100 model had not changed during the quarter. Larry confirmed his calculation with the inventory control manager, who indicated that sales of the Z100 had stopped when the Z200 semiconductor was released early in the quarter. Larry found out that the Z200 semiconductor has the same applications as the Z100, but has more computing power and a lower cost than the Z100. Larry notified Sheena Snyder , the chief financial officer, about the semiconductors and recommended that the company apply the lower-of-cost-or-market method to the Z100 semiconductors in inventory. Later that day, Sheena called Larry telling him not to apply…
The manager of a fish market pays 80 cents each The manager of a fish market pays 80 cents each for cod and sells them for $1.50 each. Fish left over at the end of the day are discarded. The daily demand can be approximated by a normal distribution having a mean of 300 and a standard deviation of 50. To maximize his expected profit, how many cod should the manager buy before the market opens each day? The manager of a fish market pays 80 cents each
Rex manufacturing purchases a printed circuit board for use in its automatic, computerized, robotbartender. The manufacturing facility has placed the following monthly demands on purchasedgoods inventory during the past year. Month 1 2 3 4 5 6 7 8 9 10 11 12 Demand 205 193 197 220 202 226 179 197 186 202 179 214 This demand schedule can be assumed to be random, to follow a normal distribution, and to berepresentative of what will occur in the future. Rex estimates that a fixed cost of $300 isincurred each time an order is placed for the boards, and that the inventory holding cost is about20% per year of the value of inventory. Each board has an estimated value of $192 at the pointof storage. The lead time on purchase orders is (1/5) month.Part A: What is the EOQ?Part B: What is the safety stock required to assure the management that the chance of a stock outin a cycle is no more than 1%?Part C: What is the reorder level?
Anna Litic, a new supply chain manager at High Precision Inc. (HP), decides to checksome data on the supply chains she manages. She discovers that HP’s in-transit inventory of electronic components from its Tacoma, Washington, factory to its Asian distribution center (DC) has increased from two quarters ago. However, the distributionof demand at the Asian DC has not changed over this period of time. Anna knows thatthe Asian DC manager is controlling inventory to achieve a fixed in-stock probabilitytarget, so she is happy to see that indeed the in-stock inventory at the Asian DC has alsonot deviated off the target. Anna wonders what has happened to the Asian DC’s averageinventory. What is she likely to discover regarding the Asian DC’s on-hand inventory? a. On-hand inventory has not changed because the in-stock probability has not changedat the Asian DC.b. On-hand inventory has increased because the lead time from Tacoma, Washington, tothe Asian DC must have increased.c. On-hand…
Firewire is a high-end manufacturer of surfboards. A surfboard is sourced at a cost of $80 and sold for $125 to surf shops in its home market (United States). One order is placed at the beginning of the summer season. Currently, Firewire disposes any unsold boards to their outlet store affiliates for $70. It costs $10 to hold a board in inventory for the entire season and ship it to outlet affiliates. Demand for this item is forecasted to be normally distributed with a mean of 4,000 units and a standard deviation of 1750 units. A) Please provide ideal service level and order quantity? Expected profits? Expected overstock to outlets?.... under your preferred policy. B) If Firewire chooses instead of outlets to ship to Australia surf shops, the salvage value would increase to $75 per unit (board) including all associated costs (including the aforementioned holding costs). Would this be a better option?….please show each result as in part A for this alternative scenario to justify your…
The retail price of a Mother’s Day cake in San Ramon Safeway is $30.00. A local bakery sells the cakes to the Safeway at $20.00. The Safeway will dispose of all of the unsold cakes at 50% off the retail price, at the end of the Mother’s Day weekend. The manager in Safeway estimates that demand for this cake during the Mother’s Day weekend is Normal Distribution with a mean of 100 cakes and a standard deviation of 50 cakes. (1) How many cakes should San Ramon Safeway order from the bakery? (2) If the store manager learned a new forecast method in a class that would reduce the standard deviation of estimated demand from 50 to 25 (mean remains 100), how many cakes should San Ramon Safeway order from the local bakery?