Problem 12-37 (Algo)A small grocery store sells fresh produce, which it obtains from a local farmer. During the strawberry season, demand for freshstrawberries can be reasonably approximated using a normal distribution with a mean of 36 quarts per day and a standard deviation of5 quarts per day. Excess costs run 50 cents per quart. The grocer orders 41 quarts per day.Use Table.What is the implied cost of shortage per quart? (Round your z value to 2 decimal places, your service level probability to 4 decimalplaces and your final answer to 2 decimal places.)Shortage cost per quart

Given:Total Orders per day, So = 41 Excess cost, Ce =0.50 cents/quartzMean= 36 quartz S.D= 5 quartz…

Answered: Problem 12-37 (Algo) A small grocery…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

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.
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
A small grocery store sells fresh produce, which it obtains from a local farmer. During the strawberry season, demand for fresh strawberries can be reasonably approximated using a normal distribution with a mean of 40 quarts per day and a standard deviation of 6 quarts per day. Excess costsrun 35 cents per quart. The grocer orders 49 quarts per day.a. What is the implied cost of shortage per quart?b. Why might this be a reasonable figure?
Problem #2Cassorla’s Clothes sells a large number of white dress shirts. The shirts, which bear the store label,are shipped from a manufacturer in New York City. Hy Cassorla, the proprietor, says, “I want to besure that I never run out of dress shirts. I always try to keep at least a two months’ supply instock. When my inventory drops below that level, I order another two-month supply. I’ve beenusing that method for 20 years, and it works.”The shirts cost $6 each and sell for $15 each. The cost of processing an order and receiving newgoods amounts to $80, and it takes three weeks to receive a shipment. Monthly demand isapproximately normally distributed with mean 120 and standard deviation 32. Assume a 20percent annual interest rate for computing the holding cost.a) What value of Q and R is Hy Cassorla sing to control the inventory of white dress shirts?b) What fill rate (Type 2 service level) is being achieved with the current policy?c) Based on a 99 percent fill rate criterion,…
A small grocery store sells fresh produce, which it obtains from a local farmer. During the strawberry season, demand for fresh strawberries can be reasonably approximated using a normal distribution with a mean of 40 quarts per day and a standard deviation of 6 quarts per day. Excess costsrun 35 cents per quart. The grocer orders 49 quarts per day.a. What is the implied cost of shortage per quart?
Answer bold italicized questions Using excel. The Metropolitan Bus Company (MBC) purchases diesel fuel from AmericanPetroleum Supply. In addition to the fuel cost, American PetroleumSupply charges MBC $250 per order to cover the expenses of deliveringand transferring the fuel to MBC’s storage tanks. The lead time for anew shipment from American Petroleum is 10 days; the cost of holding agallon of fuel in the storage tanks is $0.04 per month, or $0.48 peryear; and annual fuel usage is 150,000 gallons. MBC buses operate 300days a year.a.What is the optimal order quantity for MBC?b.Howfrequently should MBC order to replenish the gasoline supply?c.TheMBC storage tanks have a capacity of 15,000 gallons. ShouldMBC consider expanding the capacity of its storage tanks?d.What isthe reorder point?
GameStop has maintained 75% service level for inventory of PlayStation 5. Mean demand during lead time is 166 PlayStations, and the standard deviation during lead time is 58 PlayStations. The annual cost of carrying one PlayStation in inventory is $12. The store’s operations analyst recently told GameStop's management that they could expect a $550 improvement in profit (based on current figures of cost per PlayStation) if the service level were increased to 97.5%. Is it worthwhile for GameStop to make this change?
John buys goat milk at a cost of $5 per gallon from a local dairy and sells it for $8 per gallon in its store. The dairy will buy back any milk that is unsold at the end of the day for $2 per gallon. Each day John must determine how many gallons to order. Past sales have ranged between 15 and 18 gallons per day, according to the following demand pattern.Demand:15161718Number of days demand occurred:2486Assume that demand will be within this range in future.(a) What are the possible actions and states?(b) Determine the daily profit (rewards) and show on a reward table.(c) Using each of the following criteria, determine John’s best action.- Maximin- Maximax- Expected value(d) Construct the regret (opportunity cost) matrix and using minimax regret criteria determine John’s best action.
A small grocery store sells fresh produce, which it obtains from a local farmer. During the strawberry season, demand for fresh strawberries can be reasonably approximated using a normal distribution with a mean of 36 quarts per day and a standard deviation of 7 quarts per day. Excess costs run .40 cents per quart. The grocer orders 42 quarts per day.Use Table. What is the implied cost of shortage per quart?
Problem 20-36 (Algo) Palin’s Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to manage inventory of this standard muffler. Use the information in the following table to determine the optimal inventory target level (or order-up-to level). Annual demand 3,910 mufflers Ordering cost $ 75 per order Standard deviation of daily demand 6 mufflers per working day Service probability 87 % Item cost $ 27.00 per muffler Lead time 2 working days Annual holding cost 36 % of item value Working days 230 per year Review period 18 working days a. What is the optimal target level (order-up-to level)? (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.) Optimal target level_________________ b. If the…
Hayes Electronics stocks and sells a particular brand of personal computer. It costs the firm$450 each time it places an order with the manufacturer for the personal computers. The costof carrying one PC in inventory for a year is $170. The store manager estimates that total annualdemand for the computers will be 1,200 units, with a constant demand rate throughout theyear. Orders are received within minutes after placement from a local warehouse maintainedby the manufacturer. The store policy is never to have stockouts of the PCs. The store is openfor business every day of the year except Christmas Day. Determine The optimal time between orders (in working days)

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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

SEE MORE TEXTBOOKS