{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# Lecture 9 Spreadsheet - SimulationComplete - Inputs Cost...

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

Inputs Cost data Demand distribution Unit cost 7.50 Demand Probability Unit price 10.00 100.00 0.30 Unit refund 2.50 150.00 0.20 200.00 0.30 250.00 0.15 300.00 0.05 Decision Variable and simulation summaries Order quantity 100.00 125.00 150.00 175.00 200.00 Average profit \$250.00 \$255.50 \$261.00 \$229.19 \$197.38 Std. Dev. \$0.00 \$86.29 \$172.58 \$244.64 \$327.89 Minumum profit \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 Maximum profit \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 Simulation Profit for various order quantities Demand 100.00 125.00 150.00 175.00 200.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 300 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 300 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00

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

View Full Document
100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 300 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 300 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00
200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 300 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 300 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 300 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00

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

View Full Document
150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 300 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00
100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 300 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 250 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 100 \$250.00 \$125.00 \$0.00 -\$125.00 -\$250.00 200 \$250.00 \$312.50 \$375.00 \$437.50 \$500.00 150 \$250.00 \$312.50 \$375.00 \$250.00 \$125.00 250 \$250.00 \$312.50 \$375.00 \$437.50

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.
• Fall '09
• MarinaEpelman
• Harshad number, various order quantities, summaries Order quantity, price Unit refund, distribution Demand Probability, Average profit Std

{[ snackBarMessage ]}

### Page1 / 41

Lecture 9 Spreadsheet - SimulationComplete - Inputs Cost...

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

View Full Document
Ask a homework question - tutors are online