{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Title Sheet","PSTP Financial Table","Tech Specialist Fin Table"],"not_rendered":{"defined_names":3,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Title Sheet","index":0,"n_rows":12,"n_cols":1,"rows_kept":12,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[4,0,4,9],[5,0,5,9],[6,0,6,9],[7,0,7,9],[8,0,8,9],[9,0,9,9],[10,0,10,9],[11,0,11,9]]}
["Western Cape Mobility Department"]
["MT03/2026: Provincial Sustainable Transport Programme"]
[]
[]
[]
["Annexure 2: Professional Services Pricing Schedule"]
[]
["The associated sheets named PSTP Financial Table and Tech Specialist Fin Table MUST be fully completed as part of the bidders tender return. Click the worksheet tabs below to access."]
[]
["Please Note: This document is protected and only the rate flields highlighted in GREEN are accessible for providing pricing. All quantities are hard-coded and cannot be changed. Totals are auto-calculated. VERY IMPORTANT: All calculated totals in YELLOW MUST be carried to Schedule C1: Pricing Summary in the hardcopy bid document, and the total bid offer from there to Schedule A1: WCBD1 Bid Form"]
[]
["IMPORTANT: A digital copy of this Excel workbook MUST be included on removable digital media in the bid submission. As a backup safety measure, it is advised to also email this file to Mobility Supply Chain Management (SCM) on the day of bid closing. Address the email to Karin.Kock@westerncape.gov.za "]

