Comparative analysis report

84 views 11:34 am 0 Comments May 9, 2023

Comparative analysis report

Bistro departmental budget – April

April

Favourable /

Unfavourable

May

June quarter

Budget

Actual

Variance

Variance

Budget

Budget

 

$

$

$

%

 

$

$

Revenue

 

 

 

 

 

 

 

Food sales

105,120

119,837

14,716.80

14

114,975

328,500

Beverage sales

89,250

96,390

7,140.00

91,875

262,500

Total sales

194,370

216,227

21,857

206,850

591,000

Cost of sales

 

 

 

 

 

 

Food purchases

40,953

45,048

42,194

124,100

Beverage purchases

27,563

30,043

2,481

(9)

26,775

78,750

Total cost of sales

68,516

75,091

6,576

68,969

202,850

Gross profit

125,855

141,136

12.1

137,881

388,150

Expenses

 

 

 

 

 

 

Advertising/Promotions

780

624

156

20

962

2,600

Cleaning contractor

1,490

1,490

0

1,490

4,471

Small equipment replacement

333

393

(60)

333

1,000

Laundry

245

232

13

5.5

245

735

Maintenance

1,493

1,262

15.5

1,493

4,480

Printing & stationery

160

195

(35)

(22)

160

480

Training & seminars

408

653

(245)

(60)

396

1,200

Wages & on-costs

85,901

98,771

(12,870)

89,345

260,763

Utilities

3,441

3,235

206

6

3,494

10,589

Total expenses

94,251

106,855

13.4

97,918

285,858

NET PROFIT

31,604

34,281

40,116

102,292