Request for the 2015 PWC Report on Bus Rapid Transit for Wellington City

Tony Randle made this Official Information request to Wellington City Council

The request was partially successful.

From: Tony Randle

Dear Wellington City Council,

I understand from the DomPost Web Site article "Wellington bus system narrowed down to two options for rapid network" (URL: http://www.stuff.co.nz/dominion-post/new...) that the WCC has received a report from Price Waterhouse Cooper on options for Bus Rapid Transit along the Wellington City Growth Spine.

1) Could I please have a copy of the PWC Report on the options for Wellington bus rapid transit ?

2) Could I please have a copy of the detailed option costs (including how they were calculated) outlined in the PWC report ?

3) Could I please have a copy of the detailed option benefits (including how they were calculated) outlined in the PWC report ?

4) Could I please have a copy of the detailed option benefit/cost ratios (including how they were calculated) outlined in the PWC report ?

5) Could I please have a copy of the detailed option patronage estimates (including how they were calculated) outlined in the PWC report ?

If this information is held in electronic form, I would prefer the information was provided in its original and complete format.

Finally, can you please acknowledge your receipt of this information request ?

Yours faithfully,

Tony Randle

Link to this

From: BUS: IRO
Wellington City Council

Thank you for your email, sent to the Issues Resolution Office at Wellington City Council.

This email address is monitored daily. Your email will be assessed and actioned in due course.

We appreciate your patience.

Wellington City Council Issues Resolution Office.

Link to this

From: Chris Brown
Wellington City Council

Hello Mr Randle,

Thank you for submitting this request to the Council.

I will liaise with Officers with regards to the information you have requested.

Kind regards

Chris
Chris Brown | Issues Resolution Officer | Governance Directorate | Wellington City Council
P 04 801 3479
E [email address] | W Wellington.govt.nz | |

IMPORTANT: The information contained in this email may be confidential or legally privileged. It is intended solely for the recipient or recipients named in this message. Please note that if you are not the intended recipient you are not authorised to use, copy or distribute the email or any information contained in it. If you have received this email in error, please advise the sender immediately and destroy the original message and any attachments.

show quoted sections

Link to this

From: Tony Randle

Dear Chris Brown,

Thanks for the update Chris.

Can I also add a three related items of information to my request ?

6) Can I please have a copy of the Terms of Reference (or contract) for the BRT Indicative Business Case ?

7) Can I please have a copy of the membership of "The project Steering Group and Working Group" referred to in the PWC Business Case ?

8) Can I please have a copy of the minutes of the meetings of "The project Steering Group and Working Group" referred to in the PWC Business Case ?

Can you please confirm the WCC's acceptance of the above amendments to my information request ?

Yours sincerely,

Tony Randle

Link to this

From: Tony Randle

Dear Chris Brown,

Hi
At the beginning of the month I asked for some supporting information on the 2015 PWC Report on Bus Rapid Transit for Wellington City. I have yet to receive a substantive reply.
Can you please confirm when I may expect to receive a response from the WCC on this information request ?

Yours sincerely,

Tony Randle

Link to this

From: Chris Brown
Wellington City Council

Hello Tony,

I am hoping to get the response out to you today. I am just waiting for sign off.

Regards

Chris
Chris Brown | Issues Resolution Officer | Governance Directorate | Wellington City Council
P 04 801 3479
E [email address] | W Wellington.govt.nz | |

IMPORTANT: The information contained in this email may be confidential or legally privileged. It is intended solely for the recipient or recipients named in this message. Please note that if you are not the intended recipient you are not authorised to use, copy or distribute the email or any information contained in it. If you have received this email in error, please advise the sender immediately and destroy the original message and any attachments.

show quoted sections

Link to this

From: Chris Brown
Wellington City Council


Attachment IRO 4743 FYI Randle 01.pdf
689K Download View as HTML

Attachment PwC BRT Indicative business case.pdf
1.9M Download View as HTML

Attachment IRO 4743 FYI Randle 01 April minutes.pdf
1.3M Download View as HTML

Attachment IRO 4743 FYI Randle 01 June minutes.pdf
1.1M Download View as HTML

Attachment IRO 4743 FYI Randle 01 March minutes.pdf
1.0M Download View as HTML

Attachment IRO 4743 FYI Randle 01 May minutes.pdf
1.6M Download View as HTML


Hello Mr Randle,

Thank you for your patience while the Council collated the information you sought in your information request, submitted via the FYI.org.nz website.

Please find the Council response to your request, and related information, attached to this email.

Kind regards

Chris
Chris Brown | Issues Resolution Officer | Governance Directorate | Wellington City Council
P 04 801 3479
E [email address] | W Wellington.govt.nz | |

