{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["KPI and Intervention assessment","ROA Worksheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":72,"comments":1,"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":"KPI and Intervention assessment","index":0,"n_rows":96,"n_cols":12,"rows_kept":96,"cut":false,"hidden":false,"merged":[[4,1,5,11],[20,1,21,11],[36,1,37,11],[52,1,53,11],[68,1,69,11],[47,9,47,10],[47,3,47,4],[47,5,47,6],[47,7,47,8],[39,11,40,11],[39,5,39,6],[39,7,39,8],[39,9,39,10],[39,3,39,4],[31,3,31,4],[31,5,31,6],[55,11,56,11],[71,11,72,11],[55,3,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[87,11,88,11],[87,7,87,8],[87,9,87,10],[71,3,71,4],[71,5,71,6],[71,7,71,8],[84,1,85,11],[31,7,31,8],[31,9,31,10],[7,11,8,11],[23,11,24,11],[15,3,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[7,9,7,10],[23,3,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[7,3,7,4],[7,5,7,6],[7,7,7,8],[95,3,95,4],[95,5,95,6],[95,7,95,8],[95,9,95,10],[63,3,63,4],[63,5,63,6],[63,7,63,8],[63,9,63,10],[79,3,79,4],[79,5,79,6],[79,7,79,8],[79,9,79,10],[71,9,71,10],[87,3,87,4],[87,5,87,6]]}
[]
["OPTION 1"]
[]
["Title:","Business as usual / Do nothing"]
["Description:","This option involves no change to existing practice with minimal maintenance and security upgrades to existing facilities."]
[]
[]
[null,null,null,"Benefit 1",null,"Benefit 2",null,"Benefit 3 ",null,"Benefit 4 ",null,"Weighted \nBenefit Score"]
[null,null,null,0.4,0.25,0.2,0.15,0,0,0,0]
[null,"Interventions","%","KPI 1\nFaster cargo through-put","KPI 2\nIncreased and more diverse cargo","KPI 1Improved Port security","KPI 2\nReduced frequency of crashes","KPI 1","KPI 2","KPI 1","KPI 2"]
[null,"Undertake essential maintenance and security upgrades only of existing facilities",1,0,0,1,0,0,0,0,0]
[null,"<Intervention 2>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 3>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 4>",null,0,0,0,0,0,0,0,0]
[null,"KPI Score",{"$f":"SUM(C11:C14)","v":1},{"$f":"D9*SUM(D11:D14)/2","v":0},{"$f":"E9*SUM(E11:E14)/2","v":0},0.1,0,0,0,0,0]
[null,"Benefit Total",null,{"$f":"D15+E15","v":0},null,{"$f":"F15+G15","v":0.1},null,{"$f":"H15+I15","v":0},null,{"$f":"J15+K15","v":0},null,{"$f":"SUM(D16:K16)","v":0.1}]
[]
["OPTION 2"]
[]
["Title:","Close port and divert activities to Newtown Port"]
["Description:","This option focuses on closing the Oldtown Port and diverting all demand to the Newtown Port. Additional capacity both at Newtown Port and along access roads will be built to cater for increased throughput and traffic. While the Oldtown Port will be decommissioned and assets sold the site and infrastructure will still require some maintenance and security improvements."]
[]
[]
[null,null,null,"Benefit 1",null,"Benefit 2",null,"Benefit 3 ",null,"Benefit 4 ",null,"Weighted \nBenefit Score"]
[null,null,null,{"$f":"Benefit1KPI1Rating","v":0.4},{"$f":"Benefit1KPI2Rating","v":0.25},{"$f":"Benefit2KPI1Rating","v":0.2},{"$f":"Benefit2KPI2Rating","v":0.15},{"$f":"Benefit3KPI1Rating","v":0},{"$f":"Benefit3KPI2Rating","v":0},{"$f":"Benefit4KPI1Rating","v":0},{"$f":"Benefit4KPI2Rating","v":0}]
[null,"Interventions","%",{"$f":"Benefit1KPI1","v":"KPI 1\nFaster cargo through-put"},{"$f":"Benefit1KPI2","v":"KPI 2\nIncreased and more diverse cargo"},{"$f":"Benefit2KPI1","v":"KPI 1Improved Port security"},{"$f":"Benefit2KPI2","v":"KPI 2\nReduced frequency of crashes"},{"$f":"Benefit3KPI1","v":"KPI 1"},{"$f":"Benefit3KPI2","v":"KPI 2"},{"$f":"Benefit4KPI1","v":"KPI 1"},{"$f":"Benefit4KPI2","v":"KPI 2"}]
[null,"Undertake additional investment at Newtown Port to respond to diverted demand, and decommission and sell  surplus Oldtown Port assets",0.5,2,1,1,0,0,0,0,0]
[null,"Upgrade and create additional capacity on access roads to Newtown port",0.35,0,0,0,1,0,0,0,0]
[null,"Undertake essential maintenance and security upgrades only of existing facilities",0.15,0,0,0,0,0,0,0,0]
[null,"<Intervention 4>",null,0,0,0,0,0,0,0,0]
[null,"KPI Score",{"$f":"SUM(C27:C30)","v":1},{"$f":"D25*SUM(D27:D30)/2","v":0.4},{"$f":"E25*SUM(E27:E30)/2","v":0.125},{"$f":"F25*SUM(F27:F30)/2","v":0.1},{"$f":"G25*SUM(G27:G30)/2","v":7.4999999999999997E-2},{"$f":"H25*SUM(H27:H30)/2","v":0},{"$f":"I25*SUM(I27:I30)/2","v":0},{"$f":"J25*SUM(J27:J30)/2","v":0},{"$f":"K25*SUM(K27:K30)/2","v":0}]
[null,"Benefit Total",null,{"$f":"D31+E31","v":0.52500000000000002},null,{"$f":"F31+G31","v":0.17499999999999999},null,{"$f":"H31+I31","v":0},null,{"$f":"J31+K31","v":0},null,{"$f":"SUM(D32:K32)","v":0.7}]
[]
["OPTION 3"]
[]
["Title:","Focus on traditional bulk commodities at Oldtown Port and divert new industries to Newtown Port"]
["Description:","This option focuses on changing the demand at OldTown Port by diverting freight and commodities associated with new industries to the Newtown Port and making Oldtown Port a specialist bulk commodities Port.  Oldtown Port will require some modernisation and improvements to security operations as well as some targeted improvements to access roads. This option will also  require additional capacity to be built at Newtown Port. "]
[]
[]
[null,null,null,"Benefit 1",null,"Benefit 2",null,"Benefit 3 ",null,"Benefit 4 ",null,"Weighted \nBenefit Score"]
[null,null,null,{"$f":"Benefit1KPI1Rating","v":0.4},{"$f":"Benefit1KPI2Rating","v":0.25},{"$f":"Benefit2KPI1Rating","v":0.2},{"$f":"Benefit2KPI2Rating","v":0.15},{"$f":"Benefit3KPI1Rating","v":0},{"$f":"Benefit3KPI2Rating","v":0},{"$f":"Benefit4KPI1Rating","v":0},{"$f":"Benefit4KPI2Rating","v":0}]
[null,"Interventions","%",{"$f":"Benefit1KPI1","v":"KPI 1\nFaster cargo through-put"},{"$f":"Benefit1KPI2","v":"KPI 2\nIncreased and more diverse cargo"},{"$f":"Benefit2KPI1","v":"KPI 1Improved Port security"},{"$f":"Benefit2KPI2","v":"KPI 2\nReduced frequency of crashes"},{"$f":"Benefit3KPI1","v":"KPI 1"},{"$f":"Benefit3KPI2","v":"KPI 2"},{"$f":"Benefit4KPI1","v":"KPI 1"},{"$f":"Benefit4KPI2","v":"KPI 2"}]
[null,"Update site security zones, expand surveillance & streamline security operations",0.1,0,0,2,0,0,0,0,0]
[null,"Implement targeted treatments to road design and signaling and reduce conflict points between freight and commuter vehicles",0.2,0,0,0,1,0,0,0,0]
[null,"Undertake limited modernisation of port facilities and services to meet existing industry needs",0.4,1,0,0,0,0,0,0,0]
[null,"Undertake additional investment at Newtown Port to respond to diverted demand, and decommission and sell surplus Oldtown Port assets",0.3,1,1,0,1,0,0,0,0]
[null,"KPI Score",{"$f":"SUM(C43:C46)","v":1},{"$f":"D41*SUM(D43:D46)/2","v":0.4},{"$f":"E41*SUM(E43:E46)/2","v":0.125},{"$f":"F41*SUM(F43:F46)/2","v":0.2},{"$f":"G41*SUM(G43:G46)/2","v":0.15},{"$f":"H41*SUM(H43:H46)/2","v":0},{"$f":"I41*SUM(I43:I46)/2","v":0},{"$f":"J41*SUM(J43:J46)/2","v":0},{"$f":"K41*SUM(K43:K46)/2","v":0}]
[null,"Benefit Total",null,{"$f":"D47+E47","v":0.52500000000000002},null,{"$f":"F47+G47","v":0.35},null,{"$f":"H47+I47","v":0},null,{"$f":"J47+K47","v":0},null,{"$f":"SUM(D48:K48)","v":0.875}]
[]
["OPTION 4"]
[]
["Title:","Expand port operating hours, minimal infrastructure"]
["Description:","This option focuses on improving the productivity of the Oldtown Port. It aims to increase utilisation of the Port infrastructure and services through expanded resources and operating hours. This will require a significant upgrade to security operations. Investment in access improvements and road design will make freight throughput  safer and journey times more reliable."]
[]
[]
[null,null,null,"Benefit 1",null,"Benefit 2",null,"Benefit 3 ",null,"Benefit 4 ",null,"Weighted \nBenefit Score"]
[null,null,null,{"$f":"Benefit1KPI1Rating","v":0.4},{"$f":"Benefit1KPI2Rating","v":0.25},{"$f":"Benefit2KPI1Rating","v":0.2},{"$f":"Benefit2KPI2Rating","v":0.15},{"$f":"Benefit3KPI1Rating","v":0},{"$f":"Benefit3KPI2Rating","v":0},{"$f":"Benefit4KPI1Rating","v":0},{"$f":"Benefit4KPI2Rating","v":0}]
[null,"Interventions","%",{"$f":"Benefit1KPI1","v":"KPI 1\nFaster cargo through-put"},{"$f":"Benefit1KPI2","v":"KPI 2\nIncreased and more diverse cargo"},{"$f":"Benefit2KPI1","v":"KPI 1Improved Port security"},{"$f":"Benefit2KPI2","v":"KPI 2\nReduced frequency of crashes"},{"$f":"Benefit3KPI1","v":"KPI 1"},{"$f":"Benefit3KPI2","v":"KPI 2"},{"$f":"Benefit4KPI1","v":"KPI 1"},{"$f":"Benefit4KPI2","v":"KPI 2"}]
[null,"Update site security zones, expand surveillance & streamline security operations",0.3,0,0,2,0,0,0,0,0]
[null,"Improve land side access for port users & separate freight and commuter traffic",0.2,0,0,0,1,0,0,0,0]
[null,"Apply additional resources (staff & outsourced services)  to support expanded operating hours",0.5,1,0,0,0,0,0,0,0]
[null,"<Intervention 4>",null,0,0,0,0,0,0,0,0]
[null,"KPI Score",{"$f":"SUM(C59:C62)","v":1},{"$f":"D57*SUM(D59:D62)/2","v":0.2},{"$f":"E57*SUM(E59:E62)/2","v":0},{"$f":"F57*SUM(F59:F62)/2","v":0.2},{"$f":"G57*SUM(G59:G62)/2","v":7.4999999999999997E-2},{"$f":"H57*SUM(H59:H62)/2","v":0},{"$f":"I57*SUM(I59:I62)/2","v":0},{"$f":"J57*SUM(J59:J62)/2","v":0},{"$f":"K57*SUM(K59:K62)/2","v":0}]
[null,"Benefit Total",null,{"$f":"D63+E63","v":0.2},null,{"$f":"F63+G63","v":0.27500000000000002},null,{"$f":"H63+I63","v":0},null,{"$f":"J63+K63","v":0},null,{"$f":"SUM(D64:K64)","v":0.47500000000000003}]
[]
["OPTION 5"]
[]
["Title:","Build capacity for future growth in demand"]
["Description:","This option focuses on  expanding capacity of Oldtown Port  and building new infrastructure to manage forecast demand and growth. Port facilities will be modernised, road access improved considerably and a major upgrade to security capacity and operations across the expanded Port site and perimeter."]
[]
[]
[null,null,null,"Benefit 1",null,"Benefit 2",null,"Benefit 3 ",null,"Benefit 4 ",null,"Weighted \nBenefit Score"]
[null,null,null,{"$f":"Benefit1KPI1Rating","v":0.4},{"$f":"Benefit1KPI2Rating","v":0.25},{"$f":"Benefit2KPI1Rating","v":0.2},{"$f":"Benefit2KPI2Rating","v":0.15},{"$f":"Benefit3KPI1Rating","v":0},{"$f":"Benefit3KPI2Rating","v":0},{"$f":"Benefit4KPI1Rating","v":0},{"$f":"Benefit4KPI2Rating","v":0}]
[null,"Interventions","%",{"$f":"Benefit1KPI1","v":"KPI 1\nFaster cargo through-put"},{"$f":"Benefit1KPI2","v":"KPI 2\nIncreased and more diverse cargo"},{"$f":"Benefit2KPI1","v":"KPI 1Improved Port security"},{"$f":"Benefit2KPI2","v":"KPI 2\nReduced frequency of crashes"},{"$f":"Benefit3KPI1","v":"KPI 1"},{"$f":"Benefit3KPI2","v":"KPI 2"},{"$f":"Benefit4KPI1","v":"KPI 1"},{"$f":"Benefit4KPI2","v":"KPI 2"}]
[null,"Achieve better alignment between port capacity & forecast demand",0.2,0,1,0,0,0,0,0,0]
[null,"Modernise port facilities & services to meet current  & projected user needs",0.5,2,1,0,0,0,0,0,0]
[null,"Improve landside access for port users & separate freight and commuter traffic",0.15,0,0,0,2,0,0,0,0]
[null,"Update site security zones, expand surveillance & streamline security operations",0.15,0,0,1,0,0,0,0,0]
[null,"KPI Score",{"$f":"SUM(C75:C78)","v":1},{"$f":"D73*SUM(D75:D78)/2","v":0.4},{"$f":"E73*SUM(E75:E78)/2","v":0.25},{"$f":"F73*SUM(F75:F78)/2","v":0.1},{"$f":"G73*SUM(G75:G78)/2","v":0.15},{"$f":"H73*SUM(H75:H78)/2","v":0},{"$f":"I73*SUM(I75:I78)/2","v":0},{"$f":"J73*SUM(J75:J78)/2","v":0},{"$f":"K73*SUM(K75:K78)/2","v":0}]
[null,"Benefit Total",null,{"$f":"D79+E79","v":0.65},null,{"$f":"F79+G79","v":0.25},null,{"$f":"H79+I79","v":0},null,{"$f":"J79+K79","v":0},null,{"$f":"SUM(D80:K80)","v":0.9}]
[]
["OPTION 6"]
[]
["Title:","<Option 6 title>"]
["Description:","<Option 6 description>"]
[]
[]
[null,null,null,"Benefit 1",null,"Benefit 2",null,"Benefit 3 ",null,"Benefit 4 ",null,"Weighted \nBenefit Score"]
[null,null,null,{"$f":"Benefit1KPI1Rating","v":0.4},{"$f":"Benefit1KPI2Rating","v":0.25},{"$f":"Benefit2KPI1Rating","v":0.2},{"$f":"Benefit2KPI2Rating","v":0.15},{"$f":"Benefit3KPI1Rating","v":0},{"$f":"Benefit3KPI2Rating","v":0},{"$f":"Benefit4KPI1Rating","v":0},{"$f":"Benefit4KPI2Rating","v":0}]
[null,"Interventions","%",{"$f":"Benefit1KPI1","v":"KPI 1\nFaster cargo through-put"},{"$f":"Benefit1KPI2","v":"KPI 2\nIncreased and more diverse cargo"},{"$f":"Benefit2KPI1","v":"KPI 1Improved Port security"},{"$f":"Benefit2KPI2","v":"KPI 2\nReduced frequency of crashes"},{"$f":"Benefit3KPI1","v":"KPI 1"},{"$f":"Benefit3KPI2","v":"KPI 2"},{"$f":"Benefit4KPI1","v":"KPI 1"},{"$f":"Benefit4KPI2","v":"KPI 2"}]
[null,"<Intervention 1>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 2>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 3>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 4>",null,0,0,0,0,0,0,0,0]
[null,"KPI Score",{"$f":"SUM(C91:C94)","v":0},{"$f":"D89*SUM(D91:D94)/2","v":0},{"$f":"E89*SUM(E91:E94)/2","v":0},{"$f":"F89*SUM(F91:F94)/2","v":0},{"$f":"G89*SUM(G91:G94)/2","v":0},{"$f":"H89*SUM(H91:H94)/2","v":0},{"$f":"I89*SUM(I91:I94)/2","v":0},{"$f":"J89*SUM(J91:J94)/2","v":0},{"$f":"K89*SUM(K91:K94)/2","v":0}]
[null,"Benefit Total",null,{"$f":"D95+E95","v":0},null,{"$f":"F95+G95","v":0},null,{"$f":"H95+I95","v":0},null,{"$f":"J95+K95","v":0},null,{"$f":"SUM(D96:K96)","v":0}]

{"sheet":"ROA Worksheet","index":1,"n_rows":90,"n_cols":10,"rows_kept":90,"cut":false,"hidden":false,"merged":[[22,0,22,3],[17,0,17,3],[18,0,18,3],[19,0,19,3],[20,0,20,3],[21,0,21,3],[12,0,12,3],[13,0,13,3],[14,0,14,3],[15,0,15,3],[16,0,16,3],[4,1,5,7],[67,4,68,9],[46,0,46,3],[58,0,58,3],[61,0,61,3],[63,0,63,3],[67,0,67,2],[8,0,8,3],[9,0,9,3],[10,0,10,3],[23,0,23,3],[11,0,11,3],[34,0,34,3],[35,0,35,3],[34,4,35,4],[24,0,24,3],[32,4,32,9],[32,0,32,3],[33,0,33,3],[37,0,37,1],[38,0,38,1],[70,0,70,2],[83,1,83,9],[84,1,84,9],[50,0,50,3],[60,0,60,3],[62,0,62,3],[59,0,59,3],[52,0,52,9],[91,1,91,9],[56,0,56,3],[78,1,78,6],[75,1,75,9],[76,1,76,9],[77,1,77,9],[90,1,90,9],[87,1,87,9],[88,1,88,9],[89,1,89,9],[81,1,81,9],[64,0,64,3],[73,0,73,9],[80,1,80,9],[74,1,74,9],[70,4,71,9],[86,0,86,9],[85,1,85,9],[53,0,53,3],[26,1,26,9],[28,1,28,9],[29,1,29,9],[34,6,35,6],[34,7,35,7],[34,8,35,8],[34,9,35,9],[34,5,35,5],[45,0,45,3],[43,0,43,3],[82,1,82,9],[79,1,79,7],[40,0,40,1],[2,1,3,7],[47,0,47,3],[51,0,51,3],[55,0,55,3],[41,0,41,1],[48,0,48,9],[49,0,49,3],[8,4,8,9],[54,0,54,3],[44,0,44,3],[25,0,25,9],[42,0,42,9],[39,0,39,1],[27,1,27,9],[30,1,30,9],[36,0,36,3]]}
[]
[null,null,null,null,null,null,null,null,"Department:","<department name>"]
[null,"Delivering customer-focused, efficient and secure port services",null,null,null,null,null,null,"Investor:","<first name surname>"]
[null,null,null,null,null,null,null,null,"Facilitator:","<first name surname>"]
[null,"Upgrade and expansion of Oldtown Port",null,null,null,null,null,null,"Initial Workshop:","<did/mm/yyyy>"]
[null,null,null,null,null,null,null,null,"Version No.:","<e.g. 0.1, 1.0 etc.>"]
[null,null,null,null,null,null,null,null,"Last Modified by:","<first name surname did/mm/yyyy >"]
[]
[null,null,null,null,"Response options"]
["Interventions",null,null,null,"Option 1","Option 2","Option 3","Option 4","Option 5","Option 6"]
[null,null,null,null,{"$f":"Option1Title","v":"Business as usual / Do nothing"},{"$f":"Option2Title","v":"Close port and divert activities to Newtown Port"},{"$f":"Option3Title","v":"Focus on traditional bulk commodities at Oldtown Port and divert new industries to Newtown Port"},{"$f":"Option4Title","v":"Expand port operating hours, minimal infrastructure"},{"$f":"Option5Title","v":"Build capacity for future growth in demand"},{"$f":"Option6Title","v":"<Option 6 title>"}]
["Undertake essential maintenance and security upgrades only of existing facilities",null,null,null,1,0.15]
["Undertake additional investment at Newtown Port to respond to diverted demand, and decommission and sell  surplus Oldtown Port assets",null,null,null,null,0.5]
["Upgrade and create additional capacity on access roads to Newtown port",null,null,null,null,0.35]
["Update site security zones, expand surveillance & streamline security operations",null,null,null,null,null,0.1,0.3,0.15]
["Implement targeted treatments to road design and signaling and reduce conflict points between freight and commuter vehicles",null,null,null,null,null,0.2]
["Undertake limited modernisation of port facilities and services to meet existing industry needs",null,null,null,null,null,0.4]
["Undertake additional investment at Newtown Port to respond to diverted demand, and decommission and sell surplus Oldtown Port assets",null,null,null,null,null,0.3]
["Improve land side access for port users & separate freight and commuter traffic",null,null,null,null,null,null,0.2]
["Apply additional resources (staff & outsourced services)  to support expanded operating hours",null,null,null,null,null,null,0.5]
["Achieve better alignment between port capacity & forecast demand",null,null,null,null,null,null,null,0.2]
["Modernise port facilities & services to meet current  & projected user needs",null,null,null,null,null,null,null,0.5]
["Improve landside access for port users & separate freight and commuter traffic",null,null,null,null,null,null,null,0.15]
[]
["Total",null,null,null,{"$f":"SUM(E12:E24)","v":1},1,1,1,1,0]
["NOTES"]
[1,"The range of interventions that could respond to the identified problem and deliver the KPIs for the expected benefits are listed in the left-hand column.  "]
[2,"Against the listed interventions a spread of response options are structured to provide genuine alternative approaches to the problem."]
[3,"Response options should be titled to reflect the underlying strategy."]
[4,"The shaded boxes indicate which interventions are used in each response and the percentage (%) indicates the relative importance of each specific intervention within the response.  \nThe total should be 100%."]
[5,"This is a balance of two factors: the importance of the intervention in delivering the response option, and the likely effort/cost involved."]
[]
[null,null,null,null,"Response options"]
["Benefits",null,null,null,"Option 1","Option 2","Option 3","Option 4","Option 5","Option 6"]
[null,null,null,null,{"$f":"E11","v":"Business as usual / Do nothing"},"Close port and divert activities to Newtown Port","Focus on traditional bulk commodities at Oldtown Port and divert new industries to Newtown Port","Expand port operating hours, minimal infrastructure","Build capacity for future growth in demand","<Option 6 title>"]
[]
["Percentage of full benefit to be delivered",null,null,null,{"$f":"Option1WeightedBenefit","v":0.1},{"$f":"Option2WeightedBenefit","v":0.7},{"$f":"Option3WeightedBenefit","v":0.875},{"$f":"Option4WeightedBenefit","v":0.47500000000000003},{"$f":"Option5WeightedBenefit","v":0.9},{"$f":"Option6WeightedBenefit","v":0}]
["Benefit 1",null,"More efficient and customer-focused port services",0.65,{"$f":"Option1Benefit1","v":0},{"$f":"Option2Benefit1","v":0.52500000000000002},{"$f":"Option3Benefit1","v":0.52500000000000002},{"$f":"Option4Benefit1","v":0.2},{"$f":"Option5Benefit1","v":0.65},{"$f":"Option6Benefit1","v":0}]
["Benefit 2",null,"Safer and more secure port operations",0.35,{"$f":"Option1Benefit2","v":0.1},{"$f":"Option2Benefit2","v":0.17499999999999999},{"$f":"Option3Benefit2","v":0.35},{"$f":"Option4Benefit2","v":0.27500000000000002},{"$f":"Option5Benefit2","v":0.25},{"$f":"Option6Benefit2","v":0}]
["Benefit 3",null,"<Insert description here>",null,{"$f":"Option1Benefit3","v":0},{"$f":"Option2Benefit3","v":0},{"$f":"Option3Benefit3","v":0},{"$f":"Option4Benefit3","v":0},{"$f":"Option5Benefit3","v":0},{"$f":"Option6Benefit3","v":0}]
["Benefit 4",null,"<Insert description here>",null,{"$f":"Option1Benefit4","v":0},{"$f":"Option2Benefit4","v":0},{"$f":"Option3Benefit4","v":0},{"$f":"Option4Benefit4","v":0},{"$f":"Option5Benefit4","v":0},{"$f":"Option6Benefit4","v":0}]
[]
["Risk and uncertainty"]
["Risk 1 ",null,null,null,"Serious road accident involving fatalit(ies) (H)","Decommissioning & sale of existing port assets do not meet financial objectives (M)","Decommissioning & sale of existing port assets do not meet financial objectives (M)","Insufficient staff skills & resources available (M)","Appropriate zoning for port-expansion  land not obtained (H)","<Insert description and rating - H,M,L>"]
["Risk 2",null,null,null,"Breach of maritime regulations & loss of port status (M)","Efficiency savings for customers eliminated by additional freight costs to Newtown (H)","Efficiency savings for new industry customers eliminated by additional freight costs to Newtown (H)","Mismatch of demand & resource allocation leads to inefficient and expensive operations (M) ","Insufficient flexibility built into upgrades to warehousing and infrastructure  to respond to volatility in future demand  & industry shifts  (H)","<Insert description and rating - H,M,L>"]
["Risk 3",null,null,null,"Local economic growth, & its diversity, constrained (H)","Diversity of local economy constrained leading to longer-term adjustment costs & adverse social impacts (H)","Dissatisfied new industry customers relocate to interstate ports or use other freight methods (M)","Without capital investment, port services become less competitive over time & less viable (H)","Timing and locational uncertainties relating to Government's long-term requirements for a new, additional commercial port in the state impact the future  demand for Oldtown port services (H)","<Insert description and rating - H,M,L>"]
["Risk 4",null,null,null,"Serious loss or damage to cargo or other assets, leading to customer loss (H)","Scope of change and transition underestimated leading to cost & time overruns (M)","Unexpected variability  in global demand for traditional commodities impacts costs and  revenue from Oldtown port  and performance of Newtown port (H)",null,"Impacts of climate change on physical infrastructure results in frequent system failures and compromises capacity of the port (H)","<Insert description and rating - H,M,L>"]
[]
["Disbenefits"]
["Disbenefit 1",null,null,null,"Delays and costs to local importers and exporters unrelieved (H)","Higher local unemployment in short to medium term (M)","Port operations lack diversity in customer base (H)","Adverse environmental  & amenity impact of 24/7 road traffic (M)","Long-term growth of Newtown Port constrained (M)","<Insert description and criticality - H,M,L>"]
["Disbenefit 2",null,null,null,null,"Government incurs  costs of managing old site in short to medium term (M)",null,"No capacity to scale up in future (H)","Increased maintenance and asset liability for port enterprise (M)","<Insert description and criticality - H,M,L>"]
[]
["Interdependencies"]
["Interdependency 1",null,null,null,null,"Sufficient capacity at Newtown Port","Sufficient capacity at Newtown Port","Industrial agreements can be negotiated at cost-effective levels","State economic & transport policy","<Insert description and impact - H,M,L>"]
["Interdependency 2",null,null,null,null,"Willingness of port customers to relocate and change  operations","State agribusiness policy & strategy","Willingness of port customers to adjust schedules and operations","Continued growth in freight volumes as modelled ","<Insert description and impact - H,M,L>"]
[]
["Is a real options analysis workshop required? Yes/No/Maybe",null,null,null,"No","Maybe","Yes","No","Yes","<…>"]
[]
["Cost"]
["Capital total estimated investment (TEI) (range)",null,null,null,"$2-3 mil","$500-600 mil","$150-200 mil","$10-20 mil","$100-150 mil","$n mil - $n mil"]
["Net incremental output costs (range)",null,null,null,"$0.5-1 mil","$0 mil","$0 mil","$5-10 mil","$0 mil","$n mil - $n mil pa"]
["Time"]
["(Range)",null,null,null,"0-12 mm","60-84 mm","12-72 mm","12-24 mm","12-48 mm","mm-mm"]
["Ranking"]
["1-6",null,null,null,null,3,2,null,1]
[]
[]
["Overall Assessment:",null,null,null,"Option 1 is the 'business as usual' approach with a modest amount of additional resources being applied to essential security and safety upgrades but no other improvements in services or capacity.  This has low benefit delivery and fails to respond to immediate demand, security and economic growth imperatives. It largely defers a more substantive decision to further down the track. Option 2 represents a substantial change in the port provision in the region by consolidating all services in one location. This option has relatively high benefit delivery but would be costly and timely to implement and has uncertain wider economic impacts. Option 3 focuses on creating 'specialised' ports for the region which  has strong benefit delivery but may limit longer term flexibility and economic diversity in the region and for the ports' longer term operating model. Option 4 is a relatively short-term tactical response which is relatively cheap and speedy to implement.  In common with Option 1, it effectively defers a more long-term decision on the port's future whilst eroding its asset base and competitiveness. This option has lower benefit delivery than Options 2 and 3. Option 5 focuses on upgrading and expanding current capacity to meet expected demand without a fundamental change in the overall port provision in the eastern region. This option provides strong benefit delivery and represents good value for money with a manageable risk profile. However, the scale of investment and the risks and uncertainty around the demand and timing of a second container port means that a real options analysis is required."]
[]
[]
["Recommendation:",null,null,null,"Option 5 is the preferred option - it has strong benefit delivery and the risk profile can be managed. It is recommended that this option be developed through a full business case.  Oldtown port is, however, operating in an environment of some uncertainty particularly in respect of the impact of climate change on agricultural production in the region and uncertainty associated with the timing of a second container port. As a result, it is recommended that a real options analysis workshop occurs during the business case development. Options 2 and 3 are not without merit and more detailed analysis of these options should be undertaken. Either  may become viable if  key assumptions and estimations for Option 5 cannot be validated during business case development."]
[]
[]
["Notes:"]
["a","Benefits - % benefit weighting derived from ILM\nThe value the investment will provide to the organisation or its customers. Benefits are the of successfully responding to the identified problem. \nA benefit is supported by one or more key performance indicators (KPIs).  "]
["b","Benefit delivery- rank (0-Marginal, 1-Partial, 2-Full) - See Worksheet 2."]
["c","Dis-benefits - negative impacts that are likely to  occur as a direct consequence of  successfully implementing this option"]
["d","Risk - one to four of the most significant things that might result in the delivery of the the benefits being significantly different from expectations. These should include exogenous factors that may influence the investment's benefit delivery"]
["e","Interdependencies - identify external factors that  need to be in place if an intervention is to be successful"]
["f","Real options workshop - determine whether a real options, or managing uncertainty, analysis workshop is required."]
["g","Timeframe - from commencement of funding to date of full benefit delivery (not completion of the investment delivery)"]
["h","Capital TEI- range should be sufficiently reliable to provide an order of magnitude for the response"]
["i","Output costs- output costs  should be identified  as these may substantially differ between responses.  These should be the incremental costs, directly incurred as a result of the investment, net of any expected savings as a result of the investment"]
["j","Ranking - considering all factors, which response option is the preferred approach to resolving the problem?"]
["k","Overall Assessment - why was the preferred response chosen? Are there any other assessment observations?"]
["l","Recommendation - how should this investment proceed…or not?"]
["Instructions for creating Response Options Analysis Report (Word)"]
["a","Complete KPI intervention assess and then select Copy Interventions function under ROA Report"]
["b","Complete risk and uncertainty, disbenefit, interdependencies, cost, timeframe, ranking and overall assessment and recommendation fields (after relveant workshops)"]
["c","Save and select Create Report function to generate Word Report of Response Options Analysis"]