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
can you explain the concept of the great divide in supply chain management

develop a method that will optimal ordering quanties so that we maximize the gross profits and also take into account inventory costs, product cost and price markups

assignment based on drivers

R educing and controlling errors of measurement To reduce and control errors for all sources of measurement variation steps can be taken. By applying a numerical connectio

i want to know about five value chain of ferrari company

What is the factors influencing demand in organic food market? Organic Food Market Organic farming is influenced by several factors. In this section, we analyse the factors tha

QUESTION 1 (i) Explain a Free Trade Area with examples. (ii) Outline the activities of a Free Port. QUESTION 2 (a) (i) Define Incoterms (ii) How many Incoterms ha

Modified Atmosphere Packaging: Modified atmosphere packaging (MAP) broadly defined any type of packaging system that attempted to modify the atmosphere inside the package to ex

Question 1: Critically evaluate the case for outsourcing the transport and distribution activities of an organisation to a third party provider. Question 2: a) What are

Explain the impacts of e-Commerce on Supply Chain Management Impacts of E-commerce on SCM - a. Cost efficiency b. Flexibility in distribution system c. Customer orient