E - Task 3 Management ReportPrepare a management report

• Prepare a short report to management outlining the following information.
• Positive and negative budget variations indicated in monthly and quarter analysis reports and profit and loss statement that are significant enough to affect the operation of the bistro and its profitability.
• Trends identified in the trend analysis report that have the potential to affect the bistro's profitability in the immediate future.
• Possible reasons for the positive or negative variations and trends.
• Any recent actions that have been taken or changes to operational procedures as a result of trends and deviations.
• Base the report on the following information.
• Profit and loss statement
• Trend analysis report
• April, May and June comparative analysis reports
• Case study information provided in Assessments C and D
• Your responses to questions in Assessments C and D
• The report should present information in a clear, concise and easy to understand manner so it supports good decision-making processes.
• Save your completed management report as Assessment E_Management report.
• Submit the completed report to your assessor once completed.

Submission status

Attempt numberThis is attempt 1 ( 4 attempts allowed ).Submission statusNo attemptGrading statusNot gradedLast modified-Submission commentsComments (0)

Make changes to your submission

Jackson Hotel operational budget - June quarter

April

May

June

June quarter

$

$

$

$

Revenue

Food sales

116,800

127,750

120,450

365,000

Beverage sales

240,000

247,500

262,500

750,000

Tab commission

49,300

47,850

47,850

145,000

Total revenue

406,100

423,100

430,800

1,260,000

Cost of sales

Food purchases

48,180

49,640

48,180

146,000

Beverage purchases

84,000

86,625

91,875

262,500

Total cost of sales

132,180

136,265

140,055

408,500

Gross profit

273,920

286,835

290,745

851,500

Expenses

Accounting

2,700

3,000

4,300

10,000

Advertising/promotions

3,900

4,810

4,290

13,000

Bank charges

7,582

7,359

7,359

22,300

Cleaning contractor

7,451

7,451

7,451

22,354

Commission credit card

767

767

767

2,300

Small equipment replacement

833

833

833

2,500

Insurance

1,833

1,833

1,833

5,500

Laundry

347

357

347

1,050

Legal fees

1,280

360

360

2,000

Licence fees & permits

983

983

983

2,950

Motor vehicle expenses

500

500

500

1,500

Maintenance

4,224

4,352

4,224

12,800

Printing & stationery

800

800

800

2,400

Rubbish removal

500

500

500

1,500

Communication

2,000

2,000

2,000

6,000

Training & development

1,190

1,155

1,155

3,500

Wages &on-costs

193,050

198,900

193,050

585,000

Utilities

12,000

11,647

11,647

35,295

Total expenses

241,941

247,608

242,400

731,449

NET PROFIT

31,979

39,227

48,345

120,051