IMPORTANT: The information contained in this email may be confidential or legally privileged. It is intended solely for the recipient or recipients named in this message. Please note that if you are not the intended recipient you are not authorised to use, copy or distribute the email or any information contained in it. If you have received this email in error, please advise the sender immediately and destroy the original message and any attachments.

show quoted sections

Link to this

From: Tony Randle

Dear Chris Brown,

Thank you for the WCC response. However, the response is incomplete. This is partially because the WCC has interpreted the information requested incorrectly (refer requests 2, 3, 4 & 5) and partially because some requested information stated to be provided appears to be missing (refer requests 6, 7 & 8).

With respect to the WCC response to requests 2, 3, 4 & 5:
The WCC response to all these requests is:“This is included in the information provided as a response to question 1” i.e. included in the PWC BRT Indicative Business Case (IBC) document.

Each of the requests specifically asks for the details “including how they were calculated”. It is not possible to determine how the actual figures and scores were calculated from the PWC BRT IBC document. For example “Table 22. Costs, benefits and Benefit-cost ratios – core BRT options” (page 37) states the Capex cost for recommended option 3 has total benefits of $48.0m (NPV), total costs $20.6M (NPV) and a Benefit-cost ratio of 2.3. However, the PWC BRT IBC does not include the specific calculations (including the formula used) used to produce the option benefit and cost amounts.

In fact my request asks for a copy of the PWC BRT IBC data and calculations that were created for the project (such as by GWRC) or created by the project (often identified as “PWC calculated”). In practice I would expect to receive copies of the original calculation analysis spreadsheets used by the project to create the respective tables of costs, benefits, Benefit-cost ratios and patronage figures outlined throughout the PWC BRT IBC. I would also note that my original request states “If this information is held in electronic form, I would prefer the information was provided in its original and complete format.”

I repeat my request for copies of the detailed option costs, benefits, benefit/cost ratios and patronage (including how they were calculated) outlined in the PWC report.

With respect to the WCC response to requests 6, 7 & 8:
The WCC response appears to be incomplete in that information requested is claimed to have been provided but it is not clear that is actually attached.

Confirmation is sought from WCC that the information requested in requests 6, 7 & 8 has been provided.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
For the sake of clarity, I have detailed the exact information I still seek from the PWC BRT IBC project under my information request:

2) Could I please have a copy of the detailed option costs (including how they were calculated) outlined in the PWC report ?

PWC IBC - Main Report - Cost Related Tables:
* The spreadsheet used to create Table 19: Capital expenditure of construction ($2013 m)
* The spreadsheet used to create Table 31. Expected total capital expenditure and annual operating expenditure savings for each core BRT option ($2013 m)
* The spreadsheet used to create Table 32. Capital costs for the core BRT options, disaggregated into key components ($2013 m)
* The spreadsheet used to create Table 33. Time series of capital costs for the core options ($2013 m)
* The spreadsheet used to create Table 34. Funding required for the core BRT Options 1 - 3 ($2013 m)
* The spreadsheet used to create Table 35. Funding required for the core BRT Options 4 and 5 ($2013 m)

PWC IBC - Appendix C Cost benefit analysis technical appendix - Cost Related Table:
* The spreadsheet used to create Table 96. Expected total capex and annual opex for each BRT option ($2013 m)

