Use probability determine the expected value of sales, Supply Chain Management

Aerial Products maintains a safety stock of 5 airframes in any given week. The owner likes to have the supply as a just in case buffer.  Given the weekly demand in the data table in the accompanying spreadsheet:

A: Set up a simulation model that simulates sales over the number of weeks indicated and compute:

  • Average weekly sales
  • Number of weeks of stockouts over the two year period.

Replicate the model 200 times, using Data Table, to determine average weekly sales and the probability of more than 20 weeks with stockouts over a 2 year period.

B: Use the probability distribution for sales to determine the expected value of sales. Explain any differences between this value and the value from Part A.

 

 

Posted Date: 3/13/2013 1:34:13 AM | Location : United States







Related Discussions:- Use probability determine the expected value of sales, Assignment Help, Ask Question on Use probability determine the expected value of sales, Get Answer, Expert's Help, Use probability determine the expected value of sales Discussions

Write discussion on Use probability determine the expected value of sales
Your posts are moderated
Related Questions
Definition - Inspection, Test and Measurement in Quality Inspection can be defined as the formal evaluation exercise which studies the  characteristics  of  the  product  to

A company has three factories A, B and C which supply units to warehouses X, Y and Z every month. The capacities of the factories are 60, 70 and 80 units at A, B and C

what is the potential negative or downside to the long-term Starbucks-OHL collaboration? identify what you consider to be three major potential problems in such long term relations

Describe the supply chain for milk?

If I follow your recommended approach to managing my farm so as to maximize my operating income next month, how much will I earn from selling the 100 hogs?” asks Igor. “How many ho

Describe the importance of temperature controlled supply chains. Require for Temperature controlled supply chains. Importance of temperature controlled food supply chain - Qual

Kateville Textile Printing Company Ltd Introduction Kateville Textile Printing Company Ltd. design company which produces design fashion products and distribute to all branches of

Problem 1: What do you meant by the ‘Purchasing Function'? Describe some benefits accrued to a firm having an effective purchasing function? Problem 2: Purchasing Depar

i am a management trainee and currently i am working with a supply chain company which deals with supply of raw materials all over India to Mc Donalds. I am tryin to implement a be