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

The expected profit for blockbuster, A  movie studio sells  the latest movi...

A  movie studio sells  the latest movie on DVD to Blockbuster at $10 per DVD.  The marginal production cost for the movie studio is $1 per DVD.  Blockbuster prices each DVD at $20

Procurement make or buy decision assignment.., how to perform a proper assi...

how to perform a proper assignment for the above mentioned project?

Assignmment on supply chain management, I had a assignment on supply chain ...

I had a assignment on supply chain management please help me i dont have enough knowledge of this topic

#title.sourcing and procurement., critically evaluate the relationship betw...

critically evaluate the relationship between the sourcing and procurement strategy with the corporate strategy

Principles and Practices of management, questionHow will you influence peop...

questionHow will you influence people to strive willingly for group objectives in your organization (target based industry)? Apply your interpersonal influence through communicatio

The 3c model by kenichi ohmae, The 3C model by Kenichi Ohmae The 3C mod...

The 3C model by Kenichi Ohmae The 3C model has been given by well known business strategist of Japanese origin, Kenichi Ohmae. The 3 C's of the model stands for: The

Errors of measurement in quality of product, Errors of Measurement To e...

Errors of Measurement To ensure the quality of a product, errors of measurement is very important, as test cases are executed at various levels defects if found any in the test

Prompt, 4. About 5% of delivered products are spoiled upon delivery with ei...

4. About 5% of delivered products are spoiled upon delivery with either the fish or plants dying, or both, due to sensitivity to changes in temperatures, which is a major financial

Supply chain risk management, what are the various strategies used in contr...

what are the various strategies used in contracting in supply chain

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