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

Material requirement planning, explain the major inputs into the Material R...

explain the major inputs into the Material Requirement Planning system

Problems, 1- The smallest defect in a computer chip will render the entire ...

1- The smallest defect in a computer chip will render the entire chip worthless. Therefore, tight quality control measures must be established to monitor these chips. In the past

Lean operations, Kateville Textile Printing Company Ltd Introduction Katevi...

Kateville Textile Printing Company Ltd Introduction Kateville Textile Printing Company Ltd. design company which produces design fashion products and distribute to all branches of

Case study, Where does Ace Dairies fit into this? What specific activities ...

Where does Ace Dairies fit into this? What specific activities form the logistics in Ace Dairies?imum 100 words accepted#

Assignments, Discuss the applications of scm principle in financial service...

Discuss the applications of scm principle in financial services.

Supply Chain Management, What are the factors influencing contracting strat...

What are the factors influencing contracting strategies? A Internal forces, external forces, project characteristics

Logistics, 1-what are distribution costs? 2- what are lost opportunity cost...

1-what are distribution costs? 2- what are lost opportunity costs? 3-what are ordering costs?

Show the cpfr model and its benefits, Question 1: Describe in detail th...

Question 1: Describe in detail the management processes in the SCOR model. Diagram and Definition of each process Ambit, Main aspects and functions of SCOR model

#title.project risk and procurement management., How do i evaluate the use ...

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

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

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