Just need help with CBA Sheet at bottom

Using the modified 5-question approach, analyze the ethicality of the decision to (or not to) incorporate the new technology and make a fully supported recommendation to the Board of Directors. Supplement this analysis with a Cost-Benefit Analysis (CBA) table.

You will need to reference your CBA in your recommendation to the board. Make sure you thoroughly detail your recommendation with reflections on the consequences of the decision, whether the decision is fair to all, and whether the decision demonstrates the virtues expected of the Board of Directors, taking relevant codes of conduct into consideration, and the company as a whole in terms of social responsibility.

The following information and assumptions should be used to complete the Cost-Benefit Analysis:

• Annual revenues from the mill average 750 million.
• Profit margin from the mill is approximately 12%.
• Implementing the new technology would take 2 full years. The first year, the company would operate at 55% capacity (assume the company could maintain the 12% profit margin during reduced operations). During the second year, it would need to be completely shut down. After the 2 year period, the mill could reopen and operate at pre-implementation levels.
• Approximate cost of litigation including medical costs for all affected by the contamination, environmental sanctions, legal and court costs, victims' pain and suffering, and several other items is 1.8 billion. Estimate present value of future costs at 20%.
• The company would spend approximately 5 million in hiring, onboarding, and training new employees after reopening as a result of several of their existing employees having to seek employment elsewhere during the shutdown.
• As a result of the layoffs and shut down, the local economy would suffer greatly. The community would be forced to implement a 3 year tax on all local business profits of 5%. The tax would be enforced for 3 years beginning after the reopening of the mill. (Assume pre-implementation profit margins when calculating this and exclude all other costs and taxes when preparing this analysis. Actual cost of new technology is 70 million.

Cost-Benefit Analysis

Benefit/Savings 100% likely 25% likely 50% likely 75% likely

Present Value (at 20%) of Possible Litigation

Cost to Implement New Technology

Decrease in Profit during Year 1

Decrease in Profit during Year 2

Actual cost of new technology

Onboarding/Training new employees

Additional Local Taxes

Net Benefit