Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 4 6 1 Points Prepare a Flexible Budget Analysis Based on the calculations made thus far and the prepared Budgeted Income Statement for Rest
Question
Points
Prepare a Flexible Budget Analysis
Based on the calculations made thus far and the prepared Budgeted Income Statement for "Rest Assured", prepare a Flexible Budget Analysis using the following table.
Round all numbers to the nearest whole number with the exception of RevenueCost per UnitGuest which can be rounded to two decimal places. Use brackets for negative numbers when appropriate. Do not include commas or decimals.
NOTE: The second Blank in the variance columns are meant to be populated with a U for and unfavourable variance or F for a favourable variance. Please refer to the "Sample Row" for correct formatting.
Rest Assured
Flexible Budget Analysis
For the Month Ending January
Actual Results
Flexible Budget Variance
Flexible Budget
SalesVolume Variance
Static Budget
RevenueCost per UnitGuest
SAMPLE ROW
$
$ U
$
$ F
$
Rooms Sold
Blank
Blank Blank
Blank
Room Revenue
Blank Blank
Blank
Blank Blank
$
$
Restaurant Guests Served
Blank
Blank Blank
Blank
Restaurant Revenue
Blank Blank
Blank
Blank Blank
$
$
Total Revenue
U
F
Variable Costs
Housekeeping Wages Expense
Blank Blank
Blank
Blank Blank
Blank
Cost of Sales food & beverage
Blank Blank
Blank
Blank Blank
Blank
Restaurant Wages Expense
Blank Blank
Blank
Blank Blank
Blank
Total Variable Costs
U
U
Rooms Contribution Margin
Blank Blank
Blank
Blank Blank
Blank
Blank
Restaurant Contribution Margin
Blank Blank
Blank
Blank Blank
Blank
Blank
Total Contribution Margin
U
Blank
F
Fixed Costs
Management Salaries Expense
Blank Blank
NA
Utilities Expense
Blank Blank
NA
Property Taxes Expense
Blank Blank
NA
Insurance Expense
Blank Blank
NA
Property Lease Expense
NA
Marketing Expense
Blank Blank
NA
Total Fixed Costs
F
NA
Income from Operations
$
$ F
$
F
$
Blank
Add your answer
Blank
Add your answer
Blank
Add your answer
Blank
Add your answer
Blank
Add your answer
Blank
Add your answer
Blank
Add your answer
Blank
Add your answer
Blank
Add your answer
Blank
Add your answer
Blank
Add your answer
Blank
Add your answer
Blank
Add your answer
Blank
Add your answer
Blank
Add your answer
Blank
Add your answer
Blank
Add your answer
Blank
Add your answer
Blank
Add your answer
Blank
Add your answer
Blank
Add your answer
Blank
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