Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

JW Hotel (JWH) has three operating departments including room department, gift shop and restaurant. Following are data of revenues, expenses and profits for the year

JW Hotel (JWH) has three operating departments including room department, gift shop and restaurant. Following are data of revenues, expenses and profits for the year ended 31 December, 2016 (in US dollars):

1. Data from department P/L statements:

Year 2017

Budget 2017

Year 2016

Room revenue

2,380,500

2,358,400

2,240,000

Gift shop revenue

207,000

228,800

128,000

Restaurant revenue

862,500

932,800

832,000

Total hotel department revenues

3,450,000

3,520,000

3,200,000

Room department expenses

833,175

778,272

739,200

Gift shop department expenses

155,250

171,600

96,000

Restaurant department expenses

603,750

680,944

565,760

Total hotel department expenses

1,592,175

1,630,816

1,400,960

2. Data related to expense centers and fixed expenses are as follows:

Year 2017

Budget 2017

Year 2016

Interest expense

100,000

100,000

100,000

Wage and benefit expense

241,500

246,400

224,000

Heat, light, and power

138,000

140,800

128,000

Property insurance

50,000

50,000

50,000

Repairs and maintenance

172,500

176,000

160,000

Accident expense

34,500

35,200

32,000

Lease expense

50,000

50,000

50,000

Training expense

51,750

52,800

48,000

Advertising

207,000

211,200

192,000

Licenses and permits

10,000

10,000

10,000

Management fee

69,000

70,400

64,000

Depreciation

100,000

100,000

100,000

3. Income tax rate: 30%

Required:

1. Prepare Consolidated P&L Statement for year 2016 (including three columns: this year, budget and last year)

2. Compute dollars change and percentage change for the following items. Discuss the current year performance.

Actual

Budget

Last Year

Dollars change

Percentage change

Actual to Budget

Actual to Last Year

Actual to Budget

Actual to Last Year

Total hotel revenue

Total hotel department expenses

Total hotel department prot

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Step: 3

blur-text-image

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

Lessons Learned On The Audit Trail

Authors: Richard F.Chambers, CIA, QIAL, CGAP, CCSA, CRMA

1st Edition

ISBN: 0894139037, 978-0894139031

More Books

Students also viewed these Accounting questions

Question

Draw a schematic diagram of I.C. engines and name the parts.

Answered: 1 week ago