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
Q. What are the different methods for evaluating inventory cost? i. FIFO method ii. Average cost method iii. LIFO method iv. Actual cost method v. Base stock prices

Question 1: (a) Explain the term ‘framework agreement' in the context of public procurement. (b) Discuss the benefits of aggregation of some items in public procurement in M

daily 3 bus services for 15 pax daily

Question 1: (a) Using a diagram, describe clearly the Supply Chain. (b) Examine some main objectives of the Supply Chain Management. Question 2: Explain three types

topics of studies


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

Q. Explain the different methods for identifying fair? i. Competition based pricing: In this method, a product's price is set based on the competitor's price for the same produ


Why do you think Standard Machine is in this difficult situation with what was previously a loyal customer?