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

Stocks, Differentiate between stock checking, stock taking and stock verifi...

Differentiate between stock checking, stock taking and stock verification

A Supply chain reconfiguration case study , A Supply chain reconfiguration ...

A Supply chain reconfiguration case study The case company (referred to as ABC) is a leading supplier of maintenance, repair and operating (MRO) products to business and institut

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

Maintain effective supplier relationship, Describe the different types of s...

Describe the different types of sourcing available and strategies formulated to manage them in Your organization.( i.e Consumables, capital goods, goods for resale) What are

Determine the eoq for the material, Problem 1 Aerial Products has prod...

Problem 1 Aerial Products has produced 100 airframes with the following mix data.  Perform a complete SPC analysis identifying if the process is in control, if the process is

Zappos, Define SCM and how it can benefit Zappos

Define SCM and how it can benefit Zappos

Green logistics, what is the procedure for greening an enterprise

what is the procedure for greening an enterprise

Logistics, Discuss the logistics strategies

Discuss the logistics strategies

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