Based off the charts below how could I categorize each column and score them to meet the organization needs?

As a manager overseeing an enterprise-level portfolio for a large utility company, you have limited capital dollars available for investment in necessary projects. These funds are categorized into STRATEX, CAPEX, and OPEX. The preferred allocation ratio for these funds is 30-40-30, but variations have been made over the years based on organizational needs.

The state regulatory commission controls the amount of profit that can be obtained from residential power generation, so the company prefers to pursue other sources of income that are not profit restricted. Commercial generation is favored due to its lower operational costs. International business operations have proved unreliable, despite their potential for substantial profits.

The company has publicly announced its commitment to cleaner energy sources, which entails replacing or converting coal-burning plants to integrated gasification combined cycle (IGCC), 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 comply with NERC, FERC, and other regulatory bodies. The company prioritizes limiting operational costs while ensuring that all internal hardware and software is supported by the vendor to mitigate technology risks.

Additionally, the company is expected to clean up retired plant sites and contribute to the communities in which they provide power service. Any projects initiated and funded must be appropriately documented and communicated.

This year, the company is willing to invest $6.75 billion in projects, with over $8 billion in potential projects submitted. Your task is to review the list of projects and determine which ones should move forward based on the information presented. Your selections must be justified using the information provided.

Project Name	Summary	Expected TPC (in Millions)	Contingency Total	Program Name	Potential Regulatory Impact (Y/N)	Regulatory Requirement (Y/N)	Sponsoring Organization	Funding Source	Profit Potential
Bad Creek Pumped-Storage Generating Station - Pump Maintenance	Perform pump maintenance as a part of the annual outage	12	1.2	N/A	Yes	Yes	Hydro	OPEX	No
Catawba-Wateree Relicensing	The Catawba-Wateree project provides 819 megawatts (MW) of clean, economical, and renewable power, which on average is enough electricity to power 103,000 homes. The original license was issued by the FERC in 1958 as Duke Energy was building the 11th and largest reservoir on the Catawba River - Lake Norman.	28	3.36	N/A	Yes	Yes	Hydro	OPEX	No

and

Location	Asset EOL?	Available IT Resources	Available Engineering Resources	Available LOB Resources	Available PM/PC Resources	Ability to execute	Business Value	Alignment to Business Goals	Enterprise Value
South Carolina	No	N/A	Yes	Limited	Yes	High	High	Moderate	Moderate
North Carolina	No	N/A	N/A	Yes	Yes	High	High	High	Moderate