Project Plan Worksheet Fill in sequentially blue cells first
NPG Ref No !_*&% Name of Award State name as per Funding Agreement Remaining cells contain formulae & will facilitate quick worksheet completion
Name of Municipality Lekwa Local Municipality Project Reference No PP00!
Project Name Informal Trade Market Date of Project Plan 39836
Name of Township where Project is located Sakhile Name of Node within Township where Project is Located N/a
Project Details [List each discrete sub-component of the project. If breakdown is not yet possible, state totals only]
No Project Sub-Component Description Status Quo No of Units Size or No of Unit of Measure Total Provided Average Unit Total Cost per Ave No of Days in
Units Cost (Rands) Sub- mth
Component2
1 Informal trading stalls Small, linear market to support existing taxi rank Trader consultation for buy-in to sketch layout complete. 5 3.2 m2 16 R 5,500 R 88,000 30
2 Temba Road Widening Widening of ex road by 3m Sketch layout only completed. 1 1.5 km 1.5 R 1,200,000 R 1,800,000
3 Street lighting to Temba Road Prov of luminaires as per muni standards Part of above. 30 1 No of 30 R 30,000 R 900,000
4 Trees to Temba Road & irrigation Prov of shade trees along linear market Part of above. 15 1 No of 15 R 5,500 R 82,500
5 Bins Specially designed metal bins using local steel manufacturers Part of above. 5 1 No of 5 R 5,500 R 27,500
Total Project Cost2 R 2,898,000
Notes:
1 List each discrete sub-components of each project. If breakdown is not yet possible, state totals only. Add as many rows as necessary.
2 Excluding VAT, escalation and contingencies, but including planning for the project
Project Accountabilities in Municipality [List the accountable officials for approving the design of the asset to be created AND who will be responsible for owning and managing the asset (name, designation & department) for each discrete project sub-component]
No Project Sub-Component Design Sign-off Receiving Officer (Name & Designation) Asset Ownership Agreed by Receiving Officer (Name & Designation) Comment on Operations/ Asset Management
1 Informal trading stalls F Brown (Exec Dir: LED) K Mohlantle (Sen Eng: Roads Dept) To be managed by taxi association through 7-year lease at R6,000 p.a.
2 Temba Road Widening D Smit (Sen Eng: Tech Div) K Mohlantle (Sen Eng: Roads Dept) Managed as part of general roads management, ops budget sufficent for this asset.
3 Street lighting to Temba Road D Smit (Sen Eng: Tech Div) K Mohlantle (Sen Eng: Roads Dept) As above.
4 Trees to Temba Road & irrigation P Oranje (Parks Dept) P Oranje (Parks Dept) Indigenous trees are to be specified, maintenance limited to one year of irrigation to ensure establishment of trees.
5 Bins P Oranje (Parks Dept) & D Smit (Sen Eng: Tech Div) M Mashatile (Waste Management Services) Waste management to agree that bins not acc to std muni spec at design stage in order to operate normal service.
Project Timing and Sequencing [If detailed planning not yet available, provide estimated dates only. Period stated to include design AND implementation. Should align to Schedule 3A &/or Schedule 3B of Funding Agreement. Add rows as required.]
No Project Sub-Component Start Date End Date No of Days to No of Months Comment on Any Factor Impacting on Progress
Implement
1 Informal trading stalls 23-Jan-09 30-Aug-09 219.00 7 One informal trader objects to relocation of stall during construction period, to be negotiated.
2 Temba Road Widening 23-Jan-09 23-Jun-09 151.00 5 N/a
3 Street lighting to Temba Road 23-Jan-09 23-Jun-09 151.00 5 N/a
4 Trees to Temba Road & irrigation 1-Aug-09 30-Aug-09 29.00 1 Only indigenous trees to be specified.
5 Bins 1-Aug-09 30-Aug-09 29.00 1 Bins acc to std muni spec.
Overall Project Time Frames 23-Jan-09 30-Aug-09 219.00 7
Costs by NDPG [Provide as much information as possible. If detailed planning is not yet available, state totals only]
No Project Sub-Component Planning Costs Implementation Costs Thus Total
Detailed As % of Project State if funded Basis of Planning Costs Estimate Detailed Basis of Implementation Costs Estimate NDPG Cost per Total cost per
Planning Costs Sub-Component through TA or Implemen-tation Sub-Component Sub-Component
Cost CG Costs (Check Total)
1 Informal trading stalls R 8,800 10 CG Arch Tariff of Fees (10%). R 79,200 Prelim cost estimates by QS. R 88,000 R 88,000
2 Temba Road Widening R 180,000 10 CG Fee as per Eng Tariff of Fees (10%). R 1,620,000 MIG cost guides. R 1,800,000 R 1,800,000
3 Street lighting to Temba Road R - 0 CG No cost as luminaires are standard. R 900,000 MIG cost guides. R 900,000 R 900,000
4 Trees to Temba Road & irrigation R 7,125 9 CG Min cost to specify trees, their layout & design irrigation system & layout (15 hrs @R475). R 75,375 MIG cost guides. R 82,500 R 82,500
5 Bins R 9,000 33 CG Cost as per Arch Tariff of Fees for design & work with SMME welders (h18hrs @ R500). R 18,500 Estimate only - very provisional. R 27,500 R 27,500
Subtotal 1 for Planning Costs R 204,925 Subtotal 2 for Implementation Costs R 2,693,075 Subtotal 3 (add Subtotal 1 + 2) for NDPG Cost R 2,898,000 R 2,898,000
Add Contingencies 4 5.00% R 144,900
Notes: Add Escalation 5 0.00% R -
1 Provide as much information as possible. If detailed planning is not yet available, state totals only.
2 Use Spreadsheet option if preferred. Total (Excluding VAT), thus Total NDPG Ceiling for this project is R 3,042,900
3 Add rows as required.
4 First state the percentage (o%, 5%, 10%), then calculate on NDPG Cost Add VAT (NOT borne by NDPG) 6 14.00% R 426,006 Note CG excludes VAT!
5 First state the percentage (o%, 5%, 10%), then calculate on NDPG Cost, applicable only to project longer than 12 - 18 months
6 Note VAT costs are NOT borne by NDPG and this calculation is for the municipality's information only Total (Including VAT) R 3,468,906
Employment Creation
During Construction
Category No of People No
No of Days Worked of person % Youth % Women % Disabled
days of jobs to
be created
EPWP 5 2 10
Other
10
Notes:
1 Person-days of jobs created: Number of people who worked on the project multiplied by the number of days each person worked. E.g. if 5 people worked for 2 days then the person-days of work equals 10 days.
After Project Completion
Category Number of
persons
SMMEs
Print Date:12/28/2011 Pg 1 of 2
Business type No of SMMEs No of SMMEs
that are HDE
E.g. Services
E.g. Construction
Total Project Costs: Leverage and Partnerships
Funder Funder Name Details of Contributions
Project Planning Implement- Total Basis of Assumption Implement-ation
Amounts ation/ Capital Year
Amounts
NDPG National Treasury R 204,925 R 2,693,075 R 2,898,000 As above. 2009
Municipality Lekwa Municipality R 1,800 R - R 1,800 In-kind contribution. Provides check on spec for street lighting - based on 3hrs of Sen Eng's time for design & project management. 2009
Municipality Lekwa Municipality R - R 223,000 R 223,000 In-kind contribution of land, value based on sales in areas in last 12 months. 2008
Private Sector Kippy Properties R 4,800,000 R 48,000,000 R 52,800,000 This project will unlock R48m mall. Indicative commitment attached. Planning cost est at 10% on top of R48m. 2012
Public Sector National Roads R 700,000 R 7,000,000 R 7,700,000 DoT to construct R7m taxi rank.See attached letter noting their MTEF allocation. Planning cost est at 10% on top of capital investment. 2011
Public Sector Provincial Health R 1,750,000 R 17,500,000 R 19,250,000 Prov to fund R10m clinic extension may be funded in 2014-15 - see attached. Planning cost est at 10% on top of capital investment. 2015
Public Sector Kippy Properties R - R - R - Company proposes ext of mall if viable in 2020, highly uncertain so value not included. 2020
Other ABC University R 7,500 R - R 7,500 Art Faculty proposes design support to bin sub-project. In-kind contribution based on 10 students working with community @ R150/hr and total of 5 days. 2009
Other ABC University R 12,600 R - R 12,600 School of Economics' PhD students (3) have undertaken demand study of informal trade in project area, based on 40 hrs @ R200/hr & total of 21 days. 2008
Other TBC R - R - R - TBC Post-MTEF
Other TBC R - R - R - TBC Post-MTEF
Total Project Cost R 7,476,825 R 75,416,075 R 82,892,900
Thus Leverage of NDPG is 1 to 27.6 And NDPG Funding Share is 3.5 % of the Total Project Cost
4.3.4_ProjectPlan_Worksheet_Apr10
Print Date:12/28/2011 Pg 2 of 2