09 Sample Qs Lect Note A Sim Q3,4,5 Ans

# 09 Sample Qs Lect Note A Sim Q3,4,5 Ans - Q3 Answer 0 0.05...

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

Q3 Answer Cum Prob # Showing uProbability 0 0.05 28 0.05 0.05 0.35 29 0.3 0.35 0.75 30 0.4 0.75 0.8 31 0.05 0.8 0.85 32 0.05 0.85 0.95 33 0.1 0.95 1 34 0.05 Demand Trial RN #showing # In # Bumped Rev Cost/PenaltNet 1 0.03 28 28 0 5600 0 5600

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

View Full Document
Q4 a,b Answer Q4a, demand=200 Q4b: demand Normal,One trial Cost \$5 \$5 Price \$15 \$15 Left over Price \$3 \$3 Shortfall Cost \$16 \$16 Order Quantity,Q 150 150 Demand 200 227.37 Shortfall cases 50 77.37 Leftover cases 0 0 Revenue \$3,000 \$3,411 Leftover Rev \$0 \$0 Cost \$750 \$750 Shortfall Cost \$800 \$1,238 Profit \$1,450 \$1,423 How to make copies of excel sheets? Edit, move or copy sheet, move to end, click create copy
Q4a, demand=200 Q4b: demand Normal,One trial Cost \$5 \$5 Price \$15 \$15 Left over Price \$3 \$3 Shortfall Cost \$16 \$16 Order Quantity,Q 150 150 Demand \$200 135.76 Shortfall cases 50 0 Leftover cases 0 14.24 Revenue \$3,000 \$2,036 Leftover Rev \$0 \$43 Cost \$750 \$750 Shortfall Cost \$800 \$0 Profit \$1,450 \$1,329 Type 1-500 in A21 to A520. In B21, type =D16

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 08/10/2011 for the course BUSQOM 0050 taught by Professor Glowackia during the Spring '08 term at Pittsburgh.

### Page1 / 5

09 Sample Qs Lect Note A Sim Q3,4,5 Ans - Q3 Answer 0 0.05...

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

View Full Document
Ask a homework question - tutors are online