Rent-A-Car Project

Datasets and description for the case assignments:

http://www.washburn.edu/sobu/dnizovtsev/RentacarCase.html

1. Estimate the demand for �economy� vehicles using the variables provided, you might also derive data from other resources and combine with the dataset. Choose the best model.
2. Forecast the demand for  �economy� vehicles in Week 30.
3. Our customers who choose to keep a car for an extra day are currently paying the same base daily rate. Do you see any potential in exploring alternative schemes? If so, what changes should we implement-shall we change the price for extra days? What considerations are involved in this decision? Provide your thoughts on this issue.
4. What other issues or news you would pay attention to adjust your price and managerial strategies?

Rent-A-Car: Description of the variables in the data set

PownE	Average daily rate Rent-A-Car charged for its economy cars in a given week
PownL	Average daily rate Rent-A-Car charged for its luxury vehicles in a given week
Pcomp	Average daily rate of the only competitor across all vehicle categories
Session	Binary variable with 1 indicating weeks when college is in session
Weather	Number of days in a week with severe weather
Unemployment	Number of unemployed workers in the county as of Tuesday each week
FlghtWk	Number of flights (in- and outbound) serving the local airport that week
CancWk	Total number of flights cancelled that week
Holiday	Binary variable with 1 indicating weeks of national holidays (long weekends)
Wrecks	Number of major accidents that week
Discount	Number of customers in a given week using the 15 percent discount off the base rate offered through our affiliate partner, a credit card company
Upgrade	Number of customers who received a free upgrade to a luxury vehicle due to the unavailability of economy vehicles
TotalAd	Amount spent on local advertising each week
AdBlbd	Weekly spending on billboard ads
AdPaper	Weekly spending on ads in local newspapers, including the online version
AdTV	Weekly spending on ads placed with local TV
QE	Number of rental contracts initiated each week in the economy category
Q_length	Number of paid days of rentals, grouped by the agreement starting date
Age<25	Number of rental agreements in a given week for which the person listed as the primary driver on the rental agreement was less than 25 years old
Age25_50	Number of rental agreements for which the person listed as the primary driver on the rental agreement was between 25 and 50 years of age
Age51+	Number of rental agreements in a given week for which the person listed as the primary driver on the rental agreement was 51 years of age or older
FleetAge	Average age of our fleet measured in weeks
BedTax	Amounts collected from the 1% local hospitality tax in the county - this information is reported only on a monthly basis

