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

Case study, what is the supply chain for milk

what is the supply chain for milk

Calculate long-run aggregate, 1. Explain whether each of the following even...

1. Explain whether each of the following events will increase, decrease, or have no effect on long-run aggregate supply. Canada experiences a wave of immigration. Provinci

E-scm, benefits of e-scm

benefits of e-scm

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

Assignment, I would like to know whether you can help me in MRP questions?

I would like to know whether you can help me in MRP questions?

Explain the meaning of and reasons for currency fluctuation, QUESTION 1 ...

QUESTION 1 (a) Explain the meaning of and reasons for currency fluctuation (b) How can buyers protect themselves against the risks of currency fluctuation in International P

Strategic cost management, 1. Prepare the j entries for traditional and bac...

1. Prepare the j entries for traditional and backflush costing. For backflush costing, assume there are 2 trigger points: 1). the purchase of raw materials and 2). the completion o

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