2016 - Barchester Comparator Report

Creditors

Page 1

06/12/2016

PREFACE Throughout the report your figures are shown in tables and in graphical form. If you are not familiar with our reports we hope this page will help you to better understand the way we present this data. Averages: Almost all of our tables and charts compare your figure with a group average. The average is the unweighted mean value for the group. This average value ignores missing data, or data that we have excluded and for this reason sets of averages sometimes do not reconcile precisely. Charts: We display a large amount of data on charts as this allows us to show the data for the entire group efficiently and gives far more information than a simple average (i.e. range of data, individual authority values etc…). Below we have annotated an example chart to help explain what they are showing.

Bar Charts: These are our standard method of displaying a full set of data Each bar represents an authority's value

100%

Title

% Remittances faxed or emailed

90% 80%

Your authority's bar highlights in black

70% 60%

The group average is shown by a horizontal line

50% 40% 30% 20% 10% 0%

% BACS remittances 'Missing bars' on the left represent missing data or excluded data and are not included in calculating the average

Faxed E-mailed Posted Not sent

Creditors

Page 2

%

Avg

54%

22%

0%

4%

46%

71%

0%

3%

'Missing bars' on the right represent zero values and are included in the average

06/12/2016

INTRODUCTION The report is divided into the following sections: Page 1

Summary 2016

2

Cost Performance

5

3

Central Processing Costs

4

Payment Information

11

5

Staff Related Information

15

6

Timeseries Analysis

17

6A,6B 7

Section 1 - Summary 2016 This page provides a brief summary of the most salient aspects of the report. Section 2 - Cost Performance This section concentrates on the cost/invoice ratio and various breakdowns. It is useful for identifying areas of good and poor cost performance. Care should be taken to ensure comparator authorities have a similar workload mix for types of invoice. Some members have not shown local data prep costs. Where their volume of local-input invoices is significant we cannot therefore compare their total costs per invoice, only their central costs. A comparison of central costs alone is not very meaningful between centralised and decentralised authorities. We have therefore presented two alternative versions of the cost per invoice comparisons: - Pages 6A Figures and 6A Charts compare total costs per invoice, and excludes members with over 20% local input invoices who have not shown the associated costs. - Pages 6B Figures and 6B Charts compare central costs and local costs separately. This excludes members with under 20% local input. (The local and total cost comparisons obviously also exclude those not showing these costs). Members with over 20% local input, who have shown these costs, are covered in both sets of comparisons, and their report includes both sets of pages. Other benchmarks shown are staff cost/FTE and invoices/FTE Section 3 - Central Processing Costs This section takes the information from Table 2(b) of the questionnaire and displays it in the same way that the costs information is fed back in 6A and 6B of this report. Section 4 - Payment Information This section looks at: - payment performance using the benchmark: invoices paid on time and levels of processing error - methods and frequency of payment - types of invoice - % invoices paid by BACS - days added for postage.

Creditors

Page 3

06/12/2016

Section 5 - Staff Related Information This section looks at: - pay by band, which gives a comparison of salary levels - sickness, which is analysed for both long-term and short-term sickness - staff turnover. Staff cost/FTE and Invoices/FTE are shown in Section 2. Section 6 - Timeseries Analysis This section is particularly useful as it shows performance over time compared with the average for your tier. The timeseries shown are for cost/invoice, staff cost/invoice, IT cost/invoice, other costs/invoice and normal invoices as a % of the total.

Creditors

Page 4

06/12/2016

SECTION 1 - SUMMARY 2016 KEY: Club average

TOTAL COST/INVOICE 2015/16 £15.00

X

Barchester

Total cost

Total cost

£2.00 £1.50

£10.00

£1.00 £5.00 £0.50 £0.00

£0.00 h

z

e

d

n

j

s

x

w

t

g

o

k

b

u m

r

a

f

2011

2012

2013

2014

2015

2016

STAFF COST/INVOICE 2015/16 £8.00

Staff cost

Staff cost

