Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

EX4-3: 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_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

Alexander Hamilton On Finance Credit And Debt

Authors: Richard Sylla

1st Edition

0231174012, 978-0231184571

More Books

Students also viewed these Finance questions

Question

1 . Television News channels importantance of our Life pattern ?

Answered: 1 week ago

Question

1. How is the newspaper help to our daily life?

Answered: 1 week ago

Question

1. Prepare a short profile of Mikhail Zoshchenko ?

Answered: 1 week ago

Question

What is psychology disorder?

Answered: 1 week ago