{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Company Details","Instructions - PLEASE READ","Volume and Assumptions","Price Weightings","Benefits Platform & Service Man","Salary Sacrifice Schemes","Employee Discounts","Payroll Giving","Reward & Recognition","Financial Wellbeing","Summary Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Company Details","index":0,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[[17,0,17,11],[0,0,3,11],[5,0,6,11],[8,0,8,11],[11,0,11,11],[14,0,16,11],[9,0,9,11],[12,0,12,11]]}
["Attachment 3 - Price Matrix \nEmployee Benefits"]
[]
[]
[]
[]
["Contract Reference: RM6133"]
[]
[]
["Please enter your ORGANISATION'S NAME in the text box below"]
[]
[]
["Please enter your ORGANISATION'S TRADING NAME in the text box below"]
[]
[]
["If you are registered with Companies House or non-UK equivalent, please enter your COMPANY REGISTRATION NUMBER or non-UK eqivalent number in the text box below "]

{"sheet":"Instructions - PLEASE READ","index":1,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["PRICING INSTRUCTIONS"]
[]
["PRICING APPROACH"]
["- The Pricing Matrix is designed to enable bidders the flexability to adopt different pricing mechanisms. "]
[" - Pricing is on a usage (volume) basis rather than the number of employees in a Buyer organisation. "]
[" - Volumes are based on annual volume assumptions (see \"Volume and Assumptions tab\" within this Pricing Matrix). "]
["COMPLETION"]
["- Pricing compliance for this Framework Agreement is explained further in Attachment 2 paragraph 11.2 \"Price Compliance Process\""]
["- On each Pricing worksheet bidders are required to insert prices in each of the price cells (£0.00) that are highlighted in Blue. Bidders may input a nil cost for any price that is not chargeable to the Buyer."]
["- Prices submitted in the Pricing Matrix will be evaluated using an electronic auction (\"eAuction\") in accordance with Attachment 2 paragraph 11.3 \"eAuction Evaluation Process\"  and will be used to calculate your Final Score and ranking. "]
["- Prices entered in the Green cells within the Financial Wellbeing tab will not form part of the price evaluation.\n- White cells will be automatically calculated and should NOT be populated by Bidders. \n- Orange cells in the Cost Component Breakdown tables will not form part of the price evaluation.\n- The \"Cost Component Breakdown\" tables are mandatory and will form part of Framework Schedule 3 Framework Prices to ensure price transparency and to assist verification of value for money in provision of the Services. The \"Cost Component Breakdown\" cells highlighted orange should include a detailed breakdown of your total costs in percentage terms for each service cost you are quoting in the relevant tab. \n- Cost recovery from other service elements or from employee benefits (within the Cost Component Breakdown table) must be entered as a minus (-) figure. \n"]
["PLEASE NOTE"]
["- CCS reserves the right to verify any prices which may appear unsustainable or uncompetitive, and any prices that are significantly low or that may appear unsustainable or uncompetitive. Bidders should note that as part of the Price Evaluation process, if we believe that a pricing scenario is abnormally low it will conduct a further analysis of the offer in accordance with Regulation 69."]
["- You may submit \"zero bids\"  for any price elements, however, see above provision regarding abnormally low tenders."]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"Volume and Assumptions","index":2,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,6],[31,0,31,3],[24,0,24,3],[22,0,23,3],[25,0,25,3],[26,0,26,3],[27,0,27,3],[28,0,28,3],[29,0,29,3],[30,0,30,3],[1,0,1,1]]}
["VOLUME ASSUMPTIONS and CAVEATS"]
["VOLUME ASSUMPTIONS"]
["Price Element","Estimated Annual Usage"]
["Online Employee Benefits Platform and service management -  number of organisations",90]
["Online Employee Benefits Platform and service management -  number of registered Users",400000]
["Promotion - indicative number of roadshows full day",10]
["Promotion - indicative number of roadshows half day",10]
["Childcare Voucher Scheme orders",19000]
["Cycle to Work Scheme orders",2000]
["Discounted Gym Membership Scheme - estimated employee headcount usage",8000]
["Technology and Smartphone Scheme - Discounts total employee headcount usage",800]
["Green Cars Scheme - estimated employee headcount usage",1500]
["Employee Discounts Scheme - registered Users",400000]
["Payroll Giving Scheme- registered Users",160000]
["Reward & Recognition Scheme -  Number of organisations set up",40]
["Reward & Recognition Scheme - online voucher orders",100000]
["Reward & Recognition Scheme - physical vouchers issued",4500]
["Financial Wellbeing Scheme - estimated employee headcount usage (Education)",20000]
["Financial Wellbeing Scheme - Debt Management","Not Known"]
["Financial Wellbeing Scheme - Loans","Not Known"]
["Financial Wellbeing Scheme - Savings","Not Known"]
[" "]
["CAVEATS"]
[]
["- Volume assumptions are based on usage data on the exisiting CCS Employee Benefits Agreement in 2017/18, 99% of which was in central government."]
["- Grey cells represent services delivered under the existing CCS Employee Services Agreement RM3704. Yellow cells represent new benefits not currently offered by CCS.\n"]
["- Volume data in grey cells is 2017/18 data from the existing CCS Employee Services Agreement and is approximately the mid-term point of the Agreement."]
["- Volume data in yellow cells is based on buyers of the existing CCS Employee Services Agreement who anticipate accessing these new benefits in future and is as anticipated at the mid-term point of the new Agreement."]
["- HM Treasury currently restricts use of Salary Sacrifice Schemes for Civil Servants to the Childcare Voucher Scheme and Cycle to Work Scheme.\nRestrictions on use of Salary Sacrifice Schemes by HM Treasury do not apply to public sector organisations outside of the Civil Service."]
["- Use of Gym Discounts and Technology and Smartphone Discounts in Central Government will be via net pay deduction or employee discount, subject to any change in Salary Sacrifice rules for Civil Servants."]
["- Use of Green Car Salary Sacrifice Scheme is not currently permitted to Civil Servants under HM Treasury rules. There are a small number of non-Civil Service Users accessing a Car Benefit Scheme under the exisitng CCS Employee Services Agreement. The volumes provided for existing customers will only materialise if there is a change in HM Treasury rules on Salary Sacrifice for Civil Servants.  "]
["- Financial Wellbeing is not likely to be used by customers of the existing Employee Benefits Agreement in the first year of the new Agreement.  \nThe anticipated volumes of Financial Wellbeing products is not known. "]