week	PownE	PownL	Pcomp	session	weather	unempl	flights/wk	canc/wk	holiday	wrecks	TotlAD	QE	Q_length	Age<25	26-50	51+	Q_length	E_days	age/weeks	BedTax
1	29.99	37.99	37.75	0	4	701	41	9	0	22	430	87	334	9	64	14	334	3.839	50.3	$104,025.67
2	29.99	41.99	41.5	0	1	739	41	2	0	16	430	76	327	13	46	17	327	4.303	51.3
3	24.99	26.99	35.25	0	2	814	41	3	0	12	430	82	315	20	51	11	315	3.841	52.3
4	28.99	37.99	35.5	1	1	880	47	0	1	6	430	77	275	24	42	11	275	3.571	53.3
5	24.99	36.99	24.5	1	0	881	47	0	0	10	430	76	316	20	51	5	316	4.158	54.3
6	29.99	43.99	28.75	1	3	799	47	6	0	17	430	78	301	15	59	4	301	3.859	55.3	$70,251.75
7	28.99	44.99	34.5	1	1	857	47	0	0	20	815	81	355	14	55	12	355	4.383	56.3
8	21.99	25.99	33	1	0	871	47	0	0	4	815	91	332	20	61	10	332	3.648	57.3
9	26.76	48.99	29.5	1	0	870	47	0	0	12	815	77	260	20	40	17	260	3.377	58.3
10	28.99	42.99	38.25	1	2	889	47	3	0	19	815	84	317	22	44	18	317	3.774	59.3	$80,998.15
11	25.99	37.99	28	1	0	855	47	0	0	9	2197	76	291	14	49	13	291	3.829	60.3
12	25.99	37.99	30.25	1	0	911	48	2	0	4	2520	75	350	10	54	11	350	4.667	61.3
13	25.99	28.99	31.5	1	0	894	48	0	0	15	1646	68	448	22	36	10	448	6.588	62.3
14	24.99	38.99	28.5	0	0	909	48	0	0	5	815	89	481	38	38	13	481	5.404	63.3	$72,072.62
15	24.99	40.99	30.25	1	1	956	48	0	0	12	815	68	261	21	35	12	261	3.838	64.3
16	23.99	34.99	28.25	1	0	988	48	0	0	8	815	63	227	16	32	15	227	3.603	28.5
17	30.99	41.99	36	1	0	983	48	0	0	9	815	52	186	9	31	12	186	3.577	29.5
18	24.99	41.99	30.5	1	1	938	62	3	0	1	815	94	405	20	64	10	405	4.309	30.5	$83,166.36
19	26.99	41.99	31	1	0	939	62	0	0	1	815	78	314	14	54	10	314	4.026	31.5
20	25.99	45.99	32	1	0	948	62	0	0	3	1455	87	338	12	66	9	338	3.885	32.5
21	26.99	45.99	32.5	1	0	902	64	0	0	7	4965	70	248	19	34	17	248	3.543	33.5
22	29.99	45.99	31	0	2	888	64	1	0	17	4325	86	287	27	45	14	287	3.337	34.5
23	29.99	41.99	33.75	0	0	937	64	1	0	12	4325	68	264	21	31	16	264	3.882	35.5	$92,470.99
24	29.99	41.99	31.25	1	0	953	64	0	0	12	4325	84	405	15	51	18	405	4.821	36.5
25	24.99	41.99	32.5	1	0	983	58	0	0	8	4325	86	374	15	52	19	374	4.349	37.5
26	28.99	40.99	34.75	1	0	988	58	2	0	9	4325	84	458	9	60	15	458	5.452	38.5
27	24.99	46.99	33	1	0	995	58	0	1	11	4325	92	400	10	68	14	400	4.348	39.5	$91,174.48
28	29.99	40.99	31.5	0	0	961	58	0	0	2	4325	81	459	11	53	17	459	5.667	40.5
29	28.99	37.99	37.75	1	0	996	58	0	0	6	4325	85	396	14	60	11	396	4.659	41.5
30	27.99	37.99	37.5	1	0	945	58	0	0	1	4018	89	458	14	63	12	458	5.146	42.5
31	29.99	37.99	37.25	1	0	986	59	0	0	5	6268	80	344	16	48	16	344	4.300	43.5
32	26.99	40.99	31	1	1	953	59	0	0	5	4018	80	269	17	48	15	269	3.363	44.5	$182,486.48
33	30.99	39.99	37.25	0	0	989	59	3	0	6	4018	85	332	15	56	14	332	3.906	45.5
34	31.99	46.99	38.25	0	0	1031	59	0	0	13	4018	77	303	22	37	18	303	3.935	46.5
35	30.99	46.99	31.25	1	0	1042	59	0	0	5	4853	67	297	23	28	16	297	4.433	47.5
36	27.99	38.99	32.25	1	0	1023	59	0	1	2	3477	81	478	14	51	16	478	5.901	48.5	$56,038.77
37	28.99	40.99	37	1	0	1045	61	0	0	7	4485	84	263	21	48	15	263	3.131	49.5
38	29.99	37.99	38.75	1	0	1065	61	0	0	11	2642	78	367	20	44	14	367	4.705	50.5
39	30.99	41.99	37.75	1	0	1037	61	0	0	15	2642	71	263	22	32	17	263	3.704	33.2
40	30.99	42.99	39.5	1	0	1052	61	0	0	11	2642	77	222	14	43	20	222	2.883	34.2	$123,935.45
41	26.99	41.99	31	1	0	1055	61	0	0	12	508	89	279	9	63	17	279	3.135	35.2
42	31.99	38.99	31.25	1	1	1071	61	3	0	12	508	71	343	16	38	17	343	4.831	36.2
43	34.99	39.99	35	0	0	1104	61	0	0	11	1237	61	294	16	27	18	294	4.820	37.2
44	28.99	40.99	35.75	1	0	1145	61	0	0	7	1237	72	349	14	42	16	349	4.847	38.2
45	25.99	41.99	37.5	1	0	1157	61	0	0	6	3117	101	441	14	71	16	441	4.366	39.2	$99,591.43
46	34.99	46.99	31.5	1	0	1136	61	0	0	9	1237	52	215	16	24	12	215	4.135	40.2
47	25.99	37.99	33.25	1	2	1140	61	2	1	15	1237	103	388	17	74	12	388	3.767	41.2
48	28.99	42.99	39.5	1	0	1146	58	2	0	12	1237	75	354	12	49	14	354	4.720	42.2
49	27.99	45.99	37	1	2	1156	58	4	0	14	3852	95	372	7	71	17	372	3.916	43.2	$70,942.70
50	34.99	40.99	30.5	1	0	1166	53	0	0	18	1237	73	452	9	53	11	452	6.192	44.2
51	34.99	39.99	30	0	1	1175	53	0	0	21	1237	89	362	15	55	19	362	4.067	45.2
52	26.99	41.99	35.25	0	0	1155	53	0	1	6	1237	82	353	14	51	17	353	4.305	46.2p

Answer rating: 100% (QA)

These solutions may offer stepbystep problemsolving explanations or g... View the full answer