{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Guidance","1.Pricing schedule-Mobilisation","2. Pricing schedule - yr 1 - 3","3.- Supplier Finance Viability "," 4. Summary Total Price"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Guidance","index":0,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"Guidance on completing this pricing schedule"]
[]
[null,null,null,"1.1 Basis of price evaluation/value for money assessment"]
[null,null,null,"Supplier price will be evaluated on the basis of: "]
[null,null,null,"1. The total price for the contract term including extensions (years 1-3) including mobilisation for delivery of the Core Specification "]
[]
[null,null,null,"1.2 Price Variation "]
[null,null,null," Day rates and prices for delivery of the Core Specification shall remain fixed for the full term of the contract.  "]
[]
[null,null,null,"1.3 Time of payment"]
[null,null,null,"The timing for payments will be made  in line with the specification. "]
[]
[null,null,null,"1.4 General instructions for completion of Price submission "]
[null,null,null,"All costs submitted must be exclusive of VAT and VAT calculated separately- please include the VAT rate in cell F:18 of the pricing schedules "]
[null,null,null,"All costs specified must be in GBP."]
[]
[null,null,null,"1.5 What is in scope of the price"]
[null,null,null,"The cost quoted must be a total cost for the delivery of the specification in full and must include (but is not limited to) costs arising from: All products, tools, hardware, storage, software packages, licences, application fees supplied to the customer, staff (including specialists and sub contractors and any products, tools, software packages, licences, application fees required for the staff to deliver the Service), travel and subsistence costs and any other cost required to deliver the service as outlined in the Specification. Daily rates should include subsistence "]
[]
[null,null,null,"1.6 Format of Price Submission"]
[null,null,null,"Suppliers are required to provide their pricing within the Pricing Schedule in this document  (Pricing schedule- Mobilisation and Pricing schedule yr 1-4)"]
[null,null,null,"The total contract price will be Pricing schedule- Mobilisation+Pricing schedule yr 1-3 and will be calculated automatically in tab 4. Summary Total Price "]
[null,null,null,"Suppliers must complete all cells with the information as requested and in accordance with the instructions provided "]
[null,null,null,"Where a price does not apply, Suppliers should note this by leaving blank"]
[null,null,null,"Suppliers are able to add/ and or remove any job roles and service items as they see fit"]
[null,null,null,"Cells highlighted in grey will be auto filled"]
[null,null,null,"Completed pricing schedules should be submitted along with your bid via Atamis"]
[null,null,null,"Suppliers are required to provide their summary of Financial Metrics utilised to assess financial stability of a Supplier in tab 3. Supplier Finance Viability "]
[null,null,null," Supplier Finance Viability will not be evaluated. "]
[null,null,null," If suppliers are unsure on how to calculate the metrics required within this tab, "]
[null,null,null,"they should refer to the Assessing and monitoring the economic and financial standing of suppliers guidance note on - "]
[null,null,null,"https://www.gov.uk/government/publications/the-sourcing-and-consultancy-playbooks\n"]
[null,null,null,"1.7 Approach to evaluation "]
[null,null,null,"The price evaluation/ value for money assessment is worth 30% of the overall evaluation of the ITT assessment and will be caluculated as follows:"]
[]
[null,null,null,"Lowest total cost for delivery offered x Financial weighting ÷ the Tendered total cost for delivery "]
[null,null,null,"For example, where Supplier A submits the lowest price for delivery out of all suppliers at a price of £160,000 for the core specification and Supplier B submits a price of £170,000 for total cost of delivery, each Supplier would score as follows: "]
[null,null,null,"Supplier A = 160,000 x 30 /160,000 = 30% "]
[null,null,null,"Supplier B = 160,000 x 30 /170,000 = 28.24%  (rounded to two decimal places)"]

