APPENDIX 2

2002/2003 CASHFLOW PROJECTION

LATEST

ACTUAL

FORECAST

FORECAST

FORECAST

TOTAL

C/FWD

REVISED

SPEND

SPEND

SPEND

SPEND

FORECAST

SPEND TO

SCHEME

BUDGET

QTRS 1 & 2

QTRS 1 & 2

QTR 3

QTR 4

SPEND

2003/2004

EDUCATION

ACG

1,479

23

100

450

550

1,100

379

Formula & Seed Challenge

1,573

-

250

500

750

823

Increase Repairs

1,156

20

75

350

500

925

231

NDS modernisation

509

46

50

200

200

450

59

Access Initiative

243

30

50

80

100

230

13

NDS condition survey

720

-

220

450

670

50

Staff workplaces

52

-

20

32

52

Nursery Places

52

-

20

32

52

School Security

35

-

10

25

35

Radstock Schools Project

850

-

150

500

650

200

Carry Forward formula/seed challenge funding

916

63

150

350

416

916

Other Carry Forward Schemes

1,755

447

500

600

555

1,655

100

TOTAL EDUCATION COMMITTEE

9,340

629

925

2,700

3,860

7,485

1,855

SOCIAL SERVICES

Access to Buildings/Services

15

4

4

7

15

Occupational Therapy Equipment

40

20

20

10

10

40

Leaving Care Grant

15

4

4

7

15

Personal PC's for looked after people

22

7

7

8

22

Health & Safety Issues

35

14

12

9

14

35

QP - IT for looked after children

19

6

6

7

19

Minor Works

22

6

7

9

22

Healthy Living Centre

187

20

70

97

187

CRISSP Replacement

434

6

101

100

233

434

Replace elderly peoples homes

500

28

12

63

103

397

Springfield Stables refurbishment

100

5

45

50

100

Information Management

91

20

71

91

Mental Health IT

75

20

55

75

TOTAL SOCIAL SERVICES COMMITTEE

1,555

40

213

314

631

1,158

397

-

-

-

-

-

-

TRANSPORTATION, ACCESS & WASTE MAN'MENT

Bridge Assessment/Works

520

296

250

200

50

500

20

Principal Road Networks

2,340

535

650

800

840

2,290

50

Urban Traffic Management

430

63

100

150

150

400

30

Public Transport

354

67

100

120

120

340

14

Safety Schemes

1,335

794

600

600

135

1,335

Pedestrian/Cycle Schemes

828

197

250

250

280

780

48

Waste Management

75

-

-

-

75

75

Other Minor Projects

207

10

30

75

85

190

17

Landscape/Conservation Schemes

34

1

5

15

14

34

Parking

195

71

65

65

65

195

TOTAL TRANSPORTATION COMMITTEE

6,318

2,034

2,050

2,275

1,814

6,139

179

PROPERTY

Planned Maintenance - Education

1,133

144

530

370

233

1,133

Planned Maintenance - Corporate Estate

470

137

150

120

150

420

50

Risk Assessment/disabled works - Corp. Estate

375

43

43

137

116

296

79

Commercial estate development fund

200

194

150

50

-

200

Long Term Office Approach

202

12

25

40

50

115

87

Education condition survey

467

143

120

140

140

400

67

Pulteney Weir Investigation

20

6

5

15

-

20

Asset Management software

35

-

-

35

-

35

Carry forward funding

624

340

300

200

124

624

TOTAL PROPERTY COMMITTEE

3,526

1,019

1,323

1,107

813

3,243

283

ECONOMIC DEVELOPMENT

Midsomer Norton Town Square

43

3

5

15

23

43

Norton Radstock SRB

232

232

232

Local Shopping - bid to RDA

29

2

5

12

12

29

Office Relocation

14

5

14

14

Study to revitalise Moorland Road shopping

15

2

6

7

15

CCTV

14

4

10

14

Market & Coastal Towns Initiative

11

10

6

5

11

TOTAL ECONOMIC DEVELOPMENT COMMITTEE

358

20

36

48

274

358

-

RESOURCES

IT - Consolidate Service Provision

130

-

30

100

130

Finance/Housing Best Value Review - tech/accomm

370

-

90

280

370

IT - Server & Networks

200

-

-

200

200

FMS Replacement Project

923

-

-

700

700

223

TOTAL RESOURCES COMMITTEE

1,623

-

-

120

1,280

1,400

223

CULTURE & LEISURE

Review use of Guildhall

56

21

28

21

7

56

Replace play equipment at RVP

83

16

20

29

34

83

Invest to sustain fund (retail warehouse roof)

67

67

67

Invest to sustain fund (concert room projetc)

83

83

83

Theatre Royal youth theatre grant

50

-

50

Haycombe Crematorium refurb grounds/chapel

3

1

3

3

Purchase Mobile Library

2

2

2

CCTV RVP

9

2

7

9

S.106 Play Schemes

68

1

3

15

15

33

35

TOTAL CULTURE, COMMUNITY & LEISURE CTTEE

421

39

53

137

146

336

85

CORPORATE PROJECTS

Stone Mines

252

91

80

80

80

240

12

Improve Community Access to Council Services

317

14

20

268

29

317

Western Riverside Project

680

282

250

230

200

680

Spa Scheme ****

1,225

2,055

400

500

325

1,225

Major projects contingency

2,000

-

2,000

E-government

200

15

20

70

110

200

Base capital contingency budget

195

195

195

Community Safety Projects

64

10

10

40

60

4

TOTAL CORPORATE PROJECTS

4,933

2,457

780

1,158

979

2,917

2,016

HOUSING GENERAL FUND

Social Housing Grants

3,493

1,211

1,279

1,000

1,215

3,494

Disabled Facility Grants

550

288

273

138

139

550

Lettings & Choice

52

5

25

22

52

Support for low income homes

280

145

137

70

70

277

Provide safe private rented sector

30

19

18

6

7

31

Support for elderly/disabled

20

7

7

6

20

Secure homes initiative

20

10

8

6

7

21

TOTAL HOUSING GENERAL FUND

4,445

1,673

1,727

1,252

1,466

4,445

-

TOTAL PROGRAMME

32,519

7,911

7,107

9,111

11,263

27,481

5,038

-

*** Spa scheme - anticipated millenium grant of £1.5m will reduce current overspend position.