{"sheet":"PSTP Financial Table","index":1,"n_rows":131,"n_cols":7,"rows_kept":131,"merged":[[0,2,0,6],[2,3,38,3],[2,4,2,6],[39,2,39,5],[40,2,40,6],[42,3,78,3],[42,4,42,6],[79,2,79,5],[80,2,80,6],[83,3,93,3],[94,2,94,5],[95,2,95,6],[97,3,102,3],[103,2,103,5],[104,2,104,6],[106,3,113,3],[114,2,114,5],[115,2,115,6],[116,2,116,5],[117,2,117,5],[118,2,118,5],[119,2,119,5],[120,2,120,6],[121,2,121,6],[122,3,122,6],[123,3,123,6],[124,3,124,6],[125,3,125,6],[126,3,126,6],[127,3,127,6],[128,3,128,6],[129,3,129,6],[130,3,130,6]]}
[null,null,"MT03/2026 PTSP FINANCIAL TABLE (Part 1)"]
[null,null,"Category A","Description","Illustrative Hours","Rate","Price"]
[null,null,"Core roles","minimum 15 years relevant experience, recognised national or international as an expert in their field, directing and leading project and assignment, and with a relevant advanced degree"]
[null,null,"Business and strategic lead",null,2904,{"v":0,"d":"R0.00"},{"$f":"E4*F4","v":{"v":0,"d":"R0.00"}}]
[null,null,"Financial and funding lead",null,2904,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Strategic transport planning and operations lead",null,2904,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Institutional lead",null,2904,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Legal and contractual lead",null,2904,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Corporate governance lead",null,2904,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Financial structuring and private sector participation lead",null,2904,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Project manager",null,2904,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Specialist roles"]
[null,null,"Additional project manager",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Public transport business planning specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Public transport policy specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Bus, minibus taxi and learnter transport planning specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Financial modelling specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Public transport project finance structuring specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Payment systems specialist (with banking interface)",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Public transport fiscal and funding specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Strategic technology and systems specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Business parameters and business rules specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Rail business strategy specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Freight business strategy specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Urban development policy and finance specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Urban planning and design specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Public sector strategy specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Disaster risk management specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Organisational development specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Transport legalisation and public law specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Contracts specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Transport economist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Additional resources as/when required"]
[null,null,"Project manager",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Business/finance/institutional/strategy",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Legal",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Technical/ operational/ planning",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Transport systems and technology",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Auxiliary",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"TOTAL Category A",{"$nulls":3},{"$f":"SUM(G4:G39)","v":{"v":0,"d":"R0.00"}}]
[]
[null,null,"Category B","Description","Illustrative Hours","Rate","Price"]
[null,null,"Core roles","minimum 10 years relevant experience, recognised as an expert with a high level of expertise, leading tasks or projects on the assignment, and relevant advanced degree"]
[null,null,"Business and strategic lead",null,2904,{"v":0,"d":"R0.00"},{"$f":"E44*F44","v":{"v":0,"d":"R0.00"}}]
[null,null,"Financial and funding lead",null,2904,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Strategic transport planning and operations lead",null,2904,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Institutional lead",null,2904,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Legal and contractual lead",null,2904,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Corporate governance lead",null,2904,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Financial structuring and private sector participation lead",null,2904,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Project manager",null,2904,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Specialist roles"]
[null,null,"Additional project manager",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Public transport business planning specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Public transport policy specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Bus, minibus taxi and learnter transport planning specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Financial modelling specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Public transport project finance structuring specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Payment systems specialist (with banking interface)",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Public transport fiscal and funding specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Strategic technology and systems specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Business parameters and business rules specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Rail business strategy specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Freight business strategy specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Urban development policy and finance specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Urban planning and design specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Public sector strategy specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Disaster risk management specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Organisational development specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Transport legalisation and public law specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Contracts specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Transport economist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Additional resources as/when required"]
[null,null,"Project manager",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Business/finance/institutional/strategy",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Legal",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Technical/ operational/ planning",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Transport systems and technology",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Auxiliary",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"TOTAL Category B",{"$nulls":3},{"$f":"SUM(G44:G79)","v":{"v":0,"d":"R0.00"}}]
[]
[null,null,"Category C","Description","Illustrative Hours","Rate","Price"]
[null,null,"Specialist roles"]
[null,null,"Public transport project finance structuring specialist","minimum 5 years relevant experience, delivering tasks and technical analysis on the assignment, and with relevant qualification",704,{"v":0,"d":"R0.00"},{"$f":"E84*F84","v":{"v":0,"d":"R0.00"}}]
[null,null,"Payment systems specialist (with banking interface)",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Public sector strategy specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Organisational development specialist",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Additional resources as/when required"]
[null,null,"Project manager",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Business/finance/institutional/strategy",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Legal",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Technical/ operational/ planning",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Transport systems and technology",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Auxiliary",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"TOTAL Category C",{"$nulls":3},{"$f":"SUM(G84:G94)","v":{"v":0,"d":"R0.00"}}]
[]
[null,null,"Category D","Description","Illustrative Hours","Rate","Price"]
[null,null,"Project manager","minimum 1 year relevant experience, contributing to tasks and technical analysis on the assignment under the control of a Category A, B or C resource, and with a relevant qualification",704,{"v":0,"d":"R0.00"},{"$f":"E98*F98","v":{"v":0,"d":"R0.00"}}]
[null,null,"Business/finance/institutional/strategy",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Legal",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Technical/ operational/ planning",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Transport systems and technology",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Auxiliary",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"TOTAL Category D",{"$nulls":3},{"$f":"SUM(G98:G103)","v":{"v":0,"d":"R0.00"}}]
[]
[null,null,"Category E","Description","Illustrative Hours","Rate","Price"]
[null,null,"Administrative support","poviding administrative, project management or technical support functions under the control of a Category A, B, C or D resource and with a relevant qualification for the required support",2112,{"v":0,"d":"R0.00"},{"$f":"E107*F107","v":{"v":0,"d":"R0.00"}}]
[null,null,"Project management support",null,2112,{"v":0,"d":"R0.00"},{"$f":"E108*F108","v":{"v":0,"d":"R0.00"}}]
[null,null,"Data collection and surveys",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Technical planning/operations support and interns",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Business/finance/institutional/strategy support and interns",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Legal support",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Transport systems and technology support",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Auxiliary",null,704,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"TOTAL Category E",{"$nulls":3},{"$f":"SUM(G107:G114)","v":{"v":0,"d":"R0.00"}}]
[null,null,"IMPORTANT: All the amounts highlighted in YELLOW MUST be carried to Schedule C1: Pricing Summary in the hardcopy bid document"]
[null,null,"PART 1 Total Fees excl VAT",{"$nulls":3},{"$f":"SUM(G115,G104,G95,G80,G40)","v":{"v":0,"d":"R0.00"}}]
[null,null,"PART 1 Illustrative Disbursements",{"$nulls":3},{"v":12000000,"d":"R12,000,000.00"}]
[null,null,"PART 1 VAT @ 15%",{"$nulls":3},{"$f":"SUM(G117:G118)*15%","v":{"v":1800000,"d":"R1,800,000.00"}}]
[null,null,"PART 1 Total incl VAT",{"$nulls":3},{"$f":"SUM(G117:G119)","v":{"v":13800000,"d":"R13,800,000.00"}}]
[]
[null,null,"Resource Category Descriptions"]
[null,null,"Project manager","Resource with appropriate qualifications and experience for the designated category providing general project management services and other related services."]
[null,null,"Business/finance/institutional/strategy","Resource with appropriate qualifications and experience for the designated category, providing business, finance, institutional and policy or strategy services, including strategic project guidance, and other related services."]
[null,null,"Legal","Resource with appropriate qualifications and experience for the designated category, providing legally and contractually related services, and other related services."]
[null,null,"Technical/ operational/ planning","Resource with appropriate qualifications and experience for the designated category, providing technical, operational and planning services related to transport planning, engineering, transport operations, and other related services."]
[null,null,"Transport systems and technology","Resource with appropriate qualifications and experience for the designated category, providing services related to the design, development or implementation of systems and technology, and other related services."]
[null,null,"Auxiliary","Resource with appropriate qualifications and experience for the designated category, providing services required for the project not incorporated elsewhere."]
[null,null,"Administrative support","Resource with appropriate qualifications and experience for the designated category, providing project and other adminstrative support as required by the project, and related services."]
[null,null,"Project management support","Resource with appropriate qualifications and experience for the designated category, providing project management related support for the project, and other related services."]
[null,null,"Data collection and surveys","Resource with appropriate qualifications and experience for the designated category, providing on the ground support for data collection and surveys or other relevant field work or related services."]

{"sheet":"Tech Specialist Fin Table","index":2,"n_rows":28,"n_cols":7,"rows_kept":28,"merged":[[0,2,0,6],[3,2,3,5],[4,2,4,6],[6,3,7,3],[8,2,8,5],[9,2,9,6],[11,3,12,3],[13,2,13,5],[14,2,14,6],[17,2,17,5],[18,2,18,6],[21,2,21,5],[22,2,22,6],[23,2,23,5],[24,2,24,5],[25,2,25,5],[26,2,26,5],[27,2,27,5]]}
[null,null,"MT03/2026 PTSP TECH SPECIALIST FINANCIAL TABLE (Part 2)"]
[null,null,"Category A","Description","Illustrative Hours","Rate","Price"]
[null,null,"Team leader / Top technical resource","minimum 15 years relevant experience, recognised national or international as an expert in their field, directing and leading project and assignment, and with a relevant advanced degree or qualification unless the absence of the advanced degree or qualification can be motivated on the basis of exceptional experience",100,{"v":0,"d":"R0.00"},{"$f":"E3*F3","v":{"v":0,"d":"R0.00"}}]
[null,null,"TOTAL Category A",{"$nulls":3},{"$f":"SUM(G3:G3)","v":{"v":0,"d":"R0.00"}}]
[]
[null,null,"Category B","Description","Illustrative Hours","Rate","Price"]
[null,null,"Project manager","minimum 10 years relevant experience, recognised as an expert with a high level of expertise, leading tasks or projects on the assignment, and relevant advanced degree or qualification unless the absence of the advanced degree or qualification can be motivated on the basis of exceptional experience",100,{"v":0,"d":"R0.00"},{"$f":"E7*F7","v":{"v":0,"d":"R0.00"}}]
[null,null,"Team leader / Senior technical resource",null,100,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"TOTAL Category B",{"$nulls":3},{"$f":"SUM(G7:G8)","v":{"v":0,"d":"R0.00"}}]
[]
[null,null,"Category C","Description","Illustrative Hours","Rate","Price"]
[null,null,"Project management","minimum 5 years relevant experience, delivering tasks and technical analysis on the assignment, and with relevant qualification",100,{"v":0,"d":"R0.00"},{"$f":"E12*F12","v":{"v":0,"d":"R0.00"}}]
[null,null,"Mid-level technical resource",null,100,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"TOTAL Category C",{"$nulls":3},{"$f":"SUM(G12:G13)","v":{"v":0,"d":"R0.00"}}]
[]
[null,null,"Category D","Description","Illustrative Hours","Rate","Price"]
[null,null,"Junior technical resource","minimum 1 years relevant experience, contributing to tasks and technical analysis on the assignment under the control of a Category A, B or C resource, and with a relevant qualification",100,{"v":0,"d":"R0.00"},{"$f":"E17*F17","v":{"v":0,"d":"R0.00"}}]
[null,null,"TOTAL Category D",{"$nulls":3},{"$f":"SUM(G17:G17)","v":{"v":0,"d":"R0.00"}}]
[]
[null,null,"Category E","Description","Illustrative Hours","Rate","Price"]
[null,null,"Project technical support","providing administrative, project management or technical support functions under the control of a Category A, B, C or D resource and with a relevant qualification for the required support",100,{"v":0,"d":"R0.00"},{"$f":"E21*F21","v":{"v":0,"d":"R0.00"}}]
[null,null,"TOTAL Category E",{"$nulls":3},{"$f":"SUM(G21:G21)","v":{"v":0,"d":"R0.00"}}]
[null,null,"IMPORTANT: All the amounts highlighted in YELLOW MUST be carried to Schedule C1: Pricing Summary in the hardcopy bid document"]
[null,null,"PART 2 Total Fees excl VAT",{"$nulls":3},{"$f":"SUM(G22,G18,G14,G9,G4)","v":{"v":0,"d":"R0.00"}}]
[null,null,"PART 2 Illustrative Disbursements",{"$nulls":3},{"v":2000000,"d":"R2,000,000.00"}]
[null,null,"PART 2 VAT",{"$nulls":3},{"$f":"SUM(G24:G25)*15%","v":{"v":300000,"d":"R300,000.00"}}]
[null,null,"PART 2 Total incl VAT",{"$nulls":3},{"$f":"SUM(G24:G26)","v":{"v":2300000,"d":"R2,300,000.00"}}]
[null,null,"TOTAL PRICE OFFER PARTS 1 AND 2",{"$nulls":3},{"$f":"G27+'PSTP Financial Table'!G120","v":{"v":16100000,"d":"R16,100,000.00"}}]