{"sheet":"1.Pricing schedule-Mobilisation","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,0,2,1],[18,0,18,1],[19,0,19,5]]}
[null,"NHS England DQASS  Mobilisation "]
[]
["Job Role/ Service Item",null,"Day Rate/ individual cost (fixed for the duration of the contract)(£) exclusive of VAT","Number of Days/Quantity e.g. 1,2,3 etc.","Mobilisation\nEXC VAT (£)","Mobilisation VAT  (£)"]
[1,null,null,null,{"$f":"SUM(C4*D4)","v":0},{"$f":"SUM(E4/100)*$F$18","v":0}]
[2,null,null,null,{"$f":"SUM(C5*D5)","v":0},0]
[3,"[Add additional items as required]",null,null,{"$f":"SUM(C6*D6)","v":0},0]
[4,"[Add additional items as required]",null,null,{"$f":"SUM(C7*D7)","v":0},0]
[5,"[Add additional items as required]",null,null,{"$f":"SUM(C8*D8)","v":0},0]
[6,"[Add additional items as required]",null,null,0,{"$f":"SUM(E9/100)*$F$18","v":0}]
[7,"[Add additional items as required]",null,null,0,0]
[8,"[Add additional items as required]",null,null,0,0]
[9,"[Add additional items as required]",null,null,0,0]
[10,"[Add additional items as required]",null,null,0,0]
[11,"[Add additional items as required]",null,null,0,0]
[12,"[Add additional items as required]",null,null,0,0]
[13,"[Add additional items as required]",null,null,{"$f":"SUM(C16*D16)","v":0},{"$f":"SUM(E16/100)*$F$18","v":0}]
[null,"Total ",null,null,{"$f":"SUM(E4:E16)","v":0},{"$f":"SUM(E17/100)*F19","v":0}]
[null,null,null,null,"Please add VAT % in cell F:18"]

{"sheet":"2. Pricing schedule - yr 1 - 3","index":2,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,9,1,11],[1,12,1,13],[2,0,2,1],[19,0,19,7],[18,0,18,1],[1,3,1,5],[1,6,1,8]]}
[null,"NHS England Genetic Counselling Courses  year 1-4 "]
[null,"NHS England DQASS  ",null,"Year 1",null,null,"Year 2",null,null,"Year 3 ",null,null,"Total "]
["Job Role/ Service Item",null,"Day Rate/ individual cost (fixed for the duration of the contract)(£) exclusive of VAT","Number of Days/Quantity e.g. 1,2,3 etc.","Year 1\nEXC VAT (£)","Year 1 VAT (£)","Number of Days/Quantity e.g. 1,2,3 etc.","Year 2\nEXC VAT (£)","Year  2 VAT (£)","Number of Days/Quantity e.g. 1,2,3 etc.","Year 3\nEXC VAT (£)","Year  3 VAT(£)","Total Price\nEXC  VAT For years 1-3  (£)","Total Price\ninc VAT For years 1-3  (£)"]
[1,"Education Facilitator ",null,null,{"$f":"SUM(C4*D4)","v":0},{"$f":"SUM(E4/100)*$F$18","v":0},null,{"$f":"SUM(C4*G4)","v":0},{"$f":"SUM(H4/100)*$F$18","v":0},null,{"$f":"SUM(C4*J4)","v":0},{"$f":"SUM(K4/100)*$F$18","v":0},{"$f":"SUM(E4+H4+K4)","v":0},{"$f":"SUM(E4+F4+H4+I4+K4+L4)","v":0}]
[2,"Support Facilitator ",null,null,{"$f":"SUM(C5*D5)","v":0},{"$f":"SUM(E5/100)*$F$18","v":0},null,{"$f":"SUM(C5*G5)","v":0},0,null,{"$f":"SUM(C5*J5)","v":0},0,{"$f":"SUM(E5+H5+K5)","v":0},{"$f":"SUM(E5+F5+H5+I5+K5+L5)","v":0}]
[3,"Guest Speakers/ Subject matter experts",null,null,0,{"$f":"SUM(E6/100)*$F$18","v":0},null,0,0,null,0,0,{"$f":"SUM(E6+H6+K6)","v":0},0]
[4,"Admin/Project support ",null,null,0,0,null,0,0,null,0,0,{"$f":"SUM(E7+H7+K7)","v":0},0]
[5,"Room/Venue hire including refreshments ",null,null,0,0,null,0,0,null,{"$f":"SUM(C8*J8)","v":0},0,{"$f":"SUM(E8+H8+K8)","v":0},0]
[6,"Course Materials/ Equipment",null,null,0,0,null,0,0,null,0,0,{"$f":"SUM(E9+H9+K9)","v":0},0]
[7,"[Add additional items as required]",null,null,0,0,null,null,{"$f":"SUM(H10/100)*$F$18","v":0},null,0,{"$f":"SUM(K10/100)*$F$18","v":0},0,0]
[8,"[Add additional items as required]",null,null,0,0,null,null,0,null,0,0,0,0]
[9,"[Add additional items as required]",null,null,0,0,null,null,0,null,0,0,0,0]
[10,"[Add additional items as required]",null,null,0,0,null,0,0,null,0,0,0,0]
[11,"[Add additional items as required]",null,null,0,0,null,0,0,null,0,0,0,0]
[12,"[Add additional items as required]",null,null,null,null,null,null,0,null,0,0,0,0]
[13,"[Add additional items as required]",null,null,0,{"$f":"SUM(E16/100)*$F$18","v":0},null,0,0,null,0,0,0,0]
[null,"Total ",null,null,{"$f":"SUM(E4:E16)","v":0},{"$f":"SUM(E17/100)*F18","v":0},null,{"$f":"SUM(H4:H16)","v":0},{"$f":"SUM(H17/100)*F18","v":0},null,{"$f":"SUM(K4:K16)","v":0},{"$f":"SUM(K17/100)*F18","v":0},{"$f":"SUM(E17+H17+K17)","v":0},{"$f":"SUM(E17+F17+H17+I17+K17+L17)","v":0}]
[null,null,null,null,"Please add VAT % in cell F:18"]

