The wine cellar places orders for a popular pinot

Assignment Help Strategic Management

Reference no: EM1328883

The Wine Cellar places orders for a popular Pinot Noir on a weekly basis. The weekly demand for this wine was found to approximately follow the probability distribution shown below. The Wine Cellar buys this wine at $10 per bottle and sells it for $16 per bottle. The inventory carrying cost is $0.50 per bottle per week, and the shortage cost is $1.00 per bottle. The Wine Cellar does not permit backlogs, so shortages incur a cost only in the week they occur and then are ignored

Demand.......Probability

15....................0.20

16....................0.25

17.....................0.4

18....................0.15

Total................1.00

a) Using an order size of 16 bottles per week, simulate this ordering system for one year (52 weeks) and determine the expected profit. (Please include your simulation spreadsheet with this exam).

b) In at most 3 sentences, explain how your simulation system may be used to determine the best order size for this store.

Reference no: EM1328883

Questions Cloud

Why are computer networks so tough to secure : define Why are computer networks so tough to secure.

Regulating civil rights between state and federal : Describe the balance of powers between state and federal government while protecting civil rights.

Explain e-business marketing evaluation : Explain E-business Marketing Evaluation and eExplain how you would improve the marketing and customer service on Scamaless

How much juice will the costumer purchase in a month : how much juice will the costumer purchase in a perticular month. What is the elasticity of demand for juice.

The wine cellar places orders for a popular pinot : The Wine Cellar places orders for a popular Pinot Noir on a weekly basis. The weekly demand for this wine was found to approximately follow the probability distribution shown below.

Description of present value of lump sum : What is the future value of lump sum at the end of year 5? What is the future value of mixed stream at the end of year 5? Based upon your findings in parts (a) and (b), which alternative should Gina take?

Difference between the typed password and "phoenix" : explain difference between the typed password and "Phoenix".

Public leader deciding issues : How does a public leader decide which issues to address and when? Can a public leader keep everybody happy?

The impacts of the sp downgrade on the us & global economy : Standard & Poor's downgraded the U.S.'s AAA credit rating for the first time, slamming the nation's political process and criticizing lawmakers for failing to cut spending or raise revenue enough to reduce record budget deficits.

User Account

All Pages