# Shoreline Waikiki Beach Hotel Has Asked You To Calculate The Variance

0 Comment

oreline Waikiki Beach Hotel has asked you to calculate the variance for the following figures for the month of
d August. Also calculate the total profit that was budgeted and actual. Analyse the findings and inform them a
he variance as they are concerned and would like to monitor the income, expenditure, profit levels, budgetary
erformance of their Food and Beverage Department.+
ill in / out the ……… with correct values (\$) using the correct formulas (calculations)+
Item
July-
August
Budget-
Actual-
Variance
Budget
Actual-
Variance
Sales Revenue
230,0004
225,000-
-5000+
230,000+
228,000 -2000
Food Costs
85,000-
87,000 -2000+
85,000
86,000-
-1000+
Beverage Costs
14,000
15,000
-1000+
15,000
15,000-
Labour Costs
77,000
82,000
-5000
78,000
[ 82,000
-4000
Fixed Costs
35,000.
35,000
35,000+
35,000P
Total Costs
211,000
219,000
-8000-
213,000-
180,000-
-5000-
Profit
19,000-
6000-
13000-
17,000-
10.000
-7000-
The Hotel owners and managers would like to know from you the major areas of concern where there is a deviation
that needs further monitoring and improvement.quot;
Sales Revenue
have variance of July is -5,000 and August is -2,000, thing to do offer (and publicize) special
deals and discounts, reaching new customer, can raise the prices on their current sales