{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["PRICING SCHEDULE","Disc Model & Pricing Principle","Base Component","Growth Component","Professional Services"],"not_rendered":{"images":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"PRICING SCHEDULE","index":0,"n_rows":38,"n_cols":16,"rows_kept":38,"merged":[[14,2,14,3],[15,2,15,3],[15,5,17,5],[16,2,16,3],[17,2,17,3],[19,4,19,6],[19,7,19,9],[19,10,19,12],[34,1,37,1],[34,2,34,3],[34,4,34,5],[35,2,35,3],[36,2,36,3],[36,4,36,5],[37,2,37,3],[37,4,37,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing Schedule"]
["RFB No","RFB-3192-2025"]
["RFB Title","REQUEST FOR THE ESTABLISHMENT OF A NEW 3 YEAR REPORT AND BI DASHBOARD CAPABILITY CONTRACT WITHIN SDM IT SERVICE MANAGEMENT FOR THE PROCUREMENT OF THE YELLOWFIN TECHNOLOGY."]
["Bidder Name "]
[]
["1. INSTRUCTION FOR COMPLETING THE PRICING SCHEDULE"]
["(a)  Bidder must complete the Disc Model and Pricing Principle, Base Component, Growth Component and Professional Services sheets and then confirm the values transferred correctly to the Pricing Schedule sheet"]
["(b)  Below is the total cost for 3 years (not committed)"]
["(c)  Bidder must complete/enter YELLOW cells only"]
["(d)  Unit and Line prices must be VAT EXCLUSIVE and in South African Rand (ZAR) currency"]
["(e) The price must include all cost to deliver the goods or render the service, including all applicable taxes, duty fees, logistics/delivery, storage, labour, overtime and subsistance and travel"]
["(f)  Prices that are dependent on Rate of Exchange (ROE) must use ROE indicated below, then enter in Column \"Forex %\" the percentage of the price that is ROE dependent (0% means the price is not ROE dependent)"]
[]
[null,"Foreign currency","South African Rand (ZAR) exchange rate "]
[null,"1 US Dollar",{"v":17.3,"d":"R17.30"},null,null,"Mark with an X, which ROE is applicable"]
[null,"1 Euro",{"v":22.67,"d":"R22.67"}]
[null,"1 Pound (UK)",{"v":19.96,"d":"R19.96"}]
[]
[{"$nulls":4},"YEAR 1",null,null,"YEAR 2",null,null,"YEAR 3",null,null,"TOTAL"]
["Item No","Goods/Service description","Unit of measure","Forex %","Qty Y1","Unit Price Y1\n(Excl VAT)","Line Price Y1","Qty Y2","Unit Price Y2\n(Excl VAT)","Line Price Y2","Qty Y3","Unit Price Y3\n(Excl VAT)","Line Price Y3","Line Price Term \n(Excl VAT)","Forex Price portion","Price clarification comment"]
[1,"Base Component",{"$nulls":4},{"$f":"SUBTOTAL(9, G23:G23)","v":0},null,null,{"$f":"SUBTOTAL(9, J23:J23)","v":0},null,null,{"$f":"SUBTOTAL(9, M23:M23)","v":0},{"$f":"SUBTOTAL(9, N23:N23)","v":0},{"$f":"SUBTOTAL(9, O23:O23)","v":0}]
["1.1","License Software: Name YellowFin, Version Newest, Type Subscription, Rate Type Concurrent,  Rate Period Yearly","each",{"$f":"'Base Component'!C12","v":{"v":0,"d":"0%"}},0,0,{"$f":"E23*F23","v":0},{"$f":"'Base Component'!J12","v":320},0,{"$f":"H23*I23","v":0},{"$f":"'Base Component'!J12","v":320},0,{"$f":"L23*K23","v":0},{"$f":"SUM(G23,J23,M23)","v":0},{"$f":"D23*N23","v":0}]
[2,"Growth Component",{"$nulls":4},{"$f":"SUBTOTAL(9, G25:G25)","v":0},null,null,{"$f":"SUBTOTAL(9, J25:J25)","v":0},null,null,{"$f":"SUBTOTAL(9, M25:M25)","v":0},{"$f":"SUBTOTAL(9, N25:N25)","v":0},{"$f":"SUBTOTAL(9, O25:O25)","v":0}]
["2.1","License Software: Name YellowFin,Type Subscription, Rate Type Concurrent,  Rate Period Yearly","each",{"$f":"'Growth Component'!C18","v":{"v":0,"d":"0%"}},0,0,{"$f":"E25*F25","v":0},{"$f":"'Growth Component'!H18","v":100},0,{"$f":"H25*I25","v":0},{"$f":"'Growth Component'!K18","v":150},0,{"$f":"L25*K25","v":0},{"$f":"SUM(G25,J25,M25)","v":0},{"$f":"D25*N25","v":0}]
[3,"Professional Services",{"$nulls":4},{"$f":"SUBTOTAL(9,G27:G27)","v":0},null,null,{"$f":"SUBTOTAL(9,J27:J27)","v":0},null,null,{"$f":"SUBTOTAL(9,M27:M27)","v":0},{"$f":"SUBTOTAL(9,N27:N27)","v":0},{"$f":"SUBTOTAL(9,O27:O27)","v":0}]
["3.1","Hire Consultant: Type Business Analyst, Speciality YellowFin, Rate Reriod Hourly (Functional Specialist, Technical Specialist)","hour",{"$f":"'Professional Services'!C27","v":{"v":0,"d":"0%"}},{"$f":"'Professional Services'!D27","v":4995},0,{"$f":"E27*F27","v":0},{"$f":"'Professional Services'!G27","v":4995},0,{"$f":"H27*I27","v":0},{"$f":"'Professional Services'!J27","v":4995},0,{"$f":"L27*K27","v":0},{"$f":"SUM(G27,J27,M27)","v":0},{"$f":"D27*N27","v":0}]
[4,"Implementation",{"$nulls":4},{"$f":"SUBTOTAL(9,G29:G29)","v":0},null,null,{"$f":"SUBTOTAL(9,J29:J29)","v":0},null,null,{"$f":"SUBTOTAL(9,M29:M29)","v":0},{"$f":"SUBTOTAL(9,N29:N29)","v":0},{"$f":"SUBTOTAL(9,O29:O29)","v":0}]
["4.1","Implement Software: Name YellowFin, Version Newest","each",{"v":0,"d":"0%"},1,0,{"$f":"E29*F29","v":0},null,0,{"$f":"H29*I29","v":0},null,0,{"$f":"K29*L29","v":0},{"$f":"SUM(G29,J29,M29)","v":0},{"$f":"D29*N29","v":0}]
[null,"TOTAL  BID PRICE (EXCL VAT)",{"$nulls":4},{"$f":"SUM(G22,G24,G26,G28)","v":0},null,null,{"$f":"SUM(J22,J24,J26,J28)","v":0},null,null,{"$f":"SUM(M22,M24,M26,M28)","v":0},{"$f":"SUM(N22,N24,N26,N28)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G30*0.15","v":0},null,null,{"$f":"J30*0.15","v":0},null,null,{"$f":"M30*0.15","v":0},{"$f":"N30*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"SUM(G30:G31)","v":0},null,null,{"$f":"SUM(J30:J31)","v":0},null,null,{"$f":"SUM(M30:M31)","v":0},{"$f":"SUM(N30:N31)","v":0}]
[]
[]
[null,"I, the bidder, confirm that the price(s) and rate(s) quoted cover all the goods and/or works specified in the bidding documents; that the price(s) or rate(s) cover all my obligations and I accept that any mistakes regarding price(s), rate(s) or calculations will be at my own risk.\n[Note: First convert to PDF, then add signature]"]
[null,null,"Name",null,"Capacity"]
[]
[null,null,"Signature (above)",null,"Date"]

{"sheet":"Disc Model & Pricing Principle","index":1,"n_rows":31,"n_cols":6,"rows_kept":31,"merged":[[0,0,0,3],[0,4,0,6],[1,0,1,3],[1,4,1,6],[2,0,2,6],[9,0,9,6],[10,0,10,6],[11,0,11,6],[12,0,12,6],[13,0,13,6],[14,0,14,6],[15,0,15,6],[16,0,16,6],[17,0,17,6],[18,0,18,6],[19,0,19,6],[20,0,20,6],[21,0,21,6],[22,0,22,6],[23,0,23,6],[24,0,24,6],[25,0,25,6]]}
["The growth component of this RFB includes possible customer taken on."]
["The following growth principles will apply to this contract:"]
["a)           There should be a tiered discount model that will cover growth requirements over the 3 years, as per the example below:"]
["Description","Year 1","Year 2","Year 3","Total Base","Price"]
["Initial base",null,320,null,320,"X-A"]
["Growth 1",null,100,null,420,"X-B"]
["Growth 2",null,null,150,570,"X-C"]
[]
["Tiered Discount Example"]
["b)          Growth will be projected for the purposes of developing a discount model. No upfront commitment will be made as all growth will be supported by a new client being onboarded."]
["c)           Discount model principles:"]
["     i)            Starting price = Market price = X"]
["     ii)           % discount = A-F"]
["               (1)         A = 0%"]
["               (2)         B = 50%"]
["               (3)         C = 55%"]
[]
["     iii)         Maximum discount based on volumes must be defined"]
["     iv)         Starting volume will be 320 licenses."]
["d)          The model will be based on Pay as you use (Buy as needed)."]
["e)           Additional license subscription will be prorated and paid upfront to the end of the contract."]
["f)            Start with the current base of deployed licenses with some capacity for flexibility."]
["g)           All licenses procured during the 3 year term will be co-termed for the 3-year contract period. (No licenses will be extended beyond the contract term)"]
["h)          Upon renewal of this contract only the new base will be renewed, and a new discount table will be negotiated."]
["i)            The actual subscription that will be paid per year will be based on the existing base at the time of subscription payment. "]
[]
["Complete tiered discount model"]
["#","Discount Level","Total Licences","% discount"]
[1,"A",320,{"v":0,"d":"0%"}]
[2,"B",350,{"v":0,"d":"0%"}]
[3,"C",400,{"v":0,"d":"0%"}]

{"sheet":"Base Component","index":2,"n_rows":12,"n_cols":14,"rows_kept":12,"merged":[[2,0,2,3],[3,0,3,3]]}
["Base Component:"]
[]
["a) The base component of this RFB is based on 320 concurrent licenses."]
["b) The inflation rate to be used for the calculations is 5,6%."]
[]
["Table 1: Base subscription 3 years (SITA use - committed)"]
[null,"License cost no Discount","No Licenses ","Year 1","Year 2","Year 3","Total","Projected discount"]
["Base licences per year:",null,320,320,320,320,320,{"$f":"'Disc Model & Pricing Principle'!D29","v":{"v":0,"d":"0%"}}]
[]
["Goods/Service description","Unit of measure","Forex %","Qty Y1","Unit Price Y1\n(Excl VAT)","Line Price Y1","Qty Y2","Unit Price Y2\n(Excl VAT)","Line Price Y2","Qty Y3","Unit Price Y3\n(Excl VAT)","Line Price Y3","Line Price Term \n(Excl VAT)","Forex Price portion"]
["Base Component",{"$nulls":4},{"$f":"SUBTOTAL(9, F12:F12)","v":0},null,null,{"$f":"SUBTOTAL(9, I12:I12)","v":0},null,null,{"$f":"SUBTOTAL(9, L12:L12)","v":0},{"$f":"SUBTOTAL(9, M12:M12)","v":0},{"$f":"SUBTOTAL(9, N12:N12)","v":0}]
["License Software: Name YellowFin, Version Newest, Type Subscription, Rate Type Concurrent,  Rate Period Yearly","each",{"v":0,"d":"0%"},320,{"$f":"B8-(B8*H8)","v":0},{"$f":"D12*E12","v":0},{"$f":"D12","v":320},{"$f":"E12*1.056","v":0},{"$f":"G12*H12","v":0},{"$f":"G12","v":320},{"$f":"H12*1.056","v":0},{"$f":"J12*K12","v":0},{"$f":"SUM(F12,I12,L12)","v":0},{"$f":"M12*C12","v":0}]

{"sheet":"Growth Component","index":3,"n_rows":25,"n_cols":15,"rows_kept":25,"merged":[[2,0,2,7],[3,0,3,7],[4,0,4,7],[7,0,7,9],[15,4,15,6],[15,7,15,9],[15,10,15,12],[15,14,16,14],[23,0,23,9],[24,0,24,9]]}
["Growth Component:"]
[]
["a) The growth component of this RFB includes possible customer taken on."]
["b) See the Disc Model and Pricing Principle sheet for the growth principles that will apply to this contract."]
["c) The inflation rate to be used for the calculations is 5,6%."]
[]
["Table 1: Subscription cost for 3 years"]
["Total Subscription cost over 3 years"]
[null,"License growth per year","Base","Year 1","Year 2","Year 3","Total","Projected discount"]
["Growth year 1",50,320,50,null,null,{"$f":"SUM(C10:F10)","v":370},{"$f":"'Disc Model & Pricing Principle'!D31","v":{"v":0,"d":"0%"}}]
["Growth year 2",50,null,null,50,null,{"$f":"SUM(C11:F11)+G10","v":420},{"$f":"'Disc Model & Pricing Principle'!D32","v":{"v":0,"d":"0%"}}]
["Growth year 3",50,{"$nulls":3},50,{"$f":"SUM(C12:F12)+G11","v":470},{"$f":"'Disc Model & Pricing Principle'!D33","v":{"v":0,"d":"0%"}}]
["Total",{"$f":"SUM(B10:B12)","v":150}]
["License cost no Discount",{"$f":"'Base Component'!B8","v":{"v":0,"d":"R0.00"}},null,{"$f":"B14","v":{"v":0,"d":"R0.00"}},{"$f":"D14*1.056","v":{"v":0,"d":"R0.00"}},{"$f":"E14*1.056","v":{"v":0,"d":"R0.00"}}]
[]
[{"$nulls":4},"YEAR 1",null,null,"YEAR 2",null,null,"YEAR 3",null,null,"TOTAL","Forex Price portion"]
["Goods/Service description","Unit of measure","Forex %","License growth per year","Qty Y1","Unit Price Y1\n(Excl VAT)","Line Price Y1","Qty Y2","Unit Price Y2\n(Excl VAT)","Line Price Y2","Qty Y3","Unit Price Y3\n(Excl VAT)","Line Price Y3","Line Price Term \n(Excl VAT)"]
["Growth licenses per year total","each",{"v":0,"d":"0%"},null,{"$f":"SUM(E19:E21)","v":50},{"$f":"F19","v":0},{"$f":"E18*F18","v":0},{"$f":"SUM(H19:H21)","v":100},{"$f":"I20","v":0},{"$f":"H18*I18","v":0},{"$f":"SUM(K19:K21)","v":150},{"$f":"L21","v":0},{"$f":"K18*L18","v":0},{"$f":"SUM(G18,J18,M18,)","v":0},{"$f":"C18*N18","v":0}]
["Growth year 1","each",{"$f":"C18","v":{"v":0,"d":"0%"}},{"$f":"D10","v":50},50,{"$f":"D14-(D14*H10)","v":0},{"$f":"E19*F19","v":0},null,null,{"$f":"H19*I19","v":0},null,null,{"$f":"K19*L19","v":0},{"$f":"SUM(G19,J19,M19,)","v":0},{"$f":"C19*N19","v":0}]
["Growth year 2","each",{"$f":"C19","v":{"v":0,"d":"0%"}},{"$f":"E11","v":50},null,null,0,{"$f":"D20+E19","v":100},{"$f":"E14-(E14*H11)","v":0},0,null,null,0,0,{"$f":"C20*N20","v":0}]
["Growth year 3","each",{"v":0,"d":"0%"},{"$f":"F12","v":50},null,null,0,null,null,0,{"$f":"D21+H20","v":150},{"$f":"F14-(F14*H12)","v":0},0,0,{"$f":"C21*N21","v":0}]
[]
["**Note: "]
["1. The base component is not included in the growth licences in order to keep the comitted and projected costs separate."]
["2. After award the actual subscription including base should be used to calculate discounts on the contract when operational."]

{"sheet":"Professional Services","index":4,"n_rows":27,"n_cols":14,"rows_kept":27,"merged":[[2,0,2,7],[3,0,3,7],[4,0,4,7],[5,0,5,7],[6,0,6,7],[7,0,7,7],[8,0,8,7],[9,0,9,7],[19,0,19,4],[23,3,23,5],[23,6,23,8],[23,9,23,11]]}
["Professional Services:"]
["The professional services required for this service must comply with the following:"]
["a)           Professional services will be requested, as and when needed."]
["b)          The service delivery resource must be available on-site within 8 hours of such a request (This excludes any potential travel to other offices outside of the three main Gauteng SITA offices)."]
["c)           Support hours may be carried over to the next year, or moved back from a future year to the present year, during the three years, according to workload requirements."]
["d)          The bidder must be able to provide 1665x3 = 4995 support hours per year for 3 years. (1665x3x3 = 14985 total hours)"]
["e)           SITA is not obligated to utilize the full 4995 hours per annum or over the 3 year term of the contract and utilization will be time sheet based."]
["f)            This is on-site professional services at the two main Gauteng SITA offices (Erasmuskloof and Centurion). This requirement is in addition to the support associated with the annual license subscription fees."]
["g)           A blended rate per hour must be used for calculating the professional services in Table 4. The bidder must determine own methodology to calculate blended rate."]
["h)          The inflation rate to be used for the calculations is 5,6%."]
[]
["Table 3: Professional Services"]
["Professional Services","Rate"]
["Business analyst",{"v":0,"d":"R0.00"}]
["Functional Specialist",{"v":0,"d":"R0.00"}]
["Technical Specialist",{"v":0,"d":"R0.00"}]
["Blended rate",{"$f":"AVERAGE(B14:B16)","v":{"v":0,"d":"R0.00"}}]
[]
["Table 4: Professional Services over 3 years"]
["Hourly rate over 3 years Including CPI"]
[null,"Cost per hour (Blended rate)","Cost year 1","Cost year 2","Cost year 3"]
["Professional services",{"$f":"B17","v":{"v":0,"d":"R0.00"}},{"$f":"B22","v":{"v":0,"d":"R0.00"}},{"$f":"C22*1.056","v":{"v":0,"d":"R0.00"}},{"$f":"D22*1.056","v":{"v":0,"d":"R0.00"}}]
[]
[{"$nulls":3},"YEAR 1",null,null,"YEAR 2",null,null,"YEAR 3",null,null,"TOTAL"]
["Goods/Service description","Unit of measure","Forex %","Qty Y1","Unit Price Y1\n(Excl VAT)","Line Price Y1","Qty Y2","Unit Price Y2\n(Excl VAT)","Line Price Y2","Qty Y3","Unit Price Y3\n(Excl VAT)","Line Price Y3","Line Price Term \n(Excl VAT)","Forex Price portion"]
["Professional Services",{"$nulls":4},{"$f":"SUBTOTAL(9,F27:F27)","v":0},null,null,{"$f":"SUBTOTAL(9,I27:I27)","v":0},null,null,{"$f":"SUBTOTAL(9,L27:L27)","v":0},{"$f":"SUBTOTAL(9,M27:M27)","v":0},{"$f":"SUBTOTAL(9,N27:N27)","v":0}]
["Professional services per year","Hour",{"v":0,"d":"0%"},4995,{"$f":"C22","v":0},{"$f":"D27*E27","v":0},4995,{"$f":"D22","v":0},{"$f":"G27*H27","v":0},4995,{"$f":"E22","v":0},{"$f":"J27*K27","v":0},{"$f":"SUM(F27,I27,L27,)","v":0},{"$f":"C27*M27","v":0}]