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 E5:H5 to extract data from the income analysis in the range B4:C26. In the range E5:H14, create a one-variable data table using cell C5 as the Column input cell, to calculate the revenue, expenses, and net income based on units sold. Formatting Table Comma Cu Algriment Number Sty Units sold 3. 4750 B 1 Four Winds Energy Boreas Wind Turbine Income Analysis F Net Income $216.750 Revenue Units sold Price per unit 7 Total revenue 9 10 11 Varable Expenses Units produced Material cost per unit 12 Total material cost 13 Manufacturing cost per unit 14 Total manufacturing cost 15 Total variable expenses Break Even Analysis Units Sold Revenue Expenses 4,750 $1,139 4,750 $5.410,250 $5.193.500 2,700 5,410,250 3,250 3,750 4,250 4,750 4.750 $515 5,250 2,446,250 5,750 $225 6.250 1,068,750 6,750 3,515,000 10 17 Fixed Expenses 18 Salaries and benefits $ 833.500 $216.750 1039 Net Income Analys Saies Price $1.030 19 Distribution 535.000 2,750 20 Miscellaneous 310,000 3.250 21 Total fixed expenses 1,678,500 3.750 22 4.250 23 Summary 4.750 24 Total revenue 5,410,250 5,250 25 Total expenses 5,103,500 0.750 20 Net income $ 216,750 6.250 27 6.750 28 29 31 $1.139 $1.339 $1.329