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
got my assignment submission due on thursday 18th i would like to know the price for 2300 words

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

can you help with network design questions?

Apply the model to any business. How are they fullfilling and what impact on cost?

analyse why i have a large number of orders

Differentiate between stock checking, stock taking and stock verification

difference between transaction exposure risk and translation exposure risk#

why do companies prefere outbound logistics to inbound logistics

Question: The Investment Project Process Manual (IPPM) has been issued in accordance with Section 22A of the Finance and Audit Act as amended by the Finance and Audit (Amendmen

Explain the structure of supermarket supply chain. Categorisation in the structure of supermarket supply chain - Farmers or primary producers, members of cooperative groups, Pr