£2.00

£6.00

£1.50

£4.00

£1.00

£2.00

£0.50 £0.00

£0.00 e

z

h

d

j

s

n

t

k

x

g

o

w m

b

r

f

a

2011

u

COST £'000/FTE

2012

2013

2014

2015

2016

INVOICES PROCESSED/FTE

£50

50

Cost £'000/FTE

£40

40

£30

30

£20

20

£10

10

£0

Invoices/FTE '000

0 z

e

s

n

b

j

m

h

k

g

f

u

t

o

d

r

x

w

b

a

u

f

r

a

m

g

w

o

x

k

n

t

s

j

d

CENTRAL PROCESSING COST/INVOICE

BVI8 INVOICES PAID ON TIME

£10.00

100%

Total central processing cost

£8.00

z

e

h

% paid within 30 days

90%

£6.00 80%

£4.00

70%

£2.00 £0.00

60% k

h

z

j

s

d

e

n

b

u w

r

o

g

x

t

m

f

a

u

k

j

g

f

n

e

x

h

t

r

a

w

s

b

m o

d

z

INVOICES PAID BY BACS % invoices paid by BACS

100% 80% 60% 40% 20% 0% u

Creditors

k

j

h

g

d

a

z

b

x

t

s

r

n m e

f

w o

Page 5

06/12/2016

SECTION 2 - COST PERFORMANCE Excludes members with >20% of invoices input locally who have not shown local costs

COST/INVOICE TREE 2015/16 This tree diagram analyses the cost per invoice. For each benchmark two figures are given the first being the authority's cost and the second is the group average. Staff Direct costs £1.30

Cost per FTE staff

£1.21

£22,955

£1.86

£25,933

Invoices per FTE

£1.97

19,009

24,306

Postage Other running costs Core cost per invoice £1.49

£0.09

na

£0.05

£0.11 Other

£2.84 IT

na

£0.10

£0.06

£0.24

% Local invoices 21%

Indirect costs

6%

£0.20

Accommodation £0.87

£0.11

Central charges

Local cost/Local invoice £1.88

£0.10

£0.00

£2.44

£0.53

Outsourcing costs £0.00

