DA_Capstone_1_SS.xlsx

	B	C	D	E	G	H	I	J	L	M	N	O
1					Baseline Information
2
3						Annual Costs	Annual Revenue	Profit Margin
4						$ 30,320,298	$ 52,830,207	42.6%
5
6
7
8
9
10
11
12
13
14	Strategy 1				Strategy 2				Strategy 3
15
16	Increase the rental rate for each car.				Eliminate cars with low profit margins.				Eliminate cars rented out the least
17
18		Estimated Costs	Estimated Revenue	Profit Margin		Estimated Costs	Estimated Revenue	Profit Margin		Estimated Costs	Estimated Revenue	Profit Margin
19	Percent Rental Rate Increase:				Lowest profit margins accepted:				Minimum days rented out:
20	5%	$ 30,320,298	$ 55,471,717	45.3%	-45%	$ 30,274,353	$ 52,801,303	42.7%	40	$ 30,244,793	$ 52,769,543	42.7%
21	^^ choose your rate ^^				^^ choose your percent ^^				^^ choose your days ^^
22
23
24
25
26
27
28
29	Observations:
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100