9. 4.13 PEMEX, Mexico’s petroleum corporation, has an estimated budget for oil and gas exploration that includes equipment for three offshore platforms as shown. Use PW analysis to select the best alternative at a MARR of 15% per year. Select platform X, Y, or Z using

(a) tabulated factors, and

(b) single-cell spreadsheet functions, as instructed.

Table Summary: Table divided into 4 columns with the headings marked from left to right as: Platform; X; Y; and Z.

Platform X Y Z First cost, $ million −300 −450 −510 M&O, $ million per year −320 −290 −230 Salvage value, $ million 75 50 90 Estimated life, years 20 20 20 Answer