financial analysis software package ref 191014 rban
TRANSCRIPT
Financial Analysis Software Package – ref 191014 BAN Request for Price
__________________________________________________________________________________
Published 25th October 2019Closes 6th December 2019
Index of Supplier responses required to be considered for the contract opportunity
A. Self Evaluation sheet to be completed by vendor
B. Price – Commercial response
C. Installation approach and Training plan questions
Additional information to assist with your proposal
D. Scope document – business requirementsE. FAQ discovery call type questions
Contract Description
1. The provision of a financial analysis solution to replace Excel based worksheets forfinancial planning, and distribute budget monitoring reports.
a. The solution will act as the preferred front end for our accounting package and willbe accessible to 50 users. (5 admin, 25 read write, 20 read only)
b. The solution will be expected to load data from multiple business systems includingpayroll, and local Access databases.
c. The solution will be cloud hosted, or less than 5GB data storage required locally.
d. Implementation in three months, timetabled for 18th January – 25 April 2020including user acceptance testing and sign off.
e. Contract duration of 24 months 18th January 2020 – 17th January 2022.
2. Outcomes and values
a. Budget holder has more control over their data
b. Digital Self service (remote and online) features are exploited to give them betterownership
c. Corporate Finance service can release capacity from transactional activities,particularly by virtue of processes that can be automated or workflow enabled, andpromote completeness of transactions without corrective intervention fromCorporate Finance.
d. More accurate and timely forecast outturn positions
e. To lift financial competencies of managers to manage financial resources moreacutely, and they will be encouraged and grow more confident, thanks to aconsistent experience at every use
Financial Analysis Software Package – ref 191014 BAN Request for Price
__________________________________________________________________________________
3. What does Good look like? In the words of the procuring service
a. In terms of an ambition [of the new solution] A tool that gives budget managersthe information required to be able to forecast and record an outturn in a way thatis both easy to understand and easy to navigate, that can then be easily retrievedand reported on by finance.
b. The tool would ideally give managers the capability to model different scenarios andbuild up details of an accurate outturn including salary modelling by employee. Itwould be useful for this to be flexible so it can be adjusted to meet changing needsof the organisation without rewriting all the reporting. It is a self service tool forbudget managers that can be easily support by finance.
c. Our current predict spend spreadsheets are not fit for purpose, and have becomediscouraging and dormant, due to the time consumed by the service accountants tomaintain them. Some business units continue to use these in the background, andthey deserve better. Examples are included in the Appendices.
4. Realistic limitation on technology
a. We are a Citrix site. Any preparation or prior experience on how you wouldapproach this type of installation, would give us assurance in your proposal.
b. It is worthy of note that the processing power and local memory required to loaddata and refresh our ‘predict spend spreadsheets’ were causing Excel crashes on theCitrix desktop terminals.
c. The pool laptops fared better, but only about 25% coverage available for number ofstaff. Similar device mix for other business areas.
d. The reason for expressing this realism about the current IT landscape, is to insist thatnew processing load would be better dispersed rather than local.
5. Expected features, tools and capabilities – PRIORITY RATED
a. Salary Monitoring: automated and self input; MUST HAVE
b. Forecast Outturn: self service inputs and commentary; MUST HAVE
c. Training budget holder to exploit features, and improve outcomes; MUST HAVE
d. Likely to emulate Excel cellular tables; MUST HAVE
e. Single sign on for user authentication and security maintenance purposes; MUSTHAVE
f. Graphical dashboard display SHOULD HAVE
g. Displays clear financial position enabling budget holder SHOULD HAVE
h. User can personalise their workspace SHOULD HAVE
i. Capture of Budget variance commentary: self monitoring COULD HAVE
j. Can integrate view with Payroll data WOULD HAVE
Financial Analysis Software Package – ref 191014 BAN Request for Price
__________________________________________________________________________________
Additional Fact sheet – Basildon Council
Current corporate systems
• Integra 2 by Capita IBS, for General Ledger, Purchasing, and Budget Controlhttps://www.capita ibs.co.uk/solutions/integra/
• iTrent by MHR, for Integrated HR and Payroll, some technical specification available,https://www.digitalmarketplace.service.gov.uk/g cloud/services/619162716972283
• MSAccess, for small bespoke budget planning databases, maintained by the service
Current User base for Integra 2 Financials
Concurrent licenses 75Of which, Budget holders 40Of which, Corporate Finance 25Purchasing only 200+ (using e Series browser)
Indicative procurement and delivery timescales
Milestones From To
Request for Price 25th October 6th December 2019
Award notification 12th December 16th December 2019
Implementation 18th January 21st March 2020
User Acceptance sign off 20th February 25th April 2020
Council website
https://www.basildon.gov.uk/
Financial Analysis Software Package – ref 191014 BAN Request for Price
__________________________________________________________________________________
A. Self Evaluation sheet to be completed by vendor
PLEASE NOTE: at discretion of Council this will be evidenced from an on site demonstration
1. Key Features that are ready developed and present Yes/No
a. Self service inputs into Salary Monitoring
b. Self service inputs into Forecast Outturn
c. Self monitoring of Budget Variances
d. Displays clear financial position
e. Training for budget holder Part C2
2. Tools or capabilities demonstratable Yes/No
a. Likely to emulate EXCEL cellular tables
b. Graphical dashboard display
c. User can personalise their workspace
d. Can integrate view with Payroll data
e. User authentication works in conjunction with ActiveDirectory
Continues on to next page>>>
Financial Analysis Software Package – ref 191014 BAN Request for Price
__________________________________________________________________________________
3. Likelihood of new product to bring about betteroutcomes
Currentscore 1 3
Future score1 3
a. Budget holder has more control over their data 1
b. Empower better ownership of financial targetsby Services
1
c. Finance can release capacity fromtransactional activities
1
d. More accurate and timely forecast outturnpositions
1
e. To lift financial competencies of managers 1
PLEASE NOTE: Key to apply to Future score
1 Low propensity to affect change2 Average expectation3 Higher propensity to improve
Financial Analysis Software Package – ref 191014 BAN Request for Price
__________________________________________________________________________________
B. Price – commercial response
2020/2021 £ Price Payment terms
Implementation Costs Eg. Due on clientacceptance
Licensing Costs Eg. licensing costs duein advance annually
Maintenance Costs
Hosting Charge
Other specify
Other –specify
TOTAL (sum of above)
2021/2022 £ Price Payment terms
Implementation Costs
Licensing Costs
Maintenance Costs
Hosting Charge
Other specify
Other –specify
TOTAL (sum of above)
Financial Analysis Software Package – ref 191014 BAN Request for Price
__________________________________________________________________________________
C. Installation approach and Training plan
1. Briefly specify the installation method to be used, and indicate client resourcesinvolvement.
Describe dates in context of Project Timescales Proposed Dates
2. Briefly specify the training package offered to budget holders, who will be utilising selfservice.
Describe dates in context of Project Timescales Proposed Dates
Financial Analysis Software Package – ref 191014 BAN Request for Price
__________________________________________________________________________________
D. Business Requirements and ScopeIncluded Examples Not included
1. The Service team would like the BudgetDatabase that is maintained on Access, tobe connected to the new reporting tool,and the planning tool. Example reportextracts.
APPENDIX BANDAPPENDIX C
2. The Service team would like the EN1D (byemployee itemised budget analysis)database that is maintained on Access, tobe connected to the new reporting tool,and the planning tool. Example reportextract, attached.
APPENDIX D 3. There is no requirementto re engineer the EN1D(by employee itemisedbudget analysis), and thiswill not be included inthe new planning tool.
4. The Service team would like a newcollaborative planning tool to replace thePredictive Outturn workbooks currentlycollated on Excel, selecting profileallocation method and capturing changecommentary from servicemanager. Example worksheet, attached.
APPENDIX F
5. The Service team would like to replacethe Salary Monitoring worksheet, whichbenefits from a monthly payroll dataextract file by payroll number, agencycost detail and allows Service Manager toadd/delete individual posts, and estimatetiming of changes. This outputs into thePredictive Outturn workings. Exampleinput worksheet, attached.
APPENDIX G
6. The Service team would most likely bepersuaded to replace BDM (budget datamanagement) module of the existingFMS, which holds budget holdercomments, and pushes on to reporting inCrystal, X query and Excel, attached.
APPENDIX HANDAPPENDIX J
7. The Service team would like the ability toproduce reports easily at any level,however they need to be ‘cut’. Currentlythis is all done via downloading data ontoExcel and then summarised (manually)depending on the audience which is fineuntil someone wants it presenteddifferently halfway through theyear. Data sources can be either directlyfrom Integra transactions, the BDMmodule or our databases.
APPENDIX KAPPENDIX LANDAPPENDIXM
8. There will be norequirement to pushbudgeting data, orforecasting data backinto Integra (existingFMS), as the newreporting tool isaccessing or creating thisdata directly, ready forany reporting purposes.
9. There will be norequirement to replaceother budget settingworkbooks or databases.
Financial Analysis Software Package – ref 191014 BAN Request for Price
__________________________________________________________________________________
E. Virtual Discovery Call FAQ’sDiscovery type questions Buyer responseCan I ask if the software providers for theexisting payroll and Integra software will allowaccess or be willing to provide APIs to theirsoftware to extract the information required?
No, the existing payroll software provider willnot allow API. Must rely on a routine extract.Yes, Integra software provider, it is possiblethey will provide API. There is flexibility here.
Can you provide us with a sample excel sheetwhich requires conversion?
This will be an appendix in the BusinessRequirements document.
Report Distribution Can you clarify what willbe mode(s) of distribution of reports?
The Council uses SharePoint (intranet) andOutlook primarily, to distributed reports andinformation. Or ideally prompted within thedashboard for users to retrieve by themselves.
Is it possible to deploy an agent on the localinfrastructure where data is present?
Need to consult with IT, but possibly for an SQLagent.
Where will extracted data be stored? Preferably hosted data storage, or local serversif the data load can be minimised.
How often data extraction needs to happen? Periodically, usually monthly for payroll.Data feed from Financial Management Systemshould be near daily, currently runs overnightbatches to process journals, and purchaseledger integration.
What are cloud provider options? Does thecloud provider provide all cloud related securityfeatures? What is the budget set forhosting? Does the software need to be available24x7?
See clarification repeated below.Cloud SaaS software is strong favourite.Availability according to SLA in proposal, eg99.5% during core hours Monday to Friday.There is only one availability performanceindicator, this is the one.
User Management Would the user beauthenticated by an existing auth service?If that service is present, is it present in thesame cloud?
Yes, We would strongly prefer that user isauthenticated using Active Directory, meaningthe user gets a single sign on experience.We are introducing 2 factor authorisation inconjunction with Active Directory as we are nolonger housing our own servers on site.
Once the solution has been developed anddeployed, who will be responsible formonitoring the smooth running of theapplication?
We would expect a maintenance contract withthe vendor would hold primary responsibility,and we will client side have a corporatesystems analyst for local support.
Are there any diagrams of the existinginfrastructure?
Will endeavour to obtain this, but not likely toimpact your proposal. Firewalls can bereconfigured to facilitate data exchanges.
Can you elaborate on the "financialmanagement system"? Does this accountingpackage exist already?
The existing FMS is an accounting softwarepackage called Integra 2, supplied by CapitaIBS. Purchase ledger, Stores Management,Banking and General Ledger all integratedwithin the system. Does not include Payroll.
Financial Analysis Software Package – ref 191014 BAN Request for Price
__________________________________________________________________________________
Discovery type questions Buyer responseWhat is the relationship of this software withthis "financial management system"?
The new financial analysis and reporting toolwill have a close relationship with this existingsystem, with a fair degree of integration.
How many users will be involved in useracceptance testing? Please elaborate on theiravailability during the development phase ofthe software?
It is planned that up to five testers are availableat this phase, this is included in my projectplan, and has been communicated internally.
Any preferred T&C’s? G Cloud 11 Call off contract version 4.3 ispreferred. Appendix B. Lot 2: Cloud Softwareservice definition.
We have chosen SaaS hosted in the cloud tospecifically mitigate risk to our infrastructureand networks, including the avoidance ofperformance and stability detriments to otherbusiness systems and IT services.
Any preferred SLA’s? Vendor to define own SLA, to access the lowerprice point. Eg 99.5% availability for core hours8am – 5pm.There is only 23 minutes difference per monthbetween 99.5% and 99.95%. For a budgetplanning tool, this shouldn’t be too servicecritical, for the extra 23 minutes!
Our data centre is physically located remotely inHemel Hempstead. We do not currently havecloud infrastructure.
The vendor can do an assisted installation onthird party cloud hosting, or their own.
Please supply a SaaS in your Cloud, we do nothave our own.
SaaS Cloud which is equivalent to G cloud’sCloud Software Lot 2.Cloud software Services sold through G Cloudare applications that are accessed over theinternet and hosted in the cloud. Buyers onlyneed to pay for what they use.We expect vendor solution to economicallyhold its data lookup tables, to mitigate theoccurrence of excessive duplication of storeddata.
SIGNPOSTINGWe are a Citrix site, meaning end userapplications are installed centrally. This comeswith it the usual restriction and limitations.There is no current plan to replace Citrix, and ithas been recently improved by our outsourcedinfrastructure provider.
There is a trade off of loss of granular controlover software versions. And Pass through iseffected if AppV wraps are used to preservealternative software versions for specifiedusers. This may be a matter of convenience,and we don’t view Citrix as a major obstacle.
Financial Analysis Software Package – ref 191014 BAN Request for Price
__________________________________________________________________________________
APPENDICES INDEX
APPENDIX B G CLOUD 11 CALL OFF CONTRACThttps://assets.crowncommercial.gov.uk/wpcontent/uploads/RM1557.11 G Cloud 11 Calloff contract version 4.3.docx
APPENDIX C Example Cost StatementAPPENDIX D Example Note 1 EN1DAPPENDIX F Predictive Outturn input worksheetAPPENDIX G Salary Monitoring input worksheetAPPENDIX H Example Budget Monitoring summaryAPPENDIX J Example BDM commentary input screengrabAPPENDIX K Committee BDM EnclosuresAPPENDIX L BDM data extract period outturn pivot tableAPPENDIX M SLT quarterly report Outturn page
NOTE: Appendices A, E, and I are not missing, they are just skipped vowels.
Cost Centre Code: 70111-000000
Financial AccountingActuals2018/19
£
Working2019/20
£
Estimate2021/22
£
Estimate2020/21
£
Original2019/20
£
Estimate2022/23
£
Subj.Code
Prof.
Management & Administration SupportSERVICE COST STATEMENT STRICTLY CONFIDENTIAL
Estimate2023/24
£
Accountant: Lee BramptonCost Centre Manager:Richard Larkman
- - - - - - TOTAL NET COST OF SERVICE -
EMPLOYEES0 1000-00Salaries - Basic Pay 208,668.09 303,700 309,900 387,600 387,600 387,600 55 387,600 0 1000-05Performance Related Pay 5,180.00 - - - - - - 0 1006-00Pay Award - 7,600 - 4,800 9,600 14,500 55 19,400 0 1007-00Vacancy Factor - (19,700) (19,600) (24,900) (24,900) (24,900)55 (24,900)0 1052-00Evening Meeting Allowances 288.36 - 1,900 1,900 1,900 1,900 55 1,900 0 1060-00Superannuation - salaries 33,503.12 49,900 49,600 57,200 57,200 57,200 55 57,200 0 1070-00National Insurance - salaries 21,921.39 32,600 32,000 43,000 43,000 43,000 55 43,000 0 1090-00Statutory Sick Pay - Salaries 420.80 - - - - - - 0 1500-00Professional Fees 1,140.00 900 900 1,100 1,100 1,100 55 1,100 0 1630-00Recruitment advertising 762.00 - - - - - - 0 1721-00Merit Awards - - - - - - - -1 1740-00Employee insurance 1,500.00 1,900 1,900 900 900 1,000 11 1,000 TOTAL EMPLOYEES 273,383.76 376,900 376,600 471,600 476,400 481,400 486,300
TRANSPORT0 3400-00Car Mileage Allowances 49.12 - - - - - 55 - 0 3401-00Car Parking Charges etc 12.54 - - - - - - 0 3410-00Public Transport Fares 116.30 - - - - - 55 - TOTAL TRANSPORT 177.96 - - - - - -
SUPPLIES & SERVICES0 4000-25Door Entry Cards 10.00 - - - - - - 0 4104-00Refreshments 6.97 - - - - - - 0 4210-00Printing - 1,000 1,000 1,000 1,000 1,000 55 1,000 0 4230-00Stationery 117.50 - - - - - - 0 4244-00Publications / Newspapers 3,728.75 3,100 3,100 3,100 3,100 3,100 55 3,100 0 4315-01Credit check 165.93 2,000 2,000 1,900 1,900 1,900 55 1,900 0 4316-02Credit Cards - - - - - - - 0 4390-00Consultancy Services 744.35 - - - - - 55 - 0 4390-28VAT - Consultancy 2,950.00 7,300 7,300 7,300 7,200 7,200 55 7,200 0 4431-00Benchmarking 385.00 - - - - - - -1 4500-00Postages 38.55 - - - - - - 0 4550-00I.T. Hardware Purchase 10.00 - - - - - - 0 4553-00I.T. Licences 5,607.93 5,500 5,500 5,500 5,400 5,400 55 5,400 0 4554-00IT Software Purchases 3,362.68 - - - - - - 0 4701-00External Conferences 999.00 - - - - - - 0 4702-00Conferences - Subsistence 1,190.00 - - - - - - 0 4720-00Subsistence - general 26.12 - - - - - - 0 4724-00Travel Costs - - - - - - - 0 4801-00Subscriptions 10,079.00 3,500 3,500 3,500 3,500 3,500 55 3,500 0 4950-00Miscellaneous Expenses - - - - - - - 0 4995-00Services supplied by BBC - - - - - - - -1 4999-00Public Liability Insurance 2,300.00 2,100 2,100 1,700 2,200 2,700 11 2,800 TOTAL SUPPLIES & SERVICES 31,721.78 24,500 24,500 24,000 24,300 24,800 24,900
MANAGEMENT & ADMINISTRATION-1 7000-00Office Accomodation 6,600.00 8,200 8,200 - - - 22 - -1 7002-00Depot Accommodation Charge 400.00 200 200 - - - 22 - -1 7200-00Operational Recharges 24,800.00 12,900 12,900 - - - 22 - -1 7300-00Support Recharges 45,900.00 58,500 58,500 41,800 42,800 43,900 22 45,000 -1 7500-00CSC Recharges - 300 300 - - - 22 - TOTAL MANAGEMENT & ADMINISTRATION 77,700.00 80,100 80,100 41,800 42,800 43,900 45,000
382,983.50 481,500 481,200 537,400 543,500 550,100 TOTAL EXPENDITURE 556,200
INCOME0 9842-00Miscellaneous Income 20.00 - - - - - - -1 9905-00Recharges (Business Units) (295,303.50) (370,000) (369,800) (347,000) (351,500) (356,300)22 (360,900)-1 9990-00Recharges to HRA (Res Mgmt) (73,700.00) (97,500) (97,400) (130,400) (132,000) (133,800)22 (135,300)0 9994-00Recharges to Sempra (14,000.00) (14,000) (14,000) (60,000) (60,000) (60,000)22 (60,000)TOTAL INCOME (382,983.50) (481,500) (481,200) (537,400) (543,500) (550,100) (556,200)
Page 1 of 2 16/10/2019 12:30
Appendix C example Cost Statement report
xxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxx
pg. 12
Cos
t Cen
tre
Cod
e:20
600-
0000
00
Cos
t Cen
tre
Nam
e:Ta
xi L
icen
sing
Not
e 1
- Sal
arie
s B
udge
t for
Liv
e 20
19/2
0 Es
timat
eD
irect
Reg
ulat
ion
- Env
ironm
enta
l Hea
lth
Spin
eSu
rnam
eD
esig
natio
nSc
ale
Hou
rsFi
rst N
ame
Pay
No.
Pens
.B
asic
Sala
ry
1000
-00
Frin
ge
1000
-00
Ove
rtim
e - C
ontr
act
1050
-00
Ove
rtim
e - N
on-
Con
trac
t10
50-0
0
Oth
er
Paym
ents
Car
Loa
n Su
bsid
y
1730
-00
Infla
tion
1006
-00
Supe
r
1060
-00
NI
1070
-00
Tota
lPo
sitio
n N
umbe
rPd
.Ex
t. Fu
nd.
Tota
l les
s VF
Vaca
ncy
Fact
or5.
00%
1007
-00
Agen
cy
Paym
ents
1097
-00*
-
Prof
. Fee
s
1500
-00 -
Rec
ruit.
C
osts
1590
-00 -
Post
-Ent
. Tr
aini
ng16
50-0
0 -
Exte
rnal
Tr
aini
ng16
60-0
0 -
Oth
er
-
Empl
oyee
In
sura
nce
1740
-00
600
Addi
tiona
l Inf
orm
atio
n
TOTA
L EM
PLO
YEE
CO
STS
127,
605
Tota
l In
dire
ct
Cos
ts 600
App
rove
d by
Cos
t Cen
tre M
anag
er:
Dat
e:
Tota
l Dire
ct C
osts
3.35
FT
Es10
1,68
6 2,
039
- 4,
700
- -
- 14
,734
10
,046
13
3,20
5 (6
,200
)12
7,00
5
18Ba
nd 4
18.1
302
150
11,2
31
304
- -
- -
- 1,
845
996
14,3
76
1-12
1186
KNW
(719
)13
,657
16
Band
418
.13
9921
810
,583
30
4 -
- -
- -
- 90
7 11
,794
1-
1211
87KN
W(5
90)
11,2
04
24Ba
nd 6
36.2
599
999
9,00
0 20
3 -
- -
- -
1,47
2 79
10
,754
1-
4PN
0130
0(5
38)
10,2
16
15Ba
nd 4
21.7
599
315
12,2
06
365
- -
- -
- 2,
011
544
15,1
26
1-12
PN01
301
(756
)14
,370
02
SE2
9.06
1282
316
,401
15
2 -
- -
- -
2,64
9 1,
987
21,1
89
1-12
PN01
327
(1,0
59)
20,1
30
34Ba
nd 8
18.1
313
501
2,99
5 51
-
- -
- -
- 33
0 3,
376
1-2
PN01
484
(169
)3,
207
35Ba
nd 8
18.1
313
501
15,3
65
254
- -
- -
- -
1,65
0 17
,269
3-
12PN
0148
4(8
63)
16,4
06
25Ba
nd 6
36.2
599
452
18,6
03
406
- -
- -
- 3,
041
1,43
2 23
,482
5-
12PN
0159
1(1
,174
)22
,308
Not
eU
ser
Dat
e30
/04/
2018
rstil
wel
l-sta
gePo
sitio
n PN
0132
7 cr
eate
d w
ef 2
6/03
/201
8 - N
o bu
dget
(pen
ding
rest
ruct
ure)
24/0
4/20
19C
Bei
rne
EMP
0013
501
actin
g up
in p
ositi
on P
M01
484
until
30/
06/2
019
02/0
7/20
19rs
tilw
ell-s
tage
Emp
1350
1 ac
ting
up fr
om 1
184K
NW
to P
N01
484
19/0
8/20
19rs
tilw
ell-s
tage
Posi
tion
PN01
300
repl
aces
PN
0159
1 - E
mp
9945
2 st
artin
g in
pos
ition
wef
30/
07/2
019
Ove
rtim
e-
- -
- 4,
700
- -
- 18
2 53
5 5,
417
- 5,
417
Uns
ocia
l Hou
rs-
2,00
0 -
- -
- -
- -
- 2,
000
- 2,
000
Bala
nce
from
PN
0130
1 (w
as b
udge
ted
at S
P18)
- 1,
271
- -
- -
- -
204
175
1,65
0 (8
3)1,
567
PRP
- 1,
100
- -
- -
- -
200
100
1,40
0 -
1,40
0 Ba
lanc
e fro
m P
N01
484
(was
118
2KN
W) (
Budg
eted
at S
P38
and
with
Pen
sion
)-
1,53
1 -
- -
- -
- 3,
230
211
4,97
2 (2
49)
4,72
3
PN01
591/
PN01
300
was
bud
gete
d at
SP
24-
(600
)-
- -
- -
- (1
00)
1,10
0 40
0 -
400
FMS
WO
RK
ING
BU
DG
ET12
7,60
0 VA
RIA
NC
E5
VAC
ANT/
CAS
UAL
/AG
ENC
Y PO
SITI
ON
S10
,216
VAR
IAN
CE
IF P
OSI
TIO
NS
NO
T FI
LLED
(10,
211)
04/1
0/20
19 1
9:26
Pag
e 1
of 1
App
endi
xD
exam
ple
Not
e1
EN
1Dda
tash
eet
pg.1
3
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxx
xxxx
xxx
xxxx
xxx
xxxx
xxx
xxxx
xxx
xxxx
xxx
Pred
icte
d O
uttu
rn 2
016/
17Se
rvic
e N
ame
- 204
1220
412
PRED
ICTE
DO
UTT
UR
N V
AR
TOTA
L PR
OFI
LE
AC
TUA
L C
UR
REN
TA
CTU
AL
(SA
VIN
G)
PRIO
R Y
EAR
BU
DG
ETB
UD
GET
PER
IOD
VAR
IAN
CE
CO
MM
ITM
ENTS
PER
IOD
DEF
ICIT
AC
TUA
LSN
otes
Act
ions
125
512
1212
.00
EXPE
ND
ITU
RE
Sal
arie
s - B
asic
Pay
1000
0040
7,30
016
9,70
915
7,37
7.36
(12,
331.
64)
2,31
1.68
370,
282.
56P
erfo
rman
ce R
elat
ed P
ay10
0005
5,30
05,
300
5,31
9.44
19.4
4-
6,20
0.36
Vac
ancy
Fac
tor
1007
00(2
5,80
0)(1
0,75
0)-
10,7
50.0
0-
-O
verti
me
sala
ries
1050
00-
--
--
742.
54E
veni
ng M
eetin
g A
llow
ance
s10
5200
2,00
083
348
0.60
(352
.40)
-3,
987.
23S
uper
annu
atio
n - s
alar
ies
1060
0066
,000
27,9
6725
,794
.72
(2,1
72.2
8)-
62,8
44.3
6N
atio
nal I
nsur
ance
- sa
larie
s10
7000
45,1
0019
,258
17,9
38.1
6(1
,319
.84)
-43
,216
.86
Sta
tuto
ry M
ater
nity
Pay
- S
al10
8000
--
--
--
Sta
tuto
ry S
ick
Pay
- S
alar
ies
1090
00-
--
--
420.
80A
genc
y P
aym
ents
1097
00-
--
--
-E
xter
nal T
rain
ing
1660
00-
--
--
418.
25M
erit
Aw
ards
1721
00-
--
--
(500
.00)
Car
Loa
n S
ubsi
dy17
3000
--
500.
0050
0.00
-53
3.76
Em
ploy
ee in
sura
nce
1740
002,
400
2,40
02,
400.
00-
-2,
400.
00-
2,20
0.00
EMPL
OYE
ES50
2,30
021
4,71
720
9,81
0.28
(4,9
06.7
2)2,
311.
6847
8,43
3.99
(23,
866.
01)
490,
346.
72
Car
Mile
age
Allo
wan
ces
3400
001,
600
667
449.
38(2
17.6
2)-
1,07
8.51
(521
.49)
788.
83C
ar P
arki
ng C
harg
es e
tc34
0100
--
136.
5713
6.57
-32
7.77
327.
7720
2.54
Pub
lic T
rans
port
Fare
s34
1000
--
148.
5014
8.50
-35
6.40
356.
4047
1.15
TRA
NSP
OR
T R
ELA
TED
1,60
066
773
4.45
67.4
5-
1,76
2.68
162.
681,
462.
52
Equ
ipm
ent P
urch
ase
4000
00-
--
--
--
35.0
0R
efre
shm
ents
4104
00-
--
--
--
283.
67H
ave
mov
ed h
alf t
o 20
401
Prin
ting
4210
00-
--
--
--
35.2
0S
tatio
nery
4230
00-
--
--
--
59.8
4H
ardw
are
4246
00-
--
--
--
548.
76Le
gal F
ees
4378
00-
--
--
--
-La
nd R
egis
try F
ees
4379
00-
--
--
--
-P
osta
ges
4500
0030
030
031
0.23
10.2
3-
744.
5544
4.55
230.
20I.T
. Lic
ence
s45
5300
--
700.
0070
0.00
-1,
680.
001,
680.
00-
Sub
sist
ence
- ge
nera
l47
2000
--
--
--
-14
.41
Trav
el C
osts
4724
00-
-5.
005.
00-
12.0
012
.00
159.
17S
ubsc
riptio
ns48
0100
12,2
005,
083
10,4
80.8
45,
397.
84-
25,1
54.0
212
,954
.02
12,5
83.1
7E
vent
s48
0202
--
--
--
-35
8.01
Pub
lic L
iabi
lity
Insu
ranc
e49
9900
2,80
02,
800
2,80
0.00
--
2,80
0.00
-3,
300.
00
SUPP
LIES
& S
ERVI
CES
15,3
008,
183
14,2
96.0
76,
113.
07-
30,3
90.5
715
,090
.57
17,6
07.4
3
Offi
ce A
ccom
odat
ion
7000
009,
200
9,20
09,
200.
00-
-9,
200.
00-
9,40
0.00
Hav
e se
nt C
hris
tine
a br
eakd
own
Ope
ratio
nal R
echa
rges
7200
0016
,100
16,1
0016
,100
.00
--
16,1
00.0
0-
15,8
00.0
0S
uppo
rt R
echa
rges
7300
0061
,300
61,3
0061
,300
.00
--
61,3
00.0
0-
32,7
00.0
0C
SC
Rec
harg
es75
0000
300
300
300.
00-
-30
0.00
-10
0.00
SUPP
OR
T86
,900
86,9
0086
,900
.00
--
86,9
00.0
0-
58,0
00.0
0
EXPE
ND
ITU
RE
606,
100
310,
467
311,
741
1,27
3.80
2,31
1.68
597,
487.
24(8
,612
.76)
567,
416.
67
INC
OM
E
Cas
tle P
oint
Inco
me
9827
00-
--
--
(8,0
00.0
0)(8
,000
.00)
(41,
918.
79)
This
offs
ets
with
sal
arie
s.
Win
ding
dow
n ov
er th
e ne
xt
4 m
onth
s to
allo
w fo
r foc
us
on o
ur o
wn
loca
l pla
n w
ork.
E
xpec
ting
arou
nd £
8,60
0 m
ore
befo
re y
ear e
nd. T
his
is b
eing
revi
ewed
from
Apr
il on
war
ds.
Rec
harg
es to
HR
A (D
irect
)99
9100
(43,
800)
--
--
(43,
800.
00)
-(4
2,70
0.00
)M
W to
che
ck th
is fo
r thi
s ye
ar, s
ome
may
nee
d re
char
ging
to
Sem
pra.
And
may
be
low
er th
an b
udge
ted.
INC
OM
E(4
3,80
0)-
--
-(5
1,80
0.00
)(8
,000
.00)
(84,
618.
79)
TOTA
L56
2,30
031
0,46
731
1,74
0.80
1,27
3.80
2,31
1.68
545,
687.
24(1
6,61
2.76
)48
2,79
7.88
Inte
gra
Che
ck56
2,30
031
0,46
731
1,74
0.80
1,27
3.80
2,31
1.68
482,
797.
88D
iffer
ence
--
-(0
.00)
--
Oth
er A
ctio
ns
476,
033.
99(2
3,86
6.01
)
AP
PE
ND
IX F
Pre
dict
ive
Out
turn
ser
vice
204
12
App
endi
xF
Pre
dict
ive
Out
turn
inpu
tspr
eads
heet
pg.1
4
xxxx
xxxx
xIn
com
e
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xx
xxxx
xxxx
xxxx
x
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
x
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxx
Ser
vice
Nam
e - 2
0401
Bud
get
Pay
roll
Num
ber
Apr
ilM
ayJu
neJu
lyA
ugus
tS
epte
mbe
rO
ctob
erN
ovem
ber
Dec
embe
rJa
nuar
yFe
brua
ryM
arch
Age
ncy
Tota
lE
N1D
12
34
56
78
910
1112
0014
63,
740.
533,
740.
453,
740.
643,
740.
423,
740.
223,
740.
643,
729.
583,
729.
583,
729.
583,
729.
583,
729.
583,
729.
5844
,820
.40
44,7
55.0
0O
ffice
r00
213
3,26
6.50
3,26
6.50
3,26
6.50
3,26
6.50
3,26
6.50
3,26
6.50
3,26
6.50
3,26
6.50
3,26
6.50
3,26
6.50
3,26
6.50
3,26
6.50
39,1
98.0
039
,198
.00
Tech
nica
l Sup
port
Offi
cer
0032
73,
266.
503,
266.
501,
416.
427,
949.
4239
,198
.00
Tech
nica
l Sup
port
Offi
cer
0710
23,
266.
503,
266.
5001
329
3,26
6.50
3,26
6.50
3,26
6.50
3,26
6.50
3,26
6.50
3,26
6.50
3,35
9.92
3,35
9.92
3,35
9.92
3,35
9.92
3,35
9.92
3,35
9.92
39,7
58.5
040
,319
.00
App
licat
ions
Offi
cer
1093
64,
280.
624,
280.
334,
280.
314,
280.
834,
342.
674,
280.
434,
269.
754,
269.
754,
269.
754,
269.
754,
269.
754,
269.
7551
,363
.69
51,2
37.0
0P
rinci
pal O
ffice
r13
145
4,28
0.83
4,28
0.83
4,28
0.83
4,28
0.83
4,28
0.83
4,34
3.21
4,26
9.75
4,26
9.75
4,26
9.75
4,26
9.75
4,26
9.75
4,26
9.75
51,3
65.8
651
,237
.00
Prin
cipa
l Offi
cer
3413
43,
740.
373,
740.
283,
740.
643,
740.
383,
740.
643,
740.
423,
729.
583,
729.
583,
729.
583,
729.
583,
729.
583,
729.
5844
,820
.23
44,7
55.0
0O
ffice
r50
947
3,32
2.41
3,32
2.66
3,32
3.47
3,32
1.32
3,32
3.47
3,38
0.71
3,26
6.50
3,26
6.50
3,26
6.50
3,26
6.50
3,26
6.50
3,26
6.50
39,5
93.0
439
,198
.00
Offi
cer
9912
93,
632.
693,
633.
313,
633.
143,
633.
243,
633.
173,
633.
653,
622.
503,
622.
503,
622.
503,
622.
503,
622.
503,
622.
5043
,534
.20
43,4
70.0
0O
ffice
r99
187
3,63
3.65
3,63
3.25
3,63
3.37
3,63
3.65
3,63
3.13
3,63
3.14
3,85
3.50
3,85
3.50
3,85
3.50
3,85
3.50
3,85
3.50
3,85
3.50
44,9
21.1
946
,242
.00
Offi
cer (
Enf
orce
men
t)99
260
3,74
2.28
3,74
2.28
3,74
2.28
3,74
2.28
3,74
0.67
3,74
2.28
3,73
1.17
3,73
1.17
3,73
1.17
3,73
1.17
3,73
1.17
3,73
1.17
44,8
39.0
744
,774
.00
Prin
cipa
l Offi
cer
9926
63,
080.
243,
080.
243,
080.
243,
080.
243,
080.
243,
080.
242,
985.
002,
985.
002,
985.
002,
985.
002,
985.
002,
985.
0036
,391
.44
35,8
20.0
0Te
chni
cal S
uppo
rt O
ffice
r (E
nfor
cem
ent)
9928
85,
618.
195,
617.
575,
679.
835,
618.
195,
617.
375,
618.
195,
486.
585,
486.
585,
486.
585,
486.
585,
486.
585,
486.
5866
,688
.84
65,8
39.0
0S
peci
alis
t Man
agem
ent
9936
64,
153.
704,
153.
705,
847.
134,
153.
704,
153.
704,
153.
703,
804.
463,
804.
463,
804.
463,
804.
463,
804.
463,
804.
4649
,442
.38
45,6
53.5
0H
ead
of S
ervi
ce (5
0%)
VA
CA
NT
0.00
62,9
15.0
0M
anag
erV
acan
t0.
0050
,903
.69
Spe
cial
ist M
anag
emen
t0.
00A
genc
y2,
011.
262,
626.
932,
652.
123,
115.
262,
141.
303,
426.
108,
946.
0024
,918
.97
34,6
44.0
0Te
ch S
uppo
rt O
ffice
rA
genc
y6,
658.
749,
281.
886,
524.
2212
,644
.88
4,90
9.98
16,7
47.7
435
,378
.76
92,1
46.2
090
,336
.00
Man
ager
Age
ncy
4,32
3.52
5,65
4.56
5,79
6.16
7,60
0.34
4,71
6.07
8,84
6.23
21,3
97.3
658
,334
.24
40,3
19.0
0O
ffice
rA
genc
y1,
931.
822,
464.
22-4
,396
.04
0.00
0.00
Age
ncy
1,52
0.10
3,20
9.10
4,22
2.50
2,55
9.87
4,98
3.04
11,8
80.5
928
,375
.20
0.00
Oth
erD
escr
iptio
n no
te4,
500.
004,
500.
00O
ther
Des
crip
tion
note
500.
0050
0.00
-45,
543.
00V
acan
cy F
acto
r (ef
ficie
ncy
for v
acan
t pos
ts)
Oth
erD
escr
iptio
n no
te11
0.00
110.
00O
ther
Des
crip
tion
note
395.
0039
5.00
Insu
ranc
e4,
400.
00E
xter
nal T
rain
ing
70.0
021
0.00
420.
0015
,000
.00
Ove
rtim
e
68,0
20.3
574
,782
.09
67,1
36.8
681
,851
.06
72,3
07.8
387
,649
.22
49,3
74.7
949
,374
.79
49,3
74.7
949
,374
.79
49,3
74.7
949
,374
.79
747,
996.
1688
0,27
0
Tota
l Spe
nd74
7,99
6.16
Tota
l Bud
get
880,
300.
00U
nder
spen
d13
2,30
3.84
App
endi
xG
exam
ple
Sal
ary
Mon
itorin
gw
orks
heet
pg.1
5
Pos
ition
No
pg.1
6
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
x
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
x xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
x
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xx
App
endi
xJ
exam
ple
BD
Mco
mm
enta
ryin
put
pg.1
7
d_ho
s5bm
soriginal
working
working_ytd
actuals
total_varia
nceou
tturn
cfOutturn
afterC
cf_justification
ccm_com
men
tsMIP
StTheresa'sN
ursery
20,000
20,000
20,000
Policy&Re
MIP
DigitalA
utho
rity
97,500
48,750
24,511
(24,23
9)Po
licy&Re
MIP
PlaceVisio
nary
50,000
17,931
17,931
Policy&Re
MIP
Unitary
Authority
50,000
Policy&Re
CorporateSpecialist
50,400
50,400
25,450
32,695
7,24
5Po
licy&Re
HousingBe
nefit
Subsidy
(489
,400
)(489
,400
)26
,681
,900
21,738
,153
(4,943
,747
)Po
licy&Re
GDPR
99,900
71,400
63,547
(7,853
)Bu
dget
isallocatedto
interim
Inform
ationManagem
ent
consultant.Thisw
illbe
spen
tbyen
dDe
cPo
licy&Re
DigitalBusinessD
evelop
men
t50
0,00
017
9,45
071
,071
(108
,379
)Po
licy&Re
PanaceaPrint
13,000
13,000
13,000
3,53
5(9,465
)Po
licy&Re
Gov.De
livery
12,500
12,500
12,500
5,23
4(7,266
)Po
licy&Re
CentralExpen
ses:Stat
FinExp
69,600
69,600
391
391
Policy&Re
ServiceDe
velopm
entInvestm
ent
187,00
013
5,90
0
Thisisthecorporate'investto
save'bud
geta
ndisallocatedto
services
whe
napproved
byS151
.Cu
rren
tlyshow
ingnil
outturnbu
tthism
aybe
unde
rspe
ntby
theen
dof
theyear
ifno
furthe
rbusinessc
ases
arepu
tforward.
Policy&Re
Corp
Staffin
g:Ap
pren
ticeLevy
125,00
012
5,00
062
,500
47,806
(14,69
4)Po
licy&Re
Corp
Staffin
g:Ap
pren
tices
267,00
040
0,50
024
9,35
020
8,40
7(40,94
3)Po
licy&Re
CentralExpen
ses:Au
ditF
ees
53,800
53,800
38,050
(7,894
)(45,94
4)(7,500
)(7,500
)NFIcostpaideverytw
oyears,no
tevery
year
sosaving
of£2
.5thisyear.
Policy&Re
StaffA
wards
10,000
10,000
5,00
05,16
516
5Po
licy&Re
CentralExpen
ses:Ba
nkCh
arges
113,50
011
3,50
082
,450
133,17
850
,728
Thisbu
dget
coversallbankchargesfor
Coun
cilservices.
Curren
tlyexpe
ctingto
beon
budget,further
workisbe
ing
carriedou
ttoanalysetheim
pactof
therecent
change
inbankingarrangem
ents.
Policy&Re
Bren
twoo
dShared
Service
(1,346
,040
)(1,652
,058
)(306
,018
)(69,00
0)(69,00
0)
Civica
ITSoftwaremainten
ance
contractsincreaseannu
ally
with
inflatio
neach
financialyear,towhich
with
regard
tothe
volumeof
contractsw
earecurren
tlypaying
forcan
resultina
significantv
arianceover
timewhich
wou
ldno
tbemanageable
with
incurren
tbud
gety
earo
nyear.
Postagespen
dforB
rentwoo
disanticipated
toremain
consisten
twith
volumes
from
lastyear
andwilllikelyincrease
with
inflatio
n,he
nceprod
ucingan
ongoingpressure
tobu
dget.
Estim
ated
Outturn
Und
erspen
diswith
regard
toBren
twoo
dinvoiceannu
alinflatio
nary
increase
andelem
entfor
capital
contrib
utionwhich
exceed
sbud
getedincome.
Overachievemen
tofincom
efora
nnualinvoice
isto
beused
topartially
offset
pressure
inHb
enresulting
from
redu
ctionto
19/20Ad
mingrantA
llocatio
n.Po
licy&Re
CentralBud
getR
&M
885,50
088
5,50
041
3,48
141
3,48
1Po
licy&Re
CapitalFinancing
(5,131
,200
)(2,911
,300
)2,91
8,10
067
,349
(2,850
,751
)(100
,000
)(100
,000
)Im
proved
investmen
treturns.
Policy&Re
CommercialTeam
345,40
035
2,50
022
6,20
020
9,21
8(16,98
2)(20,00
0)(20,00
0)Und
erspen
ddu
eto
restructure.
Policy&Re
Contingency
487,50
020
5,50
0
Thisisthecorporatecontingencybu
dget
which
isallocatedto
services
whe
napproved
byS151
/com
mittee.Thefullbu
dget
for2
019/20
hasb
eenallocatedthereforewillou
tturnas
nil.
Policy&Re
Corp
Staff:Co
rpInitiatives
149,90
028
1,90
018
8,40
011
2,32
0(76,08
0)Po
licy&Re
CorporateManagem
ent
3,05
3,30
02,35
4,00
01,39
3,65
01,40
1,16
47,51
4Cu
rren
tlyexpe
ctingon
budget
pend
ingtheou
tcom
esof
vario
uscorporatereview
s.Po
licy&Re
Coun
cilTax
&NNDR
Costof
Col
982,80
099
3,20
01,87
7,59
51,54
0,66
6(336
,929
)(20,00
0)(20,00
0)
Estim
ated
unde
rspe
ndiswith
regard
tocostof
court
summon
sesc
omingsig
nificantly
unde
rbud
get.Lastfin
ancial
year
areview
took
placeof
thecostof
courtd
ocum
ents,asa
resultof
thisreview
thecostwas
redu
cedfrom
£3.00pe
rdo
cumen
tto50
ppe
rdocum
ent.Ifthenu
mbe
rofcou
rtsummon
sesrem
ains
consisten
twith
priory
eara
ndaverage
mon
thlyprojectedvolumes,thisw
illPo
licy&Re
HousingBe
nefit
&CT
axSupp
ort
330,30
033
7,80
01,18
0,55
01,64
9,41
846
8,86
866
,000
66,000
Admingrantisred
ucingyear
onyear
andwillcontinue
todo
soon
goinginfuture
yearsa
ndhe
ncewillno
tbeachieved
againsto
ngoing
budget.
Admingranth
asredu
cedby
84kup
onou
r18/19
fund
ing
allocatio
nandhash
ence
resulte
dina80
kpressure
tobu
dget.
TheDW
Phave
advisedthat
fund
ingwillcontinue
toredu
cefor
theforseeablefuture
andifthelevelofred
uctio
nremains
consisten
twith
priory
ears,w
eestim
atethiswillroughly
workout
at9.7%
ongoingandhe
nceweanticipateou
rpressure
tobu
dget
toriseto
153k
inthene
xtfin
ancialyear.
Policy&Re
App
endi
xK
Com
mitt
eeB
DM
Enc
losu
res
pg.1
8
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
xxxx
RowLabe
lsNo.
ofareas
No.
ofOutturnsc
ompleted
Sum
ofou
tturns
Sum
ofcf
Sum
ofOutturn
afterC
FNo.
ofcommen
tscompleted
Sum
ofOngoing
Outturn
Percen
tage
outturns
completed
Percen
tage
commen
tscompleted
GF#D
IV/0!
#DIV/0!
Commun
ities
245
1146
3288
0000
7653
685
6000
20.83%
20.83%
ADCo
mmun
ities
10
0.00
%0.00
%Ho
usingCh
oice
30
0.00
%0.00
%Ho
usingManagem
ent&
Comms
75
1146
3288
0000
7653
685
6000
71.43%
71.43%
Prop
ertyServices
Delivery
70
0.00
%0.00
%StrategicProp
erty
60
0.00
%0.00
%Co
ntingency
22
00
02
100.00
%10
0.00
%Co
rporateServices
2019
6200
00
6200
016
5000
95.00%
80.00%
ADCo
rporateServices
44
5000
050
002
100.00
%50
.00%
IT,R
esilien
ce&Info
Governan
87
5000
050
006
5000
Legal&
Democracy
88
7200
00
7200
08
EfficienciesT
arget
11
2200
000
2200
001
2400
00En
gagemen
t11
0ExecutiveTeam
150
Grow
th24
825
0000
078
5000
053
5000
08
ADGrow
th1
0He
adof
Regen&Econ
omicDe
v17
20
00
2Planning
66
2500
000
7850
000
5350
000
6Pe
ople&Ch
ange
80
PublicSpaces
6020
4300
00
4300
017
4900
0AD
PublicSpaces
10
Environm
entalH
ealth
Services
33
4000
00
4000
03
5000
0Leisu
re30
1680
000
080
000
1310
00Street
Scen
e&TechnicalSvcs
261
3000
030
001
Resources
3430
1935
000
1935
0024
1000
0AD
Resources
10
Finance&Co
mmercialServices
1717
1200
000
1200
0011
Governance
&Assurance
65
2500
025
005
5000
Revs,B
enefits
andCu
stServs
108
7100
00
7100
08
5000
GFCa
pital
Commun
ities
410
StrategicProp
erty
410
CorporateServices
11
5000
0050
0000
01
IT,R
esilien
ce&Info
Governan
11
5000
0050
0000
01
Grow
th17
0He
adof
Regen&Econ
omicDe
v17
0Pu
blicSpaces
407
8667
50
8667
57
Environm
entalH
ealth
Services
20
Leisu
re20
786
675
086
675
7Street
Scen
e&TechnicalSvcs
180
Resources
50
Finance&Co
mmercialServices
50
HRA Commun
ities
77
3650
0060
000
3050
002
HousingCh
oice
22
3500
00
3500
0Ho
usingManagem
ent&
Comms
22
3300
0060
000
2700
002
Prop
ertyServices
Delivery
22
00
0StrategicProp
erty
11
00
0HR
ACa
pital
30
(blank
)(blank
)Gran
dTo
tal
313
100
3960
807
9290
000
5329
193
8317
0000
App
endi
xL
BD
Mda
taex
tract
perio
dou
tturn
spi
vott
able
pg.1
9
June July August September Ongoing Carry F/wds£000 £000 £000 £000 £000 £000
Finance & Commercial Services (160) (120) (120) (120) - Revenues, Benefits & Customer Services (70) (70) (15) (71) 5 Governance & Assurance 10 (7) (12) (3) 5 Regeneration & Economic Development (41) 23 (9) - 6 88 Planning - - - (50) - 2,450 Legal & Democracy 16 (24) (18) 72 - IT, Resilience & Information Governance (1) (5) (5) (5) 5 Housing Management & Communities 7 6 7 (27) - Strategic Property - - - - - Property Services Delivery - - - - - Housing Choice - - - - - Street Scene & Technical Services 90 (140) - (3) - Leisure 27 24 5 (80) (1) Environmental Health 25 25 40 40 50 Digital Business Development - - - - - Insight - - - - - Communications - - - - - Workforce (inc. HR/OD) - - - - - Corporate Programme - - - - - ET/SLT - - 10 (5) - Efficiencies (220) (220) (220) (220) (240)
TOTAL (317) (508) (337) (472) (170) 2,538 Change from previous month (£) (191) 171 (135) Change from previous month (%) 60% -34% 40%
June July August September Ongoing Carry F/wds£000 £000 £000 £000 £000 £000
Housing Management & Communities (125) (125) (125) (270) - 60 Housing Choice 70 (38) (90) (35) -
(55) (163) (215) (305) - 60
June July August September Ongoing Carry F/wds£000 £000 £000 £000 £000 £000
General Fund ProgrammeRegeneration & Economic Development 25 (20,614) (20,430) - - IT, Resilience & Information Governance - - - - - 500 Leisure - 3 (87) (87) -
25 (20,611) (20,517) (87) - 500 HRA Programme
Strategic Property - - - - - Property Services Delivery - - - - -
- - - - - -
25 (20,611) (20,517) (87) - 500
General Fund EstimatedOutturn
The table below summarises the estimated outturn position for the General Fund provided by service managers (requested carry forwards are shown in the last column for information):
HRAEstimatedOutturn
The table below summarises the estimated outturn position for the HRA provided by service managers (requested carry forwards are shown in the last column for information):
CapitalProgrammeEstimatedOutturn
The table below summarises the estimated outturn position for the Capital Programme provided by service managers (requested carry forwards are shown in the last column for information):
Appendix M SLT quarterly report Outturn page
pg. 20