Clarification: To understand how each of the option costs were calculated I asked for a copy of the supporting option costs calculations for each of the above tables in the PWC IBC ?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3) Could I please have a copy of the detailed option benefits (including how they were calculated) outlined in the PWC report ?
PWC IBC - Main Report - Benefit Related Tables:
* The spreadsheet used to create Table 15. Weights for travellers along the Newtown and Kilbirnie routes by destination
* The spreadsheet used to create Table 16. Weighted average travel time savings (2031 am peak, min)
* The spreadsheet used to create Table 17. Weighted average travel time savings for the core BRT options (2031 am peak,
* The spreadsheet used to create Table 26. Results of multi-criteria analysis – core BRT options
* The spreadsheet used to create Table 27. Unweighted aggregate MCA scores – core BRT options
* The spreadsheet used to create Table 28. Weighted aggregate MCA scores – core BRT options
* The spreadsheet used to create Table 29. Multi-criteria analysis scores for the preferred options

PWC IBC - Appendix C Cost benefit analysis technical appendix - Benefit Related Tables:
* The spreadsheet used to create Table 55. Travel time savings along the Kilbirnie route (2031 am peak, min)
* The spreadsheet used to create Table 56. Travel time savings along the Newtown route (2031 am peak, min)
* The spreadsheet used to create Table 57. Weights for travellers along the Newtown and Kilbirnie routes by destination
* The spreadsheet used to create Table 58. Weighted average travel time savings (2031 am peak, min)
* The spreadsheet used to create Table 63. Key intersections along the Newtown and Kilbirnie routes and assumed impact of the option on the delay at the intersection
* The spreadsheet used to create Table 64. Example calculation for Adelaide/John St
* The spreadsheet used to create Table 65. Travel time savings for intermediate options, relative to Option 5
* The spreadsheet used to create Table 66. Weighted average travel time savings for core options and “a” variant (2031 am peak, mins)
* The spreadsheet used to create Table 67. Weighted average travel time savings for “b” BRT options (2031 am peak, mins)
* The spreadsheet used to create Table 72. Values of time for seated bus and train passengers ($/hour, all road categories, all time periods)
* The spreadsheet used to create Table 73 a). Value of time calculations for car passengers
* The spreadsheet used to create Table 75 b). Value of time calculations for car passengers
* The spreadsheet used to create Table 74. Annualisation factors
* The spreadsheet used to create Table 75 a). Travel time savings for core BRT options (NPV, 40 years)
* The spreadsheet used to create Table 77 b). Travel time savings for BRT options (NPV, 40 years)
* The spreadsheet used to create Table 77 c). Travel time savings for BRT options (NPV, 40 years)
* The spreadsheet used to create Table 76. Value of benefit for PT infrastructure
* The spreadsheet used to create Table 77 a). Additional PT user benefits for BRT options (NPV, 40 years)
* The spreadsheet used to create Table 79 b). Additional PT user benefits for BRT options (NPV, 40 years)
* The spreadsheet used to create Table 79 c). Additional PT user benefits for BRT options (NPV, 40 years)
* The spreadsheet used to create Table 78. Assumptions on average reduction in minutes late for BRT options.
* The spreadsheet used to create Table 79. Key walking and bus stop assumptions
* The spreadsheet used to create Table 80 a). Value of walking benefits for BRT options (NPV, 40 years)
* The spreadsheet used to create Table 82 b). Value of walking benefits for BRT options (NPV, 40 years)
* The spreadsheet used to create Table 82 c). Value of walking benefits for BRT options (NPV, 40 years)
* The spreadsheet used to create Table 84 a). Emissions benefits for BRT options (NPV, 40 years)
* The spreadsheet used to create Table 86 b). Emissions benefits for BRT options (NPV, 40 years)
* The spreadsheet used to create Table 86 c). Emissions benefits for BRT options (NPV, 40 years)
* The spreadsheet used to create Table 87. Car trips to the CBD
* The spreadsheet used to create Table 88 a). Car travel time disbenefits for BRT options (NPV, 40 years)
* The spreadsheet used to create Table 90 b). Car travel time disbenefits for BRT options (NPV, 40 years)
* The spreadsheet used to create Table 90 c). Car travel time disbenefits for BRT options (NPV, 40 years)
* The spreadsheet used to create Table 89 a). VOC reduction benefits for BRT options (NPV, 40 years)
* The spreadsheet used to create Table 91 b). VOC reduction benefits for BRT options (NPV, 40 years)
* The spreadsheet used to create Table 91 c). VOC reduction benefits for BRT options (NPV, 40 years)
* The spreadsheet used to create Table 90 a). Agglomeration benefits for BRT options (NPV, 40 years)
* The spreadsheet used to create Table 92 b). Agglomeration benefits for BRT options (NPV, 40 years)
* The spreadsheet used to create Table 92 c). Agglomeration benefits for BRT options (NPV, 40 years)

PWC IBC - Appendix D Detailed multi-criteria analysis results
Benefit Related Tables:
* The spreadsheet used to create Table 105. Scores for criteria for ‘Increased economic activity’
* The spreadsheet used to create Table 106. Scores for criteria for ‘Improved multi-model network efficiency’
* The spreadsheet used to create Table 107. Scores for criteria for ‘Improved accessibility’
* The spreadsheet used to create Table 108. Scores for criteria for ‘Increased PT patronage’
* The spreadsheet used to create Table 109. Scores for criteria for ‘Improved PT user experience’
* The spreadsheet used to create Table 110. Scores for criteria for ‘Minimise emissions’
* The spreadsheet used to create Table 111. Scores for criteria for ‘Minimise impacts on physical environment / amenity’
* The spreadsheet used to create Table 112. Scores for criteria for ‘Affordable / value for money’
* The spreadsheet used to create Table 113. Scores for criteria for ‘Alignment / integration with other infrastructure & services
* The spreadsheet used to create Table 114. Scores for project objectives

Clarification: To understand how each of the option benefits were calculated I asked for a copy of the supporting option benefit calculations for each of the above tables in the PWC IBC ?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
4) Could I please have a copy of the detailed option benefit/cost ratios (including how they were calculated) outlined in the PWC report ?

PWC IBC - Main Report - Benefit Cost Analysis Related Table:
* The spreadsheet used to create Table 22. Costs, benefits and Benefit-cost ratios – core BRT options