{"sheet":"3.- Supplier Finance Viability ","index":3,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,1,21,5],[16,3,16,7],[2,2,3,4],[12,3,12,7],[13,3,13,7],[14,3,14,7],[15,3,15,7]]}
[]
[]
[null," ","Non-critical (Bronze) procurements "]
[null,"Metric ","Low risk  "]
[null,"Metric 1 - Turnover Ratio ",">2.0x ","1.5 - 2.0x ","<1.5 "]
[null,"Metric 3(B) - Net Debt / EBITDA ","< 2.5x ","2.5 - 3.5x ","> 3.5x "]
[null,"Metric 5 - Net Interest Paid Cover ","> 4.0x ","2.5 - 4.0x ","< 2.5x "]
[null,"Metric 6 - Acid Ratio ","> 0.8x ","0.7 - 0.8x ","< 0.7x "]
[]
[]
[null,"Supplier Information "]
[]
[null,"Metric ","Supplier ratio's","Please show Calculations"]
[null,"Metric 1 - Turnover Ratio "]
[null,"Metric 3(B) - Net Debt / EBITDA "]
[null,"Metric 5 - Net Interest Paid Cover "]
[null,"Metric 6 - Acid Ratio "]
[]
[]
[]
[null,"please note that that the supplier finance viability will not be evaluated but will be used once the preferred supplier is known to assess what measures (if any) are required when entering into a contract. The authority may request a guarantee or take further actions dependent on the outcome of the above. The authority reserves the right to take necessary measures to insure any supplier entering into a contract is financially viable to do so."]

{"sheet":" 4. Summary Total Price","index":4,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Total Mobilisation\nEXC VAT (£)","Total Price\nEXC  VAT For years 1-3  (£)","Total Price EXC VAT","MOB1-4 INC VALT "]
[null,{"$f":"'1.Pricing schedule-Mobilisation'!E17","v":0},{"$f":"'2. Pricing schedule - yr 1 - 3'!M17","v":0},{"$f":"B4+C4","v":0}]