Managerial Decision Analysis Homework (Excel Spreadsheet)

profilemooeas
module_2_excel_assignment.xlsx
Home>Business & Finance homework help>Financial markets homework help>Managerial Decision Analysis Homework (Excel Spreadsheet)

Office

Day Number of Service Calls Range of x Value 1a x Count P(x)
1 2 Min(x) =
2 1 Max(x) =
3 3
4 2
5 4
6 3
7 2
8 0 E(x) = Var(x) =
9 5 StdDev(x) =
10 2 Grader
11 5 1b
12 3 1c
13 4 1d
14 2 1e
15 6 1f
16 1 1g
17 0 1h
18 3
19 5
20 2
21 4
22 3
23 5
24 1
25 5
26 2
27 2
28 4
29 3
30 6
31 2
32 4
33 0
34 4
35 5
36 1
37 3
38 4
39 2
40 3

Asterex

Sample No Sample OD Measures (mm) Sample Statistics 2a Grader Grader
1 381.77 Mean OD = 2b Prob =
2 383.89 Std Dev OD =
3 387.71 Max OD = 2c Prob =
4 386.00 Min OD =
5 387.81
6 386.03
7 386.44
8 383.43
9 390.24
10 388.30
11 383.23
12 389.59
13 386.12
14 387.89
15 390.96
16 390.23
17 385.84
18 386.27
19 390.03
20 384.83
21 384.81
22 387.32
23 388.56
24 389.12
25 385.77
26 385.15
27 386.18
28 387.83
29 386.29
30 387.07
31 384.40
32 385.98
33 383.81
34 386.84
35 386.34
36 386.03
37 388.62
38 385.04
39 391.78
40 384.62
41 383.99
42 385.73
43 391.24
44 384.20
45 390.14
46 387.48
47 386.08
48 386.41
49 383.75
50 385.66
51 385.82
52 384.70
53 389.59
54 388.68
55 386.30
56 387.37
57 388.32
58 388.70
59 386.74
60 390.78
61 388.73
62 385.66
63 383.71
64 388.54
65 384.89
66 384.57
67 386.16
68 388.70
69 390.01
70 387.59
71 389.29
72 384.05
73 386.64
74 386.82
75 387.72
76 389.46
77 386.65
78 387.44
79 386.34
80 391.75
81 386.93
82 387.69
83 388.12
84 384.86
85 387.80
86 388.96
87 385.73
88 385.09
89 384.15
90 386.50
91 382.47
92 388.52
93 384.98
94 384.44
95 385.33
96 383.83
97 387.63
98 385.30
99 385.08
100 384.74

Savannah Bee

3a. Mean 2,000
Standard Deviation
3b. Production Quantity Stockout Probability
1,500
1,800
2,400
2,800
3c. Production Quantity 1,500
Cost $11 Sales
Unit Sales Total Production Cost $20 $10 Profit
1,000
2,000
3,000 Average Profit
Production Quantity 1,800
Cost $11 Sales
Unit Sales Total Production Cost $20 $10 Profit
1,000
2,000
3,000 Average Profit
Production Quantity 2,400
Cost $11 Sales
Unit Sales Total Production Cost $20 $10 Profit
1,000
2,000
3,000 Average Profit
Production Quantity 2,800
Cost $11 Sales
Unit Sales Total Production Cost $20 $10 Profit
1,000
2,000
3,000 Average Profit
3d. Production Quantity

Gateway

Grader
X P(x) 4a
4b
Grader
4c Mean =
4d Prob =
4e Prob =

[

]

2

()

()

Px

xEx

×

-

(2)

PX

³

(2)PX

(1)

PX

£

()

xPx

×

()

xEx

-

[

]

2

()

xEx

-