{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["PI Completion Guide","Project Implementation (PI)","SS Completion Guide","Software subscription","SME Completion Guide","SME Augmentation"],"read":"whole","date_system":"1900"}

{"sheet":"PI Completion Guide","index":0,"n_rows":57,"n_cols":8,"rows_kept":57}
["Project Implementation"]
[]
["The section provides a guideline for the completion of the pricing for the implementation of the project."]
[]
["Project resources"]
["1. The project resources includes the resources that will form part of the working committee to report on the progress of the project."]
["2. Example of the project resources are project manager, training manager, technical team lead, change manager etc. "]
["3. The number of resouces indicate how many of the resources listed will be required to execute the project. "]
["4. If a resource is needed to for a specific component of the solution the applicable software solution must be completed e.g. a change manager could be required for a specific software solution, if another change manager is required for a different software solution that resource should be listed on another line."]
["5. The rate per hour is the rate that will be charged for the specific resource. "]
["6. The hours required is the number of hours that the specific resource will be required per year and should be aligned to the flight plan e.g. the change manager will be required at the beginning of an iteration to provide guidance to TFR People Change and during the execution of the deployment of the solution."]
["7. The price for each year is the rate per hour multiplied by the number of hours per year for a specific resource. "]
["8. The total for 3 years is the sum of the price for each year. "]
[]
["The baseline working hours should be calculated as follow:"]
["Days in a year",{"$nulls":5},365]
["Subtract New Year's Day",{"$nulls":5},1]
["Start work say on Jan 10",{"$nulls":5},9,"Days; At least one weekend. 2 weekends if New Years day falls on Friday, Saturday, or Sunday"]
["Subract Reconciliation Day, Christmas, and Boxing day",{"$nulls":5},3]
["Stop work on Dec 15",{"$nulls":5},13,"Days (non-holiday) from Dec 16 t0 Dec 31; 2 weekends"]
["Subtract on average 6 other non-weekend holidays during the year",{"$nulls":5},6]
[]
["Working days: ",null,{"$f":"G16 - G17 - G18 - G19 - G20 - G21","v":333}]
["Less 49 weekends",null,{"$f":"C23 - 98","v":235}," "]
["Working Hours per year",null,{"$f":"C24 * 8.5","v":1997.5}]
[]
["Tecnical resources"]
["1. The technical resources includes the resources that will build the solution during execution."]
["2. Example of the technical resources are functional specialist, integration specialist, database specialist, technical specialist etc. "]
["3. The number of resouces indicate how many of the resources listed will be required to execute the project. "]
["4. If a resource is needed to for a specific component of the solution the applicable software solution must be completed e.g. a functional specialist could be required for a specific software solution, if another functional specialist is required for a different software solution that resource should be listed on another line."]
["5. The rate per hour is the rate that will be charged for the specific resource. "]
["6. The hours required is the number of hours that the specific resource will be required per year and should be aligned to the flight plan e.g. the functional specialist for the simulation will be required until all simulation scenarios are completed."]
["7. The price for each year is the rate per hour multiplied by the number of hours per year for a specific resource. "]
["8. The total for 3 years is the sum of the price for each year. "]
[]
["Stabilisation resources"]
["1. This section focus on the resources that will be required after implementation and deployment to provide hypercare during the 6 month stabilisation period.  "]
["2. The same rules as for project and technical resources will apply. "]
[]
["Software subscription during implementation"]
["1. Each proposed software solution must be listed on this section for pricing purposes. "]
["2.  The solutions must align with the proposed solution design presented in the architecture section."]
["3. The cost of licences for each user during implementation perio must be defined."]
["4. Where shared licenses are applicable the cost of shared licenses must be specified."]
["5. The number of licences required for the building and testing of the solution must be specified.  The number should include the TFR employees that should have access to the solution."]
["6. The year in which the licenses will be required must be indicated and aligned to the flight plan e.g. the simulation solution will commnece in year 1 and monitoring and execution solution build will commence in year 3"]
["7. The total price of the licenses per year is the sum of the number of users multiplied by either the cost of individual licenses or cost of shared licenses."]
["8. The total price is the sum of the licence prices for each year of imlenentation. "]
[]
["Training Material"]
["1. Each proposed software solution must be listed on this section for compilation of training material. "]
["2. The number of user roles will define the best practice roles for the solution e.g. Administrator, End user, user with view capabilities, navigation training."]
["3. The cost must include the development of the training material for all the roles in a hard copy and e-learning format."]
["4. The year in which the training material will be develop and completed must be aligned to the flight plan."]
["5. Price for each year will be based on the cost to compile training material in the specific year.   "]
["6. The total for the 3 years are the sum of the price for each individual software solution for year 1 to year 3. "]

