Solutions-Assignment4

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

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

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

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

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 Right Arrow Icon
Ask a homework question - tutors are online