Use probability determine the expected value of sales, Supply Chain Management

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.

 

 

Posted Date: 3/13/2013 1:34:13 AM | Location : United States







Related Discussions:- Use probability determine the expected value of sales, Assignment Help, Ask Question on Use probability determine the expected value of sales, Get Answer, Expert's Help, Use probability determine the expected value of sales Discussions

Write discussion on Use probability determine the expected value of sales
Your posts are moderated
Related Questions
This is the guideline for my research project, Please send me your Quotes against my 4 assignments as per below subjects and attached documents -Company Description in 3,500 wo

The history of Mauritius is closely linked with the cultivation of sugarcane. Despite the fact that Mauritius has evolved from an agricultural-based economy to a services-based eco


A publisher sells books to Borders at $12 each.  Borders prices the book to its customers at $24 and expects demand over the next 2 months to be normally distributed, with a mean o

Develop purchasing systems for standard and non-standard items Explain the organizational structure and possible organizational configurations Describe how the efficiency of

Good day! Is it possible to find multiple locations using Center of Gravity Method? Regards, Anna.

suggest to avoid delays in dispatch of products

Suppose Norwitch has worked out a new contract, accepted by all its customers, of being allowed up to one week to satisfy each demand. Norwitch still uses a 99% “fill rate” as a t

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

How you can calculate EOQ and set safety level