{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Compliance Template","P&MS Engagement Types Overview","Definition Guide","Working Holidays","Capped Rates","Discount Structure"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":20,"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":"Instructions","index":0,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Standard commercial framework compliance checklist"]
[null,"This compliance checklist verifies whether the proposal is compliant with the standard commercial framework. "]
[]
[null,"To use this checklist, please follow these steps:"]
[null,"Step 1. Select a high level SCF groupings engagement type from 1-6. (Refer to Sheet 3 - P&MS Engagement Types mapping to high level grouped engagement types)"]
[null,"Step 2. Select the pricing model applicable to engagement type."]
[null,"Step 3. Select whether this engagement is a secondment or not."]
[null,"Step 4. Enter estimated engagement start and end dates in the following format DD/MM/YY."]
[null,"Step 5. Provide the list of proposed resources specifying: resource type, daily rate, and estimated working days. Refer to Sheet 4 - Resource Type Definition Guide."]
[null,"Step 6. Provide additional discount rate as % if applicable."]
[null,"Step 7. Input estimated expenses."]
[]
[null,"Tips: \n1. All manual inputs fields are highlighted in yellow.\n2. Ensure macros are enabled within this workbook.\n3. The form will not allow daily rates and estimated expenses exceeding the caps in the standard commercial framework.\n4. Engagement start and end dates are limited between 1/1/2018 - 31/12/2029."]
[]
[null,"For further assistance/enquiries with this form, please contact NSW Procurement Service Centre on:\n1800 679 289 or email professionalservices@treasury.nsw.gov.au"]

{"sheet":"Compliance Template","index":1,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[28,1,28,3],[30,4,30,5],[31,4,31,5],[32,4,32,5],[33,3,33,5],[36,4,36,5],[37,4,37,5],[35,1,35,5],[32,1,32,2],[33,1,33,2],[0,3,0,4],[15,2,16,2],[15,3,16,3],[15,4,16,4],[5,1,5,5],[11,3,11,5],[15,5,16,5],[12,1,13,2],[15,1,16,1],[12,4,12,5],[13,4,13,5],[14,4,14,5],[11,1,11,2],[2,2,3,5],[1,2,1,5],[4,3,4,4]]}
[null,null,null,"P&MS Scheme (SCM005)"]
[null,null,"Supplier engagement - Compliance Checklist for standard commercial framework"]
[null,null,"Suppliers to complete and attach this checklist when submitting their offer by selecting Grouped engagement type from 1 - 6, which are mapped to the Engagement Types 1 -12 (BAS) of the P&MS Scheme to confirm that the standard commercial framework requirements have been met."]
[]
[null,null,null,"Agency Reference no."]
[null,"Grouped Engagement Type"]
[]
[]
[]
[]
[]
[null,"Pricing model",null,"Timeframe"]
[null,null,null,"Start Date\n(DD/MM/YY)"]
[null,null,null,"End Date\n(DD/MM/YY)"]
[null,"Secondment",null,"Duration1 \n(working days)",{"$f":"IF(E13=\"\",\"\",IF(NETWORKDAYS(E13,E14)<0,0,NETWORKDAYS(E13,E14,'Working Holidays'!B2:M10)))","v":""}]
[null,"Engagement","Resource Types","Daily rate (ex GST) ","Estimated days\n(1 day = 8 hrs)","Total costs \n(ex GST)"]
[]
[null,null,null,null,null,{"$f":"D18*E18","v":0}]
[null,null,null,null,null,{"$f":"D19*E19","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"$D$28*$E$28","v":0}]
[null,"Total estimated days2|Total costs:",null,null,{"$f":"SUM(INDIRECT(\"E18:E\"&ROW()-1))","v":0},{"$f":"SUM(INDIRECT(\"F18:F\"&ROW()-1))","v":0}]
[]
[null,"Discount structure (%)",{"$f":"IF('Capped Rates'!$C$4=\"TRUE\",10%,VLOOKUP(F29,'Discount Structure'!A10:C14,2,TRUE))","v":0},"Additional discount (%)\n(If applicable)"]
[null,"Maximum expenses estimated**\n(ex GST)",null,null,{"$f":"IF(C31=\"\",(F29*(Add_Discount)),(F29*(C31+Add_Discount)))","v":0}]
[null,"**Expenses are capped at 7% of total engagement cost after discount",null,"Total engagement cost\nafter discount\n(ex GST)",{"$f":"F29-E32","v":0}]
[null,"Estimated engagement cost after discounts and expenses (ex GST)",null,{"$f":"Max_Expenses+Total_Eng_After_Disc","v":0}]
[]
[null,"Internal (client) sign-off"]
[null,"Name",null,"Role"]
[null,"Signature",null,"Date"]

{"sheet":"P&MS Engagement Types Overview","index":2,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[8,1,12,1],[8,4,12,4],[13,1,15,1],[13,4,15,4]]}
[]
[null,"P&MS Scheme (SCM0005) - Engagement Types Overview"]
[null,"The Standard Commercial Framework applies to Engagement Types 1 to 12 that are mapped to 6 high level groupings. "]
[null,"Grouped Engagement Types","P&MS Scheme Eng. No.","Engagement Type","Sub-engagement Types"]
[null,"Government & Business Strategy",1,"Government & Business Strategy","1a. Strategy development and planning, \n1b. Strategic business case, \n1c. Business performance reviews, \n1d. Organisational design / transformation, \n1e. Business intelligence, \n1f. Cost management,\n1g. Governance, \n1h. Policy review / development"]
[null,"Financial Services",5,"Financial Services","5a. Accounting services, \n5b. Accounting standards,\n5c.  Finance process reviews, \n5d. Asset management, \n5e. Valuations, \n5f. Financial / economic advisory services,\n5g. Forensic advisory"]
[null,"Audit, Quality Assurance and Risk",6,"Audit, Quality Assurance and Risk","6a. Internal / external audit, \n6b. Risk management, \n6c. Probity services"]
[null,"Marketing and Customer",10,"Marketing and Customer","10a. Market research, \n10b. Customer / customer experience, pricing"]
[null,"Operations",2,"Business Processes","2a. Business process mapping / re-engineering,\n3a. Project management, \n4a. Change management,\n8a. Human capital management, \n8b. Culture, \n8c. Work health and safety (WHS), \n8d. Remuneration, \n8e. Retention, \n8f. Diversity, \n9a. Procurement / sourcing, \n9b. Category management, \n9c. Procurement accreditation, \n9d. Supply chain"]
[null,null,3,"Project Management"]
[null,null,4,"Change Management"]
[null,null,8,"Human Resources"]
[null,null,9,"Procurement & Supply Chain"]
[null,"Transaction, Actuarial, Taxation",7,"Taxation","7a. Goods and services tax (GST), \n7b. Other tax services,\n11a. Actuarial services, \n12a. Transaction services"]
[null,null,11,"Actuarial Services"]
[null,null,12,"Transaction Services"]

{"sheet":"Definition Guide","index":3,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,2,23,3],[17,1,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[1,1,1,3],[2,1,2,3]]}
[]
[null,"Resource type and definitions guide"]
[null,"The following resource types to be used to obtain quotes from Suppliers. "]
[null,"Resource type","Description","Minimum years of relevant experience guide"]
[null,"Partner","Senior management member",12]
[null,"Director","Management member with deep expertise",10]
[null,"Senior Manager","Senior employee with significant specialist expertise and team leadership capabilities",8]
[null,"Manager","Junior level of entity management, specialist technical and subject matter expertise; manages assignment schedules and resource allocation",6]
[null,"Senior Consultant","Field leadership role, moderate level of technical and subject matter expertise; provides business system advice and consulting services",4]
[null,"Consultant","Performs detailed data and systems analysis, identifies risks, gathers additional data, interprets data and provides recommendations for improvement.  Higher level technical skills, broader experience base, business process & industry knowledge and requiring less supervision than an analyst",2]
[null,"Analyst","Performs data gathering and analysis with strong technical skills. Low level of industry knowledge.  Supervised by more senior members.","0 - 4"]
[]
[null,"Terms","Definition"]
[null,"Assignment","Assignment is a form of Engagement with specific Deliverables, and management of the Engagement is the responsibility of the supplier. "]
[null,"Secondment","Secondment is a form of Engagement where the Supplier’s personnel work under the Agency’s supervision and direction to provide Services and/or Deliverables.  "]
[null,"Variation","Variation means any change to an Engagement, including any addition, increase, decrease, omission, removal to or from the scope, timeframe, fees or requirements for an Engagement. "]
[]
[null,"Pricing Models"]
[null,"Pricing Model","The method used to determine the price for products and services. (e.g. Fixed Price,  Time and Material - Capped, Time and Material - Uncapped, Outcome based Risk & Reward) "]
[null,"Fixed Price","The cost for an engagement is agreed as fixed price by both parties before the engagement starts based on a defined scope and deliverables, and is not affected by the actual amount of resources utilised. However, supplier must submit the breakdown of the Fixed Price by Resource Types and Daily rates in compliance with Standard Commercial Framework. \nAny Variations in scope or deliverables after contract award may generate changes to the fixed price."]
[null,"Time and Materials- Capped","The cost for an engagement depends on the actual amount of resources required to achieve the desired outcomes and is variable. Commercials are agreed before the engagement starts at a Daily Rate level for each Resource Type (cost per day of a resource x the number of days). The supplier invoices the client for the full amount of resources utilised during a particular period up to or equal to the agreed capped amount and cannot be exceeded. Engagement cost is capped as agreed between the parties in the contract."]
[null,"Time and Materials- Uncapped","The total cost for an engagement depends on the actual amount of resources required to achieve the desired outcomes and is variable. Commercials are agreed before the engagement starts at a Daily Rate level for each Resource Type (cost per day of a resource x the number of days). The supplier invoices the client for the full amount of resources utilised during a particular period. The engagement cost is not capped."]
[null,"Risk and Reward - Outcome based","The cost for an engagement depends on the supplier’s ability to meet defined outcomes rather than for the actual resourcing requirements and expenses. The supplier is financially rewarded for exceeding expectations but risks penalty or non-payment if outcomes are not delivered. Outcomes based Risk/ Reward is often difficult to monitor and measure and may lead to disputes between parties."]
[null,"Daily","A day is defined as 8 hours of work"]

