$$ Open the fileNP$\_$EX$19\_$EOM$8-1\_$FirstLastName$\_1.$xlsx$,$ available for download from the SAM website.

Files downloaded from the SAM website are safe and do not contain viruses, but due to a recent Microsoft policy update, macros in downloaded files are disabled by default. To complete this project, you will need to enable macros in the file. To enable macros on this file:

o For PC: Open Windows File Explorer and go to the folder where you saved the file. Right$-$click the file and choose Properties from the context menu. At the bottom of the General tab, select the Unblock checkbox and select Apply, and then click OK$.$

o For Mac: If a dialog box about macros appears, click Enable Macros.

$$ Save the file as NP$\_$EX$19\_$EOM$8-1\_$FirstLastName$\_2.$xlsx by changing the $1$ to a $2.$

o If you do not see the $.$xlsx file extension in the Save As dialog box, do not type it$.$ The program will add the file extension for you automatically.

$$ With the file NP$\_$EX$19\_$EOM$8-1\_$FirstLastName$\_2.$xlsx still open, ensure that your first and last name is displayed in cell B$6$ of the Documentation sheet.

o If cell B$6$ does not display your name, delete the file and download a new copy from the SAM website.

$$ This project requires you to use the Solver add$-$in$.$ If this add$-$in is not available on the Data tab in the Analyze group $($or if the Analyze group is not available$),$ install Solver as follows:

o In Excel, click the File tab, and then click the Options button in the left navigation bar. Click the Add$-$Ins option in the left pane of the Excel Options dialog box. Click the Manage arrow, click the Excel Add$-$Ins option, and then click the Go button. In the Add$-$Ins dialog box, click the Solver Add$-$In check box and then click the OK button. Follow any remaining prompts to install Solver.

PROJECT STEPS

$1.$ Madhu Patel is a sales analyst for Four Winds Energy, a manufacturer of wind energy products, in San Antonio, Texas. Madhu is developing a workbook to analyze the profitability of the company's wind turbines. She asks you to help her analyze the sales data to determine how the company can increase profits.

Go to the Income Analysis worksheet, which lists the revenue and expenses for the Boreas wind turbine and calculates the net income. Madhu wants to compare the financial outcomes for varying amounts of turbines sold and identify the number of units the company needs to sell to break even. Madhu has already entered formulas in the range E$5$:H$5$ to extract data from the income analysis in the range B$4$:C$26.$ In the range E$5$:H$14,$ create a one$-$variable data table using cell C$5$ as the Column input cell, to calculate the revenue, expenses, and net income based on units sold.

$2.$ Madhu asks you to provide a visual representation of the break$-$even data. Create a Scatter with Straight Lines chart based on the units sold, revenue, and expenses in the data table $($range E$4$:G$14).$ Resize and position the chart so it covers the range I$3$:N$15.$

$3.$ Madhu wants to clarify the purpose of the chart and focus on the areas containing data. Use Break$-$Even Point as the chart title. Change the Minimum bound of the horizontal axis to $2,500$ and let the Maximum bound adjust automatically. Change the Minimum bound of the vertical axis to $2,000,000$ and let the Maximum bound adjust automatically.

$4.$ Madhu also wants to examine how varying sales price and volume affects net income from wind turbines. She has already entered the net income in cell E$18$ and sales prices in the range F$18$:J$18.$ For the range E$18$:J$27,$ create a two$-$variable data table using the price per unit $($cell C$6)$ as the Row input cell and the units sold $($cell C$5)$ as the Column input cell. In cell E$18,$ create a custom number format that displays "Units Sold" instead of the net income value.

$5.$ Madhu has also created two scenarios in the Income Analysis worksheet. The Current scenario assumes the current values for units sold, price, and fixed expenses $($salaries and benefits, distribution, and miscellaneous$).$ The Lower Price scenario assumes more units sold at a lower price. She also wants to create a scenario that assumes fewer units sold at a higher price. Create a scenario using the data shown in bold in Table $1$ without applying any scenarios.

Table $1$: Income Analysis Scenario Values

Scenario name Raise Price

Changing cells C$5$:C$6,$ C$18$:C$20$

Units$\_$sold $($C$5)4500$

Price$\_$per$\_$unit $($C$6)1239$

Salaries$\_$and$\_$benefits $($C$18)800000$

Distribution $($C$19)510000$

Miscellaneous $($C$20)300000$

$6.$ Use the Scenario Manager to create a Scenario Summary report that summarizes the effect of the Current, Lower Price, and Raise Price scenarios. Use the total revenue, total expenses, and net income in the range C$24$:C$26$ as the result cells. Go to the Scenario Summary worksheet and delete column D$,$ which repeats the current values.

$7.$ Return to the Income Analysis worksheet. Create a Scenario PivotTable report of the three scenarios displaying the total revenue, total expenses, and net income $($range C$24$:C$26)$ for each scenari