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
Supply Chain Quality Improvement Lean  is  a journey of  continuous  improvement.  Suppliers  must  often be provided with technical assistance which leads to co operation. At

What are the factors influencing contracting strategies? A Internal forces, external forces, project characteristics

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 activities and levels of the food supply chain. Food Supply management - activities in the Food supply chain - Production, Consolidation Logistics, Further consol

What are the basic functions of supply chain management?

Supply chains are really supply networks that move the products, money, information and services. Explain 5 critical roles of supply networks that a manager must manage f

Inspection N ecessity:    In    case   of   project    management,    planning    and    quality management are necessary processes. However, for quality maintenance and pro

As a newly recruited materials manager explain all the functions of the units in your department to a group of students on a visit to your organization.

What are the benefits of outsourcing Logistical Activities? a. Focus on core competencies b. Operational flexibility c. Geographical Coverage: d. Use of best methods and experi

Question 1 Discuss the Visualisation strategy in advertising and the components of Visualisation strategy Question 2 Describe the elements of execution of advertising in brie