{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Instructions to PM-don't print","Instructions","Compliance with TOR Checklist","Company Exp","Proposed Team","Team detail exp"],"not_rendered":{"images":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Instructions to PM-don't print","index":0,"n_rows":10,"n_cols":1,"rows_kept":10,"merged":[[7,0,7,9],[8,0,8,9],[9,0,9,9]]}
{"$rows_empty":7}
["INSTRUCTIONS FOR PROJECT MANAGERS - do not print as part of bid"]
["Complete red only"]
["See comments on spreadsheet to assist compiling"]

{"sheet":"Instructions","index":1,"n_rows":21,"n_cols":3,"rows_kept":21,"merged":[[7,0,7,10],[8,2,8,10],[10,0,10,10],[11,0,11,10],[13,0,13,10],[14,0,14,10],[15,0,15,10],[17,0,17,10],[18,0,18,10],[19,0,19,10],[20,0,20,10],[21,0,21,10]]}
{"$rows_empty":7}
["ANNEXURE D: INSTRUCTIONS"]
["DOT/10/2026/IPT",null,"Terms of Reference (TOR) for the appointment of a service provider/consultant to provide technical support to the Department and monitor Integrated Public Transport Networks (IPTNs) in the Cluster A municipalities of Cape Town, George and Nelson Mandela Bay for a period of 36 months"]
[]
["1.  STRUCTURE OF THE TENDER"]
["This spreadsheet  contains the compliance with the TOR checklist, company, project leader and project team experience submission templates for the bid. "]
[]
["2.  GENERAL INSTRUCTIONS FOR COMPLETING THE PRICING SCHEDULE TEMPLATES"]
["2.1  Tender submission format"]
["2.1.1 Bidders must submit  a paper copy and a protected electronic copy of Annexure D.\n         In the event of a discrepancy, the paper copy will prevail."]
["2.1.2 Bidders must complete all schedules"]
["2.1.3 Bidders must sign all paper copies of their Annexure D."]
["2.2  Input spreadsheets"]
["2.2.1 Annexure D templates are contained within the one (1) Excel Workbook"]
["2.2.2 Bidders may make changes as agreed, to the spreadsheets."]

{"sheet":"Compliance with TOR Checklist","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,1,0,4]]}
[{"$f":"Instructions!A9","v":"DOT/10/2026/IPT"},{"$f":"Instructions!C9","v":"Terms of Reference (TOR) for the appointment of a service provider/consultant to provide technical support to the Department and monitor Integrated Public Transport Networks (IPTNs) in the Cluster A municipalities of Cape Town, George and Nelson Mandela Bay for a period of 36 months"}]
[]
["NR","DELIVERABLE","SCOPE/ACTIVITIES","NARRATION / COMPLIANCE SUPPLEMENTS","COMPLIANCE STATUS (YES/NO)","EVIDENCE REFERENCE"]
[1,"Prepare an inception report","•\tDevelop project plan\n•\tPresent to EXCO\n•\tConsult Organised Labour\n•\tSchedule/document engagements","•\tMust include methodology, stakeholder map, compliance checklist, and governance framework. \n•\tEvidence: minutes, registers. \n•\tPerformance milestone: payment tied to inception completion."]
[2,"Develop an integrated fit‑for‑purpose organisational structure (macro and micro)","•\tDesign macro/micro structures\n•\tDevelop three possible options\n•\tFinalise and present final structure\n•\tEnsure DPSA compliance<\n•\tPrepare Risk Management Plan","•\tFinal structure must be DPSA aligned and supported by consultation evidence. \n•\tRisk plan must show mitigation strategies (legal, financial, operational). \n•\tQuality assurance review required."]
[3,"Develop a service delivery model (SDM)","•\tConsider National Office and Entities\n•\tConsult branches\n•\tConsolidate and prepare SDM","•\tMust demonstrate operational efficiency and effectiveness, aligned to developmental state practices. \n•\tEvidence of stakeholder engagement required"]
[4,"Map business processes and develop Standard Operating Procedures (SOPs)","•\tMap functions across 5 levels\n•\tDevelop SOPs\n•\tEngage branches","•\tMust cover Level 1: Enterprise Process Landscape, Level 2: End to End Processes, Level 3: Sub-Processes, Level 4: Activities (Swimlane Processes and Level 5: Procedures and System Processes. \n•\tSOPs aligned to strategic mandate and embedded in workflow tools (HRIS/ERP). \n•\tKnowledge transfer required."]
[5,"Develop and review job descriptions","•\tDraft/update job descriptions\n•\tInclude new jobs","•\tMust ensure clarity of responsibilities and alignment with organisational structure. \n•\tIndependent validation required."]
[6,"Conduct job evaluation and provide report","•\tEvaluate all posts\n•\tPresent results to panel","•\tMust provide scientific evaluation with JE results, aligned to DPSA grading standards. \n•\tIndependent validation required."]
[7,"Prepare a business case / management services report","•\tDetermine posts\n•\tConduct work measurement\n•\tSubmit report","•\tMust include determination of posts, analysis of work measurement outcomes, managerial workload justification. \n•\tSubmitted in booklet + digital format. \n•\tEvidence of consultation required."]
[8,"Develop and implement a communication plan and strategy","•\tDraft plan\n•\tIssue circulars/posters\n•\tSchedule engagements\n•\tProvide reporting","•\tMust include communiqués, flyers, posters, and evidence of staff engagement. \n•\tMonthly reporting schedule required."]
[9,"Develop and implement a change management plan and interventions","•\tDraft strategy\n•\tImplement interventions\n•\tConduct capacity building workshops","•\tMust address organisational culture, readiness for change, and roll out support. \n•\tProof of workshops delivered and readiness assessments required."]
[10,"Produce a costed organisational structure","•\tCost funded posts\n•\tAlign with budget/MTEF\n•\tProduce report","•\tMust use DPSA Costing Model and demonstrate affordability within MTEF. \n•\tIndependent validation required."]
[11,"Prepare and deliver presentations to stakeholders","•\tDevelop presentations\n•\tPresent to EXCO, MINEXCO, Labour","•\tMust include structure design process, options, and final proposal. \n•\tEvidence: slide decks and minutes."]
[12,"Develop three possible options for DXA trading account structure","•\tDraft three DXA options<\n•\tPresent to stakeholders","•\tMust provide comparative analysis of DXA options."]
[13,"Submit proposed organisational structure and business case for approval","•\tPresent drafts\n•\tConsult Minister of Transport\n•\tObtain concurrence from MPSA\n•\tSubmit final structure","•\tMust comply with DPSA checklist and Ministerial concurrence requirements. \n•\tEvidence: signed approvals. "]
[14,"Develop a migration strategy and implement process","•\tDraft migration strategy\n•\tConduct matching/placing\n•\tSupport staff transition","•\tMust include detailed placement plan and staff transition support. \n•\tPost implementation advisory support required (3–6 months)."]
[15,"Prepare a close‑out report","•\tSummarise outcomes\n•\tDocument lessons learned\n•\tProvide sustainability recommendations","•\tMust include monitoring & evaluation framework, KPIs, and recommendations for ongoing performance. \n•\tKnowledge transfer required. "]

{"sheet":"Company Exp","index":3,"n_rows":15,"n_cols":6,"rows_kept":15,"merged":[[0,2,0,5],[2,0,2,5],[14,0,17,0]]}
[{"$f":"Instructions!A9","v":"DOT/10/2026/IPT"},null,{"$f":"Instructions!C9","v":"Terms of Reference (TOR) for the appointment of a service provider/consultant to provide technical support to the Department and monitor Integrated Public Transport Networks (IPTNs) in the Cluster A municipalities of Cape Town, George and Nelson Mandela Bay for a period of 36 months"}]
[]
["Annexure D1: Company Experience"]
["NUMBER OF PROJECTS COMPLETED","PROJECT  1","PROJECT 2","PROJECT 3","PROJECT 4","PROJECT 5"]
["PROJECT DETAILS"]
["PROJECT NAME"]
["DURATION"]
["SUCCESSFUL COMPLETION (Y/N)"]
["SUMMARY/DESCRIPTION OF PROJECT"]
["SCOPE OF PROJECT"]
["PROOF TO SUPPORT  (Y/N)"]
[]
[]
["Bidder signature"]
["Signature"]

{"sheet":"Proposed Team","index":4,"n_rows":23,"n_cols":5,"rows_kept":23,"merged":[[0,2,0,4],[2,0,2,4],[21,2,25,3],[22,1,25,1]]}
[{"$f":"Instructions!A9","v":"DOT/10/2026/IPT"},null,{"$f":"Instructions!C9","v":"Terms of Reference (TOR) for the appointment of a service provider/consultant to provide technical support to the Department and monitor Integrated Public Transport Networks (IPTNs) in the Cluster A municipalities of Cape Town, George and Nelson Mandela Bay for a period of 36 months"}]
[]
["Annexure D2: Proposed Team"]
["#","Name of team member","Role (As specified in Tor)","Qualifications (list)","Years Exp"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[]
[]
[null,"Bidder signature","Enter the details of the  team members allocated to executing the required deliverables. Attach certified copies of qualifications to bid.  "]
[null,"Signature"]

{"sheet":"Team detail exp","index":5,"n_rows":38,"n_cols":5,"rows_kept":38,"merged":[[0,1,0,4],[2,0,2,4],[36,3,40,4],[37,0,40,0]]}
[{"$f":"Instructions!A9","v":"DOT/10/2026/IPT"},{"$f":"Instructions!C9","v":"Terms of Reference (TOR) for the appointment of a service provider/consultant to provide technical support to the Department and monitor Integrated Public Transport Networks (IPTNs) in the Cluster A municipalities of Cape Town, George and Nelson Mandela Bay for a period of 36 months"}]
[]
["Annexure D3: Summary of past experience of team members"]
["Name of team member","Project","Client name (attach details of contact persons)","Project Start","Project end"]
{"$rows_empty":32}
["Bidder signature",null,null,"Attach verifiable / contactable references to bid"]
["Signature"]