claims 06 07 at 05 04 07

TWP SINGLE PROGRAMME 2006 - 2007 1st Qtr Claim 2005/06 Accrual As Agreed NCC Project Officer £ 2006/07 SP Allocation £ offer Letter July 2006 Famis NOT SP 2005/06 2005/06 2006/07 4/5/2007 Defrayed Accrual SP After Defrayed Allocation April 10th 2006/07 See separate spreadsheet 93,629 461 14,183 5,063 3,213 19,133 0 447,870 123,936 96,051 23,454 11,270 97,890 10,000 113,174 61,742 2,000 122,409 573 170,977 4,989 181,531 6,080 1,157 17,759 516 50,532 52,000 9,500 40,000 675,437 1,855,096 73,296 29,315 29,315 345,901 879,841 11,629 0 25,950 70,500 91,041 128,615 10,875 99,461 25,882 15,000 TWP Capital NCC FAMIS CODE Regeneration centre ouseburn Tyneside cinema Tyneside cinema - develop and restore Legibility Building Improvement Grant Scheme Business Environmental Improvement Fund Site Enabling - McPhees Yard & Ingham Place Site Enabling - Feasibility & Development Heritage assets (ouseburn) QE2 Bridge Lighting - Nexus Discovery quarter - public arts project Theatre Royal - Education centre The G N M - Cultural quart ph 3 Univ Of New Live theatre - phase 1 Bruvvers Theartre Live theatre phases 2 and 3 Feasibility Studies Discovery quarter - PPP Rev - SME office study Rev Waygood gallery Brickworks Canvass works Rev Canvass works DVD09 DZE01 DZE01 DZE02 DZE03 DZE04 DZE05 DZE06 DZE07 DZE08 DZE10 DAF02 DZC09 DZC12 DZD04 DZE09 1V660 1DD1A DPA04 DZF01 1DD1A DZF02 Dale Bolland Barbra Robson Barbra Robson Dale Bolland Dale Bolland Dale Bolland Dale Bolland Dale Bolland Dale Bolland Matthew Lennon Matthew Lennon Barbra Robson Tony Durkin B Robson Dale Bolland B Robson Dave Croft Dave Croft Barbra Robson Dale Bolland Dale Bolland Dale Bolland 14,644 19,133 119,505 62,425 171,550 6,080 56,039 9,500 40,169 834,437 80,000 38,506 51,102 23,985 75,198 103,368 17,500 40,000 573,072 1,700,000 0 245,900 718,212 0 35,000 812,000 128,615 10,875 237,125 40,169 20,277 -15,920 3,482 384 -29,000 -72,553 10,253 -47,731 25,000 102,365 80,000 38,506 51,102 23,985 75,198 103,368 17,500 40,000 1,700,000 0 73,296 29,315 11,629 25,882 15,000 100,001 718,212 0 35,000 68 15,000 Total cap 6,965,064 3,123,040 96,626 5,505,443 5,307,077 97,601 510,723 49,479 TWP Revenue Administration ISIS 1DD1B 1DF44 Barbra Robson 87,125 10,500 G3 TOTAL 5,307,077 10,500 17,000 613,998 608,324 66,479 c161b2dd-37ce-48ca-85ce-247ff34c81b4.xlsclaims 06 07 at 05 04 07 ROGRAMME 2006 - 2007 2nd Qtr Claim 3rd Qtr Claim 4th Qtr Claim includes total defrayed re accrual in col k 2,702 0 7,193 15,000 11,008 8,659 16,736 0 0 7,364 59,169 0 0 407,364 447,870 59,224 97,000 72,506 97,506 58,136 80,432 2,627 23,985 137,010 165,198 14,958 14,958 3,863 17,500 26,000 40,000 573,072 573,072 421,993 1,086,834 1,781,800 0 0 0 245,900 245,900 314,525 553,687 868,212 0 34,434 0 6,066 91,041 128,615 10,875 99,461 0 44,040 0 40,506 19,313 0 9,288 7,710 10,295 0 13,637 14,000 T10 Page 3 T10 Page 3 T10 Page 3 T10 Page 5 T10 Page 6 T10 Page 7 T10 Page 8 T10 Page10 T10 Page11 T10 Page11 T10 Page12 T10 Page13 T10 Page13 T10 Page14 T10 Page14 T10 Page14 272,973 0 0 0 0 0 copy inv attached 55,500 T9 Page 2 91,041 T4 + Invoice 128,615 T10 Page12 10,875 T9 Page 2 99,461 T10 Page12 334,271 929,741 3,584,603 4,898,094 4,898,094 17,000 17,000 36,125 10,500 87,125 10,500 97,625 T9 Page 5 T9 Page 5 351,271 total grant received 946,741 3,631,228 4,995,719 5,604,043 c161b2dd-37ce-48ca-85ce-247ff34c81b4.xlsclaims 06 07 at 05 04 07 TWP SINGLE PROGRAMME 2006 - 2007 1st Qtr Claim 2005/06 Accrual As Agreed NCC Project Officer £ Dale Bolland Barbra Robson Barbra Robson Dale Bolland Dale Bolland Dale Bolland Dale Bolland Dale Bolland Dale Bolland Matthew Lennon Matthew Lennon Barbra Robson Tony Durkin B Robson Dale Bolland B Robson Dave Croft Dave Croft Barbra Robson Dale Bolland Dale Bolland Dale Bolland 14,644 19,133 119,505 62,425 171,550 6,080 56,039 9,500 2006/07 SP Allocation £ 40,169 834,437 80,000 38,506 51,102 23,985 75,198 103,368 17,500 40,000 573,072 1,700,000 0 245,900 718,212 0 35,000 812,000 128,615 10,875 237,125 offer Letter July 2006 Famis 2005/06 2005/06 2006/07 4/12/2007 Defrayed Accrual SP After Defrayed Allocation April 10th 2006/07 20,277 93,629 461 14,183 5,063 -15,920 3,213 19,133 0 447,870 6,855 127,309 96,051 23,454 11,270 384 97,890 10,000 -14,890 136,954 61,742 2,000 -59,226 135,736 573 170,977 4,989 30,052 201,330 6,080 1,157 -25,152 128,748 516 50,532 25,000 52,000 9,500 40,000 102,365 675,437 1,855,096 73,296 29,315 29,315 100,001 345,901 879,841 11,629 0 68 25,950 70,500 91,041 128,615 10,875 99,461 25,882 15,000 NOT SP 2nd Qtr Claim 3rd Qtr Claim 4th Qtr Claim to spend 2,702 0 7,193 15,000 11,008 8,659 16,736 0 0 7,364 59,169 0 0 407,364 447,870 59,224 97,000 72,506 97,506 67,806 90,102 2,627 23,985 137,010 165,198 103,368 103,368 3,863 17,500 26,000 40,000 573,072 573,072 421,993 1,086,834 1,781,800 0 0 0 245,900 245,900 314,525 553,687 868,212 0 34,434 0 6,066 91,041 128,615 10,875 99,461 0 0 55,500 91,041 128,615 10,875 99,461 44,040 0 40,506 19,313 0 9,288 7,710 10,295 0 13,637 14,000 0 0 386,567 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 137,664 as per qtr 2 qtr 3 claim forecast additional approval qtr 4 programme at total 06/07 3/20/2007 forecast sp allocarion plus accrual 59,169 834,437 97,000 97,506 90,102 23,985 165,198 103,368 17,500 40,000 573,072 1,781,800 0 245,900 868,212 0 55,500 91,041 128,615 10,875 237,125 73,352 19,133 834,437 120,454 97,506 151,844 194,962 171,278 153,900 27,000 40,000 573,072 1,855,096 29,315 245,900 879,841 25,882 70,500 91,041 128,615 237,125 TWP Capital NCC FAMIS CODE DVD09 DZE01 DZE01 DZE02 DZE03 DZE04 DZE05 DZE06 DZE07 DZE08 DZE10 DAF02 DZC09 DZC12 DZD04 DZE09 1V660 1DD1A DPA04 DZF01 1DD1A DZF02 Regeneration centre ouseburn Tyneside cinema Tyneside cinema - develop and restore Legibility Building Improvement Grant Scheme Business Environmental Improvement Fund Site Enabling - McPhees Yard & Ingham Place Site Enabling - Feasibility & Development Heritage assets (ouseburn) QE2 Bridge Lighting - Nexus Discovery quarter - public arts project Theatre Royal - Education centre The G N M - Cultural quart ph 3 Univ Of New Live theatre - phase 1 Bruvvers Theartre Live theatre phases 2 and 3 Feasibility Studies Discovery quarter - PPP Rev - SME office study Rev Waygood gallery Brickworks Canvass works Rev Canvass works 40,169 80,000 38,506 51,102 23,985 75,198 103,368 17,500 40,000 1,700,000 0 718,212 0 35,000 73,296 29,315 11,629 25,882 15,000 272,973 0 0 0 0 40,169 0 0 80,000 38,506 51,102 23,985 75,198 103,368 17,500 40,000 500,000 1,700,000 0 718,212 0 35,000 812,000 19,000 834,437 17,000 59,000 39,000 90,000 81,800 150,000 15,000 20,500 128,615 Total cap TWP Revenue Administration ISIS 613,998 Total cap 6,965,064 3,123,040 169,814 5,676,711 G3 TOTAL 5,478,345 97,601 510,723 49,479 334,271 929,741 3,682,683 4,996,174 4,996,174 36,125 87,125 10,500 10,500 946,741 3,729,308 5,093,799 928,473 946,741 97,151 1,972,365 17,000 524,231 3,265,212 1,439,352 5,520,405 6,020,253 608,324 1DD1B 1DF44 Barbra Robson 87,125 10,500 17,000 10,500 66,479 TOTAL 7,052,189 Total Programme for this year 7,676,687 56,954 0 3,123,040 351,271 17,000 87,125 622,311 3,352,337 87,125 10,500 5,618,030 87,125 10,500 cash received to 31st jan received 23rd feb 07 received 20th march 07 relates to jan defrayed only- includes an error of 2580 includes revenue 0 0 0 15,121 0 149,043 15,121 0 149,043 5,782,194 5,782,194 SEE NEXT WORKSHEET AT 04/04/07 510,723 17,857,305 6,117,878 6,117,878 NOT GOING THRO FAMIS Low Yard Walker riverside Clocktower Court Gateway to Ouseburn c161b2dd-37ce-48ca-85ce-247ff34c81b4.xlsfamis 06 07 at 12 april TWP SINGLE PROGRAMME 2006 - 2007 1st Qtr Claim 2005/06 Accrual As Agreed NCC Project Officer £ Dale Bolland Barbra Robson Barbra Robson Dale Bolland Dale Bolland Dale Bolland Dale Bolland Dale Bolland Dale Bolland Matthew Lennon Matthew Lennon Barbra Robson Tony Durkin B Robson Dale Bolland B Robson Barbra Robson Dale Bolland Dale Bolland 14,644 19,133 119,505 62,425 171,550 6,080 56,039 9,500 2006/07 SP Allocation £ 40,169 834,437 80,000 38,506 51,102 23,985 75,198 103,368 17,500 40,000 573,072 1,700,000 0 245,900 718,212 812,000 128,615 237,125 offer Letter July 2006 Famis NOT SP 2005/06 2005/06 2006/07 4/5/2007 Defrayed Accrual SP After Defrayed Allocation April 10th 2006/07 93,629 461 14,183 5,063 3,213 19,133 0 447,870 123,936 96,051 23,454 11,270 97,890 10,000 113,174 61,742 2,000 122,409 573 170,977 4,989 181,531 6,080 1,157 17,759 516 50,532 52,000 9,500 40,000 675,437 1,855,096 73,296 29,315 29,315 345,901 879,841 11,629 0 91,041 128,615 99,461 97,601 Rev Rev Rev 1V660 1DD1A 1DD1A 1DD1B 1DF44 Dave Croft Dave Croft Dale Bolland Barbra Robson 25,882 15,000 0 35,000 10,875 87,125 10,500 0 35,000 68 25,950 70,500 10,875 10,500 469,841 25,882 15,000 34,479 2nd Qtr Claim 3rd Qtr Claim jan received inc in col p 4th Qtr Claim as per qtr 2 qtr 3 claim forecast additional approval TWP Capital Regeneration centre ouseburn Tyneside cinema Tyneside cinema - develop and restore Legibility Building Improvement Grant Scheme Business Environmental Improvement Fund Site Enabling - McPhees Yard & Ingham Place Site Enabling - Feasibility & Development Heritage assets (ouseburn) QE2 Bridge Lighting - Nexus Discovery quarter - public arts project Theatre Royal - Education centre The G N M - Cultural quart ph 3 Univ Of New Live theatre - phase 1 Bruvvers Theartre Live theatre phases 2 and 3 Waygood gallery Brickworks Canvass works Feasibility Studies Discovery quarter - PPP - SME office study Canvass works Administration ISIS NCC FAMIS CODE DVD09 DZE01 DZE01 DZE02 DZE03 DZE04 DZE05 DZE06 DZE07 DZE08 DZE10 DAF02 DZC09 DZC12 DZD04 DZE09 DPA04 DZF01 DZF02 40,169 20,277 -15,920 3,482 384 -29,000 -72,553 10,253 -47,731 25,000 102,365 2,702 0 7,193 15,000 11,008 8,659 16,736 0 0 80,000 38,506 51,102 23,985 75,198 103,368 17,500 40,000 1,700,000 0 44,040 0 40,506 19,313 0 9,288 7,710 10,295 0 13,637 14,000 421,993 0 314,525 124 20,072 10,000 7,142 2,627 31,375 8,231 73,296 29,315 11,629 272,973 0 0 100,001 718,212 334,271 0 0 17,000 895,307 0 34,434 17,000 2,580 82,151 7,364 59,169 7,240 0 0 0 407,364 447,870 407,364 59,224 97,000 39,152 72,506 97,506 62,506 58,136 80,432 50,994 2,627 23,985 0 137,010 165,198 105,635 14,958 14,958 6,727 3,863 17,500 3,863 26,000 40,000 26,000 573,072 573,072 573,072 1,086,834 1,781,800 1,086,834 0 0 0 245,900 245,900 245,900 553,687 868,212 553,687 91,041 91,041 91,041 128,615 128,615 128,615 99,461 99,461 99,461 -2,580 3,567,662 3,485,511 0 6,066 10,875 36,125 10,500 0 55,500 10,875 87,125 10,500 40,169 0 0 80,000 38,506 51,102 23,985 75,198 103,368 17,500 40,000 500,000 1,700,000 0 718,212 812,000 19,000 834,437 17,000 59,000 39,000 90,000 81,800 150,000 128,615 qtr 4 programme at total 06/07 3/20/2007 forecast sp allocarion to add to debtor plus accrual although it is wip it will be claimed assumin is defrayed by 30th june 07 59,169 73,352 19,133 834,437 834,437 97,000 120,454 97,506 97,506 90,102 151,844 9,670 23,985 194,962 165,198 171,278 103,368 153,900 88,410 17,500 27,000 40,000 40,000 573,072 573,072 1,781,800 1,855,096 0 29,315 245,900 245,900 868,212 879,841 91,041 128,615 237,125 capital debtor 98,080 3,583,591 15,000 17,000 Total cap TWP Revenue 613,998 Total cap 5,862,689 2,923,040 96,626 5,515,943 97,601 510,723 66,479 351,271 946,741 0 6,066 10,875 15,000 21,125 10,500 48,566 3,534,077 97,151 3,631,228 4,995,719 3,534,077 4,995,719 0 35,000 87,125 20,500 0 55,500 10,875 87,125 10,500 25,882 70,500 237,125 revenue debtors 48,566 3,632,157 3,632,157 3,352,337 380,915 5,618,030 5,800,597 608,324 87,125 10,500 66,479 TOTAL 5,949,814 Total Programme for this year 6,574,312 2,923,040 351,271 963,741 928,473 946,741 97,151 1,972,365 3,677,853 5,093,344 622,311 3,439,462 5,715,655 cash received to 31st jan received 23rd feb 07 received 20th march 07 relates to jan defrayed only- includes an error of 2580 includes revenue c161b2dd-37ce-48ca-85ce-247ff34c81b4.xlsdebtors april 07 Single Programme Funding Profile 06/07 Gap funded projects April - June July - Sept Oct - Dec Jan - March Actual to date 128615 245900 80432 97506 110336 59169 0 55500 40000 0 1781800 14958 97000 868212 23985 165198 17500 573072 447870 91041 2580 4900674 87125 10500 97625 4998299 Total Claims Defrayed before Grand 31st March Total 128615 128615 245900 245900 80432 90102 97506 97506 110336 248000 59169 59169 0 0 55500 55500 40000 40000 0 149043 1781800 1781800 14958 103368 97000 97000 868212 868212 23985 23985 165198 165198 17500 17500 573072 573072 447870 834437 91041 91041 2580 15121 4900674 5684569 87125 87125 10500 10500 97625 97625 4998299 5782194 Projects Brick Works Bruvvers Theatre Building and Environ Improvements Building Improvement Grant Scheme Canvas Works Centre for Regeneration Clocktower Court Disc Qtr: Office Demand Study Disc Qtr: Public Arts Gateway to Ouseburn Great North Museum Heritage Assets Legible Ouseburn Live Theatre Phases II and III Site Enabling - McPhees Yard Site Enabling Feasibility QEII Lighting Commission Theatre Royal Education Centre Tyneside Cinema Waygood Low Yard Walker Riverside Totals Prog Management REVENUE ISIS Arts REVENUE REVENUE TOTALS ALL TOTALS 'ACTUALS' BREAK DOWN BY PROGRAMME AREA Forecast Actual Forecast Actual Forecast Actual Forecast 89147 67806 72506 7364 570000 6066 26000 63751 1005034 103368 59224 553687 2627 137010 3863 500000 762201 58419 4088073 36125 36125 4124198 2000 10000 5063 15000 25000 5000 10000 20000 14000 642951 11008 15000 2702 13000 9288 0 44040 34434 14000 421993 19313 314525 7710 10295 13637 0 40506 10000 20000 18000 272973 7193 8659 16736 467923 27125 332947 10337 30000 7500 249900 11270 4989 1157 17339 3996 16046 4160 0 49479 17000 17000 66479 758492 22000 22000 780492 334271 17000 17000 351271 1186732 27000 27000 1213732 929741 17000 17000 946741 0 0 Actual 128615 245900 58136 72506 110336 7364 0 6066 26000 0 1086834 14958 59224 553687 2627 137010 3863 573072 407364 91041 2580 3587183 36125 10500 46625 3633808 Accrual 9670 137664 149043 88410 0 0 386567 12541 783895 0 783895 Aprvd for from 07/08 allocations 06/07 89147 39468 245900 0 90102 0 97506 0 248000 0 59169 0 0 0 55500 0 40000 0 149043 0 1700000 81800 103368 0 97000 0 868212 0 23985 0 165198 0 17500 0 533500 39572 802707 31730 0 91041 15121 0 5400958 283611 87125 0 10500 0 97625 0 5498583 283611 Acceleration CT CR TOTALS 0 49479 49479 272973 61298 334271 777024 152717 929741 4898094 CLAIM 4 NET OF LOW YARD WALKER 4995719 CLAIM 4 NET OF LOW YARD WALKER 3631228 CLAIM 4 NET OF LOW YARD WALKER 622311 TWP SINGLE PROGRAMME 2006 - 2007 1st Qtr Claim 2005/06 2005/06 2006/07 Defrayed Accrual SP NCC Project Officer After Defrayed Allocation April 10th 2006/07 Dale Bolland 461 14,183 5,063 Barbra Robson 19,133 0 Barbra Robson Dale Bolland 96,051 23,454 11,270 Dale Bolland 10,000 Dale Bolland 61,742 2,000 Dale Bolland 573 170,977 4,989 Dale Bolland 6,080 1,157 Dale Bolland 516 50,532 Matthew Lennon 9,500 Matthew Lennon Barbra Robson Tony Durkin 73,296 B Robson 29,315 Dale Bolland B Robson 11,629 0 Barbra Robson Dale Bolland Dale Bolland 2nd Qtr Claim 3rd Qtr Claim jan received inc in col p see famis last year movement after claim "worksheet" called debtors 05 06 in this book 461 66,112 15920 3,213 40,506 101190 76,163 35,000 29000 62,180 153073 42,462 65,643 48246 11,033 23,137 14,000 0 768,262 29,315 0 326,154 0 0 0 1,563,180 347890 1,565,760 TWP Capital Regeneration centre ouseburn Tyneside cinema Tyneside cinema - develop and restore Legibility Building Improvement Grant Scheme Business Environmental Improvement Fund Site Enabling - McPhees Yard & Ingham Place Site Enabling - Feasibility & Development Heritage assets (ouseburn) QE2 Bridge Lighting - Nexus Discovery quarter - public arts project Theatre Royal - Education centre The G N M - Cultural quart ph 3 Univ Of New Live theatre - phase 1 Bruvvers Theartre Live theatre phases 2 and 3 Waygood gallery Brickworks Canvass works NCC FAMIS CODE DVD09 DZE01 DZE01 DZE02 DZE03 DZE04 DZE05 DZE06 DZE07 DZE08 DZE10 DAF02 DZC09 DZC12 DZD04 DZE09 DPA04 DZF01 DZF02 2,702 0 7,193 15,000 11,008 8,659 16,736 0 0 44,040 0 40,506 19,313 0 9,288 7,710 10,295 0 13,637 14,000 421,993 0 314,525 124 20,072 10,000 7,142 2,627 31,375 8,231 272,973 0 0 2,580 Feasibility Studies Discovery quarter 97,601 469,841 34,479 334,271 895,307 82,151 1,913,650 c161b2dd-37ce-48ca-85ce-247ff34c81b4.xlsapplied grant 06 07