How can I organize, score, and prioritize my portfolio based on the attached screenshots?

You are managing an enterprise-level portfolio for a large utility company. There are limited capital dollars for investment (STRATEX) as well as capitalized maintenance (CAPEX) and operating expenses (OPEX) that are available for funding necessary projects for the organization. The preferred ratio is 30-40-30, but there have been multiple variations over the years based on the needs of the organization. As with all utilities, the state regulatory commission controls the amount of profit income that are not profit restricted are always preferable for the increased profit potential. Commercial generation (power created and sold to other utilities) is also preferred because of the decreased operational cost. International business operations have proven to be unreliable. Though the profit potential on many of the international plants is substantial, so are the risks and the costs. The company has also made public announcements announcing its move to cleaner energy sources including increasing the amount of energy produced through renewable energy sources. This means replacing or converting coal- burning plants to integrated gasification combined cycle (), decommissioning older plants that cannot be converted, and adding new plants to produce energy via wind, solar, and water. There are also regulatory-driven projects that must be executed to remain in compliance with North American Electric Reliability Corporation (NERC), Federal Energy Regulatory Commission (), and other regulatory bodies. Limiting operational cost is a priority, but the company has also made a commitment internally that all internal hardware and software must be supported by the vendor to limit technology risks. Last, but not least, are the public service expectations of the company to clean up retired plant sites by returning them to green fields and contributing to the communities in which they provide power service. Projects must be initiated and funded with appropriate documentation and notication. The company is willing to invest $6.75 billion in projects this year with over $8 billion in potential projects being submitted. Review the list provided (see PzMT 550 Case Study Portfolio Requests) to make a determination about which projects should move forward. Your selections must bejustified based on the information presented. Project Name summary Expected TPC Contingency Total Program Name Potential Regulatory Sponsoring Organization Funding Source Profit Potential Location Asset Available IT Available Available LOB Available Ability to Business Alignment to Enterprise (in Millions) Regulatory Impact Requirement Resources Engineering Resources PM/PC xecute Value Business Value (WIN) Resources Resources Goals 401 North Site In Cumberland County The 401 North Site is a 532 acre property located near the Highway 401 and 31.92 Site Readiness Distribution CAPEX North es Limited Igh Moderate Moderate Interstate 295 Interchange In Cumberland County. It is well suited for industrial use a Moderate Program Carolina it has excellent infrastructure that indudes rail. Bad Creek Pumped-Storage Generating Station - Pump Perform pump maintenance as a part of the annual ourage NA Yes Yes Hydro OPEX South No NA Yes High Maintenance Limited Yes High Moderate Moderate Carolina Biomass Project . Duplin County 18 MW in Craven County, N.C; 25 MW in Duplin County, N.C. Wood Waste re-use 0.936 NA Renewable CAPEX Yes North Limited Limited Limited Low ModerateH High Carolin High Catawba-Wateree Relic befree project provides 819 megawatts (MW) of dean, economical, Hydro OPEX North High High High Moderate and renewable power, which on average is enough electricity to power 103,000 Carolina homes. The original license was issued by the FERC in y the FERC in 1958 as Duke Energy was building the 11th and largest reservoir on the Catawba River . Lake Norman. Cayuga Stadion iminate ash ponds Ash Management Yes Yes OPEX Indiana Limited High Moderate M Moderate Chatham-Siler City Site The Chatham-Siler City Advanced Manufacturing Site In Chatham County Is a 290. 145 17.4 Site Readiness Yes fires Distribution CAPEX North No Limited High Moderate Moderate Moderate are tract situated in close proximity to the Siler City Advanced Manufacturing site. Program Carolina has adjacenty to Highway 64 and will likely serve as a supplier park or commerdal support park ( nt stores, etc ) to any nearby larger project. Otrus Combined-Cyde Natural Gas Plant Project Construct a new 1,640-megawatt combined-cyde natural gas plant in Otrus County, 46.2 Natural Gas CAPEX Florida Limited Fla. The plant's first 820 megawatts are expected to come online in mid-2018, and High igh High High the second $20 megawatts are expected to come online by December 2018. Convert /atwille Plant location to Solar Farm Ualize green fields from Asheville Coal Plant redrement to build solar farm to 0.9 Western NC Renewables STRATEX Yes North Limited provide renewable energy production for western NC Yes High High High Modernization Carolina Plan Craven County The 79 acre Craven County-owned site in the Craven County Industrial Park is located 39.5 4.74 Site Readiness Distribution CAPEX Limited Moderate Moderate on U.S. Highway 70 near New Bern. This is a prime location for industrial use. Program North High Carolina Desktop Refresh year maintenance replacement of all laptop and desktop computers within the 1.85 NA NO No Shared Services OPEX Corporate company Limited High High Moderat Distribution Meter Upgrades This project will replace manually read meters with meters that can be read via 27.6 NA GOT applicationi. All EOL meters will be replaced. riburion CAPEX High High East Bend Station Eliminate ash ponds 230 Ash Management Yes Yes Coal OPEX Kersucky Limited Limited High Moderate Moderate Moderate Edwardsport IGCC eliminate ash ponds 312 9346 Ash Management Yes res Coal OPEX Indiana Limited Limited High Moderate |Moderate Moderate Fromder Project New Wind Power Stadon Build 200 MW wind farm. 22 year commercial agreement with City Ualides, who will 7.2 10.854 NFA NO NO Renewables STRATEX Yes Oklahoma No Yes Limited Yes Limited Moderate High High High service 60,000 residential customers. Acquire project in flight from another uality. Gallagher Stadon Eliminate ash ponds 230 Ash Management Yes res Coal TOPEX Indiana No Yes Limited Limited High Moderate Moderate Moderate Gibson Station Eliminate ash ponds 180 Ash Management Yes Coal OPEX Indana No Yes Limited Limited High Moderate Moderate International Energy Partnership toquire 2596 partnership stake in Saudi Arabia's National Methanol Company (NMC). 52 63.36 No No international STRATE Yes Saud Arabia N WA Yes Yes Moderate High 50/50 partnership between Saudi Basic Industries Corporation (SABIC) and CTE High High es methanol and MTBE - a gasoline addidve that reduces the emission of carbon monoxide from vehides. Jocassee Pumped Storage Generating Station = Pump Perform pump maintenance as a part of the annual ourage 12 12 NA 19 Maintenance Yes Yes Hydro OPEX South NA Limited High High Moderate Moderate Keowee-Toxaway Relicensing The Federal Energy Regulatory Commission (FERC) granted the Keowee Towaway (3.36 res Yes Carolina Hydro Project license in 1966. The Federal Power Act requires non federal hydroelectric South res High High Carolina after the original license expires, with the new license being 1 Main safety by the 114 Fukushima North 97.5 Tues Nudes CAPEX ncements for C tons required for nudear safety by the 325 Fukushima Nudear CAPEX High Moderate Moderate by by the 420 126 Fukushima Nudear CAPEX High 420 126 Fukushima Nuclear CAPEX High High Moderate safety by the Moderate Moderate safety by the 97.5 Fukushima Nudes High CAPEX Maintenance & Enhancements for Robinson Nudear Plant High Moderate Moderate ons required for nudear safety by the 380 114 Fukushima Nuclear CAPEX North High Moderate Moderate NA Hydro TOPEX Muniapal Waste Project - FL 11.3 1.356 NA CAPEX Florida High Moderate |Moderate Moderate Renewables LOW Moderate|High 27 0.324 NA No LImite newables Nantahala Relicensing Low Moderate High High y Commission (FERC) issued all six hydroelectric 3.36 15.1 Yes Hydro OPEX North High High High Moderate 145 Acres of US government 1.812 TINA STRATEX 32 New Solar Power Station |124 indiana Moderate High High High 1.485 NO New Solar Power Station 14.1 1.697 NA No Renewables CAPEX Florida Limited High High High High CAPEX 100 Yes North High 34 Newlin Farm In Haw River . Alamance County n Haw Rive High CAPEX High High acre tract with heavy power and water 12 Site Readiness Distribution High Moderate |Moderate Moderate 35 Offshore Wind Feasibility Study offshore wind power In North Renewables TOPEX North Limited To.36 North Limite Limited High Moderate Moderate 16 Retire Asheville Coal Plant r generation to natural gas 397.5 47.7 Western INC Yes Low 7 Retire Beckjord Plant Cool TOPEX North Limited High High High High 390 NA Yes 38 Retire Belton Coal Plant Coal OPEX SOUT Yes High Low Low 263 OPEX Low 31.56 Joh Management Yes 39 Retire Dan River Coal Plant 49.44 North Limited High High High 5 412 oh Management Yes OPEX Limited High High High High