# Spreadsheet - TheresaM.Roeder Spring2012 Introduction typesofsimulation determ

This preview shows pages 1–6. Sign up to view the full content.

Spreadsheet Simulation Theresa M. Roeder Spring 2012

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
2 Introduction Ø Spreadsheets can be used effectively for some  types of simulation  time dynamics of little or no importance Ø Sample from system repeatedly to estimate  population parameters Ø Can be used to add stochastic component to  deterministic models (like those from DS 412) Ø Process can be simplified using Excel’s Table  function
3 Example: Sales Promotion C cost per chair R price per chair (R/2 during sale) S number of chairs ordered V number of chairs sold before sale P promotion profit ( 29 ( 29 2 R P R C V C S V = - × + - × - ÷

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
4 How Can This Model Be Used? Determine profit if: Ø Demand is stochastic (includes if timing of  sale is changed, demand during sale is  stochastic) Ø Sales price is changed Ø Different quantities are ordered Ø All (combinations of) the above
5 Generating Uniformly-Distributed

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 01/26/2012 for the course DS 408 taught by Professor Theresam.roeder during the Spring '12 term at S.F. State.

### Page1 / 12

Spreadsheet - TheresaM.Roeder Spring2012 Introduction typesofsimulation determ

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online