[HMD340] A#3-SP24-ONLINE 8.40.40 PM

docx

School

University of Nevada, Las Vegas *

*We aren’t endorsed by this school

Course

340

Subject

Accounting

Date

Apr 3, 2024

Type

docx

Pages

2

Uploaded by KidAlligatorPerson769

Report
[HMD340] Hospitality Financial Analysis Assignment #3 Name: Milla Gray [Note] You are required to provide the process for full-credit consideration. If you provide just final answers, you will get credits up to 50% of full-credit. 1. Holly’s Hotel budgeted 800 room sales for the week ended April 24. The estimated average price per room was $18.50. The actual average price per room was 10 percent greater than anticipated, while room sales in units were 10 percent less than forecasted. a. Complete the following table for the Hotel’s revenue variance analysis. Rooms Rate Total Budget 800 $18.50 $14,800 Actual 720 $20.35 $14,652 Difference -80 +$1.85 -$148 b. Calculate the budget variance. Budget Variance = Actual Revenue - Budgeted Revenue From our previous calculations: Actual Revenue = $14,652 Budgeted Revenue = $14,800 Plugging these values into the formula: Budget Variance = $14,652 - $14,800 = -$148 The budget variance is -$148. This indicates that the actual revenue fell short of the budgeted revenue by $148. c. Calculate the price variance. Price Variance = (Actual Average Price per Room - Budgeted Average Price per Room) * Actual Room Sales Given: Actual Average Price per Room: $20.35 Budgeted Average Price per Room: $18.50 Actual Room Sales: 720 rooms Plugging these values into the formula: Price Variance = ($20.35 - $18.50) * 720 = ($1.85) * 720 = $1,332 Page 1 of 2
The price variance is $1,332. This indicates that the actual revenue increased by $1,332 due to the actual average price per room being higher than the budgeted average price per room. d. Calculate the volume variance. Volume Variance = (Actual Room Sales - Budgeted Room Sales) * Budgeted Average Price per Room Given: Actual Room Sales: 720 rooms Budgeted Room Sales: 800 rooms Budgeted Average Price per Room: $18.50 Plugging these values into the formula: Volume Variance = (720 - 800) * $18.50 = (-80) * $18.50 = -$1,480 The volume variance is -$1,480. This indicates that the actual revenue decreased by $1,480 due to selling fewer rooms than budgeted. e. Calculate the price-volume variance. Price-Volume Variance = Revenue Variance - (Price Variance + Volume Variance) Given: Revenue Variance: -$148 (from previous calculations) Price Variance: $1,332 Volume Variance: -$1,480 Plugging these values into the formula: Price-Volume Variance = -$148 - ($1,332 + (-$1,480)) = -$148 - ($1,332 - $1,480) = -$148 - (-$148) = $0 The price-volume variance is $0. This indicates that the total revenue variance is entirely explained by the combination of price variance and volume variance, with no additional variance attributed to interactions between price and volume. Page 2 of 2
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help