Please solve it in one hour, I have very little time.
ABC International Hotel is a 10-story, 350-room hotel situated in Adelaide.
The ABC International Hotel's business results for one day in February were:
Budget Information
F and B revenue budgeted at $12,000. Food & Beverage dept. total department costs are 35% of F and B revenue.
Room Occupancy budgeted at 94%. ADR set at $145. Rooms Division total department costs are 60% of Room revenue.
EBIT is budgeted at 30.02% of total revenue. The budgeted Other (Operating expenses) is 15% of total revenue. Income Tax paid at 30% of earnings before tax.
Actual Results Rooms:
1. Achieved RevPAR of $115.00.
2. Rooms Division COGS were 48% of Room revenue.
Actual results F and B:
1. Food & Beverage revenue is $10,000.
2. Food & Beverage dept. COGS were 30% of F and B revenue.
3. Actual Other (Operating expenses) are $9,250.
Other information:
Loan Interest actually paid $2,000.
Total owners' equity $100,000.
Total Assets $148,000, including: Current Assets $65,000 and Non-Current Assets $83,000.
Total liabilities $48,000, including: Current liabilities $26,000 and Non-Current liabilities $22,000.
Rounding instructions:
All occupied rooms are rounded DOWN.
All percentage calculations to be rounded to two decimal places.
All dollar figures round to whole dollars.
Complete the missing information:
Income Statement Budget S % 100% 60%
Actual S % 100%
Variance S %
Room revenue
Cost of Goods Sold Gross Profit
F&B Revenue Cost of Goods Sold Gross Profit
$10,000 100%
$12,000 100% ($2,000) (16.67%) 35%
Total Revenue Total Cost of Goods Sold
100%
100%