{"sheet":"Price Weightings","index":3,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,0,1,1],[3,1,7,1],[0,0,0,2],[14,0,14,5]]}
["Cost Weightings - For information"]
["Service Element",null,"Weighting"]
["Online Employee Benefits Platform and service management",null,0.2]
["Childcare Voucher Scheme","Salary Sacrifice Schemes / Net Pay Deduction Schemes",0.11]
["Cycle to Work Scheme",null,8.5000000000000006E-2]
["Discounted Gym Membership Scheme",null,8.5000000000000006E-2]
["Technology and Smartphone Discounts Scheme",null,8.5000000000000006E-2]
["Green Car Scheme",null,0.01]
["Employee Discounts Scheme",null,0.15]
["Payroll Giving Scheme",null,8.5000000000000006E-2]
["Reward and Recognition Scheme",null,0.11]
["Financial Wellbeing Scheme",null,0.08]
["TOTAL",null,1]
[]
["The above weightings will be used to calculate your 'Total Weighted Cost' for each benefit, which will then be added together to give your 'Overall Total Weighted Cost'\nYour 'Overall Total Weighted Cost' will be used in the eAuction as stated in attachment 2 How to bid, paragraph 11.3. "]

{"sheet":"Benefits Platform & Service Man","index":4,"n_rows":63,"n_cols":5,"rows_kept":63,"cut":false,"hidden":false,"merged":[[2,0,10,6],[32,0,32,1],[49,0,49,1]]}
["Online Employee Benefits Platform and service management"]
[]
["- Bidders are required to provide a cost for initial set up fee per Buyer in cell B14.\n\n- Bidders are required to provide a combined cost for the Online Employee Benefits Platform and service management in cells B20.\n\n- The cost provided in cell B20 shall be for Users registered on the Online Employee Benefits Platform not the total number of employees, and shall include the cost of the Online Employee Benefits Platform including maintenance and upgrades, and the service management which comprises all management and administration costs, implementation and exit, and promotional activity. \n\n- Bidders are required to provide a cost for additional promotional activity where requested by a Buyer in cells B26 and C26.\n\n- Bidders may input £0.00 in any cell where a fee is not payable by the Buyer.\n\n- Travel costs for attendance at promotional events and roadshows requested by the Buyer shall be in accordance with the Buyers' travel policy for contractors.\n\n- Bidders are required to provide a breakdown of the set up fee and the annual fee per registered User of the Online Employee Benefits Platform (shown in cells B17 and B23) in cells B35 to B45 and cells B52 to B62. Bidders may enter 0% for any cost component that does not apply, however the total breakdown should equal 100%.\n\n- Bidders are required to include the percentage value of any cost recovery that contributes to the funding of the service, for example cost recovery from a share of the Employee Discounts, in cells B44 and B61.\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Initial Set Up"]
["One-off service set up fee per Buyer"]
["Volumes",90]
["Weighting",0.02]
["Weighted Cost",{"$f":"B14*B15*2%","v":0}]
[]
["Online Benefits Platform and service management"]
["Annual fee per registered User, including User registration, licence, technology maintenance and upgrades, User support and service management fees "]
["Volumes",400000]
["Weighting",0.17499999999999999]
["Weighted Cost",{"$f":"B20*B21*17.5%","v":0}]
[]
["Additional Promotional Activity requested by Buyer","Day Rate\n (4 to 8 hours)","Half Day Rate\n(up to 4 hours)"]
["Attendance at Buyer events/roadshows (excluding travel costs)"]
["Volumes",10,10]
["Weighting",4.4999999999999997E-3,5.0000000000000001E-4]
["Weighted Cost",{"$f":"B26*B27*0.5%","v":0},{"$f":"C26*C27*0.05%","v":0}]
[]
[null,null,null,"Total Weighted Cost",{"$f":"SUM(B17,B23,C23,B29,C29)","v":0}]
[]
["Breakdown of Set up Fee"]
["Cost Component","\n% Breakdown"]
["Technology"]
["Management of sub-contractors"]
["Sub-contractor pass-through costs"]
["Administration"]
["Helpline"]
["Promotional Activity"]
["Overheads"]
["Profit"]
["CCS Levy"]
["Cost recovery from other service elements or from employee benefits"]
["Other"]
["Total",{"$f":"SUM(B35:B45)","v":0}]
[]
[]
[]
["Breakdown of Online Benefits Platform and service management annual fee"]
["Cost Component","\n% Breakdown"]
["Technology"]
["Management of sub-contractors"]
["Sub-contractor pass-through costs"]
["Administration"]
["Helpline"]
["Promotional Activity"]
["Overheads"]
["Profit"]
["CCS Levy"]
["Cost recovery from other service elements or from employee benefits"]
["Other"]
["Total",{"$f":"SUM(B52:B62)","v":0}]

