Answered step by step
Verified Expert Solution
Question
1 Approved Answer
#2. A motels management discovered that a defective product was used in the motels construction. It took seven months to correct the defects, during which
#2. A motels management discovered that a defective product was used in the motels construction. It took seven months to correct the defects, during which time approximately 14 rooms in the 100-unit motel were taken out of service for one month at a time. The motel lost profits due to these closures, and the question of how to compute the losses was addressed. For this question, use the data in motel.sas. (a) The occupancy rate for the damaged motel is MOTEL_PCT, and the competitor occupancy rate is COMP_PCT. On the same graph, plot these variables against TIME. Which had the higher occupancy during the repair period (The reference lines are a Time=17 and Time=23)? (b) Compute the average occupancy rate for the motel and competitors when the repairs were not being made (call these 0 and 0) and when they were being made (1 and 1). During the non-repair period, what was the difference between the average occupancies, these 0 and 0? Assume that the damaged motel occupancy rate would have maintained the same relative difference in occupancy if there had been no repairs. That is, assume that the damaged motels occupancy would have been 1 = 1 +(0 0). Compute the simple estimate of lost occupancy 1 1. Compute the amount of revenue lost during the seven month period (215 days) assuming an average room rate of $56.61 per night (Hint: use calculator not SAS or R). 0 = 0 = The difference between the two is 0 0 = 1 = 1 = 1 = 1 + (0 0) = ? 215 $56.61 ( 1 1)= (c) Alternatively, consider a regression approach. A model explaining motel occupancy uses as explanatory variables the competitors occupancy, the relative price (RELPRICE) and an indicator variable for the repair period (REPAIR). That is, let = 1 + 2 + 3 + 4 + Obtain the least squares estimators of parameters. Interpret the estimated coefficient, as well as their signs and significance. 2 = 0.6326. This implies that holding other variables constant, on average, a one percentage increase in the competitors occupancy rate is estimated to increase the damaged motels occupancy rate by 0.63 percent. The significant test suggests that the estimate is significant at five percent. (d) Using the least squares estimate of the coefficient of REPAIR from part (c), compute an estimate of the revenue lost by the damaged motel during the repair period (215 days $56.61 4). Compare this value to the simple estimate in part (b). Construct 95% confidence interval estimate for the estimated loss (Hint: 95% C.I.=215 56.61 4 2.08 215 56.61 ..(4)). Is the estimated loss from part (b) within the interval estimate
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started