Please help with questions 1 and 2

i have added new pictures to make it more visible.

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 ES: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. 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 E4:14). Resize and position the chart so it covers the range 13:N15. 2. 2 Four Winds Energy Boreas Wind Turbine Income Analysis 3 Break Even Analysis Revenue Expenses $5,410,250 $5.193,500 Net Income 5216,750 Liris sold Price per unit Total revenue 4.750 $1. 139 5.410.250 5 6 7 8 o 10 11 12 13 14 De Expenses Units produced Materia cost per un Total material cont Manufacturing cost per unit Total manufacturing cost Total variable expenses Units Sold 4,750 2.750 3,250 3,750 4,250 4,730 5.250 5,750 6,250 6.750 4.750 $515 2.446,250 5225 1.068.750 3,515,000 Net Income Analysis + Soles PTICE 51.039 51.139 $930 51.239 51.329 Feste Salaries and benefits Distribution Miscelaneous Total Toed expenses 833,500 535,000 310.000 1,678,500 16 17 18 10 20 21 22 23 24 25 26 27 20 20 $216.750 2.750 3.250 3,750 4,250 4,750 5,250 5,750 0.280 6.750 Total revenue Total perses Net income 5.410.250 5.193,500 216.750 Four Winds Energy Boreas Wind Turbine Income Analysis Revenue Units sold Price per unit Total revenue Break Even Analysis Revenue Expenses $5.410.250 $5 193,500 Net Income $216.750 4,750 $1 139 5,410,250 $ Variable Expenses Units produced Material cost per unit Total material cost Manufacturing cost per unit Total manufacturing cost Total variable expenses Units Sold 4,750 2.750 3,250 3.750 4.250 4,750 5,250 5,750 6.250 6.750 4.750 5515 2,446,250 $225 1,068.750 3,515,000 $ + Net Income Analysis Sales Price $1,039 51.139 $ $939 $1.230 513 Fred Expenses Salanes and benefits Distribution Miscellaneous Total Toxed expenses 833,500 535,000 310.000 1,678,500 $ Surmay Total revenue Total expenses Net income $216,750 2,750 3.250 3.750 4.250 4,750 5,250 5.750 6,250 6.750 5,410,250 5.193,500 216.750 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 ES: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. 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 E4:14). Resize and position the chart so it covers the range 13:N15. 2. 2 Four Winds Energy Boreas Wind Turbine Income Analysis 3 Break Even Analysis Revenue Expenses $5,410,250 $5.193,500 Net Income 5216,750 Liris sold Price per unit Total revenue 4.750 $1. 139 5.410.250 5 6 7 8 o 10 11 12 13 14 De Expenses Units produced Materia cost per un Total material cont Manufacturing cost per unit Total manufacturing cost Total variable expenses Units Sold 4,750 2.750 3,250 3,750 4,250 4,730 5.250 5,750 6,250 6.750 4.750 $515 2.446,250 5225 1.068.750 3,515,000 Net Income Analysis + Soles PTICE 51.039 51.139 $930 51.239 51.329 Feste Salaries and benefits Distribution Miscelaneous Total Toed expenses 833,500 535,000 310.000 1,678,500 16 17 18 10 20 21 22 23 24 25 26 27 20 20 $216.750 2.750 3.250 3,750 4,250 4,750 5,250 5,750 0.280 6.750 Total revenue Total perses Net income 5.410.250 5.193,500 216.750 Four Winds Energy Boreas Wind Turbine Income Analysis Revenue Units sold Price per unit Total revenue Break Even Analysis Revenue Expenses $5.410.250 $5 193,500 Net Income $216.750 4,750 $1 139 5,410,250 $ Variable Expenses Units produced Material cost per unit Total material cost Manufacturing cost per unit Total manufacturing cost Total variable expenses Units Sold 4,750 2.750 3,250 3.750 4.250 4,750 5,250 5,750 6.250 6.750 4.750 5515 2,446,250 $225 1,068.750 3,515,000 $ + Net Income Analysis Sales Price $1,039 51.139 $ $939 $1.230 513 Fred Expenses Salanes and benefits Distribution Miscellaneous Total Toxed expenses 833,500 535,000 310.000 1,678,500 $ Surmay Total revenue Total expenses Net income $216,750 2,750 3.250 3.750 4.250 4,750 5,250 5.750 6,250 6.750 5,410,250 5.193,500 216.750