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.

What formula do i insert where in order to fill the range?

Conditional Format as Cell Insert = $ 1= Merge & Center ~ $ ~ % 2 00 20 Formatting ~ Table Styles F Number Styles Font Alignment pard X V f H B C A Four Winds Energy Boreas Wind Turbine Income Analysis Break-Even Analysis Units Sold Revenue Expenses Net Income Revenue 4,750 4,750 $5,410,250 $5,193,500 $216,750 Units sold Price per unit $1,139 2,750 Total revenue 5,410,250 3,250 3,750 Variable Expenses 4,250 10 Units produced 4,750 4.750 11 Material cost per unit $515 5,250 12 Total material cost 2,446,250 5,750 13 Manufacturing cost per unit $225 6.250 14 Total manufacturing cost 1,068,750 6,750 15 Total variable expenses $ 3,515,000 16 Net Income Analysis 17 Fixed Expenses Sales Price 18 Salaries and benefits $ 833,500 $ 216.750 $939 $1,039 $1,139 $1,23 Documentation Income Analysis Product Line Ready o K Accessibility. Investigate Type here to search O a W x hp 4- 4+ 19 144 mort sc @ delete # 2 % 4 & backspace E R P S D F G H K X B N M pause