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!

Click to edit the document details