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

S upplier certification A certified supplier is one whose quality data record shows that it does not need to perform routine inspection and test on each lot or batch received.

Explain the Stages in food Product development Process? Food Product Development Process: The food product coordinates the technology used by the company and its culture to de


Question 1: Describe the terminologies used in purchasing of services and goods? A Client, users, sponsors, bidding, tender, contract, purchase order, line managers, buyer,

The resources such as equipment and human resources should be effectively managed. To facilitate effective management of equipment resources on line records of equipment location a

Supply Chains and Value Chains Supply Chains and Value Chains have been around for many years and Logistics has served as glue to bind the different members. But in the curren

explain the concept of benchmarking

causes of poor performance of inbound logistics activities?

Question 1  Explain the Shipping Process Flow Chart and the issues associated with seaports Question 2 Discuss the important documents that are used in international logistic