Sample Profit And Loss

Understanding Profit & Loss Every Outlet works to a Budget which has been set for the financial year. Our financial year runs from start October to end September. Theses figures are then phased over 13 x 4 weekly Periods depending on time of year, key dates and local/national events. The end date of each Period is shown at the top of the P&L. 1.This band of figures shows our actual 4 weekly take (less vat) for the periods

2.These figures are our “Gross Profit” [Sales (less vat) - Cost of Sales] from the take above. Calculated by 1. X 6. 3.This shows all our Managerial Costs [i.e. Employment Costs, Energy, Entertainment & Promotions, Uniforms, Taxis, Crockery, Cleaning Materials…etc] which eat away our Gross Profit in 2. [A full breakdown of which can be found on the reverse of the P&L] 4.This shows our “Managerial Profit” [Gross Profit - Managerial Costs] from the 4 weeks take in 1. Calculated by 2. - 3. Managers are bonused on this figure if ahead of Budget come the end of the financial year as well as receiving 2% of these totals every Quarter 5.These are the Budget figures for the year phased over 13 Periods. What MAB would like you to take and spend 6.These percentages are based against actual Sales in line 1. A.This column tells us how we are doing for the “latest Period” against Budget for that Period in 5. and how we are doing compared to last year for the same Period B.This column tells us how we are doing for “all Periods to date” against all the same Period Budgets in 5. And how we are doing compared to all the same Periods this time last year Note: Figures that are in (brackets) mean you are behind sales or overspent to budget except on page 2 or the reverse sheet of the P&L where a (bracket) here would indicate you have made a saving or had a credit ! Abbreviations: PD or Pd = Period Bud = Budget LY = Last Year Cum = Cumulative (running total) VAR = Variance

1

Pub Nam e

A

Description Drinks Food

1

Accom odation Machines Pay/Room Phones

Annual Budget

27961

27404

33002

35761

27895

27630

33090

34756

34100

31102

1116

1627

312702

5546

17288

399533

1226

1116

1223

1130

1082

1098

1200

1463

1056

1233

39

262

11827

[113]

152

15522

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

2020

2230

2039

2461

2094

2192

2267

2102

2675

2482

805

788

22563

1772

3831

26203

130

129

227

199

121

138

149

157

154

154

49

1533

1533

316

0

31

53

14

61

59

57

105

80

96

117

[66]

35

673

[1334]

[347]

3043

TOTAL SALES

31367

30933

36407

39640

31329

31098

36800

38550

38084

35088

2048

2761

349298

7404

21240

444301

Drinks

20362

19628

23579

26025

20040

19944

24080

25348

24638

22731

769

1593

226376

3777

17203

290573

639

496

625

319

510

514

526

837

365

582

[3]

1402

5414

[436]

982

7606

Accom odation

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Till Varience

9

[7]

[7]

[2]

28

[30]

[3]

[15]

58

1

1

2

33

33

107

0 15866

1286

1506

1333

1691

1365

1478

1571

1401

1954

1827

812

810

15412

2824

4014

Pay/Room Phones

73

110

82

181

164

19

83

74

187

154

154

102

1126

1126

473

0

Other Gross Profit

31

53

14

61

59

57

105

80

96

117

[19]

35

673

[813]

[347]

2254

22400

21786

25626

28275

22166

21982

26362

27725

27298

25412

1714

3944

249034

6511

22432

316299

Salary & NI

3054

2949

3070

3117

2773

2910

2313

1831

1811

1935

505

340

25763

[1974]

[3544]

31104

Staff Wages & NI

3208

3312

3895

4500

3306

3557

4419

3951

3917

4248

[498]

[1197]

38314

67

[2317]

49923

323

323

323

323

323

323

323

257

257

257

11

4

3035

[355]

[429]

3488

6585

6584

7288

7940

6402

6790

7055

6039

5985

6440

18

[853]

67112

[2262]

[6290]

84515

177

321