{"sheet":"Salary Sacrifice Schemes","index":5,"n_rows":96,"n_cols":7,"rows_kept":96,"cut":false,"hidden":false,"merged":[[66,0,66,1],[82,0,82,1],[8,0,8,1],[50,0,50,1],[2,0,2,7],[3,0,3,7],[4,0,4,7],[5,0,5,7],[6,0,6,7]]}
["Salary Sacrifice Schemes/Net Pay Deduction Schemes"]
[]
["- Bidders are required to provide a cost for the salary sacrifice/net pay schemes in cells B10 to B14. "]
["- Bidders may enter £0.00 for any cost that does not apply or where the cost is included in the Online Employee Benefits Platform and service management annual fee."]
["- Bidders are required to provide a breakdown of fees for salary sacrifice schemes in cells B21 to B31, B37 to B47, B53 to B63, B69 to B79 and B85 to B95.  "]
["- Bidders may enter 0% for any cost component that does not apply or where the cost is included in the Online Employee Benefits Platform and service management annual fee, however the total breakdown must equal 100%."]
["- Bidders are required to include the percentage value of any cost recovery that contributes to the funding of the service, for example cost recovery from a share of the 'Employee Discounts, in cells B32, B48, B64, B80 and B97."]
[]
["Salary Sacrifice/net pay Schemes",null,"Volumes","Weighting","Weighting","Weighted Cost"]
["Childcare Voucher Scheme fee per order",null,19000,0.105,0.11,{"$f":"B10*C10*11%","v":0}]
["Cycle to Work Scheme fee per order",null,2000,0.08,8.5000000000000006E-2,{"$f":"B11*C11*8.5%","v":0}]
["Discounted Gym Membership Scheme fee per order",null,8000,0.08,8.5000000000000006E-2,{"$f":"B12*C12*8.5%","v":0}]
["Technology and Smartphone Discounts Scheme fee per order",null,800,0.08,8.5000000000000006E-2,{"$f":"B13*C13*8.5%","v":0}]
["Green Car Scheme fee per order",null,1500,8.9999999999999993E-3,0.01,{"$f":"B14*C14*1%","v":0}]
[]
[null,null,null,"Total Weighted Cost Direct Access Option","Total Weighted Cost",{"$f":"SUM(F10:F14)","v":0}]
[]
[]
["Breakdown of Childcare Voucher Scheme service fee"]
["Cost Component","\n% Breakdown",null,null,null,null,9.4499999999999993]
["Technology"]
["Management of sub-contractors"]
["Sub-contractor pass-through costs"]
["Administration"]
["Helpline"]
["Promotional Activity"]
["Overheads"]
["Profit"]
["CCS Levy"]
["Cost recovery from other service elements or from employee benefits"]
["Other"]
["Total",{"$f":"SUM(B21:B31)","v":0}]
[]
[]
["Breakdown of Cycle to Work Scheme service fee"]
["Cost Component","\n% Breakdown"]
["Technology"]
["Management of sub-contractors"]
["Sub-contractor pass-through costs"]
["Administration"]
["Helpline"]
["Promotional Activity"]
["Overheads"]
["Profit"]
["CCS Levy"]
["Cost recovery from other service elements or from employee benefits"]
["Other"]
["Total",{"$f":"SUM(B37:B47)","v":0}]
[]
[]
["Breakdown of Discounted Gym Membership Scheme service fee"]
["Cost Component","\n% Breakdown"]
["Technology"]
["Management of sub-contractors"]
["Sub-contractor pass-through costs"]
["Administration"]
["Helpline"]
["Promotional Activity"]
["Overheads"]
["Profit"]
["CCS Levy"]
["Cost recovery from other service elements or from employee benefits"]
["Other"]
["Total",{"$f":"SUM(B53:B63)","v":0}]
[]
[]
["Breakdown of Technology And Smartphone Discounts Scheme service fee"]
["Cost Component","\n% Breakdown"]
["Technology"]
["Management of sub-contractors"]
["Sub-contractor pass-through costs"]
["Administration"]
["Helpline"]
["Promotional Activity"]
["Overheads"]
["Profit"]
["CCS Levy"]
["Cost recovery from other service elements or from employee benefits"]
["Other"]
["Total",{"$f":"SUM(B69:B79)","v":0}]
[]
[]
["Breakdown of Green Car Scheme service fee"]
["Cost Component","\n% Breakdown"]
["Technology"]
["Management of sub-contractors"]
["Sub-contractor pass-through costs"]
["Administration"]
["Helpline"]
["Promotional Activity"]
["Overheads"]
["Profit"]
["CCS Levy"]
["Cost recovery from other service elements or from employee benefits"]
["Other"]
["Total",{"$f":"SUM(B85:B95)","v":0}]

{"sheet":"Employee Discounts","index":6,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[9,0,9,1],[2,0,2,10],[7,0,7,10],[6,0,6,10],[5,0,5,10],[4,0,4,10],[3,0,3,10]]}
["Employee Discounts Scheme"]
[]
["- Bidders are required to provide a price for Employee Discounts in cell B11. "]
["- The price provided in cell B11 shall be for Users of Employee Discounts."]
["- Bidders may enter £0.00 for any cost that does not apply or where the cost is included in the Online Employee Benefits Platform and service management annual fee."]
["- Bidders are required to provide a breakdown of any applicable service fees for Employee Discounts in cells B20 to B30.  "]
["- Bidders may enter 0% for any cost component that does not apply or where the cost is included in the Online Employee Benefits Platform and service management annual fee, however the total breakdown must equal 100%."]
["- Bidders are required to include the percentage value of any cost recovery that contributes to the funding of the service, for example cost recovery from a share of the Employee Discounts, in cell B31."]
[]
["Employee Discounts"]
["Annual fee per user registered on the discounts platform"]
["Volumes",400000]
["Weighting",0.15]
["Weighted Cost",{"$f":"B11*B12*15%","v":0}]
[]
[null,null,"Total Weighted Cost",{"$f":"B14","v":0}]
[]
["Breakdown of Employee Discounts service fee"]
["Cost Component","% Breakdown"]
["Technology"]
["Management of sub-contractors"]
["Sub-contractor pass-through costs"]
["Administration"]
["Helpline"]
["Promotional Activity"]
["Overheads"]
["Profit"]
["CCS Levy"]
["Cost recovery from other service elements or from employee benefits"]
["Other"]
["Total",{"$f":"SUM(B20:B30)","v":0}]

{"sheet":"Payroll Giving","index":7,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[16,0,16,1],[2,0,2,7],[4,0,4,7],[5,0,5,7],[6,0,6,7],[3,0,3,7]]}
["Payroll Giving Scheme"]
[]
["- Bidders are required to provide a cost for the Payroll Giving Scheme in cell B10. "]
["- Bidders may enter £0.00 for any cost that does not apply or where the cost is included in the Online Employee Benefits Platform and service management annual fee."]
["- Bidders are required to provide a breakdown of fees for the Payroll Giving Scheme in cells B19 to B28.  "]
["- Bidders may enter 0% for any cost component that does not apply or where the cost is included in the Online Employee Benefits Platform and service management annual fee, however the total breakdown must equal 100%."]
["- Bidders are required to include the percentage value of any cost recovery that contributes to the funding of the service, for example cost recovery from a share of the Employee Discounts, in cell B29. "]
[]
["Payroll Giving Scheme"]
["Fee for each donation from an individual's salary to the Scheme."]
["Volumes",160000]
["Weighting",8.5000000000000006E-2]
["Weighted Cost",{"$f":"B10*B11*8.5%","v":0}]
[]
[null,null,"Total Weighted Cost",{"$f":"B13","v":0}]
[]
["Breakdown of Payroll Giving Scheme fee"]
["Cost Component","% Breakdown"]
["Technology"]
["Management of sub-contractors"]
["Sub-contractor pass-through costs"]
["Administration"]
["Helpline"]
["Promotional Activity"]
["Overheads"]
["Profit"]
["Cost recovery from other service elements or from employee benefits"]
["Other"]
["Total",{"$f":"SUM(B19:B28)","v":0}]

