Construct a Decision Tree

Description

Hi! Are you able to use the same example to construct a decision tree for the excel sheet you created for me? Im attaching mine and the example for reference.

Unformatted Attachment Preview

Year
Q119
Q219
Q319
Q419
Q120
Q220
Q320
Q420
Q121
Q221
Q321
Q421
Q122
Q222
Q322
Q422
Q123
Q223
Q323
Q423
Dependent Variable (y)
House Prices in Los Angeles
$
672,415
$
656,480
$
672,788
$
697,597
$
705,194
$
698,351
$
718,046
$
767,533
$
781,100
$
810,319
$
844,482
$
867,201
$
899,882
$
923,762
$
919,626
$
908,228
$
873,317
$
872,921
$
914,167
$
939,865
Actuals
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
672,415
656,480
672,788
697,597
705,194
698,351
718,046
767,533
781,100
810,319
844,482
867,201
899,882
923,762
919,626
908,228
873,317
872,921
Moving Avg
Dbl Moving Average
664,448
664,634
685,193
701,396
701,773
708,199
742,790
774,317
795,710
827,401
855,842
883,542
911,822
921,694
913,927
890,773
873,119
664,541
674,913
693,294
701,584
704,986
725,494
758,553
785,013
811,555
841,621
869,692
897,682
916,758
917,811
902,350
881,946
Level
Trend
664,727
695,472
709,497
701,961
711,412
760,085
790,080
806,406
843,246
870,062
897,392
925,962
926,630
910,044
879,195
864,292
187
20,559
16,203
377
6,426
34,591
31,527
21,393
31,691
28,441
27,700
28,281
9,872
-7,767
-23,155
-17,654
House prices in Los Angeles
$1,200,000
$1,000,000
$800,000
$600,000
$400,000
$200,000
$-
Q119
Q219
Q319
Q419
Q120
Q220
Q320
Q420
Q121
Q221
Q321
Q421
Q122
Q222
Q322
Q422
Q123
Q223
Q323
Q423
House prices in Los Angeles
QTR
Q119
Q219
Q319
Q419
Q120
Q220
Q320
Q420
Q121
Q221
Q321
Q421
Q122
Q222
Q322
Q422
Q123
Q223
Q323
Q423
Quarter
Actuals
Forecast
Forecast
664,914
716,030
725,700
702,338
717,838
794,676
821,607
827,799
874,937
898,503
925,092
954,243
936,502
902,277
856,041
846,639
828,985
MSE
MAD
1,068,194,831
117,424,314
747,967,801
246,741,264
2,469,642,720
184,307,776
127,418,944
278,322,489
59,845,696
1,901,641
1,767,570
1,198,319,381
799,419,076
838,652,640
284,942,840
561,657,932
22683.75
11900.00
3233.00
13060.50
42039.00
22547.00
25306.00
32927.00
25580.00
30190.50
26080.25
2868.00
9582.50
29032.75
9024.75
20,404
MAPE
3.37%
1.71%
0.46%
1.87%
5.85%
2.94%
3.24%
4.06%
3.03%
3.48%
2.90%
0.31%
1.04%
3.20%
1.03%
2.57%
On average our forecast varies from actuals by 0.31% so almost 5.85%
by 0.31% so almost 5.85%
Actuals
Time Period
$ 672,415
$ 656,480
$ 672,788
$ 697,597
$ 705,194
$ 698,351
$ 718,046
$ 767,533
$ 781,100
$ 810,319
$ 844,482
$ 867,201
$ 899,882
$ 923,762
$ 919,626
$ 908,228
$ 873,317
$ 872,921
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Time^2
1
4
9
16
25
36
49
64
81
100
121
144
169
196
225
256
289
324
361
400
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
Forecast
MSE
628,072.34
652,426.44
675,870.94
698,405.83
720,031.12
740,746.80
760,552.88
779,449.35
797,436.22
814,513.48
830,681.13
845,939.18
860,287.63
873,726.47
886,255.71
897,875.34
908,585.36
918,385.78
927,276.60
935,257.81
$ 1,966,271,309.17
$
16,431,314.04
$
9,504,527.09
$
654,211.15
$ 220,140,128.98
$ 1,797,403,993.27
$ 1,806,834,685.47
$ 141,999,384.41
$ 266,871,942.95
$
17,593,635.46
$ 190,463,937.13
$ 452,064,838.09
$ 1,567,714,194.54
$ 2,503,554,280.97
$ 1,113,576,572.55
$ 107,177,661.70
$ 1,243,857,265.13
$ 2,067,046,284.26
$ 860,508,898.13
$1,000,000
$900,000
$800,000
$700,000
$600,000
$500,000
$400,000
$300,000
$200,000
$100,000
$-
Q119
Q219
Q319
Q419
Q120
Q220
Q320
Q420
Q121
Q221
Q321
Q421
Q122
Q222
Q322
Q422
Q123
Q223
Q323
Q423
House prices in Los Angeles
QTR
Q119
Q219
Q319
Q419
Q120
Q220
Q320
Q420
Q121
Q221
Q321
Q421
Q122
Q222
Q322
Q422
Q123
Q223
Q323
Q423
Quarter
Actuals
Forecast
MAD
44343
4054
3083
809
14837
42396
42507
11916
16336
4194
13801
21262
39594
50036
33370
10353
35268
45465
24090
MAPE
7%
1%
0%
0%
2%
6%
6%
2%
2%
1%
2%
2%
3%
2%
2%
2%
3%
3%
2%
On average our forecast varies from actuals by 2%.
Actuals
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
672,415
656,480
672,788
697,597
705,194
698,351
718,046
767,533
781,100
810,319
844,482
867,201
899,882
923,762
919,626
908,228
873,317
872,921
Moving Avg
Dbl Moving Average
674,820.00
683,014.75
693,482.50
704,797.00
722,281.00
741,257.50
769,249.50
800,858.50
825,775.50
855,471.00
883,831.75
902,617.75
912,874.50
906,233.25
893,523.00
884,822.00
689,028.56
700,893.81
715,454.50
734,396.25
758,411.63
784,285.25
812,838.63
841,484.19
866,924.00
888,698.75
901,389.31
903,812.13
899,363.19
Level
Trend
720,565.44
743,668.19
767,060.50
804,102.75
843,305.38
867,265.75
898,103.38
926,179.31
938,311.50
937,050.25
911,077.19
883,233.88
870,280.81
10,512.29
14,258.13
17,202.00
23,235.50
28,297.92
27,660.17
28,421.58
28,231.71
23,795.83
16,117.17
3,229.29
-6,859.42
-9,694.13
House prices in Los Angeles
$1,200,000
$1,000,000
$800,000
$600,000
$400,000
$200,000
$-
Q119
Q219
Q319
Q419
Q120
Q220
Q320
Q420
Q121
Q221
Q321
Q421
Q122
Q222
Q322
Q422
Q123
Q223
Q323
Q423
House prices in Los Angeles
QTR
Q119
Q219
Q319
Q419
Q120
Q220
Q320
Q420
Q121
Q221
Q321
Q421
Q122
Q222
Q322
Q422
Q123
Q223
Q323
Q423
Quarter
Actuals
Forecast
Forecast
731,078
757,926
784,263
827,338
871,603
894,926
926,525
954,411
962,107
953,167
914,306
876,374
860,587
MSE
1,328,986,772
537,019,792
678,941,192
293,908,164
19,380,172
24,562,762
7,633,939
1,209,997,674
2,902,982,560
6,376,089,042
1,712,757,886
1,372,023,632
MAD
66639
65646
75923
86070
82916
87043
82278
52702
19529
28072
30891
61610
MAPE
9%
9%
10%
11%
10%
10%
9%
6%
2%
3%
4%
7%
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.850336545
R Square
0.72307224
Adjusted R Square 0.70461039
Standard Error 51437.05614
Observations
17
ANOVA
df
Regression
Residual
Total
Intercept
50000
SS
1 1.0362E+11
15 3.9687E+10
16 1.4331E+11
Coefficients Standard Error
609494.8193 33044.2035
0.267910216 0.04280909
PROBABILITY OUTPUT
Percentile
2.941176471
8.823529412
14.70588235
20.58823529
26.47058824
32.35294118
38.23529412
44.11764706
50
55.88235294
61.76470588
67.64705882
73.52941176
79.41176471
85.29411765
91.17647059
97.05882353
672415
656480
672788
697597
698351
705194
718046
767533
781100
810319
844482
867201
872921
873317
899882
908228
919626
923762
MS
F
Significance F
1.03624E+11 39.16575075
1.53278E-05
2645770745
t Stat
P-value
18.44483314 1.01611E-11
6.258254609 1.53278E-05
Lower 95%
539062.7668
0.17666479
Upper 95%
679926.8718
0.359155641
672415
Normal Probability Plot
1000000
500000
0
0
20
40
60
80
Sample Percentile
Lower 95.0% Upper 95.0%
539062.7668 679926.9
0.17666479 0.359156
100
120
Anova: Single Factor
SUMMARY
Groups
672415
50000
Count
Sum
Average Variance
17 13616827 800989.8 8.96E+09
17 12151142 714773.1 9.02E+10
ANOVA
Source of Variation
SS
Between Groups 6.32E+10
Within Groups
1.59E+12
Total
1.65E+12
df
MS
F
P-value
F crit
1 6.32E+10 1.274001 0.267409 4.149097
32 4.96E+10
33
Quarter
Q119
Q219
Q319
Q419
Q120
Q220
Q320
Q420
Q121
Q221
Q321
Q421
Q122
Q222
Q322
Q422
Q123
Q223
Q323
Q324
Dependent Variable (y)
(X2)
(X1)
House Prices in Los AngelesRemote workers in Los AngelesLos Angeles Employment Pop.
$
672,415
50,000
3,415,696
$
656,480
221,291
3,460,070
$
672,788
233,637
3,151,451
$
697,597
260,000
3,424,188
$
705,194
457,243
3,422,225
$
698,351
567,252
3,291,507
$
718,046
621,637
2,948,425
$
767,533
691,975
3,171,794
$
781,100
750,434
3,133,737
$
810,319
780,283
3,199,561
$
844,482
801,444
3,081,109
$
867,201
807,890
3,234,279
$
899,882
831,726
3,452,457
$
923,762
884,527
3,515,339
$
919,626
900,234
3,316,597
$
908,228
940,500
3,512,564
$
873,317
1,053,769
3,713,424
$
872,921
1,347,300
3,962,648
1,708,733
4,123,245
4,223,423
4,324,552
Total in thousands
House prices in Los Angeles
$2,000,000
y = 65382x + 148859
R² = 0.8714
$1,500,000
$1,000,000
$500,000
$-
Quarter
House Prices in Los Angeles
Remote workers in Los Angeles
Linear (Remote workers in Los Angeles)
Remote workers
Collinearity test
1,800,000
1,600,000
1,400,000
1,200,000
1,000,000
800,000
y = 0.8257x
Remote workers
800,000
600,000
400,000
200,000
0
0
500,000
1,000,000
1,500,000
2,000,000
2,500,000
3,000,000
Los Angeles Employed Population
3,500,000
(X2)
Remote workers in Los Angeles
50,000
221,291
233,637
260,000
457,243
567,252
621,637
691,975
750,434
780,283
801,444
807,890
831,726
884,527
900,234
940,500
1,053,769
1,347,300
1,708,733
$4,500,000
$4,000,000
$3,500,000
$3,000,000
$2,500,000
$2,000,000
$1,500,000
$1,000,000
$500,000
$-
y = 8104.5×2 – 119210x + 4E+06
R² = 0.8825
Q119
Q219
Q319
Q419
Q120
Q220
Q320
Q420
Q121
Q221
Q321
Q421
Q122
Q222
Q322
Q422
Q123
Q223
Q323
Q324
Total in thousands
Los Angeles Employment Pop.
Quarter
House Prices in Los Angeles
y = 0.8257x – 2E+06
R² = 0.368
Los Angeles Employment Pop.
3,500,000
4,000,000
4,500,000
Quarter
Q423
Q323
Q223
Q123
Q422
Q322
Q222
Q122
Q421
Q321
Q221
Q121
Q420
Q320
Q220
Q120
Q419
Q319
Q219
Q119
Dependent Variable (y)
Supercharger Connectors WW
54892
51105
48082
45169
42419
38883
36165
33657
31498
29281
26900
24515
23277
19437
18100
17007
16104
14658
13881
12767
Actuals
14,658
16,104
17,007
18,100
19,437
23,277
24,515
26,900
29,281
31,498
33,657
36,165
38,883
42,419
45,169
48,082
51,105
54,892
Moving Avg
Dbl Moving Average
15,381
16,556
17,554
18,769
21,357
23,896
25,708
28,091
30,390
32,578
34,911
37,524
40,651
43,794
46,626
49,594
52,999
15,968
17,055
18,161
20,063
22,627
24,802
26,899
29,240
31,484
33,744
36,218
39,088
42,223
45,210
48,110
51,296
Level
17,143
18,053
19,376
22,651
25,166
26,613
29,282
31,539
33,672
36,078
38,831
42,215
45,366
48,041
51,078
54,701
Worldwide Supercharger Connectors
70,000
60,000
50,000
40,000
30,000
20,000
10,000
0
Q319
Q419
Q120
Q220
Q320
Q420
Q121
Q221
Q321
Q421
Q122
Q222
Q322
Q422
Q123
Q223
Q323
Q423
Q124
Q224
Total Supercharger Connectors
QTR
Q319
Q419
Q120
Q220
Q320
Q420
Q121
Q221
Q321
Q421
Q122
Q222
Q322
Q422
Q123
Q223
Q323
Q423
Q124
Q224
Quarter
Actuals
Forecast
Trend
1,175
998
1,215
2,589
2,539
1,812
2,383
2,299
2,188
2,334
2,613
3,127
3,143
2,832
2,968
3,405
Forecast
18,317
19,051
20,591
25,240
27,705
28,425
31,665
33,838
35,860
38,411
41,444
45,342
48,509
50,873
54,046
58,106
61,511
MSE
MAD
47,198
149,382
7,214,596
525,263
647,220
733,164
27,889
32,761
93,330
222,548
951,600
29,756
181,902
53,940
716,562
775,141
1045.50
1276.00
3214.25
1888.50
2098.25
2382.00
2258.00
2173.50
2420.75
2665.50
3331.50
2946.50
2872.25
2995.50
3596.00
2,478
MAPE
0.06
0.07
0.17
0.08
0.09
0.09
0.08
0.07
0.07
0.07
0.09
0.07
0.06
0.06
0.07
0.08
On average our forecast varies from actuals by .08 so almost 1%
by .08 so almost 1%
Actuals
Time Period
14,658.00
16,104.00
17,007.00
18,100.00
19,437.00
23,277.00
24,515.00
26,900.00
29,281.00
31,498.00
33,657.00
36,165.00
38,883.00
42,419.00
45,169.00
48,082.00
51,105.00
54,892.00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Time^2
1
4
9
16
25
36
49
64
81
100
121
144
169
196
225
256
289
324
361
400
Forecast
MSE
14298.99
15688.55
17202.09
18839.61
20601.09
22486.56
24496.00
26629.42
28886.81
31268.18
33773.52
36402.84
39156.13
42033.40
45034.65
48159.87
51409.06
54782.24
58279.38
61900.51
128,887
172,596
38,061
547,016
1,355,116
624,796
361
73,216
155,387
52,819
13,577
56,566
74,601
148,686
18,051
6,063
92,455
12,048
198,350
Worldwide Supercharger Connectors
70,000.00
60,000.00
50,000.00
40,000.00
30,000.00
20,000.00
10,000.00
0.00
Q319
Q419
Q120
Q220
Q320
Q420
Q121
Q221
Q321
Q421
Q122
Q222
Q322
Q422
Q123
Q223
Q323
Q423
Q124
Q224
Total Supercharger Connectors
QTR
Q319
Q419
Q120
Q220
Q320
Q420
Q121
Q221
Q321
Q421
Q122
Q222
Q322
Q422
Q123
Q223
Q323
Q423
Q124
Q224
Quarter
Actuals
Forecast
MAD
359
415
195
740
1164
790
19
271
394
230
117
238
273
386
134
78
304
110
345
MAPE
2%
3%
1%
4%
6%
3%
0%
1%
1%
1%
0%
1%
2%
2%
2%
2%
2%
1%
2%
On average our forecast varies from actuals by 2%.
Actuals
14,658.00
16,104.00
17,007.00
18,100.00
19,437.00
23,277.00
24,515.00
26,900.00
29,281.00
31,498.00
33,657.00
36,165.00
38,883.00
42,419.00
45,169.00
48,082.00
51,105.00
54,892.00
57497.42
Moving Avg
Dbl Moving Average
16,467.25
17,662.00
19,455.25
21,332.25
23,532.25
25,993.25
28,048.50
30,334.00
32,650.25
35,050.75
37,781.00
40,659.00
43,638.25
46,693.75
49,812.00
52,894.10
18,729.19
20,495.44
22,578.25
24,726.56
26,977.00
29,256.50
31,520.88
33,954.00
36,535.25
39,282.25
42,193.00
45,200.75
48,259.53
Level
Trend
23,935.31
26,569.06
29,408.25
31,370.44
33,691.00
36,044.00
38,580.63
41,608.00
44,782.75
47,994.25
51,194.50
54,423.25
57,528.68
1,735.38
2,024.54
2,276.67
2,214.63
2,238.00
2,262.50
2,353.25
2,551.33
2,749.17
2,904.00
3,000.50
3,074.17
3,089.72
Worldwide Supercharger Connectors
70,000.00
60,000.00
50,000.00
40,000.00
30,000.00
20,000.00
10,000.00
0.00
Q319
Q419
Q120
Q220
Q320
Q420
Q121
Q221
Q321
Q421
Q122
Q222
Q322
Q422
Q123
Q223
Q323
Q423
Q124
Q224
Total Supercharger Connectors
QTR
Q319
Q419
Q120
Q220
Q320
Q420
Q121
Q221
Q321
Q421
Q122
Q222
Q322
Q422
Q123
Q223
Q323
Q423
Q124
Q224
Quarter
Actuals
Forecast
Forecast
25,671
28,594
31,685
33,585
35,929
38,307
40,934
44,159
47,532
50,898
54,195
57,497
60,618
MSE
1,511,209
472,513
34,938
5,175
55,696
332,352
2,205,596
1,019,427
302,592
42,746
485,809
588,005
MAD
6405
6703
6771
6680
6909
7362
8465
8634
8800
8912
9691
7757
MAPE
26%
25%
23%
21%
21%
20%
22%
20%
19%
19%
19%
21%
Quarter
Q119
Q219
Q319
Q419
Q120
Q220
Q320
Q420
Q121
Q221
Q321
Q421
Q122
Q222
Q322
Q422
Q123
Q223
Q323
Q423
Q124
Dependent Variable (y)
(X1) (previous quarter)
Supercharger Connectors WW Tesla Vehicles Deliveries WW
12,767
90,700
13,881
64,382
14,658
101,498
16,104
97,186
17,007
112,095
18,100
88,496
19,437
90,891
23,277
139,593
24,515
180,667
26,900
184,877
29,281
201,304
31,498
241,391
33,657
308,650
36,165
310,048
38,883
254,695
42,419
343,830
45,169
405,278
48,082
422,875
51,105
435,059
54,892
435,059
55,786
484,000
Total in thousands
Tesla Connectors & Production
600,000
500,000
y = 23272x + 3279.8
R² = 0.9258
400,000
300,000
200,000
100,000
Supercharger Connectors WW
Production
Linear (Production)
Collinearity test
600,000
Production
500,000
400,000
300,000
y = 1.0373x – 5305
R² = 0.9879
Q423
Q323
Q123
Q223
Q422
Q322
Q222
Q122
Q421
Quarter
Q321
Q221
Q121
Q420
Q320
Q220
Q120
Q419
Q319
Q219
Q119
0
Production
300,000
200,000
100,000
0
0
100,000
200,000
300,000
Tesla Vehicle Deliveries
400,000
500,000
(X2) (previous quarter)
Production
86,555 Q418
77,138 Q119
87,048 Q219
96,155 Q319
104,891 Q419
102,672 Q120
82,272 Q220
145,036 Q320
179,757 Q420
180,338 Q121
206,421 Q221
237,823 Q321
305,840 Q421
305,407 Q122
258,580 Q222
363,923 Q322
439,701 Q422
400,808 Q123
479,700 Q223
430,488 Q323
495,000 Q423
Tesla Connectors & Deliveries
y = 673.33×2 + 8988.2x + 55105
R² = 0.9577
400,000
300,000
200,000
100,000
Quarter
Supercharger Connectors WW
Tesla Vehicles Deliveries WW
Q423
Q323
Q223
Q123
Q422
Q322
Q222
Q122
Q421
Q321
Q221
Q121
Q420
Q320
Q220
Q120
Q419
Q319
Q219
0
Q119
Total in thousands
500,000
ANOVA 1: Tesla Vehicle Deliveries/Tesla Charger Connectors
SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
0.97990374
0.96021135
0.95800087
2741.99042
20
ANOVA
df
Regression
Residual
Total
1
18
19
Intercept
Tesla Vehicles Deliveries WW (previous quarter)
Coefficients
7313.29923
0.10014941
SS
MS
3265968399 3265968399
135333205.9 7518511.44
3401301605
Standard Error
1244.70712
0.004805165
t Stat
5.87551811
20.8420319
96% of the variance in the total number of chargers can be explained by the number of Tesla vehicle deliveries
Y=7313.29+0.100149408×(Tesla Vehicles Deliveries WW)
When there are no vehicle deliveries, the model predicts there would be 7,313 charger connectors.
For each additional Tesla Vehicle Delivery, the model predicts an increase of approximately .10014 Supercharger connectors
Tesla delivers 1,000 additional vehicles in a quarter, the model would predict that there will be approximately 100.14 more S
This means we can be 95% confident that the true value of the coefficient (the expected increase in the number of chargers f
ANOVA 2: Tesla Vehicle Production/Tesla Charger Connectors
SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
0.97622502
0.95301529
0.95040503
2979.64542
20
ANOVA
df
Regression
Residual
Total
Intercept
Production (previous quarter)
1
18
19
SS
MS
3241492441 3241492441
159809163.2 8878286.84
3401301605
Coefficients Standard Error
t Stat
8041.87506
1323.370126 6.07681472
0.0956032
0.005003392 19.1076783
F
Significance F
434.390294 4.7209E-14
P-value
Lower 95% Upper 95% Lower 95.0% Upper 95.0%
1.4557E-05 4698.26661 9928.33185 4698.26661 9928.33185
4.7209E-14 0.09005413 0.11024469 0.09005413 0.11024469
sla vehicle deliveries
y .10014 Supercharger connectors the following quarter.
ill be approximately 100.14 more Supercharger connectors available in the following quarter
ncrease in the number of chargers for each additional 10 deliveries) lies between approximately .09005 and 0.1102
F
Significance F
365.103369 2.1148E-13
P-value
Lower 95% Upper 95% Lower 95.0% Upper 95.0%
9.6331E-06 5261.57759 10822.1725 5261.57759 10822.1725
2.1148E-13 0.08509147 0.10611494 0.08509147 0.10611494
Alternatives
Retail and destination
Workplace
Fleet depots
On-the-go
Projected U.S. capital
expenditure needed to meet
charger demand 2030 (billion)
$
$
$
$
Predicted
Projected
Demand 2030
2030
9,000,000,000
4,000,000,000
12,000,000,000
29,000,000,000
2030
740000
553000
541000
459000
Average capital
expenditure per
Charging Station
$
$
$
$
Current Demand
12,162.16
7,233.27
22,181.15
63,180.83
2023
80000
95000
13000
79000
Retail and Destination
$
(12,162.16) $ 184,907.88
Workplace
$
(7,233.27) $ 160,002.98
3
$
264,509.84
Fleet Depots
$
(22,181.15) $ 264,509.84
On-the-go
$
(63,180.83) $ 133,919.21
Current
Charger
Utilization
2023
0.15
0.10
0.30
0.15
Based on the highest returns listed, investing in Fleet Depots would be the best choice since it has the highest expected return a
Retail and Destination would be the second best place to invest in new chargers with a 10% expected utilization increase yieldin
Current Utilization 30% Utilization
Annual Revenue
Increase
30%+ Utilization
Annual Revenue
Daily
Capacity
5455
$
$
$
$
89,591
59,727
179,182
89,591
0.45
0.40
0.60
0.45
$
$
$
$
Avg Cost to
consumer
Daily Total
0.30
268,772.73
238,909.09
358,363.64
268,772.73
40%
Utilization Remains Constant
$ 77,428.84
89591 $
77,428.84
60%
Utilization increases by 30%
$ 256,560.57
268722.73 $
256,560.57
40%
Utilization Remains Constant
$ 52,493.73
59727 $
52,493.73
60%
Utilization increases by 30%
$ 231,675.82
238909.09 $
231,675.82
40%
Utilization Remains Constant
$ 157,000.85
179182 $
157,000.85
60%
Utilization increases by 30%
$ 336,182.49
358363.64 $
336,182.49
40%
Utilization Remains Constant
$ 26,410.17
89591 $
26,410.17
60%
Utilization increases by 30%
$ 205,591.90
268772.73 $
205,591.90
Yearly Total
1636.36 $
597,273
Decision Table
Prob. of utilization
increasing by 30%
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
Prob. of utilization
remaining the same
Decision
100%
90%
80%
70%
60%
50%
40%
30%
20%
10%
0%
Fleet Depots
Fleet Depots
Fleet Depots
Fleet Depots
Fleet Depots
Fleet Depots
Fleet Depots
Fleet Depots
Fleet Depots
Fleet Depots
Fleet Depots

Purchase answer to see full
attachment