{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Open","Instructions for users","Contractual Ops","Relationship","Future","Results","Actions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":7,"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":"Open","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Instructions for users","index":1,"n_rows":51,"n_cols":3,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"Supplier Management Program"]
[null,null,"Once the pilot implementation is completed, all  contracts should be reviewed and validated on a regular basis. It is recommended that reviews are conducted at least every 6 months."]
[null,null," "]
[null,null,"The following checklists for investigation fall into three categories:"]
[null,null,"* Contractual Operations"]
[null,null,"* Relationship"]
[null,null,"* Future"]
[]
[null,null,"Contractual Operations"]
[null,null,"How well does the contract work and does it reflect the current service accurately."]
[]
[null,null,"Relationship"]
[null,null,"How well is the overall relationship doing? And are we, both UNSW and supplier, investing appropriately to ensure we are aligned with the market and ahead of the competition? "]
[]
[null,null,"Future"]
[null,null,"Market trends."]
[null,null,"What is happening in the industry? "]
[null,null,"What is the supplier’s financial & performance ranking amongst its competition? "]
[null,null,"Update on technology, business environment (e.g. compliance and risks). How do they impact UNSW and supplier?"]
[null,null,"Customer trends - where are they moving? What has changed? What is coming next?"]
[null,null,"Pricing trends - benchmarking exercise (to be executed at least annually)."]
[]
[null,null,"Structure"]
[null,null,"a.      Pre-review by UNSW only. UNSW to align and review UNSW’s results and opinions."]
[null,null,"b.      Review with UNSW and supplier. This is the face-to-face session with supplier. "]
[null,null,"c.      Post-review by UNSW only. UNSW to review and re-align UNSW position and commitment."]
[]
[null,null,"Scoring for each section is as follows"]
[null,null,"5 point rating consistently exceeds competition on every occasion."]
[null,null,"4 point rating sometimes exceeds competition."]
[null,null,"3 point rating meets contractually stated improvement/competition."]
[null,null,"2 point rating sometimes fail to meet contractually stated improvement/competition."]
[null,null,"1 point rating never meets contractually stated improvement/competition."]
[]
[null,null,"Results & Action Plan"]
[null,null,"What do the results tell us?"]
[null,null,"* Red - it's broken. Can it be fixed or do we start all over again? "]
[null,null,"* Amber - it's partially broken. Let’s fix it with tools and identify the risks."]
[null,null,"* Green - does the supplier meet expectations? Do we give them more work? "]
[null,null,"From the review, action plans are to be captured."]
[]
[null,null,"Post-Review"]
[null,null,"Do our goals need an update or do they need to be expanded?"]
[null,null,"Stakeholder analysis:  are we communicating with the right stakeholders on the supplier side? What are the new relationships we need to build or strengthen?"]
[null,null,"UNSW stakeholder communication:  what is the joint Customer Procurement communication we want to make to internal UNSW?"]
[null,null,"Business needs:  what has changed after this review?"]

{"sheet":"Contractual Ops","index":2,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":false,"merged":[[7,1,7,6],[11,3,11,4],[9,3,9,4],[10,3,10,4],[9,5,11,5],[9,6,11,6]]}
[]
[]
[]
[]
[]
[null,"Section A:  Contractual Operations"]
[]
[null,"How well does the contract work and does it accurately reflect the current service?"]
[]
[null,null,null,"For Period (insert months and year, eg. Jan-June 20XX)",null,"Grading Criteria","Score"]
[null,null,null,"Assessed by"]
[null,null,null,"UNSW"]
[null,"A1","Reporting (eg. cost and performance) completeness and accuracy",null,{"$f":"IF(SUM(E14:E19)=0,\".\",AVERAGE(E14:E19))","v":"."}]
[null,null,"(a) Are the reports in line with the contract requirements?","Select your appropriate grading",{"$f":"VLOOKUP(D14,$F$14:$G$19,2,FALSE)","v":0},"Consistently exceeds  requirements on every occasion",5]
[null,null,"(b) Are the reports accurate? Are there any factors which may affect the data?","Select your appropriate grading",{"$f":"INDEX($G$14:$G$19,MATCH(D15,$F$14:$F$19,0))","v":0},"Sometimes exceeds requirements",4]
[null,null,"(c) Do reports contain a clear summary?","Select your appropriate grading",{"$f":"INDEX($G$14:$G$19,MATCH(D16,$F$14:$F$19,0))","v":0},"Meets contractually stated improvement/competition",3]
[null,null,"(d) Did the supplier deliver an interpretation and necessary action plans with timelines?","Select your appropriate grading",{"$f":"INDEX($G$14:$G$19,MATCH(D17,$F$14:$F$19,0))","v":0},"Sometimes fail to meet contractually stated improvement/requirement",2]
[null,null,"(e) Has the supplier made efforts to simplify reports and present information clearly?","Select your appropriate grading",{"$f":"INDEX($G$14:$G$19,MATCH(D18,$F$14:$F$19,0))","v":0},"Never meets contractually stated improvement/requirement",1]
[null,null,"(f) Have reports been delivered on time and correctly distributed?","Select your appropriate grading",{"$f":"INDEX($G$14:$G$19,MATCH(D19,$F$14:$F$19,0))","v":0},"Select your appropriate grading",0]
[]
[null,"A2","Change control process (variations)",null,{"$f":"IF(SUM(E22:E27)=0,\".\",AVERAGE(E22:E27))","v":"."}]
[null,null,"(a) Has the process for changes to the contract been followed in a timely manner?","Select your appropriate grading",{"$f":"VLOOKUP(D22,$F$14:$G$19,2,FALSE)","v":0}]
[null,null,"(b) Has the supplier been proactive in following up and alerting changes against the contract?","Select your appropriate grading",{"$f":"VLOOKUP(D23,$F$14:$G$19,2,FALSE)","v":0}]
[null,null,"(c) Have requests for additional information or pricing adjustments been promptly forwarded?","Select your appropriate grading",{"$f":"VLOOKUP(D24,$F$14:$G$19,2,FALSE)","v":0}]
[null,null,"(d) Has the invoicing/charging been adjusted to reflect the impact of contract changes?","Select your appropriate grading",{"$f":"VLOOKUP(D25,$F$14:$G$19,2,FALSE)","v":0}]
[null,null,"(e) Has change information been cascaded sufficiently within the suppliers organisation?","Select your appropriate grading",{"$f":"VLOOKUP(D26,$F$14:$G$19,2,FALSE)","v":0}]
[null,null,"(f) Does the supplier highlight the (potential) impact of changes in other areas of the contract?","Select your appropriate grading",{"$f":"VLOOKUP(D27,$F$14:$G$19,2,FALSE)","v":0}]
[]
[null,"A3","Service levels",null,{"$f":"IF(SUM(E30:E33)=0,\".\",AVERAGE(E30:E33))","v":"."}]
[null,null,"(a) Are the service levels clearly understood within the supplier's organisation?","Select your appropriate grading",{"$f":"INDEX($G$14:$G$19,MATCH(D30,$F$14:$F$19,0))","v":0}]
[null,null,"(b) Are the current service levels appropriate in terms of targets and measures?","Select your appropriate grading",0]
[null,null,"(c) Is there a desire throughout the organisation to deliver above minimum service levels?","Select your appropriate grading",0]
[null,null,"(d) Does the supplier proactively manage service levels to correct any service issues, ahead of prompting?","Select your appropriate grading",0]
[]
[null,"A4","Service Credits",null,{"$f":"IF(SUM(E36:E39)=0,\".\",AVERAGE(E36:E39))","v":"."}]
[null,null,"(a) Are the service credits clearly understood within the suppliers organisation?","Select your appropriate grading",{"$f":"INDEX($G$14:$G$19,MATCH(D36,$F$14:$F$19,0))","v":0}]
[null,null,"(b) Are the current incentive rates appropriate in rewarding and driving results?","Select your appropriate grading",0]
[null,null,"(c) Does the supplier proactively manage service levels to correct any service issues, ahead of prompting?","Select your appropriate grading",0]
[null,null,"(d) Are service credits prioritised and actioned equally within the supplier processes","Select your appropriate grading",0]
[]
[null,"A5","Invoicing and payment",null,{"$f":"IF(SUM(E42:E46)=0,\".\",AVERAGE(E42:E46))","v":"."}]
[null,null,"(a) Have invoices been submitted in a timely manner?","Select your appropriate grading",{"$f":"INDEX($G$14:$G$19,MATCH(D42,$F$14:$F$19,0))","v":0}]
[null,null,"(b) Do invoices contain the necessary information to process payment efficiently?","Select your appropriate grading",0]
[null,null,"(c) Are changes easily tracked and related to the contract?","Select your appropriate grading",0]
[null,null,"(d) Are any queries handled promptly and efficiently?","Select your appropriate grading",0]
[null,null,"(e) Is there a clear escalation process in place in the event of a dispute?","Select your appropriate grading",0]
[]
[null,"A6","Continuous cost improvement",null,{"$f":"IF(SUM(E49:E53)=0,\".\",AVERAGE(E49:E53))","v":"."}]
[null,null,"(a) Has the supplier identified processes which could be improved?","Select your appropriate grading",{"$f":"INDEX($G$14:$G$19,MATCH(D49,$F$14:$F$19,0))","v":0}]
[null,null,"(b) Has the supplier been proactive in identifying opportunities for improvement?","Select your appropriate grading",0]
[null,null,"(c) How clearly have opportunities been communicated? Did this include an action plan and indicators of the cost benefit?","Select your appropriate grading",0]
[null,null,"(d) Is the supplier tracking costs/industry best practice and trends","Select your appropriate grading",0]
[null,null,"(e) How receptive is the supplier to challenging and sharing cost information?","Select your appropriate grading",0]
[]
[null,"A7","Contract Administration",null,{"$f":"IF(SUM(E56:E59)=0,\".\",AVERAGE(E56:E59))","v":"."}]
[null,null,"(a) Are insurance certificates updated and submitted by Supplier without prompting ","Select your appropriate grading",{"$f":"VLOOKUP(D56,$F$14:$G$19,2,FALSE)","v":0}]
[null,null,"(b) Where applicable, have disengagement plans be updated and submitted by supplier?","Select your appropriate grading",{"$f":"INDEX($G$14:$G$19,MATCH(D57,$F$14:$F$19,0))","v":0}]
[null,null,"(c) Where applicable have escrow deposits been updated and confirmed by supplier?","Select your appropriate grading",0]
[null,null,"(d) Are regular meetings scheduled and attended by supplier?","Select your appropriate grading",0]
[]
[null,null,"Overall on Contractual Ops",null,{"$f":"IF(SUM(E55,E48,E41,E35,E29,E21,E13)=0,\".\",AVERAGE(E13,E21,E29,E35,E41,E48,E55))","v":"."}]

{"sheet":"Relationship","index":3,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[8,0,8,5],[10,2,12,3]]}
[]
[]
[]
[]
[]
[]
["Section B:  Relationship"]
[]
["How well is the overall relationship doing? And are we, both UNSW and Supplier, investing appropriately to ensure we are aligned with / ahead of the market? "]
[]
[null,null,"Assessed by UNSW"]
[null,null,null,null,"Grading Criteria","Score"]
[]
["B1","Day-to-day relationship",null,{"$f":"IF(SUM(D15:D19)=0,\".\",AVERAGE(D15:D19))","v":"."}]
[null,"(a) Does the supplier provide valuable input to resolve daily operational issues?","Select your appropriate grading",{"$f":"VLOOKUP(C15,$E$15:$F$19,2,FALSE)","v":0},"Very cooperative and proactive in identifying issues and drives resolution. Easy to get information when needed. Supplier Account Team is aware of problems and able to resolve them.",4]
[null,"(b) Does the supplier set clear objectives and deliverables to resolve issues and organise work?","Select your appropriate grading",{"$f":"VLOOKUP(C16,$E$15:$F$19,2,FALSE)","v":0},"Cooperative and proactive in identifying issues and drives resolution. Occasionally requires prodding to deliver  or help with information. Supplier Account Team is usually aware of problems but not always resolved.",3]
[null,"(c) Does the supplier take initiative to create clarity when changing circumstances cause ambiguity?","Select your appropriate grading",0,"Often cooperative, works well with UNSW Team. Usually proactively. Identifies issues and drives resolution.",2]
[null,"(d) Does the supplier know when to escalate decisions and when to make on-the-spot decisions?","Select your appropriate grading",0,"Not cooperative",1]
[null,"(e) Does the supplier respond quickly to UNSW requests and needs, as a priority?","Select your appropriate grading",0,"Select your appropriate grading",0]
[]
["B2","Management relationship",null,{"$f":"IF(SUM(D22:D28)=0,\".\",AVERAGE(D22:D28))","v":"."}]
[null,"(a) Does the supplier provide valuable input which influences and improves the deliverables and achievements of the Team?","Select your appropriate grading",{"$f":"VLOOKUP(C22,$E$15:$F$19,2,FALSE)","v":0}]
[null,"(b) Does the supplier set clear objectives, defining metrics and key milestones to plan and organise work?","Select your appropriate grading",0]
[null,"(c) Does the supplier take initiative to create clarity when changing circumstances cause ambiguity?","Select your appropriate grading",0]
[null,"(d) Does the supplier know when to escalate decisions and when to make on-the-spot decisions?","Select your appropriate grading",0]
[null,"(e) Does the supplier respond quickly to customer/client requests and needs as a priority?","Select your appropriate grading",0]
[null,"(f) Does the supplier seek out and act on UNSW feedback?","Select your appropriate grading",0]
[null,"(g) Does the supplier work effectively within the Team and across the UNSW team? Is the supplier a good team player?","Select your appropriate grading",0]
[]
[]
[null,"Overall on Relationship",null,{"$f":"IF(SUM(D14,D21,)=0,\".\",AVERAGE(D14,D21,))","v":"."}]

{"sheet":"Future","index":4,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[9,2,11,3],[7,0,7,5]]}
[]
[]
[]
[]
[]
["Section C:  Future"]
[]
["How are we performing against the competition? "]
[]
[null,null,"Assessed by UNSW"]
[null,null,null,null,"Grading Criteria","Score"]
[]
["C1","Market trends",null,{"$f":"IF(SUM(D14:D19)=0,\".\",AVERAGE(D14:D19))","v":"."}]
[null,"(a) Has the supplier identified and understood trends and activities in the external market/industry, and the impact on UNSW?","Select your appropriate grading",{"$f":"VLOOKUP(C14,$E$14:$F$19,2,FALSE)","v":0},"Consistently exceeds expectations on every occasion.",5]
[null,"(b) Has the supplier kept UNSW updated on legal, risks and compliance issues relevant to UNSW-Supplier business success?","Select your appropriate grading",0,"Sometimes exceeds expectations.",4]
[null,"(c) Has the supplier kept UNSW updated on technological issues relevant to UNSW-Supplier business success?","Select your appropriate grading",0,"Meets contractually stated improvements.",3]
[null,"(d) Has the supplier used breakthrough thinking to generate insights, alternatives and opportunities for UNSW-Supplier success?","Select your appropriate grading",0,"Sometimes fails to meet contractually stated improvements.",2]
[null,"(e) How is the supplier's financial ranking amongst its competition?","Select your appropriate grading",0,"Never meets contractually stated improvements.",1]
[null,"(f) How is the supplier's performance ranked amongst its competition?","Select your appropriate grading",0,"Select your appropriate grading",0]
[]
["C2","Customer trends",null,{"$f":"IF(SUM(D22:D23)=0,\".\",AVERAGE(D22:D23))","v":"."}]
[null,"(a) Has the supplier shared critical expertise and knowledge to support the Team?","Select your appropriate grading",{"$f":"VLOOKUP(C22,$E$14:$F$19,2,FALSE)","v":0}]
[null,"(b) Has the supplier learnt from others and leverages best practices?","Select your appropriate grading",{"$f":"VLOOKUP(C23,$E$14:$F$19,2,FALSE)","v":0}]
[]
["C3","Pricing trends",null,{"$f":"IF(SUM(D26:D28)=0,\".\",AVERAGE(D26:D28))","v":"."}]
[null,"(a) Has the supplier kept UNSW updated on economic issues relevant to UNSW-Supplier business success?","Select your appropriate grading",{"$f":"VLOOKUP(C26,$E$14:$F$19,2,FALSE)","v":0}]
[null,"(b) Has the supplier identified a number of ways to continuously improve the business?","Select your appropriate grading",{"$f":"VLOOKUP(C27,$E$14:$F$19,2,FALSE)","v":0}]
[null,"(c ) How competitive is the supplier against the current market?","Select your appropriate grading",{"$f":"VLOOKUP(C28,$E$14:$F$19,2,FALSE)","v":0}]
[]
[null,"Overall on Future",null,{"$f":"IF(SUM(D13,D21,D25)=0,\".\",AVERAGE(D13,D21,D25))","v":"."}]

