{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Cover & Assumptions","4-Year TCO Summary","Implementation Costs","Software Licenses","Hosting Costs","Support & Maintenance","Escalation & Payment","Declaration"],"read":"whole","date_system":"1900"}

{"sheet":"Cover & Assumptions","index":0,"n_rows":23,"n_cols":1,"rows_kept":23}
["COMPANY DETAILS"]
["Bidder Name:"]
["Contact Person:"]
["Contact Number: "]
["Email:"]
["Date:"]
["User information"]
["total number of permanent employees: 85"]
["total number of temporary employees: 25"]
["total number of temporary employees (offsight): 10"]
["total number of SDF's: 1,638 - not all are actively using the system"]
[]
["ASSUMPTIONS & CLARIFICATIONS:"]
["[Please state ALL assumptions that underpin your pricing. This includes but is not limited to:]"]
["1. Number of internal FoodBev SETA users assumed: __100____"]
["2. Number of external stakeholder users (employers/providers) assumed: ______"]
["3. Implementation timeline assumed (months): ______"]
["4. Data migration scope assumed: [Describe what is included]"]
["5. Training scope assumed: [Describe what is included]"]
["6. Any exclusions from pricing: [List explicitly]"]
["7. Assumed annual escalation rate for Year 2-5: ______%"]
["8. Solution type: ☐ Custom Build ☐ COTS (Commercial Off-The-Shelf) ☐ Hybrid"]
["9. Hosting location: ☐ South Africa ☐ Other (Specify): ________"]

{"sheet":"4-Year TCO Summary","index":1,"n_rows":13,"n_cols":6,"rows_kept":13}
["COST CATEGORY","YEAR 1","YEAR 2","YEAR 3","YEAR 4","4-YEAR TOTAL"]
["A. Implementation & Project Costs"]
["B. Software Licenses"]
["C. Hosting & Infrastructure"]
["D. Support & Maintenance"]
["E. Contingency (if applicable)"]
["F. Enhancements Development (Retainer)"]
["GRAND TOTAL",{"$f":"SUM(B2:B6)","v":0},0,0,0,0]
[]
[]
["NOTES:"]
["Implementation (A) is typically one-time in year 1."]
["All Year 2-4 amounts should reflect proposed annual escalation(if any)"]

{"sheet":"Implementation Costs","index":2,"n_rows":49,"n_cols":5,"rows_kept":49}
["PHASE/ACTIVITY","RESOURCE ROLE","DAY RATE","NO. OF DAYS","SUBTOTAL"]
["Discovery & Requirements","Project manager"]
[null,"Business Analyst"]
[null,"Solution Architect"]
[null,"Process Engineer"]
["SUBTOTAL - Discovery"]
[]
["DESIGN & CONFIGURATION           ","Lead Functional Consultant  "]
[null,"Technical Lead              "]
[null,"Database Architect          "]
[null,"Solution Architect"]
["SUBTOTAL - DESIGN                "]
[]
["DEVELOPMENT & CUSTOMIZATION      ","Senior Developer            "]
[null,"Developer            "]
[null,"Data Specialist"]
[]
["SUBTOTAL - DEVELOPMENT           "]
[]
["DATA MIGRATION                   ","Data Migration Specialist   "]
[]
["SUBTOTAL - MIGRATION             "]
[]
["TESTING & UAT                    ","Test Manager                "]
[null,"UAT Coordinator             "]
["SUBTOTAL - TESTING               "]
[]
["TRAINING & DEPLOYMENT            ","Training Specialist         "]
[null,"Change Manager"]
[null,"Go-Live Support             "]
["TOTAL TRAINING /DEPLOY"]
[]
["PROJECT MANAGEMENT","Project manager(ongoing)"]
[]
["TOTAL -PROJECT MGMT"]
[]
["TOTAL IMPLEMENTATION COST ",{"$nulls":3},{"$f":"SUM(E6+E12+E18+E22+E26+E31+E35)","v":0}]
[]
[]
[]
["Additional fixed costs"]
["DESCRIPTION ","AMOUNT (ZAR)","NOTES"]
["Travel & Accommodation           "]
["Third-party Tools/Licenses       "]
["Contingency (recommended 10-15%) "]
[]
["TOTAL ADDITIONAL COSTS           "]
[]
["GRAND TOTAL IMPLEMENTATION (Links to Sheet 2, Cell B3) "]

{"sheet":"Software Licenses","index":3,"n_rows":10,"n_cols":9,"rows_kept":10}
["MODULE/CAPABILITY","PRICING METRIC ","QTY","ANNUAL FEE PER UNIT","YEAR 1","ESCALATIONS% pa","YEAR 2","YEAR 3","YEAR 4"]
["Core License","per internal user/Month"]
["External Portal License","Per Module/Annual"]
["Business Intelligence(BI) Module","Per user/Annual"]
["Mobile Application Process","Per Module/Annual"]
["Advanced Analytics","Per Module/Annual"]
["AI/ML Capabilities","Per Cpnnection/Annual"]
["Integration Middleware"]
[]
["ANNUAL TOTALS ",{"$nulls":3},{"$f":"SUM(E2:E8)","v":0},null,{"$f":"SUM(G2:G8)","v":0},{"$f":"SUM(H2:H8)","v":0},{"$f":"SUM(I2:I9)","v":0}]

{"sheet":"Hosting Costs","index":4,"n_rows":14,"n_cols":8,"rows_kept":14}
["COMPONENT","SPECIFICATION","MONTHLY COST","YEAR1","ESCALATIONS% pa","YEAR 2","YEAR 3","YEAR 4"]
["Cloud Server Infrastructure","e.g 8vCPU, 32GB RAM"]
["Database Hosting","e.g SQL Enterprose"]
["Storage","e.g 1TB"]
["Backup & Disaster Recovery"]
["Bandwidth/Data Transfer"]
["Security( Firewall, WAF etc"]
["Monitoring and Management"]
[]
["ANNUAL TOTALS",null,null,{"$f":"SUM(D2:D8)","v":0},null,{"$f":"SUM(F2:F8)","v":0},{"$f":"SUM(G2:G9)","v":0},{"$f":"SUM(H2:H9)","v":0}]
[]
[]
["if Not hostiong , state \"Hosting to be provided by FoodBev SETA or Separate arrangement\" "]
["these totals automatically flows to sheet 2 , Row 5 (Hosting) "]

{"sheet":"Support & Maintenance","index":5,"n_rows":15,"n_cols":6,"rows_kept":15}
["SERVICE","HOURS/MONTH","COST/EXTRA PER HOUR","RESPONSE TIME","RESOLUTION  TIME SLA","ANNUAL RETAINER COST"]
["Priority 1 (critical - System Down)"]
["Priority 2 (High- Major Impact)"]
["Priority 3 (Medium)"]
["Priority 4 ( Low/Enhancement)"]
[]
["ANNUAL SUPPORT RETAINER TOTAL"]
[]
["DEVELOPMENT/ ENHANCEMENT HOURS"]
["Annual Pool of Included Hours"]
["Rates for additional Hours"]
[]
["ANNUAL ENHANCEMENT COST"]
[]
["TOTAL ANNUAL SUPPORT & MAITANANCE  ",{"$nulls":4},{"$f":"SUM(F7+F13)","v":0}]

{"sheet":"Escalation & Payment","index":6,"n_rows":10,"n_cols":2,"rows_kept":10}
["ITEM","RATE per annum"]
["Software Licenses"]
["Hosting Services"]
["Support & Maintenance"]
["Professional Services (if applicable)"]
[]
["Payment Terms Proposed:                                  (Describe your proposed payment schedule e.g)"]
["Implementation : 30% on contract signing , 40% on completion of build , 30% on go-live acceptance"]
["Annual Licences &Support:Quarterly in advence"]
["Additional Hours : Monthly in arrears upon invoice"]

{"sheet":"Declaration","index":7,"n_rows":12,"n_cols":1,"rows_kept":12}
["I/We, the undersigned, hereby declare that:"]
["1. The pricing submitted in this template is complete, accurate, and inclusive of all costs."]
["2. We understand that this pricing will form part of any resultant contract."]
["3. We will hold these prices valid for 120 days from the bid closing date."]
["4. All amounts are in ZAR, inclusive of VAT."]
[]
["Authorised Signatory: _________________________"]
["Full Name: ____________________________________"]
["Position: _____________________________________"]
["Company: _____________________________________"]
["Date: ________________________________________"]
["Company Stamp: ________________________________"]