Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Complete the performance report. Review the existing data in the performance report. Calculate the variances. Calculate the variance percentages. Decide whether the variances are favourable

Complete the performance report.

  • Review the existing data in the performance report.
  • Calculate the variances.
  • Calculate the variance percentages.
  • Decide whether the variances are favourable or unfavourable.


Budget

$

Actual

$

Variance

$

% Variance

Favourable (F) or Unfavourable (U)

Nights booked

8,760

7,665

(1,095)

-0.13

IN

Tariff revenues

1,051,200

919,800

(131,400)

-0.13

IN

Less variable costs






Room servicing labour

175,200

160,965

(14,235)

-0.08

F

Room servicing supplies

43,800

41,391

(2,409)

-0.06

F

Total variable costs

219,000

202,356

(16,644)

-0.08

F

Gross profit

832,200

717,444

(114,756)

-0.14

UF

Less fixed costs






Admin/reception salaries

180,000

189,000

9,000

0.05

UF

Grounds & maintenance

100,000

105,000

5,000

0.05

UF

General manager

85,000

87,500

2,500

0.03

UF

Utilities

90,000

86,000

(4,000)

-0.04

UF

Depreciation

140,000

140,000

-

0.00

F

Total fixed costs

595,000

607,500

12,500

0.02

UF

Net profit before tax

237,200

109,944

(127,256)

-0.54

UF

Less estimated tax expense (30%)

71,160

32,983

(38,177)

-0.54

F

Net profit after tax

166,040

76,961

(89,079)

-0.54

UF


Question 2: Record the information you would communicate to others. Comment on the results explaining the likely causes of the variances and any significant issues you would prioritise


Question 3: What recommendations would you communicate to management given these results?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Variances Nights booked Actual 7665 vs Budget 8760 Unfavourable variance of 1095 nights or 13 Tariff ... blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial management theory and practice

Authors: Eugene F. Brigham and Michael C. Ehrhardt

13th edition

1439078106, 111197375X, 9781439078105, 9781111973759, 978-1439078099

More Books

Students explore these related Finance questions

Question

=+b. Determine the range for each data set.

Answered: 3 weeks ago