Use probability determine the expected value of sales, Supply Chain Management

Assignment Help:

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.

 

 


Related Discussions:- Use probability determine the expected value of sales

Discuss the major aims of traffic assignment, Define traffic assignment in ...

Define traffic assignment in transportation system and discuss the major aims of traffic assignment? It is the method of assigning a set of trip interchange data to a specified

Dispatch product, suggest to avoid delays in dispatch of products

suggest to avoid delays in dispatch of products

Homework, is it possible to help homework

is it possible to help homework

Aggregate Planning Modelling, Need Support and obtain solution for a manufa...

Need Support and obtain solution for a manufacturing network ; to find aggregated model and do hypothesis.

Bottlenecks - transformation process, Review your transformation process an...

Review your transformation process and identify the major bottlenecks that might be restricting smooth flow of operations, causing delays and impacting process performance.  Exp

Case study, what is the supply chain for milk

what is the supply chain for milk

Raw Materials Planning, what are some theories that would support on my re...

what are some theories that would support on my research study?

Challenge question, what is the potential negative or downside to the long-...

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

Material management, explain how to minimize the cost of production through...

explain how to minimize the cost of production through scope of material management

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd