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...

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
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
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
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 Right Arrow Icon
Ask a homework question - tutors are online