Based upon the data within this table, how can I answer the following questions: ? How do the solar panels save electricity costs and greenhouse gas emissions?? How much of the electricity needs of the warehouses would solar panel systems produce?? What are the individual expense items and amounts that make up EBIT each year?? What happens to the cash flows in Year 6 when the solar panels no longer have a tax effect from depreciation?? Should instructions be included in the model to guide the CFO to easily run extra Goal Seek scenarios?? What is the purpose of the business case?? How much capital expenditure would the Board of Directors need to approve?? After the CEO and CFO have negotiated with the solar panels manufacturer, how should Central Arizona Storage respond to those prices?

Insource Alternative 1 |Insource Alternative 2 |Insource Alternative 3 Metric (North] [South] (Combined) Outsource Alternative 1"TakImum Negotiable Solar Panel Prices $6,000.00 $4.000.00 $10,000.00 $10.000.00 Sizes of Warehouse Installations (sq. ft.) 64584.00 43056.00 107640.00 107640.00 Total Size Of All Installations (sq. ft.) 6000.00 4000.00 10000.00 10000.00 Capital Expenditures $6.000,000.00 $5,000,000.00 $10.000,000.00 $10.000,000.00 Cost per Solar Panel $1,000.00 $1,250.00 $1,100.00 $1,000.00 EBIT Impact $520.579.80 $20.198.40 $640.778.20 $650.778.20 Cash Flow Impact NPV $4.640,000.00 $3.870,000.00 $8.510,000.00 $1,347.726.61 IRR CO2 Savings in Year 1 1,126,579.80 $ 524.198.40 1.650.778.20 $ 1,650,778.20 Warehouse Electricity % Solar Generated 27.61% 16.38% 14.06% 14.06%