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

Describe the three main functions of a bill of lading, QUESTION 1 (a) (...

QUESTION 1 (a) (i) Explain the meaning of a Bill of Lading (ii) Describe the three main functions of a Bill of lading (b) Explain the meaning and purpose of an Air Waybil

Explain the concept of service mapping with example, Question 1) Explain t...

Question 1) Explain the concept of Service mapping with example Question 2) A. Factors that influence customer expectations                     B. Pricing strategies follo

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

Components of a supply chain management, Question: a) Distinguish betwe...

Question: a) Distinguish between a Venture capitalists and Internet Incubator . b) What are the components of a supply chain management? c) What is included in the develo

What is influence network design decisions, Describe the various factors th...

Describe the various factors that influence Network Design Decisions. Strategic a. Offshore facility b. Source facility c. Server facility d. Contributor facility e. Outpost f

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

What is total quality management approach, Question 1: The role of qual...

Question 1: The role of quality remains an influencing factor in the food supply chain. Substantiate analysis explanation   conclusion Question 2: Des

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