pictures are of the same worksheet

One-Variable Data Table New Gen Robotics wants you to analyze their Revenue, Expenses and Net Income by using a one- variable data table based on the sale of their robotic unit. 17. Select the l-Variable Data Table worksheet. 18. Input a range of units sold from 50,000 to 120,000 in increments of 5,000 starting in cell E7. 19. Create appropriate referencing to the Income Statement in cells E6:H6 in order to create a one variable table to calculate the output of Revenue, Expenses, and Net Income. 20. Apply appropriate number formatting using red in parenthesis for possible negatives. B Autofave OED File Home insert . Blankenburg Cody-BTS211 Final Sallstam..Winter 2030. Baca Page Layout Formulas Data Revie $ NewGen Robotics Carolus James A1 * J K L NewGen Robotics 2 2010 Income Statement Projected Units Sold Revenue Expenses Net Income 102,391 5 Revenue 6 Units Sold 7 Price per Unit 8 Total Revenue $399.95 $10.951.210.45 Projected 101.415 10 Variable Expenses 11 Units Produced (1% Surplus) 12 Material Cost per Unit 13 Total Material Cost 14 Manufacturing Cost per Unit 15 Total Manufacturing Cost 16 Total Variable Expenses $175.50 $18,149,316.71 $143.25 $14,814, 185.86 $12,963,502.56 18 Fixed Expenses 19 Salaries and Benefits 20 Advertising 21 Administrative 22 Miscellaneous Documentation Projected $3,450,000.00 S775,000.00 5520,000.00 $500,000.00 Logical Functions IF Functions 1 Variable Data Table What Analysis PMT with 2 Variable wa Table Statistics A Ready DOLL DU0,000.00 $5,245,000.00 23 Total Fixed Expenses 24 25 Summary 26 Total Revenue 27 Total Expenses 28 Net Income Projected $40,951,280.45 $38,208,502.56 $2,742,777.89 Documentation Statistics Logical Functions IF Functions PMT with a