{"sheet":"Working Holidays","index":4,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Description",2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029]
["New Years Day","2018-01-01","2019-01-01","2020-01-01","2021-01-01","2022-01-01","2023-01-01","2024-01-01","2025-01-01","2026-01-01","2027-01-01","2028-01-01","2029-01-01"]
["Australia Day","2018-01-26","2019-01-28","2020-01-27","2021-01-26","2022-01-26","2023-01-26","2024-01-26","2025-01-27","2026-01-26","2027-01-26","2028-01-26","2029-01-26"]
["Good Friday","2018-03-30","2019-04-19","2020-04-10","2021-04-02","2022-04-15","2023-04-07","2024-03-29","2025-04-18","2026-04-03","2027-03-26","2028-04-14","2029-03-30"]
["Easter Monday","2018-04-02","2019-04-22","2020-04-13","2021-04-05","2022-04-18","2023-04-10","2024-04-01","2025-04-21","2026-04-06","2027-03-29","2028-04-17","2029-04-02"]
["Anzac Day","2018-04-25","2019-04-25","2020-04-25","2021-04-25","2022-04-25","2023-04-25","2024-04-25","2025-04-25","2026-04-25","2027-04-25","2028-04-25","2029-04-25"]
["Queens Birthday","2018-06-11","2019-06-10","2020-06-08","2021-06-13","2022-06-13","2023-06-12","2024-06-10","2025-06-09","2026-06-08","2027-06-14","2028-06-12","2029-06-11"]
["Labour Day","2018-10-01","2019-10-07","2020-10-05","2021-10-04","2022-10-03","2023-10-02","2024-10-07","2025-10-06","2026-10-05","2027-10-04","2028-10-02","2029-10-01"]
["Christmas Day","2018-12-25","2019-12-25","2020-12-25","2021-12-25","2022-12-25","2023-12-25","2024-12-25","2025-12-25","2026-12-25","2027-12-25","2028-12-25","2029-12-25"]
["Boxing Day","2018-12-26","2019-12-26","2020-12-26","2021-12-26","2022-12-26","2023-12-26","2024-12-26","2025-12-26","2026-12-26","2027-12-26","2028-12-26","2029-12-26"]

{"sheet":"Capped Rates","index":5,"n_rows":8,"n_cols":17,"rows_kept":8,"cut":false,"hidden":true,"merged":[[0,8,0,14]]}
[null,"Index","Value",null,null,null,null,null,"Standardised NSW Government Role Type1",null,null,null,null,null,null,null,"Engagement"]
["Engagement Type",1,{"$f":"IF('Capped Rates'!B2=1,\"Government and business strategy\",IF('Capped Rates'!B2=2,\"Audit, Quality Assurance and Risk\",IF('Capped Rates'!B2=3,\"Marketing and Customer\",IF('Capped Rates'!B2=4,\"Financial Services\",IF('Capped Rates'!B2=5,\"Operations\",IF('Capped Rates'!B2=6,\"Transaction, Actuarial, Taxation\"))))))","v":"Government and business strategy"},null,"2022-03-31",null,null,null,"Partner","Director","Senior Manager","Manager","Senior Consultant","Consultant","Analyst",null,"Initial engagement"]
["Pricing Model",2,{"$f":"IF('Capped Rates'!B3=1, \"Fixed Price\", IF('Capped Rates'!B3=2,\"Time and materials - capped\",IF('Capped Rates'!B3=3,\"Risk/reward - outcome based\", IF('Capped Rates'!B3=4, \"Time and  materials - uncapped\"))))","v":"Time and materials - capped"},null,null,null,null,"Government and Business Strategy",3600,3000,2600,2100,1750,1340,1085,null,"Variation "]
["Secondment",2,{"$f":"IF(B4=1, \"TRUE\", \"FALSE\")","v":"FALSE"},null,null,null,null,"Audit, Quality Assurance and Risk",3350,2750,2600,2100,1400,1185,980,null,"Flow-on"]
[null,null,null,null,null,null,null,"Marketing and Customer",3100,2700,2550,2100,1750,1285,1085]
[null,null,null,null,null,null,null,"Financial Services",3500,2900,2550,2100,1700,1285,1085]
[null,null,null,null,null,null,null,"Operations",3500,2900,2550,2100,1700,1285,1085]
[null,null,null,null,null,null,null,"Transaction, Actuarial, Taxation",4025,3700,3050,2450,2200,1900,1650]

{"sheet":"Discount Structure","index":6,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":true,"merged":[[0,1,0,5],[0,6,1,6],[2,6,6,6]]}
[null,null,null,null,null,null,"Secondment"]
[null,1,4.0000000000001004,10,20,50]
[0,0,0,0.01,0.03,0.04,0.1]
[4,0,0,0.03,0.04,0.05]
[12,0.01,0.03,0.04,0.05,7.0000000000000007E-2]
[24,0.03,0.04,0.05,0.08,0.08]
[40,0.04,0.05,7.0000000000000007E-2,0.08,0.1]
[]
[]
[0,0]
[250000.01,0.02]
[500000,0.05]
[1000000,7.0000000000000007E-2]