TOTAL GROSS PROFIT

Other Em ploym ent TOTAL EMPLOYMENT Energy Ents/Prom otions Other Managerial

4

Cum LY VAR

129

Machines

3

B

PD LY Cum Bud VAR Cum YTD VAR

Other Incom e

Food

2

PD 1 PD 2 PD3 PD4 PD5 PD 6 PD7 PD8 PD9 PD10 PD11 PD12 PD13 Pd Bud 26/10/9 23/11/9 21/12/9 18/01/9 15/02/9 15/03/9 12/04/9 10/06/9 07/06/9 05/07/9 01/08/9 30/08/9 27/09/9 VAR

31

965

572

271

903

360

428

160

207

329

903

1104

1143

687

585

708

899

848

925

861

82 [170]

4226

834

763

6583

8661

[1212]

[1074]

10287

549

393

809

580

582

361

464

458

1225

534

127

61

5956

654

[186]

8567

MANAGERIAL COSTS

8068

9046

9812

9478

8472

8219

8846

7505

8342

8164

404

[641]

85955

[1986]

[6787]

109952

MANAGERIAL PROFIT

14332

12740

15814

18797

13694

13763

17516

20220

18956

17248

2118

3303

163079

4525

15645

206347

MANAGEMENT COSTS

2445

1966

2374

3128

2105

2689

2598

2543

2894

2546

[109]

[108]

25288

[1526]

[5592]

31074

MANAGEMENT PROFIT

11887

10774

13440

15669

11589

11074

14918

17677

16062

14702

2009

3195

137791

2999

10053

175273

***KEY BUDGETS*** Drinks (Sales)

30648

28634

36375

30508

28507

28760

31712

32244

29782

29986

30321

31010

31046

307156

399533

"

1194

1194

1194

1194

1194

1194

1194

1194

1194

1194

1194

1194

1194

11940

15522

Accom "

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Machines "

2193

2156

2193

2178

2195

2157

2098

2040

1904

1677

1728

1768

1916

20791

26203

Total Sales

Food

5

34274

32202

39835

34136

32096

32369

35232

35669

33041

33040

33606

34325

34476

341894

444301

Staff Wages & NI

3830

3588

4519

3813

3572

3603

3958

4022

3726

3750

3791

3874

3877

38381

49923

Total Em ploym ent

6444

6202

7133

6427

6186

6217

6619

6730

6434

6458

6499

6582

6584

64850

84515

Other Managerial

661

661

661

661

661

661

661

661

661

661

661

661

635

6610

8567

MANAGERIAL PROFIT

15797

14604

19215

15873

14685

14906

16642

16627

15075

15130

15550

16042

16201

158554

206347

MANAGEMENT PROFIT

13447

12254

16865

13523

12352

12573

14257

14190

12638

12693

13113

13605

13763

134792

175273

72.8

71.6

71.4

72.8

71.8

72.2

72.8

72.9

72.3

73.1

0

0

0

0.4

1.4

72.4

[0.3]

1.6

52.1

44.4

51.1

28.2

47.1

46.8

43.8

57.2

34.6

47.2

0

0

0

[1.8]

1.6

45.8

[3.2]

7.8

49

Machines GP %

63.7

67.5

65.4

68.7

65.2

67.4

69.3

66.7

73

73.6

0

0

0

13

13.6

68.3

7.7

7.5

60.6

Salary & NI /DFA %

7.5

***KEY RATIOS*** Drinks GP Food

6

GP

% %

72.7

10.5

10.3

9

8.4

9.6

10.1

6.7

5.1

5.2

6

0

0

0

1.5

1.5

7.9

[0.4]

[0.7]

Staff Wages / DFA %

11

11.6

11.4

12.2

11.4

12.4

12.9

10.9

11.1

13.1

0

0

0

[1.1]

[3.1]

11.8

0.2

[0.1]

12

TOTAL EMP /DFA %

22.6

23.1

21.3

21.5