{"sheet":"Reward & Recognition","index":8,"n_rows":77,"n_cols":4,"rows_kept":77,"cut":false,"hidden":false,"merged":[[63,0,64,0],[63,1,64,1],[3,0,3,7],[2,0,2,7],[7,0,8,7],[46,0,46,1],[62,0,62,1],[10,0,10,1],[30,0,30,1],[4,0,4,7],[6,0,6,7],[5,0,5,7],[47,0,48,0],[31,0,32,0],[31,1,32,1],[47,1,48,1]]}
["Reward and Recognition Scheme"]
[]
["Bidders are required to provide a price for Reward and Recognition awards in cells B12, B19 and B24. "]
["Postage of the physical voucher shall be charged to the Contracting Authority at cost."]
["Bidders may enter £0.00 for any cost component that does not apply or where the cost is included in the Online Employee Benefits Platform and Managed Service annual fee."]
["Bidders are required to provide a breakdown of fees for Reward and Recognition in cells B34 to B44, B50 to B60, and B66 to B76. "]
["Bidders may enter 0% for any cost component that does not apply or where the cost is included in the Online Benefits Platform and Managed Service annual fee."]
["Bidders are required to include the percentage value of any cost recovery that contributes to the funding of the service, for example cost recovery from a share of Employee Discounts, in cell B45, B61 and B77."]
[]
[]
["Initial Set Up"]
["One-off set up fee per Contracting Authority Interface"]
["Volumes",40]
["Weighting",3.5000000000000003E-2]
["Weighted Cost",{"$f":"B12*B13*3.5%","v":0}]
[]
["Online Reward Voucher Order*"]
["Service fee for each online reward order"]
["Volumes",100000]
["Weighting",6.5000000000000002E-2]
["Weighted Cost",{"$f":"B18*B19*6.5%","v":0}]
[]
["Physical Voucher Order"]
["Service fee for physical voucher order (excluding postage)"]
["Volumes (shipments)",4500]
["Weighting",0.01]
["Weighted Cost",{"$f":"B24*B25*1%","v":0}]
[]
[null,null,"Total Weighted Cost",{"$f":"SUM(B21,B15)","v":0}]
[]
["Breakdown of Reward and Recognition set up fee"]
["Cost Component"]
[]
["Technology"]
["Management of sub-contractors"]
["Sub-contractor pass-through costs"]
["Administration"]
["Helpline"]
["Promotional Activity"]
["Overheads"]
["Profit"]
["CCS Levy"]
["Cost recovery from other service elements or from employee benefits"]
["Other"]
["Total",{"$f":"SUM(B34:B44)","v":0}]
[]
["Breakdown of Reward and Recognition Online Reward Voucher order fee"]
["Cost Component"]
[]
["Technology"]
["Management of sub-contractors"]
["Sub-contractor pass-through costs"]
["Administration"]
["Helpline"]
["Promotional Activity"]
["Overheads"]
["Profit"]
["CCS Levy"]
["Cost recovery from other service elements or from employee benefits"]
["Other"]
["Total",{"$f":"SUM(B50:B60)","v":0}]
[]
["Breakdown of Reward and Recognition Physical Reward Voucher order fee"]
["Cost Component"]
[]
["Technology"]
["Management of sub-contractors"]
["Sub-contractor pass-through costs"]
["Administration"]
["Helpline"]
["Promotional Activity"]
["Overheads"]
["Profit"]
["CCS Levy"]
["Cost recovery from other service elements or from employee benefits"]
["Other"]
["Total",{"$f":"SUM(B66:B76)","v":0}]