Costs (£'000)

£0.00

Core Creditor cost from Procurement

Local batching & data input

Benchmark Creditor's cost

45

-

100

303

25

3

-

273

48

-

100

325

Central Creditor Cost

Central Creditor Non-core

Direct Costs Staff Other running costs Total Direct Costs

248

22

Indirect Costs IT

25

-

-

25

Accommodation

29

4

-

25

Central charges

-

-

-

-

54

4

-

-

-

-

-

-

Total cost

327

52

-

100

375

FTE staff

9.5

1.3

5.0

13.2

Total Indirect Costs Outsourcing costs

-

50

Invoices ('000) Input in Creditors' section Input in other departments

74.6

Work for other bodies

53.3

Value Avg

Others

123.0

Work for other bodies (%)

na

Total

250.9

Work for other bodies (£'000)

..

Creditors

Page 6A - Figures

3%

06/12/2016

COST PER INVOICE 2015/16 Excludes members with >20% of invoices input locally who have not shown local costs £8.00

Direct costs

£6.00 £4.00 £12.00

Total cost

£2.00

£10.00 £0.00 e

£8.00

z h d s

j

n

t

o k x g w m f

a b

r

u

£6.00 £4.00 £5.00

Indirect costs

£2.00 £4.00 £0.00 h

z

e

d n

j

s

x w

t

g

o

k

b u m r

a

f

£3.00 £2.00 £1.00 £0.00 h z d n w e x u b g k o m j

% Local invoices

80%

r

t

a

f

s

60% 40%

£1.00

20%

£0.80

0%

Outsourcing costs

£0.60 g

t

a

r m w z x u s o n k

j

h

f

e d b

£0.40 £0.20 £0.00

Cost/Local invoice

£8.00

z

x w u

t

s

r

o n m k

j

h g

f

e d b a

£6.00 £4.00 £2.00 £0.00 z x u s

r

o n m k

j

h

f

e d b w t

g a

COST PER INVOICE 2015/16 - STAFF ANALYSIS £50

Cost £'000/FTE

£40 £30 £7.00

Staff cost

£20 £10

£6.00

£0

£5.00

z

e

s n b

j m h k g

f

u

t

o d

r

x w a

£4.00 £3.00 £2.00

50

£1.00

Invoices/FTE '000

40

£0.00 e

z

h

d

j

s

n

t

k

x

g

o w m b

r

f

a

u

30 20 10 0 b u

Creditors

Page 6A - Charts

f

r

a m g w o x

k

n

t

s

j

d

z

e

h

06/12/2016

COST PER INVOICE 2015/16 - DIRECT COSTS

£8.00

Staff cost

£6.00 £4.00

£7.00

£2.00

Direct costs

£6.00

£0.00 e

£5.00

z h d

j

s n

t

k x g o w m b

r

f

a u

£4.00 £3.00 £2.00 £0.60

£1.00

Other running costs

£0.00 e

z

h

d

s

j

n

t

o

k

x

g w m f

a

b

r

£0.40

u

£0.20

£0.00 e d n o s z a

t

h w x

f

u

r

j

b g m k

Direct costs 2015/16 £'000 £/trans Staff Other running costs Total direct costs

Creditors

Avg

303.0

£1.21

£1.86

22.0

£0.09

£0.11

325.0

£1.30

£1.97

Page 6A - Charts

06/12/2016

COST PER INVOICE 2015/16 - INDIRECT COSTS £1.50

IT

£1.00

£0.50

£0.00 n d g u h e w o x m b k

£5.00

Indirect costs

£0.80

t

r

f

j

a z s

Accommodation

£4.00 £0.60 £3.00 £0.40 £2.00 £0.20 £1.00 £0.00

£0.00 h

z

d n w e

x

u

b

g

k

o m j

r

t

a

f

h e

s

z d

t

n w k m o

j

u

f

s a g b

r

x

Central charges

£4.00 £3.00 £2.00 £1.00 £0.00 h z d x w b n e u

j

k

r

a o g

f

t

s m

Indirect costs 2015/16 £'000 £/trans

Avg

IT

25.0

£0.10

£0.24

Accommodation

25.0

£0.10

£0.11

Central charges

0.0

£0.00

£0.53

50.0

£0.20

£0.87

Total indirect costs

Creditors

Page 6A - Charts

06/12/2016

SECTION 2 - COST PERFORMANCE Members with >20% of invoices input locally

COST/INVOICE TREE 2015/16 This tree diagram analyses the cost per invoice. For each benchmark two figures are given the first being the authority's cost and the second is the group average. Central staff Direct costs

£0.81

£0.90

£0.51

£0.58 Other running costs £0.07

£0.10

£0.17

IT

Core costs (central)

Indirect costs

£1.10

£0.09

£0.20

£0.86

£0.28 Accommodation £0.10

£0.06

Combined cost £1.49

Outsourcing costs

£1.21

£0.00

Central charges £0.00

£0.00

£0.05

Cost/Local invoice Local cost

£1.88

£0.40

£1.10

£0.35 % Local invoices 21%

Costs (£'000)

34%

Core Creditor cost from Procurement

Local batching & data input

45

-

100

303

25

3

-

273

48

-

100

325

Central Creditor Cost

Central Creditor Non-core

Benchmark Creditor's cost

Direct Costs Staff Other running costs Total Direct Costs

248

22

Indirect Costs IT

25

-

-

25

Accommodation

29

4

-

25

Central charges

-

-

-

-

54

4

-

-

-

-

-

-

Total cost

327

52

-

100

375

FTE staff

9.5

1.3

5.0

13.2

Total Indirect Costs Outsourcing costs

Invoices ('000) Input in Creditors' section Input in other departments

Work for other bodies 74.6

Value Avg

53.3

Others

123.0

Total

250.9

Creditors

-

50

Page 6B - Figures

Work for other bodies (%)

na

Work for other bodies (£'000)

..

3%

06/12/2016

COST PER INVOICE 2015/16

£1.50

Members with >20% local invoices

Core central cost

£1.00

£2.00

Total cost

£1.50

£0.50

£0.00 z x w u s

r

o n m k

j

h

f

e d b

t

g a

£1.00 £0.60

Local cost

£0.50 £0.40 £0.00 z

x w u

s

r

o

n m k

j

h

f

e

d

b

t

g

a

£0.20

£0.00

Excluding members not showing local costs

z x w u s

r

o n m k

j

h

f

£1.00

e d b g

t

a

Direct costs

£0.50

£0.00 z x w u s

£1.20

r

o n m k

j

£0.60

Core central cost

h

f

e d b

t

a g

Indirect costs

£1.00 £0.40

£0.80 £0.60

£0.20

£0.40 £0.20

£0.00 z x w u s

r

o n m k

j

h

f

e d b g

t

a

£0.00 z

x w u

s

r

o

n m k

j

h

f

e

d

b

t

g

a

£1.00

Outsourcing costs

£0.50

£0.00 z x w u s

r

o n m k

j

h

f

e d b

t

g a

Cost/Local invoice

£2.00 £1.50 £0.60

Local cost

£1.00 £0.50

£0.40 £0.00 z x w u s

£0.20

r

100%

o n m k

j

h

f

e d b

t

g a

% Local invoices

£0.00 z

x w u

s

r

o

n m k

j

h

f

e

d

b

g

t

a

50%

0% z x w u s

Creditors

Page 6B - Charts

r

o n m k

j

h

f

e d b g

t

a

06/12/2016

COST PER INVOICE 2015/16 - DIRECT COSTS Members with >20% local invoices £1.00

Central staff

£0.80 £0.60 £0.40 £0.20 £0.00 z x w u s

£1.00

r

o n m k

j

h

f

e d b

t

a g

Direct costs

£0.80 £0.60 £0.40 £0.20 £0.00 z

x w u

s

r

o

n m k

j

h

f

e

d

b

t

a

g

Other running costs

£0.15

£0.10

£0.05

£0.00 z x w u s

r

o n m k

j

h

f

e d b a

t

g

Direct costs 2015/16 £'000 £/trans Central staff Other running costs Total direct costs

Creditors

Avg

203.0

£0.81

£0.51

22.0

£0.09

£0.07

225.0

£0.90

£0.58

Page 6B - Charts

06/12/2016

COST PER INVOICE 2015/16 - INDIRECT COSTS Members with >20% local invoices

£0.50

IT

£0.40 £0.30 £0.20 £0.10 £0.00 z x w u s

£0.50

Indirect costs

r

o n m k

£0.15

j

h

f

e d b g

t

a

Accommodation

£0.40 £0.10

£0.30 £0.20

£0.05

£0.10 £0.00 z x w u s

£0.00 z

x w u

s

r

o

n m k

j

h

f

e

d

b

g

t

r

o n m k

j

h

f

e d b

t

a g

a

£0.15

Central charges

£0.10

£0.05

£0.00 z x w u s

r

o n m k

j

h

f

e d b a g

t

Indirect costs 2015/16 £'000 £/trans

Avg

IT

25.0

£0.10

£0.17

Accommodation

25.0

£0.10

£0.06

Central charges

0.0

£0.00

£0.05

50.0

£0.20

£0.28

Total indirect costs

Creditors

Page 6B - Charts

06/12/2016

SECTION 3 - CENTRAL PROCESSING COSTS COST/INVOICE TREE 2015/16 This tree diagram analyses the central processing costs per invoice from Table 2(b) of the questionnaire. For each benchmark two figures are given the first being the authority's cost and the second is the group average.

Cost per FTE staff £32,188

£27,345

Staff Direct costs £0.50

£0.41

£1.29

£1.37

Central processing cost £0.70

Other running costs

£2.14

£0.09 Net core central cost £1.10

Indirect costs £0.20

£2.75

£0.07

IT

£0.74

£0.10

£0.24

Accommodation £0.10

£0.08

Central data input £0.40

Central charges

£0.69

£0.00

£0.45

Outsourcing costs £0.00

Costs (£'000)

Core Central cost

Central data input

£0.00

Central processing

Invoices ('000) Input in Creditors' section

Direct costs Staff Other running costs Total Direct Costs

Input in other departments 203

100

103

22

-

22

225

100

125

Indirect costs 25

Accommodation

25

-

25

Central charges

-

-

-

50

-

50

-

-

-

Total cost

275

100

175

FTE staff

8.2

5.0

3.2

Outsourcing costs

25

53.3

Others

123.0

Total

250.9

100%

IT

Total Indirect Costs

74.6

% central staff on data input

80% 60% 40% 20% 0% k e x

t

d m a n

f

h z w u s

r o

j

g b

% Core central staff time spent on data input % 61% Creditors

Avg 26%

Page 7

06/12/2016

CENTRAL PROCESSING COSTS PER INVOICE 2015/16 The central processing cost of Creditors

£8.00

Direct costs

£6.00 £4.00 £10.00

Total central processing cost

£2.00

£8.00

£0.00 k

z h s

j

e d n b

r

u o

t w f m x a g

£6.00 £4.00 £5.00

Indirect costs

£2.00 £4.00 £0.00 k

h

z

j

s

d e

n b u w r

o g

x

t m f

£3.00

a

£2.00 £1.00 £0.00 h z n d w u b e g x o

£1.00

j

r

t m k a

f

s

Outsourcing costs

£0.80 £0.60 £0.40 £0.20 £0.00 k

z x w u

t

s

r

o n m j

h g

f

e d b a

Central data input cost

£6.00

£4.00

£2.00

£0.00 k

e

d

h

n

x

o

t

m a

f

w

z

u

s

r

j

g

b

CENTRAL PROCESSING COSTS 2015/16 - STAFF ANALYSIS £7.00

Staff cost per invoice

Cost £'000/FTE

£50

£6.00 £40 £5.00 £4.00

£30

£3.00

£20

£2.00 £10

£1.00

£0

£0.00 k

Creditors

z

h

j

s

e

d

n

b

r

u

o

t m w

f

g

a

k

x

Page 8

z e g s

t m b

j

h

f

n x a w u d

r

o

06/12/2016

CENTRAL PROCESSING COSTS PER INVOICE 2015/16 - DIRECT COSTS £8.00

Staff cost per invoice

£6.00 £4.00 £2.00 £0.00 k

£7.00

z h

j

s e d n b

r

u o

t m w f

g a x

Direct costs

£6.00 £5.00 £4.00 £3.00 £2.00 £1.00 £0.00 k

z

h

s

j

e

d

n

b

r

u

o

t

w

f m x

a

g

£0.20

Other running costs

£0.15 £0.10 £0.05 £0.00 k

s e

z o

t

n d h w x

f

a u

r

j

b g m

Direct costs 2015/16 £'000 £/trans Staff cost Other running costs Total direct costs

Creditors

Avg

103.0

£0.41

£1.29

22.0

£0.09

£0.07

125.0

£0.50

£1.37

Page 9

06/12/2016

CENTRAL PROCESSING COSTS PER INVOICE 2015/16 - INDIRECT COSTS £1.50

IT

£1.00

£0.50

£0.00 n d g u h e w o x m b k

£5.00

t

r

f

j

a z s

Indirect costs £0.60

Accommodation

£4.00 £0.40

£3.00 £2.00

£0.20

£1.00 £0.00 £0.00

k h z h

z

n

d w u

b

e

g

x

o

j

r

t m k

a

f

t

e

j

d u s g b m n

f w o a

r

x

s

£4.00

Central charges

£3.00 £2.00 £1.00 £0.00 k h z b d w x n u

j

r

e a g

f

o

t

s m

Indirect costs 2015/16 £'000 £/trans

Avg

IT

25.0

£0.10

£0.24

Accommodation

25.0

£0.10

£0.08

Central charges

0.0

£0.00

£0.45

50.0

£0.20

£0.74

Total indirect costs

Creditors

Page 10

06/12/2016

SECTION 4 - PAYMENT INFORMATION PAYMENTS - PAYMENT RUNS 6

10

Combined payment runs

5

BACS payment runs per week

8

4

6

3 4 2 2

1

0

0 r

j

u

t

d

w

h

o

b

z

e

a

x

s

n

m

k

g

b

f

x

s

r

k

g

f

n

a

o

m

j

w

e

z

u

t

h

d

Cheque runs per week

6

Payment runs/week

No.

Avg

BACS

0

2.8

Cheque

0

1.3

Combined runs

5

1.6

5 4 3 2 1 0 r

k

n

o

m

x

w

s

j

g

f

b

z

u

100%

t

h

e

d

a

% BACS remittances

Emailed

80% 60% 40%

%

Avg

E-mailed

82%

74%

Posted

18%

19%

Faxed

0%

0%

Not sent

0%

6%

20% 0% j

s

e

z

h

o

r

b

t

m n

x

k

g

a

f

d

w

u

PAYMENTS - INVOICES MATCHED TO PURCHASE ORDER Purchase order information

Invoices matched

100%

No.

80%

Purchase orders raised

23,414

Invoices matched to PO

23,414

%

Avg

60%

18%

56%

40% 20% 0% x

Creditors

g

s

b

a

w m h

d

n

f

e

r

k

z

j

o

u

t

Page 11

06/12/2016

PAYMENTS - INVOICES PAID ON TIME (BVPI8/CFH/006) 2015/16 Invoices

% BVI8 invoices paid within 30 days

100%

No.

%

Avg

211,051

97%

94%

BVI8 not paid in 30 days

7,410

3%

6%

Disputed

7,042

BVI8 paid in 30 days

Non-commercial & non-BVI8

90% 80% 70%

25,419 60%

250,922

Total counted

u

k

j

g

f

n

e

x

h

t

r

a

w

s

b

m

o

d

z

PAYMENTS - PROCESSING ERRORS % Duplicate payments identified prepayment

0.3%

% Duplicate payment

0.100%

0.3%

0.080%

0.2%

0.060%

0.2%

0.040%

0.1% 0.020%

0.1%

0.000%

0.0% z

s

r

o

n

k

j

h

g

f

a

d w m u

b

t

x

z

e

s

r

o

n

k

j

g

f

u

e

d m w

x

h

b

a

t

% Incorrect payee/amount

0.50% 0.40% 0.30% 0.20% 0.10% 0.00% z

s

r

o

n

k

j

g

f

d

e

w u

h

a

t

b

x m

Payment errors No. Duplicates identified pre-payment Duplicate payment Incorrect payee/amount Number of invoices in sample

Creditors

%

Avg

53

0.02%

0.06%

6

0.00%

0.03%

29

0.01%

0.08%

250,922

Page 12

06/12/2016

TYPES OF INVOICES PROCESSED

25%

40%

HTML / XML / similar (e-invoices)

20%

Consolidated invoices - electronical input

30%

15% 20% 10% 10%

5% 0%

0% s

w

t

50%

n

r

b

d

z

x

u

o m

k

j

h

g

f

e

a

h

t

k

u

z

o

r

x

w

s

n

m

j

60%

Consolidated invoices - manual input

g

f

e

d

b

a

Feeder - HB

40% 40%

30% 20%

20%

10% 0%

0% x

s

z

n

t

b

u

w

r

o

m k

100%

j

h

g

f

e

d

a

u

r

o

w

z

x

t

s

25%

Feeder - Other

80%

20%

60%

15%

40%

10%

20%

5%

0%

n

m

k

j

h

g

f

e

d

b

a

Purchase/Credit Cards

0% b

s

f

j

z

m k

x

a

100%

n

o

g

w

r

u

d

t

h

e

Input within Creditors

80%

t

g

f

o

e

h

m

j

k

u

80%

w

r

b

z

x

s

n

d

a

Input in other depts

60%

60% 40% 40% 20%

20% 0%

0% e

d

h

n

k

z

j

Invoices

m

t

u

w

No.

a

f

o

r

b

s

x

g

%

Avg

HTML/XML etc

12,165

4.8%

2.4%

Consolidated (e-input)

39,385

15.7%

2.5%

Consolidated (manual)

165

0.1%

2.7%

-

0.0%

7.9%

HB feeder Other feeder

17,782

7.1%

40.6%

Purchase cards etc

53,536

21.3%

2.4%

Input within Creditors

74,616

29.7%

35.3%

Input in other depts

53,273

21.2%

6.2%

%

Avg

0.0%

4.7%

Total Invoices Attributable to Creditors work for other bodies

Creditors

g

t

a

r

m w

z

x

u

60%

s

o

n

k

j

h

f

e

d

b

Work for other bodies

40%

20%

0% g

d

x

r

a

u

z

w

t

s

o

n m

k

j

h

f

e

b

250,922

No.

na

Page 13

06/12/2016

PAYMENTS - PAYMENT METHODS 100%

10%

BACS/Fastpay

80%

8%

60%

6%

40%

4%

20%

2%

0%

Cheque

0% d

x

j

f

b

a m r

o

g

k

t

h

z

0.5%

n

w e

u

s

d

Direct Debit

w

n

t

k

u

e

g

o

z

r

m a

6%

s

b

h

f

x

j

Manual cheque

5%

0.4%

4%

0.3%

3% 0.2% 2% 0.1%

1%

0.0%

0% x

s

r

n

k

g

d

h

e

b

f

z

m

j

100%

u

t

o

w

a

x

r

o

n

k

h

g

f

d

BACS/Fastpay

60%

Cheque

40%

Manual etc

20%

Direct Debit

r

e

j

b

f

m w

x

t

o

n

k

h

g

d

z

t

s m

j

b

a

%

Avg

51,862

94.1%

90.0%

3,189

5.8%

3.8%

-

0.0%

0.0%

39

0.1%

1.0%

-

0.0%

5.2%

All other*

0% z

u

No.

80%

u

w

Payments

All other*

s

e

a

Total

55,090

* includes pre-paid cards, barcode payments and all other payments

PAYMENTS - % INVOICES PAID BY BACS % invoices paid by BACS

Invoices paid by BACS

100%

No.

80%

250,922

60%

%

Avg

100%

89%

40% 20% 0% u

k

j

h

g

d

a

z

b

x

t

s

r

n m e

f

w o

ADDITIONAL INFORMATION - DAYS ADDED FOR POSTAGE (BVI8 INVOICES) 8.0

Days added for postage

Days added for postage

6.0 4.0

Days

Avg

2.0

2.5

2.0 0.0 s

o

Creditors

u

k

z

m

g

b

x

w

t

r

h

e

d

a

n

j

f

Page 14

06/12/2016

SECTION 5 - STAFF RELATED INFORMATION STAFF GRADING - PAY BY BAND 100%

Under £15k

100%

80%

80%

60%

60%

40%

40%

20%

20%

0%

£25-30k

0% z

t

s

j

g

f

e

k

w

x

u

r

o

n m h

100%

d

b

a

z

x

w

g

e

s

n

k

j

h

a

b

u

t

f

100%

£15-20k

80%

80%

60%

60%

40%

40%

20%

20%

0%

d

r

o m

£30-35k

0% z

s

j

d

x

a

r

t

e

o

u m n

w

f

100%

h

g

b

k

£20-25k

x

k

j

g

e

n m

s

z

w

o

r

f

100%

80%

80%

60%

60%

40%

40%

20%

20%

0%

t

u

h

d

b

a

Over £35k

0% s

e

z

g

b

j

f

h

w

o m k

u

r

x

t

n

d

a

x

w

r

n

k

f

e

j

s

h

u

g

z

b

t

o m d

a

Staff grading - pay by band FTE

%

Avg

na

na

4%

£15-20k

7.3

77%

52%

£20-25k

1.0

11%

34%

£25-30k

1.0

11%

15%

Under £15k

£30-35k

na

na

10%

Over £35k

0.2

2%

9%

Total FTE

9.5

Creditors

Page 15

06/12/2016

STAFF SICKNESS - LOST DAYS PER FTE EMPLOYEE

35

16

Total sickness

Long-term

14

30

12

25

10

20

8 15

6

10

4

5

2

0

0 j

g

d

e

k

w

f

t

b

z

s

h

r

n m

o

a

u

x

j

g

k

e

w

f

t

h

o

a

z

x

u

s

r

20

Lost days pa (per FTE)

n m d

b

Short-term

15

Days

Avg

Long-term sickness

7.0

3.6

Short-term sickness

2.0

3.9

Total sickness

9.0

7.7

10

5

0 j

g

d

e

b

z

s

k

r

n

f

m

t

h

u

w

x

o

a

STAFF TURNOVER 100%

Joining section

100%

80%

80%

60%

60%

40%

40%

20%

20%

0%

Leaving section

0% g

e

x

z

k

d

b

r

h

a

u

s

t

w o

n m

j

f

r

g

e

x

b

k

o

z

n

d

h

a

f

u

t

w

j

s m

Staff turnover FTE Total Creditors FTE at 31.03.2013

Creditors

%

Avg

10.3

Joining Creditors section

0.2

2.1%

19.0%

Leaving Creditors section

1.0

10.5%

19.5%

Total Creditors FTE at 31.03.2014

9.5

Page 16

06/12/2016

SECTION 6 - TIMESERIES ANALYSIS KEY:

The 2016 averages are the actual club averages.

Club average

X

For previous years, the averages shown here are scaled up or down from the 2016 figure based on the average rate of change in each year. This is calculated using data from members who supplied figures in consecutive years, otherwise the simple average in each year would be distorted by changes in the composition of the club from year to year.

Barchester

Staff

£2.00 £1.50 £1.00 £0.50

Cost/Invoice

£2.00

£0.00 2011

2012

2013

2014

2015

£1.50

2016

IT

£0.20 £1.00 £0.15 £0.50

£0.10

£0.00

£0.05 2011

2012

2013

2014

2015

2016

£0.00 2011

% Normal invoices*

100%

2012

2013

2014

£0.40

60%

£0.30

40%

£0.20

20%

£0.10

0%

2016

Other costs

£0.50

80%

2015

£0.00 2011

2012

2013

2014

2015

2016

2011

2012

2013

2014

2015

2016

Timeseries analysis 2011

2012

2013

2014

2015

2016

412

412

417

419

393

375

Cost £'000 Invoices

227,541 245,053 263,335 293,400 264,423 250,922

Cost/Invoice

£1.81

£1.68

£1.58

£1.43

£1.49

£1.49

Average

£1.65

£1.62

£1.62

£1.64

£1.54

£1.65

Staff

£1.52

£1.41

£1.31

£1.18

£1.21

£1.21

Average

£1.16

£1.08

£1.10

£1.08

£1.01

£1.06

IT

£0.11

£0.10

£0.09

£0.09

£0.09

£0.10

Average

£0.13

£0.14

£0.16

£0.17

£0.17

£0.18

Other costs

£0.19

£0.17

£0.18

£0.16

£0.18

£0.19

Average

£0.34

£0.37

£0.37

£0.36

£0.36

£0.39

% Normal invoices*

87%

79%

69%

62%

60%

51%

Average

55%

52%

49%

46%

44%

44%

*Excludes e-invoices, HB etc. Creditors

Page 17

06/12/2016