Data Table
Calculations set to Manual. Press F9 to recalculate.
Number of projects: 40 to 55 No. of jobs: 48 Run Profit
Probability of minor 0.65 1 $15,955
Minor revenue (Normal) Job Type Revenue 2 $22,933
16 Minor $100 18 $19,787
17 Major $600 19 $17,762
18 Minor $75 20 $19,175
19 Minor $127 21 $22,094
20 Minor $89 22 $16,609
21 Minor $100 23 $17,528
22 Minor $95 24 $18,208
23 Minor $85 25 $22,191
24 Minor $111 26 $14,708
31 Minor $100 33 $17,421
32 Minor $93 34 $17,788
33 Minor $89 35 $20,219
34 Major $900 36 $15,573
35 Major $1,200 37 $17,595
36 Major $1,200 38 $15,239
37 Minor $119 39 $13,521
38 Major $900 40 $16,133
39 Minor $98 41 $17,852
40 Minor $91 42 $22,471
Problem 10-34
41 Minor $87 43 $25,026
42 Minor $98 44 $17,548
43 Minor $78 45 $22,247
44 Major $900 46 $16,042
55 N/A N/A 57 $16,111
58 $21,758
59 $16,604
60 $18,381
61 $14,974
72 $19,863
73 $18,646
74 $14,225
75 $16,741
76 $14,065
87 $16,236
88 $14,950
89 $20,749
90 $17,428
91 $11,555
102 $15,117
103 $12,363
104 $15,938
105 $21,837
106 $13,250
117 $19,271
118 $20,975
119 $21,880
120 $19,201
121 $18,599
132 $15,699
133 $17,076
134 $21,413
135 $21,868
136 $17,726
147 $20,972
148 $12,212
149 $17,424
150 $21,152
151 $18,910
162 $19,740
163 $22,305
164 $15,372
165 $17,054
166 $15,010
177 $13,020
178 $16,528
179 $16,134
180 $15,633
181 $15,170
192 $14,828
193 $19,457
194 $15,841
195 $17,621
196 $13,991