{"sheet":"Financial Wellbeing","index":9,"n_rows":78,"n_cols":5,"rows_kept":78,"cut":false,"hidden":false,"merged":[[16,0,16,1],[32,0,32,1],[64,0,64,1],[9,0,9,1],[2,0,2,7],[7,0,7,7],[6,0,6,7],[5,0,5,7],[4,0,4,7],[3,0,3,7]]}
["Financial Wellbeing Scheme"]
[]
["Bidders are required to provide a cost for Financial Wellbeing in cells B11 to B14."]
["The cost provided in cell B11 shall be for Users on the financial wellbeing service not the total number of employees."]
["Bidders may enter £0.00 for any cost component that does not apply or where the cost is included in the Online Employee Benefits Platform and Managed Service annual fee."]
["Bidders are required to provide a breakdown of fees for Financial Wellbeing in cells B19 to B29, B35 to B45, B51 to B61, and B67 to B77.  Bidders may enter 0% for any cost component that does not apply or where the cost is included in the Online Benefits Platform and service management annual fee."]
["The price for Financial Wellbeing services and products (in cells B12 - B14) will not be evaluated as volumes are expected to be low in the first 12 - 18 months."]
["Bidders are required to include the percentage value of any cost recovery that contributes to the funding of the service, for example cost recovery from a share of the Employee Discounts, in cell B30, B46, B62 and B78."]
[]
["Financial Wellbeing",null,"Volumes","Weighting","Weighted Cost"]
["Service fee for each User registered for the Financial Education service",null,20000,0.08,{"$f":"B11*C11*8%","v":0}]
["Debt Management Services & Products fee per User"]
["Loan Services & Products fee per User"]
["Savings and Investment Services & Products fee per User"]
[]
[null,null,null,"Total Weighted Cost",{"$f":"E11","v":0}]
["Breakdown of Financial Education site fee"]
["Cost Component"]
["Technology"]
["Management of sub-contractors"]
["Sub-contractor pass-through costs"]
["Administration"]
["Helpline"]
["Promotional Activity"]
["Overheads"]
["Profit"]
["CCS Levy"]
["Cost recovery from other service elements or from employee benefits"]
["Other"]
["Total",{"$f":"SUM(B19:B29)","v":0}]
[]
[]
["Breakdown of Debt Management Services & Products service fee"]
["Cost Component"]
["Technology"]
["Management of sub-contractors"]
["Sub-contractor pass-through costs"]
["Administration"]
["Helpline"]
["Promotional Activity"]
["Overheads"]
["Profit"]
["CCS Levy"]
["Cost recovery from other service elements or from employee benefits"]
["Other"]
["Total",{"$f":"SUM(B35:B45)","v":0}]
[]
[]
["Breakdown of Loan Services & Products service fee"]
["Cost Component"]
["Technology"]
["Management of sub-contractors"]
["Sub-contractor pass-through costs"]
["Administration"]
["Helpline"]
["Promotional Activity"]
["Overheads"]
["Profit"]
["CCS Levy"]
["Cost recovery from other service elements or from employee benefits"]
["Other"]
["Total",{"$f":"SUM(B51:B61)","v":0}]
[]
[]
["Breakdown of Savings and Investment Services & Products service fee"]
["Cost Component"]
["Technology"]
["Management of sub-contractors"]
["Sub-contractor pass-through costs"]
["Administration"]
["Helpline"]
["Promotional Activity"]
["Overheads"]
["Profit"]
["CCS Levy"]
["Cost recovery from other service elements or from employee benefits"]
["Other"]
["Total",{"$f":"SUM(B67:B77)","v":0}]

{"sheet":"Summary Sheet","index":10,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[5,2,9,2],[5,3,9,3]]}
["Summary of Total Fees"]
[]
[]
["Service","Weighting",null,"Total Weighted Cost "]
["Online Benefits Platform and Managed Service",0.2,null,{"$f":"+'Benefits Platform & Service Man'!E31","v":0}]
["Childcare Voucher Scheme",0.11,"Salary Sacrifice Schemes",{"$f":"+'Salary Sacrifice Schemes'!F16","v":0}]
["Cycle to Work Scheme",8.5000000000000006E-2]
["Discounted Gym Membership",8.5000000000000006E-2]
["Technology and Smartphone Discounts",8.5000000000000006E-2]
["Green Car Scheme",0.01]
["Employee Discounts",0.15,null,{"$f":"+'Employee Discounts'!D16","v":0}]
["Payroll Giving Scheme",8.5000000000000006E-2,null,{"$f":"+'Payroll Giving'!D15","v":0}]
["Reward and Recognition",0.11,null,{"$f":"+'Reward & Recognition'!D29","v":0}]
["Financial Wellbeing",0.08,null,{"$f":"+'Financial Wellbeing'!E16","v":0}]
["TOTAL",1]
[null,null,"Overall Weighted Total Cost",{"$f":"SUM(D5:D14)","v":0}]