AC3025- Hospitality Finance Final Exam
Problem1. Compute the projected revenue level for July using a four-month moving average and the following sales data
January $180,000
February $220,000
March $230,000
April $200,000
May $250,000
June $280,000
Problem 2. A motel has an occupancy rate of 75%, with 260 rooms available per day. At an ARR of $68; forecast room revenue for the month using 30 days.
Problem 3. Compute the variable cost per unit and the fixed cost per month for the semi-variable expense based on the information provided using the high-low method
MonthVolumeLabor Cost
11500$280
21280$220
32500$380
41750$310
51250$230
Problem 4. If menu prices increase by 5% next year and volume increases by 8% beginning January 1st, forecast sales for the first 6 months
MonthSalesPrice IncreaseVolume increase = Budget
January35,000
February38,000
March44,500
April32,500
May48,000
June46,000
Problem 5. Use the weighted average to compute the average room rate from the following information:
RoomsRate
Single45$65.00
Double55$85.00
Suite15$125.00
Problem 6. Use the following information
Sales = $537,000
Average Guest Check = $18.75
Food Cost Percent = 35.0%
IBIT = $150,000
Calculate Break-even point
Problem 7. Complete the in/off season analysis for the following information
Last YearIn-SeasonOff-SeasonIf Closed
(12 months)(9 months)(3 months)off-season
Sales $400,000$300,000
VC $300,000
CM $100,000
FC $ 60,000
IBIT $ 40,000
Problem 8. Use the CVP analysis method to calculate sales revenue required to achieve an IBIT of $75,000 with the following forecast data: Sales Forecast = $373,000
Variable costs = $167,000
Fixed costs = $103,000
Determine sales required to achieve an IBIT objective of $75,000
Problem 9. Calculate the payback period for the following project. Use straight-line depreciation.
Purchase of equipment $ 100,000
Annual Savings $30,000
Depreciable life of asset 5 years
Salvage value 0
Problem 10. Use the following information to determine the cause of sales variances: (10 points)
BudgetActualVariance
Room Sales463,500516,750
Information from managers budget working papers
Rooms:4,500
Average room rate:$103.00
Current months statistics from the accounting department
Rooms:5,300
Average room rate:$97.50
Problem 11. Provide a series of flexible budgets giving Sales, Variable Costs, Fixed Costs and Net Income for the year for estimated sales levels of 1000, 1500, and 2000 units; using fixed costs of $3,000 and variable costs per unit of $3.00 assuming a sales price per unit of $5.25
Unit Sales 100015002000
Sales Dollars
Variable Costs
Fixed Cost
_________________________________________________________________
IBIT
Problem 12. Calculate the first months ending cash balance for the following:
Beginning cash balance of $15,000
$200,000 Sales, with 40% paid in cash. Half of the sales on account is paid equally in the month of sale and the next month.
Expenses were $120,000 all on credit. 20% paid in the month of purchase and the balance paid the second month.