22.1

23.6

20.6

16.7

17

19.9

0

0

0

0.5

[1.5]

20.7

[0.3]

[0.9]

20.4

Ent/Prom /DFA %

3.1

3.9

3.3

1.9

2

2.5

2.6

2.3

2.6

2.7

0

0

0

[0.2]

[0.4]

2.7

[0.2]

[0.2]

2.5

MANAGERIAL PROFIT %

45.7

41.2

43.4

47.4

43.7

44.3

47.6

52.5

49.8

49.2

0

0

0

2.8

6.1

46.7

0.3

1.8

46.4

MANAGEMENT PROFIT %

37.9

34.8

36.9

39.5

37

35.6

40.5

45.9

42.2

41.9

0

0

0

2.5

6.3

39.4

0

0.5

39.4

2

Description LHM Salary

PD 1 26/10/9

PD 2 23/11/9

PD3 21/12/9

PD4 18/01/9

PD5 15/02/9

PD 6 15/03/9

PD7 12/04/9

PD8 10/06/9

PD9 07/06/9

PD10 05/07/9

1292

1292

1292

1292

1292

1292

1306

1324

1324

1324

LHM Prof it Share

293

261

306

364

252

337

365

355

347

450

Partner

476

476

476

476

476

476

485

785

740

783

766

552

609

PD11 01/08/9

PD12 30/08/9

PD13 27/09/9

Pd Bud VAR

PD LY VAR

Cum Y TD

Cum Bud VAR

Cum LY VAR

A nnual Budget

Relief Manager A ssistant Manager Trainee Manager Other & NI

208

181

214

219

202

197

157

152

141

161

Salary & NI

3054

2950

3071

3117

2774

2911

2313

1831

1812

1935

Bar Staf f

2506

2206

2497

2744

2379

2598

3338

2977

2868

3129

Catering

339

624

501

516

435

557

576

530

578

513

315

336

353

341

334

314

372

342

346

367

100

500

830

100

Hotel Cleaners Doormen

100

Other NI Staf f Wages & NI

47

47

44

70

58

89

133

102

125

139

3207

3313

3895

4501

3306

3558

4419

3951

3917

4248

Gas

111

46

239

[98]

120

[35]

68

89

51

5

Electricity

[80]

919

333

369

783

395

360

71

156

324

Energy other Energy Total Entertain: WSOB

31

965

572

271

903

360

428

160

207

329

800

870

1025

585

460

584

690

660

790

740

5

132

16

23

13

80

17

11

17

Entertain: Of f . Ctr Promotions: Drinks Promotions: Food Ent / Proms: Other Total Ent / Proms

98

102

102

102

102

111

129

171

124

14

903

1104

1143

687

585

708

899

848

925

861

97

23

117

28

77

41

72

56

50

97

Cash Loss /(Prof it) Cleaning Materials

139

Crockery & Cutlery Equipment Hire

61

24

96

69

112

143

[21]

98

91

76

Sky TV

81

79

81

79

81

84

79

89

70

82

14

57

14

71

37

39

106

[5]

44

43

43

42

42

25

371

[143]

10

6

60

5

10

5

33

13

6

115

83

46

144

[8]

75

68

[95]

127

Ref use Collection

[4]

24

184

27

25

[145]

25

92

29

Serviettes / Menus

16

30

8

101

Gardening Glassw are LHM Phone Costs

75

42

LHM Expenses P, P, & Stationery Dispense Gas

19

21

8

Taxis Unif orms Window Cleaning

15

WSOB: Other

15

15

30

15

86

53

20

52

15 14

32

0

Of f ice Ctrl: Other

44

49

13

233

9

113

64

38

410 94

95

Total Other Mgrl

549

393

809

580

582

361

464

458

1225

534

BRACKETS on this pa ge indicate a credit (i.e. £80 credit for Ele ctricity in Pd 1 a ssuming w e w e re ove r-charge d the previos financial ye ar)

3