Can you assist me with Chapter 12 Question 2. Please show the steps it's easier to follow along instead of an excel spreadsheet. Thank you Probabiility(P(Z < z)Z0.000.010.020.030.040.050.060.070.080.090.00.50000.50400.50800.51200.51600.51990.52390.52790.53190.53590.10.53980.54380.54780.55170.55570.55960.56360.56750.57140.57540.20.57930.58320.58710.59100.59480.59870.60260.60640.61030.61410.30.61790.62170.62550.62930.63310.63680.64060.64430.64800.65170.40.65540.65910.66280.66640.67000.67360.67720.68080.68440.68790.50.69150.69500.69850.70190.70540.70880.71230.71570.71900.72240.60.72580.72910.73240.73570.73890.74220.74540.74860.75180.75490.70.75800.76120.76420.76730.77040.77340.77640.77940.78230.78520.80.78810.79100.79390.79670.79960.80230.80510.80790.81060.81330.90.81590.81860.82120.82380.82640.82890.83150.83400.83650.83891.00.84130.84380.84610.84850.85080.85310.85540.85770.85990.86211.10.86430.86650.86860.87080.87290.87490.87700.87900.88100.88301.20.88490.88690.88880.89070.89250.89440.89620.89800.89970.90151.30.90320.90490.90660.90820.90990.91150.91310.91470.91620.91771.40.91920.92070.92220.92360.92510.9265 0.92790.92920.93060.93191.50.93320.93450.93570.93700.93820.93940.94060.94180.94300.94411.60.94520.94630.94740.94850.94950.95050.95150.95250.95350.95451.70.95540.95640.95730.95820.95910.95990.96080.96160.96250.96331.80.96410.96490.96560.96640.96710.96780.96860.96930.97000.97061.90.97130.97190.97260.97320.97380.97440.97500.97560.97620.97672.00.97730.97780.97830.97880.97930.97980.98030.98080.98120.98172.10.98210.98260.98300.98340.98380.98420.98460.98500.98540.98572.20.98610.98650.98680.98710.98750.98780.98810.98840.98870.98902.30.98930.98960.98980.99010.99040.99060.99090.99110.99130.99162.40.99180.99200.99220.99250.99270.99290.99310.99320.99340.99362.50.99380.99400.99410.99430.99450.99460.99480.99490.99510.99522.60.99530.99550.99560.99570.99590.99600.99610.99620.99630.99642.70.99650.99660.99670.99680.99690.99700.99710.99720.99730.99742.80.99740.99750.99760.99770.99770.99780.99790.99800.99800.99812.90.99810.99820.99830.99830.99840.99840.99850.99850.99860.99863.00.99870.99870.99870.99880.99880.99890.99890.99890.99900.99903.10.99900.99910.99910.99910.99920.99920.99920.99920.99930.99933.20.99930.99930.99940.99940.99940.99940.99940.99950.99950.99953.30.99950.99950.99960.99960.99960.99960.99960.99960.99960.99973.40.99970.99970.99970.99970.99970.99970.99970.99970.99980.9998 Henrique Correa's bakery prepares all its cakes between 4 A.M.and 6 A.M.so they will be fresh when customers arrive. Day-old cakes are virtually always sold, but at a 50% discount off the regular $16 price. The cost of baking acake is $10, and demand is estimated to be normally distributed, with a mean of 25 and a standard deviation of 5. What is the optimal stocking level? Refer to the standard normal table for z-values.The optimal stocking level for the bakery is cakes (round your response to the nearest whole number).

Answered: Image /qna-images/answer/b08db0c8-8d3e-4fd4-8c74-e3bddc799cdc.jpg

Henrique Correa's bakery prepares all its cakes between 4 A.M.and 6 A.M.so they will be fresh when customers arrive. Day-old cakes are virtually always sold, but at a 50% discount off the regular $16 price. The cost of baking a cake is $10, and demand is estimated to be normally distributed, with mean of 25 and a standard deviation of 5. What is the optimal stocking level? Refer to the standard normal table for z-values. The optimal stocking level for the bakery is cakes (round your response to the nearest whole number).

Henrique Correa's bakery prepares all its cakes between 4 A.M.and 6 A.M.so they will be fresh when customers arrive. Day-old cakes are virtually always sold, but at a 50% discount off the regular $16 price. The cost of baking a cake is $10, and demand is estimated to be normally distributed, with mean of 25 and a standard deviation of 5. What is the optimal stocking level? Refer to the standard normal table for z-values. The optimal stocking level for the bakery is cakes (round your response to the nearest whole number).

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