{"sheet":"Project Implementation (PI)","index":1,"n_rows":47,"n_cols":14,"rows_kept":47,"merged":[[5,0,5,11],[23,1,23,11],[30,1,30,11],[31,2,31,3],[31,6,31,7],[31,8,31,9],[32,2,32,3],[32,6,32,7],[32,8,32,9],[33,2,33,3],[33,6,33,7],[33,8,33,9],[34,2,34,3],[34,6,34,7],[34,8,34,9],[35,2,35,3],[35,6,35,7],[35,8,35,9],[36,2,36,3],[36,6,36,7],[36,8,36,9],[37,2,37,3],[37,6,37,7],[37,8,37,9],[38,1,38,11],[39,4,39,5],[39,6,39,7],[39,8,39,9],[40,4,40,5],[40,6,40,7],[40,8,40,9],[41,4,41,5],[41,6,41,7],[41,8,41,9],[42,4,42,5],[42,6,42,7],[42,8,42,9],[43,4,43,5],[43,6,43,7],[43,8,43,9],[44,4,44,5],[44,6,44,7],[44,8,44,9],[45,4,45,5],[45,6,45,7],[45,8,45,9],[46,0,46,1]]}
[null,"Pricing template for submission with ITP Tender",null,null,"All prices must be provided in Rands"]
[]
[]
[1,"Implementation costs"]
[]
["3,5 year implementation pricing"]
[null," Project resources","Number of resources","Applicable software solution","Rate per hour","Hours required for year 1","Price for year 1","Hours required for year 2","Price for year 2","Hours required for year 3","Price for year 3","Total for 3 years"]
[null,"e.g. Project Manager",1,null,{"v":800,"d":"R800"},1998,{"$f":"F8*E8","v":{"v":1598400,"d":"R1,598,400"}},1998,{"$f":"H8*E8","v":{"v":1598400,"d":"R1,598,400"}},1998,{"$f":"J8*E8","v":{"v":1598400,"d":"R1,598,400"}},{"$f":"G8+I8+K8","v":{"v":4795200,"d":"R4,795,200"}}]
[null," "]
[null," ",{"$nulls":11}," "]
[null," "]
[null," "]
[null," "]
[null," "]
[null,"Project resources Total",{"$nulls":9},{"$f":"SUM(L8:L14)","v":{"v":4795200,"d":"R4,795,200"}}]
[null,"Technical resources","Number of resources","Applicable software solution","Rate per hour","Hours required for year 1","Price for year 1","Hours required for year 2","Price for year 2","Hours required for year 3","Price for year 3","Total for 3 years"]
[null,"e.g. Simulation SME",4,"Simulation tool",{"v":1200,"d":"R1,200"},1998,{"$f":"F17*E17*C17","v":{"v":9590400,"d":"R9,590,400"}},1998,{"$f":"H17*E17*C17","v":{"v":9590400,"d":"R9,590,400"}},1500,{"$f":"J17*E17*C17","v":{"v":7200000,"d":"R7,200,000"}},{"$f":"K17+I17+G17","v":{"v":26380800,"d":"R26,380,800"}}]
[null," "]
[null," "]
[null," "]
[null," "]
[null,"Technical resources total"]
[null,"Resource Totals",{"$nulls":9},{"$f":"SUM(L17:L22)","v":{"v":26380800,"d":"R26,380,800"}}]
[null,"6 month stabilisation resources"]
[null,"Stabilisation resources ","Number of resources","Applicable software solution","Rate per hour","Hours required for month 1","Hours required for month 2","Hours required for month 3","Hours required for month 4","Hours required for month 5","Hours required for month 6","Total for 6 months"]
[null,"e.g. Project Manager",1,null,{"v":800,"d":"R800"},180,180,180,180,180,180,{"$f":"(K26+J26+I26+H26+G26+F26)*E26*C26","v":{"v":864000,"d":"R864,000"}}]
[]
[]
[{"$nulls":11},{"$f":"SUM(L26:L28)","v":{"v":864000,"d":"R864,000"}}]
[]
[null,"Software subscription during implementation"]
[null,"Proposed solution","Cost of license  ",null,"Number of licenses required (including TFR resources)","Year in which licenses will be required","Price for year 1",null,"Price for year 2",null,"Price for year 3","Total for 3 years"]
[null,"e.g. Simulation tool",{"v":3500,"d":"R3,500"},null,10,"Year 1",{"$f":"E33*C33","v":{"v":35000,"d":"R35,000"}},null,{"$f":"E33*C33","v":{"v":35000,"d":"R35,000"}},null,{"$f":"E33*C33","v":{"v":35000,"d":"R35,000"}},{"$f":"K33+I33+G33","v":{"v":105000,"d":"R105,000"}}]
[]
[]
[]
[]
[null,"Software subscription totals",{"$nulls":9},{"$f":"SUM(L33:L37)","v":{"v":105000,"d":"R105,000"}}]
[null,"Training Material"]
[null,"Proposed solution","Number of user roles","Cost of training material","Year in which training material will be developed",null,"Price for year 1",null,"Price for year 2",null,"Price for year 3","Total for 3 years"]
[null,"e.g. Simulation tool",3,{"v":2500,"d":"R2,500"},"Year 2",null,{"v":0,"d":"R0"},null,{"$f":"D41*C41","v":{"v":7500,"d":"R7,500"}},null,{"v":0,"d":"R0"},{"$f":"K41+I41+G41","v":{"v":7500,"d":"R7,500"}}]
[]
[]
[]
[]
[null,"Training Material totals",{"$nulls":9},{"$f":"SUM(L41:L45)","v":{"v":7500,"d":"R7,500"}}]
["3 year implementation total",{"$nulls":10},{"$f":"L46+L38+L29+L23+L15","v":{"v":32152500,"d":"R32,152,500"}}]

