Rent A Car Project Datasets and description for the case assignments http www washburn edu sobu dnizovtsev RentacarCase html 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 Forecast the demand for economy vehicles in Week 30 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 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

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jan 15, 2021

Rent-A-Car Project Datasets and description for the case assignments: http://www.washburn.edu/sobu/dnizovtsev/RentacarCase.html Estimate the demand for economy vehicles using the variables provided, you might also derive data

Rent-A-Car Project

Datasets and description for the case assignments:

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

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.
Forecast the demand for �economy� vehicles in Week 30.
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.
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