{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Annexture A","Project Teams"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Annexture A","index":0,"n_rows":90,"n_cols":17,"rows_kept":90,"merged":[[0,0,0,3],[1,0,1,2],[2,10,2,16],[7,10,7,16],[10,10,10,16],[33,10,33,16],[45,10,45,16],[56,10,56,16],[71,4,71,16],[79,4,79,16]]}
["Annexture A"]
["Item",null,null," Task Description","July","August","September","October","November","December","January","February","March","April","May","June","July"]
[1,null,null,"Project Management "]
[null,"a.",null,"Assist municipality to setup project steering committee"]
[null,"b.",null,"conduct monthly progress reports. "]
[null,"c.",null,"Make resource available for on-site support(site Manager) -one week per month and then two weeks per month (june, july, August)"]
[null,"d.",null,"Submit Closure report at end of july each year"]
[2,null,null,"Mobile Mapping (Key Resource – Surveyor)"]
[null,"a.",null,"Conduct a 3D survey of the road reserves and municipal infrastructure sites"]
[null,"b.",null,"Supply 360 degree photographs every 4 meters of line of travel in PlanetGIS forma"]
[3,null,null,"Geographic Information System in Planet GIS format (as currently used by Municipal entity) "]
[null,"a.",null,"Gather electronic GIS data and compile base map"]
[null,null,"i.","Compile all available aerial photography for the municipal area"]
[null,null,"ii."," Acquire a full deeds dump of all properties in municipal jurisdiction area"]
[null,null,"iii.","Create an up-to-date cadastral map and deeds map – reconcile all deeds properties with map information"]
[null,null,"iv.","Land use and zonings map"]
[null,null,"v.","Linking water and electricity consumption detail per property"]
[null,null,"vi.","Linking existing valuation roll"]
[null,null,"vii."," Map existing fixed asset register (from supplied GIS data, alternatively plotting coordinates from existing asset register)"]
[null,null,"viii.","Import and display 360 degree photographs as a separate layer in the GIS* (see note 7 below)"]
[null,"b.",null," Gather non-electronic Infrastructure map data"]
[null,null,"i.","Scan, rectify and present infrastructure as-built plans"]
[null,null,"ii.","Digitise information into GIS"]
[null,"c.",null,"Analyze data received and supply discrepancy reports"]
[null,null,"i.","Cadastral and deeds map – properties not registered"]
[null,null,"ii.","Water and electricity consumption – properties without services"]
[null,null,"iii.","Valuation roll – properties not listed in roll"]
[null,null,"iv.","Asset register – identify areas without municipal services (water, electricity, sewer, roads)"]
[null,"d.",null,"Conduct workshop or work session with municipal staff"]
[null,null,"i.","Presentation status quo and discrepancy reports"]
[null,null,"ii.","Identify gaps"]
[null,"e.",null,"Gather additional information"]
[null,null,"i."," Allocate responsibilities for acquiring additional information"]
[4,null,null,"Field Survey and Verifying of  Fixed Assets "]
[null,"a.",null,"Document condition assessment assumptions"]
[null,"b.",null,"Electrical Infrastructure"]
[null,null,"i.","Extract all visible infrastructure data from 3D mobile mapping and capture as the correct components in the register"]
[null,"c.",null,"Electricity facilities"]
[null,null,"i.","Field Survey and componentise utilizing an electronic Data Logger"]
[null,"d.",null,"Water facilities"]
[null,null,"i.","Field Survey and componentise utilizing an electronic Data Logger"]
[null,"e.",null,"Sewer facilities"]
[null,null,"i.","Field Survey and componentise utilizing an electronic Data Logger"]
[null,"f.",null,"Other facilities"]
[null,null,"i.","Field Survey and componentise utilizing an electronic Data Logger"]
[5,null,null,"Capital Projects "]
[null,null,"i.","Gather all source documentation"]
[null,null,"ii.","Reconcile with General ledger and source documentation"]
[null,null,"iii.","Componntise(ubundle based on source documentation and final bill of quantities"]
[null,null,"iv.","Field survey and geo-tag componentised items to confirm existence"]
[null,null,"v.","Update WIP schedule with projects cost per year"]
[null,"b.",null,"Donated projects"]
[null,null,"i.","Gather all source documentation"]
[null,null,"ii.","Reconcile with General ledger and source documentation"]
[null,null,"iii.","Componentize based on available source documentation in accordance with policy"]
[null,null,"iv.","Survey componentized items"]
[6,null,null,"Land and Building Registers"]
[null,"a.",null,"Gather all source documentation relevant to the Property Portfolio"]
[null,"b.",null,"Update deeds data of municipal owned properties as at 30 June each year"]
[null,"c.",null,"Obtain council minutes of meetings relating to properties to identify intention of council relating to the properties"]
[null,"d.",null,"Compare Contract Register with Property Portfolio"]
[null,"e.",null,"Identify transfers in the past year and current year"]
[null,"f.",null,"Identify additions in the past year and current year"]
[null,"g.",null,"Survey and verify municipal entity properties"]
[null,"h.",null,"Categorize properties - Investment, Inventory or Land/Buildings (PPE)"]
[null,"i.",null,"Perform professional valuation of all municipal entity properties as per take-on date"]
[null,"j.",null,"Perform fair value adjustment on investment properties"]
[null,"k.",null,"Conduct Workshop an present anomalies to municipal entity"]
[null,"l.",null,"Conclude actions on properties and sign-off by municipal entity"]
[null,"m.",null,"Document factors taken into account in determination of classification of properties and prepare required disclosure"]
[null,"n.",null,"Prepare the required disclosures relating to maintenance and rental income earned for investment properties"]
[7,null,null,"Financial calculation and reconciliation "]
[null,"a.",null,"Perform Current Replacement Cost (CRC) calculation of assets"]
[null,"b.",null,"Perform Depreciated Replacement Cost (DRC) calculation of assets"]
[null,"c.",null,"Perform depreciation calculation of assets"]
[null,"d.",null,"Perform remaining useful life adjustments for identified assets (documentation of assumptions and factors)"]
[null,"e.",null,"Perform impairment adjustments for identified assets (documentation of assumptions and factors)"]
[null,"f.",null,"Prepare all assets related notes in the AFS"]
[null,"g.",null,"Prepare appendix B & C as per the prescribed Annual Financial Statements format"]
[8,null,null,"Audit support "]
[null,"a.",null,"Prepare methodology documentation and present to Auditor General"]
[null,"b.",null,"Prepare audit file"]
[null,"c.",null,"Attend Audit Committee Meetings where requested"]
[null,"d.",null,"Assist with register to floor exercise of Auditor General"]
[null,"e.",null,"Assist with floor to register exercise of Auditor General"]
[null,"f.",null,"Propose adjustment to the assets management policy where required"]
[null,"g.",null,"Communication of audit finding responses (Resolve the findings raised both current and prior year)"]
[9,null,null,"Supply Final Register "]
[null,"a.",null,"Supply a Draft Asset Register by 1st August each year – export into MS Exel format with no formulas"]
[null,"b.",null,"Supply the Final Register with changes by 15th of August each year – signed off by the CFO"]

{"sheet":"Project Teams","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"hidden":true}
[]
[]
[null,"Resource","Hourly Rate","Rate/day"]
[null,"Project Director ",2300,{"$f":"C4*0.5","v":1150}]
[null,"Project Manager",1800,{"$f":"C5*0.5","v":900}]
[null,"Senior Engineer",1600,800]
[null,"Engineer",650,325]
[null,"Field Assessor (FA)",600,300]
[null,"Data Analyst (DA)",500,250]
[null,"GIS ",800,400]
[null,"Valuer",800,400]
[null,"Accountant ",1100,550]