{"sheet":"SS Completion Guide","index":2,"n_rows":15,"n_cols":10,"rows_kept":15}
["Solution Subscription Costs"]
[]
["1. On proposed solution column list the applicable solution modules"]
["2. Year indicate the year"]
["3. Percentage increase per year(YoY) - indicate the percentage increase per module year on year."]
["4. Licence costs per user - indicate the licence costs per user per solution module"]
["5. License cost per 100 users - indicate the total cost per module for 100 users"]
["6. License cost per 1000 users - indicate the total cost per module for 1000 users"]
["7. License cost per 2000 users - indicate the total cost per module for 2000 users"]
["8. Ability to amend licenses on an annual basis e.g. true-up /  true-down  (Y/N) - indicate per solution module whether the licence costs can be amended on an annual basis"]
[]
["An Example "]
[null,null,"Proposed solution","Year","Percentage increase per year","Licence cost per user","License cost per 100 users","Licence cost per 1000 users","Licence cost for 2000 users","Ability to amend licenses on an annual basis e.g. true-up /  true-down  (Y/N)"]
[null,null,"Solution / Module A","Year 1",0,"800.00","80000.00","600000.00","1150000.00","y"]
[{"$nulls":3},"Year 2",10,"880.00","88000.00","660000.00","1265000.00","y"]

{"sheet":"Software subscription","index":3,"n_rows":27,"n_cols":9,"rows_kept":27,"merged":[[2,0,2,8],[14,0,14,1],[25,0,25,1],[26,0,26,1]]}
[2,"Sofware subscription for 10 years"]
[]
["Software subscription after implementation "]
[null,"Proposed solution","Year","Percentage increase per year","Licence cost per user","License cost per 100 users","Licence cost per 1000 users","Licence cost for 2000 users","Ability to amend licenses on an annual basis e.g. true-up /  true-down  (Y/N)"]
[null,"Solution / Module A","Year 1"]
[null,null,"Year 2"]
[null,null,"Year 3"]
[null,null,"Year 4"]
[null,null,"Year 5"]
[null,null,"Year 6"]
[null,null,"Year 7"]
[null,null,"Year 8"]
[null,null,"Year 9"]
[null,null,"Year 10"]
["Solution A total"]
[null,"Solution / Module B","Year 1"]
[null,null,"Year 2"]
[null,null,"Year 3"]
[null,null,"Year 4"]
[null,null,"Year 5"]
[null,null,"Year 6"]
[null,null,"Year 7"]
[null,null,"Year 8"]
[null,null,"Year 9"]
[null,null,"Year 10"]
["Solution B total"]
["Software Subcritption contract total "]