{"sheet":"Results","index":5,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[7,3,7,4],[8,3,8,4],[21,2,21,3]]}
[]
[]
[]
[]
[null,null,"Review between UNSW and Supplier Results"]
[]
[]
[null,null,"What are the results?",{"$f":"'Contractual Ops'!D10:G10","v":"For Period (insert mth & year; e.g. Jan-June 20XX)"}]
[null,null,null,"Assessed by"]
[null,null,null,"UNSW","Supplier"]
[null,null,{"$f":"'Contractual Ops'!C61","v":"Overall on Contractual Ops"},{"$f":"'Contractual Ops'!E61","v":"."},{"$f":"'Contractual Ops'!#REF!","v":"."}]
[null,null,{"$f":"Relationship!B31","v":"Overall on Relationship"},{"$f":"Relationship!D31","v":"."},{"$f":"Relationship!#REF!","v":"."}]
[null,null,{"$f":"Future!B30","v":"Overall on Future"},{"$f":"Future!D30","v":"."},{"$f":"Future!#REF!","v":"."}]
[]
[null,null,"Results Weightage"]
[null,null,"Contractual Operations x 45%",{"$f":"D11*45%","v":{"$error":"#VALUE!"}},{"$f":"45%*E11","v":{"$error":"#VALUE!"}}]
[null,null,"Relationship x 30%",{"$f":"30%*D12","v":{"$error":"#VALUE!"}},{"$f":"30%*E12","v":{"$error":"#VALUE!"}}]
[null,null,"Future x 25%",{"$f":"25%*D13","v":{"$error":"#VALUE!"}},{"$f":"25%*E13","v":{"$error":"#VALUE!"}}]
[null,null,"Total - 100%",{"$f":"SUM(D16:D18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E16:E18)","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,"What do the results tell us?"]
[null,null,"Results","Status","Actions"]
[null,null,"Green  -  Total @ 75%-100%","Working well.","How well is it? How can we develop this relationship further?"]
[null,null,"Amber  -  Total @ 60%-74%","Its partially broken.","Let's fix it."]
[null,null,"Red  -  Total @ 59% & lower","Its broken.","Can it be fixed? Or do we start all over again?"]

{"sheet":"Actions","index":6,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Review between UNSW and Supplier"]
[null,"Agreed Actions Plan"]
[]
[null,null,"Category","Issue description","Agreed action s","Owner","Start date","Completion date"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,null,null,"Add more rows as required"]