Solutions-Assignment4

# Solutions-Assignment4 - Assignment 4 solutions BUS 220...

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

1 Assignment 4 solutions, BUS 220 – Introduction to Decision Sciences Problem 1: (30 points) The spreadsheet for this problem is as follows: Selected cell formulas are as follows: Cell Formula B9 =NORMINV(RAND(),\$C\$4,\$C\$5) F10 =COU NTIF(B9:B508,”>40000”) a. Most simulations will provide between 105 and 130 tires exceeding 40,000 miles. The percentage should be roughly 24%. b. Mileage In Most Simulations Number of Tires Approximate Percentage 32,000 80 to 100 18% 30,000 42 to 55 10% 28,000 18 to 30 4% c. Of mileages considered, 30,000 miles should come closest to meeting the tire guarantee mileage guideline. Problem 2 a.(10 points) Let x 1 = number of units of product 1 produced x 2 = number of units of product 2 produced 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 A B C D E F G Grear Tire Company Tire Mileage Mean Standard Deviation 5000 Simulation Results Tire Mileage 1 38,379 Mileage Number Percent 2 36,597 Exceed 40,000 118 23.6% 3 28,820 Less Than 32,000 88 17.6% 4 38,387 Less Than 30,000 48 9.6% 5 39,638 Less Than 28,000 25 5.0% 6 34,548 Note: To reconstruct the complete speadsheet: 1.

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 '08
• drexel
• David Beckham, Mike Jefferies, Kuno Becker, Goal! 2: Living the Dream..., Goal! 3: Taking on the World, Goal!

{[ snackBarMessage ]}

### Page1 / 4

Solutions-Assignment4 - Assignment 4 solutions BUS 220...

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

View Full Document
Ask a homework question - tutors are online