{"sheet":"SME Completion Guide","index":4,"n_rows":13,"n_cols":17,"rows_kept":13,"merged":[[0,1,0,13],[1,1,1,13],[2,1,2,13],[3,1,3,13],[5,0,5,16],[12,0,12,4]]}
[null,"1. Per Solution, subject matter expert hours will be required on a monthly basis to provide support for:\n    1. Resolution of production issues and problems\n    2. New requirements development and changes to existing funtionality on solution\n    3. Support queries\n    4. Knowledge Transfers\n    5. Solution Training\n    6. Operational Support where needed"]
[null,"2. Per solution provide the number of hours that will be needed to maintain and support the solution, the rate per hour and then the total cost per year, as per below example."]
[null,"3. Note hours are allocated to a solution, not a fixed resource, this enables the bringing in of the required SME from resource pool to support where needed"]
[null,"4. Example Below"]
[]
[]
["No","Proposed solution","Description","Hourly cost ","Hour requirement per month","Percentage increase from Year n","Total Cost Year 1","Total Cost Year 2","Total Cost Year 3","Total Cost Year 4","Total Cost Year 5","Total Cost Year 6","Total Cost Year 7","Total Cost Year 8","Monthly Total Year 9","Total Cost Year 10","Total Cost"]
[1,"Solution: Simulation Tool","Support Hours Allocated Monthly.\nSupport Hourse Utlised for:\n1.  Average of 15 Days a Month Production Support, Incident & Problem Managment and Change Requests to systems\n3. 20 Days per year allocated for Training and Skills Transfer\nNote: \nHours can be increased or decreased with 3 months notice.\nHours are managed quartely\n",{"v":800,"d":"R800"},"20 Days per month * 8 hours per day = 160 Hours\nTotal Hours for year = 7360 Hours per year",{"v":0.05,"d":"5%"},{"$f":"SUM(800*7360)","v":{"v":5888000,"d":"R5,888,000.00"}},{"$f":"SUM(G8,G8*0.05)","v":{"v":6182400,"d":"R6,182,400.00"}},{"v":6491520,"d":"R6,491,520.00"},{"$f":"SUM(I8,I8*0.05)","v":{"v":6816096,"d":"R6,816,096.00"}},{"v":7156900.8,"d":"R7,156,900.80"},{"v":7514745.84,"d":"R7,514,745.84"},{"v":7890483.132,"d":"R7,890,483.13"},{"v":8285007.288600001,"d":"R8,285,007.29"},{"v":8699257.65303,"d":"R8,699,257.65"},{"v":9134220.535681501,"d":"R9,134,220.54"},{"$f":"SUM(G8:P8)","v":{"v":74058631.2493115,"d":"R74,058,631.25"}}]
[2,"Solution: Production Plan","Support Hours Allocated Monthly.\nSupport Hourse Utlised for:\n1.  Average of 15 Days a Month Production Support, Incident & Problem Managment and Change Requests to systems\n3. 20 Days per year allocated for Training and Skills Transfer\nNote: \nHours can be increased or decreased with 3 months notice.\nHours are managed quartely",800,"20 Days per month * 8 hours per day = 160 Hours\nTotal Hours for year = 7360 Hours per year",{"v":0.05,"d":"5%"},{"$f":"SUM(800*7360)","v":{"v":5888000,"d":"R5,888,000.00"}},{"v":6182400,"d":"R6,182,400.00"},{"v":6491520,"d":"R6,491,520.00"},{"v":6816096,"d":"R6,816,096.00"},{"v":7156900.8,"d":"R7,156,900.80"},{"v":7514745.84,"d":"R7,514,745.84"},{"v":7890483.132,"d":"R7,890,483.13"},{"v":8285007.288600001,"d":"R8,285,007.29"},{"v":8699257.65303,"d":"R8,699,257.65"},{"v":9134220.535681501,"d":"R9,134,220.54"},{"v":74058631.2493115,"d":"R74,058,631.25"}]
[3,"Solution: Monitoring and Deviation Management","Support Hours Allocated Monthly.\nSupport Hourse Utlised for:\n1.  Average of 15 Days a Month Production Support, Incident & Problem Managment and Change Requests to systems\n3. 20 Days per year allocated for Training and Skills Transfer",800,"20 Days per month * 8 hours per day = 160 Hours\nTotal Hours for year = 7360 Hours per year",{"v":0.05,"d":"5%"},{"$f":"SUM(800*7360)","v":{"v":5888000,"d":"R5,888,000.00"}},{"v":6182400,"d":"R6,182,400.00"},{"v":6491520,"d":"R6,491,520.00"},{"v":6816096,"d":"R6,816,096.00"},{"v":7156900.8,"d":"R7,156,900.80"},{"v":7514745.84,"d":"R7,514,745.84"},{"v":7890483.132,"d":"R7,890,483.13"},{"v":8285007.288600001,"d":"R8,285,007.29"},{"v":8699257.65303,"d":"R8,699,257.65"},{"v":9134220.535681501,"d":"R9,134,220.54"},{"v":74058631.2493115,"d":"R74,058,631.25"}]
[4,"Solution: Capacity Plan","Support Hours Allocated Monthly.\nSupport Hourse Utlised for:\n1.  Average of 15 Days a Month Production Support, Incident & Problem Managment and Change Requests to systems\n3. 20 Days per year allocated for Training and Skills Transfer",800,"20 Days per month * 8 hours per day = 160 Hours\nTotal Hours for year = 7360 Hours per year",{"v":0.05,"d":"5%"},{"$f":"SUM(800*7360)","v":{"v":5888000,"d":"R5,888,000.00"}},{"v":6182400,"d":"R6,182,400.00"},{"v":6491520,"d":"R6,491,520.00"},{"v":6816096,"d":"R6,816,096.00"},{"v":7156900.8,"d":"R7,156,900.80"},{"v":7514745.84,"d":"R7,514,745.84"},{"v":7890483.132,"d":"R7,890,483.13"},{"v":8285007.288600001,"d":"R8,285,007.29"},{"v":8699257.65303,"d":"R8,699,257.65"},{"v":9134220.535681501,"d":"R9,134,220.54"},{"v":74058631.2493115,"d":"R74,058,631.25"}]
[5,"Solution: Base Plan","Support Hours Allocated Monthly.\nSupport Hourse Utlised for:\n1.  Average of 15 Days a Month Production Support, Incident & Problem Managment and Change Requests to systems\n3. 20 Days per year allocated for Training and Skills Transfer",800,"20 Days per month * 8 hours per day = 160 Hours\nTotal Hours for year = 7360 Hours per year",{"v":0.05,"d":"5%"},{"$f":"SUM(800*7360)","v":{"v":5888000,"d":"R5,888,000.00"}},{"v":6182400,"d":"R6,182,400.00"},{"v":6491520,"d":"R6,491,520.00"},{"v":6816096,"d":"R6,816,096.00"},{"v":7156900.8,"d":"R7,156,900.80"},{"v":7514745.84,"d":"R7,514,745.84"},{"v":7890483.132,"d":"R7,890,483.13"},{"v":8285007.288600001,"d":"R8,285,007.29"},{"v":8699257.65303,"d":"R8,699,257.65"},{"v":9134220.535681501,"d":"R9,134,220.54"},{"v":74058631.2493115,"d":"R74,058,631.25"}]
["SME Augmentation contract total",{"$nulls":5},{"$f":"SUM(G8:G12)","v":{"v":29440000,"d":"R29,440,000.00"}},{"v":30912000,"d":"R30,912,000.00"},{"v":32457600,"d":"R32,457,600.00"},{"v":34080480,"d":"R34,080,480.00"},{"v":35784504,"d":"R35,784,504.00"},{"v":37573729.2,"d":"R37,573,729.20"},{"v":39452415.660000004,"d":"R39,452,415.66"},{"v":41425036.443,"d":"R41,425,036.44"},{"v":43496288.26515,"d":"R43,496,288.27"},{"v":45671102.678407505,"d":"R45,671,102.68"},{"v":370293156.2465575,"d":"R370,293,156.25"}]

{"sheet":"SME Augmentation","index":5,"n_rows":10,"n_cols":17,"rows_kept":10,"merged":[[2,0,2,16],[9,0,9,4]]}
[]
[]
[]
["No","Proposed solution","Number of resources","Hourly cost ","Hour requirement per month","Percentage increase from Year n","Total Cost Year 1","Total Cost Year 2","Total Cost Year 3","Total Cost Year 4","Total Cost Year 5","Total Cost Year 6","Total Cost Year 7","Total Cost Year 8","Total Cost Year 9","Total Cost Year 10","Total Cost"]
[1," ",{"$nulls":14},{"$f":"SUM(G5:P5)","v":0}]
[2," "]
[3," "]
[4," "]
[5," "]
["SME Augmentation contract total"]