Henrique Correa’s bakery prepares all its cakesbetween 4 a.m. and 6 a.m. so they will be fresh when customers arrive. Day-old cakes are virtually always sold, but at a50% discount off the regular $10 price. The cost of baking acake is $6, and demand is estimated to be normally distributed, with a mean of 25 and a standard deviation of 4. Whatis the optimal stocking level?
Henrique Correa’s bakery prepares all its cakesbetween 4 a.m. and 6 a.m. so they will be fresh when customers arrive. Day-old cakes are virtually always sold, but at a 50% dis-count off the regular $10 price. The cost of baking a cake is $6, and demand is estimated to be normally distributed, with a mean of 25and a standard deviation of 4. What is the optimal stocking level?
Chris usually sells 120 copies of newspaper each day and believe that sale are normally distributed, with a standard deviation of 15 papers. He pays 70 cents for each paper, which sells $1.25. For each unsold paper, he receives 30-cent credit. a) determine how many papers he should order each day b) calculate the stockout risk for that quantity.
A Mercedes dealer pays $40,000 for each car purchased (wholesale price). The annual holding cost is estimated to be 30% of the dollar value of inventory. The dealer sells an average of 1200 cars per year. They believe that demand is backlogged but estimate that if they are short one car for one year, the loss in future profits is about 10% of the wholesale price. Each time the dealer places an order for cars, ordering costs amount to $1600. Assume there are 360 work days per year. Question: If the Mercedes dealer wants to limit backorders so that they occur 20% of the time, what is the maximum number of backorders that should be allowed (assuming the optimal order quantity doesn't change)?
3. Skinner’s Fish Market buys fresh Boston bluefish daily for $4.20 per pound and sells it for $6 per pound. At the end of each business day, any remaining bluefish is sold to a producer of cat food for $3 per pound. Daily demand can be approximated by a normal distribution with a mean of 64 pounds and a standard deviation of 11 pounds. What is the optimal order quantity (stocking level)? Round your answer to 2 decimal places. Answer:_______
The Olde Town Microbrewery makes Townside beer,which it bottles and sells in its adjoining restaurant and bythe case. It costs $1700 to set up, brew, and bottle a batchof the beer. The annual cost to store the beer in inventory is$1.25 per bottle. The annual demand for the beer is 21,000bottles and the brewery has the capacity to produce 30,000bottles annually.a. Determine the optimal order quantity, total annual inventory cost, the number of production runs per year, andthe maximum inventory level.b. If the microbrewery has only enough storage space tohold a maximum of 2500 bottles of beer in inventory,how will that affect total inventory costs?
Happy Pet, Inc., is a large pet store located in LongBeach Mall. Although the store specializes in dogs, it a lso sellsfish, turtle, and bird supplies. The Everlast Leader, a leather leadfor dogs, costs Happy Pet $7 each. There is an annual demand for6,000 Everlast Leaders. The manager, Stephan Wagner, has determinedthat the ordering cost is $20 per order and the carrying cost,as a percentage of unit cost, is 15%. Happy Pet is now consideringa new supplier of Everlast Leaders. Each lead would cost only$6.65, but, in order to get this discount, Happy Pet would have tobuy shipments of 3,000 at a time. Should Happy Pet use the newsupplier and take this discount for quantity buying?
The Farmer’s Wife is a country store specializing in knickknacks suitable for a farm-house décor. One item experiencing a considerable buying frenzy is a miniature Holstein cow. Average weekly demand is 30 cows, with a standard deviation of 5 cows. The cost to place a replenishment order is $15 and the holding cost is $0.75/cow/year. The supplier, however, is inChina. The lead time for new orders is 8 weeks, with a standard deviation of 2 weeks. The Farmer’s Wife, which is open only 50 weeks a year, wants to develop a continuous review inventory system for this item with a cycle-service level of 90 percent.a. Specify the continuous review system for the cows. Explain how it would work in practice.b. What is the total annual cost for the system you developed?
A lawn and garden shop that is open for business seven days a week orders bags of grass seed every OTHER Monday. Lead time for seed orders is 5 days. On Monday, at ordering time, a clerk found 112 bags of seed in stock, and so he ordered 198 bags. Daily demand for grass seed is normally distributed with a mean of 15 bags and a standard deviation of four bags.The manager would like to know what the probability is that a grass seed stockout will occur before the next order arrives. Please show a correct solution and answer. Thank you.
Weekly demand for printers at a store is normally distributed with a mean of 250 and a standard deviation of 96. The store manager continuously monitors inventory and currently orders 14400 printers each time the inventory drops to 1,000printers. The supply lead time is normally distributed with a mean of 2 weeks and a standard deviation of 1.5 weeks. a.How much safety inventory should this store carry if it wants to provide a CSL of 95%? b.How does the required safety inventory change as the standard deviation of lead time is reduced from 1.5 weeks to zero in intervals of 0.5 weeks? c.What fill rate does the store achieve?
A department store uses a (Q, R) policy to control its inventories. Sales of a pocket FM radioaverage 1.4 radios per week. The radio costs the store $50.00, and fixed costs of replenishmentamount to $20.00. Holding costs are based on a 20 percent annual interest charge, and thestore manager estimates a $12.50 cost of lost profit and loss of goodwill if the radio is demanded when out of stock. Reorder lead time is 2 weeks, and statistical studies have shownthat demand over the lead time is accurately described by a Poisson distribution. Find the optimallot sizes and reorder points for this item.
1) Store A orders on a weekly basis. Its weekly demand is 50 units with a standard deviation of five units. The holding cost is $10 per unit per week and a 0.99 in-stock probability is desired. What is Store A’s average holding cost incurred each week for on-order inventory if lead time is five weeks? 2) Store A orders on a weekly basis. Its weekly demand is 50 units with a standard deviation of five units. The holding cost is $10 per unit per week and a 0.99 in-stock probability is desired. What is Store A’s average on-hand inventory if lead time is five weeks?