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
Question 1 Briefly explain contract farming Question 2 Explain the aspects that will have an impact on wholesaling of food Question 3 The food product development

where can I get good reliable information to write a paper on supply chain management ?

detail layout for footwear industry for their Finish goods

WHAT IS THE DIFFERENCE BETWEEN SUPPLY CHAIN AND VALUE CHAIN

I would like to know whether you can help me in MRP questions?

Does the company's purchasing activities influenced by national and transnational organizations Briefly explain. Investigate the relationship with the foreign suppliers, Compar


Explain the risks and advantages of Global Supply Chain Risks - 1. Supply side risks 2. Risks in international logistics 3. Demand side risks 4. Government regulations -

Catalytic converters are made in batches of 10 units and are moved in special hand carts to the fabrication cells. The catalytic converter cell is designed so that different types

How do i evaluate the use of a complex models for this title?