PWC IBC - Appendix C Cost benefit analysis technical appendix - Benefit Cost Analysis Related Tables:
* The spreadsheet used to create Table 97. Costs, benefits and BCRs – core BRT options
* The spreadsheet used to create Table 98a. Costs, benefits and BCRs – other BRT variants
* The spreadsheet used to create Table 98b. Costs, benefits and BCRs other BRT variants
* The spreadsheet used to create Table 99. Benefit-cost ratio for core BRT options with higher value of time
* The spreadsheet used to create Table 100. Benefit-cost ratio for core BRT options with higher construction costs
* The spreadsheet used to create Table 101. Benefit-cost ratio for core BRT options with higher agglomeration benefits
* The spreadsheet used to create Table 102. Benefit-cost ratio for core BRT options with reduced reliability benefits
* The spreadsheet used to create Table 103. Benefit-cost ratio for core BRT options with reduced walking benefits
* The spreadsheet used to create Table 104. Benefit-cost ratio for core BRT options with reduced walking benefits

Clarification: To understand how each of the option benefit/cost ratios were calculated I asked for a copy of the supporting option benefit/cost ratio calculations for each of the above tables in the PWC IBC ?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
5) Could I please have a copy of the detailed option patronage estimates (including how they were calculated) outlined in the PWC report ?

PWC IBC - Main Report - Patronage Related Table:
* The spreadsheet used to create Table 18. Additional PT patronage for core BRT options (2031)

PWC IBC - Appendix C Cost benefit analysis technical appendix - Patronage Related Tables:
* The spreadsheet used to create Table 61. Decade growth rates in patronage
* The spreadsheet used to create Table 68. Additional PT patronage for core options and “a” variant (2031)
* The spreadsheet used to create Table 69. Additional PT patronage for “b” BRT options (2031)
* The spreadsheet used to create Table 71. GWRC factor assumptions on level of priority for the options at key intersections

Clarification: To understand how each of the option patronage estimates were calculated I asked for a copy of the supporting option patronage estimate calculations for each of the above tables in the PWC IBC ?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
6) Can I please have a copy of the Terms of Reference (or contract) for the BRT Indicative Business Case ?

Question: The WCC response states a copy of the Terms of Reference for the BRT Indicative Business Case is attached but I cannot identify this document. Can the WCC confirm the Terms of Reference for the BRT Indicative Business Case was provided ?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
7) Can I please have a copy of the membership of "The project
Steering Group and Working Group" referred to in the PWC Business
Case ?
Question: The WCC response states a copy of the Steering Group Terms of Reference is attached but I cannot identify this document. Can the WCC confirm a copy of the Steering Group Terms of Reference was provided ?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
8) Can I please have a copy of the minutes of the meetings of "The project Steering Group and Working Group" referred to in the PWC Business Case ?
Question: The WCC response includes the minutes of the Nguaranga to Airport Steering Group. Is this the also the project Steering Group referred to in the PWC BRT Indicative Business Case?
Question: The WCC response includes the minutes of the Nguaranga to Airport Steering Group. Is this the also the project Working Group referred to throughout the PWC BRT Indicative Business Case?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I am happy to discuss this information request if required.

Yours sincerely,

Tony Randle

Link to this

From: Chris Brown
Wellington City Council


Attachment BRT Working Group Members.docx
44K Download View as HTML

Attachment Steering Group Terms of Reference.pdf
310K Download View as HTML

Attachment Working Group Terms of Reference.pdf
103K Download View as HTML


Hello Mr Randle,

Thank you for the below email, further stating your request.

I have spoken with WCC colleagues, who advise me that the Council does not hold the information (raw data and calculations) you are seeking. You are best served, in this request, in working directly with the NZTA, for whom PwC were directly contracting, and who were the lead agency.

Please advise me if you wish me to formally transfer your request to them, or whether you will approach them directly.

Concerning the information you advise was missing from the Council's response to parts 6-8, that was due to an attachment error. For this I apologise.

Please find attached the following documents:

Ngauranga to Airport Steering Group Terms of Reference
BRT Working Group Terms of Reference
BRT Working Group Membership

Kind regards

Chris
Chris Brown | Issues Resolution Officer | Governance Directorate | Wellington City Council
P 04 801 3479
E [email address] | W Wellington.govt.nz | |

IMPORTANT: The information contained in this email may be confidential or legally privileged. It is intended solely for the recipient or recipients named in this message. Please note that if you are not the intended recipient you are not authorised to use, copy or distribute the email or any information contained in it. If you have received this email in error, please advise the sender immediately and destroy the original message and any attachments.

show quoted sections

Link to this

Tony Randle left an annotation ()

Based on advice from the WCC, I have raised a new request to the NZTA who hold some of the information originally requested.

Link to this

Tony Randle left an annotation ()

Note my follow-up request is here: https://www.fyi.org.nz/request/3136-requ...

Link to this

Things to do with this request

Anyone:
Wellington City Council only: