Home Insert Draw Page Layout v Data Review View Tell me Formulas Queries & Connections Stocks Currencies Geography Automatic Properties Get Data (Power Query) Data from Picture Refresh All Edit Links A1 fx Unit Sales A B C D E F G H 1 Unit Sales 2 Unit Cost 3 Revenues 300 37.00 $11,100.00 4 Variable Costs $ 8,000.00 5 Foxed Costs $ 7,000.00 eg shipping cost by weight, number of shipments eg utilities, salaries 6 Net Income $ (3,000.00) 7 8 9 Data Table 10 Unit Sales Revenues 11 0 12 50 13 100 14 150 15 200 16 250 17 300 18 350 19 400 20 450 21 500 22 550 23 600 24 650 25 700 26 750 27 800 28 850 29 900 30 950 31 1000 32 33 34 35 36 37 38 39 40 41 42 43 44 1 Variable Data Table 1 Variable Data Table Part 2 + M Q20 fx A B 1 Unit Sales 2 Unit Cost $ 3 Revenues 300 37.00 $11,100.00 4 Variable Costs 5 Fixed Costs 6 Net Income 7 8 9 10 Unit Sales $8,000.00 $ 7,000.00 $ (3,900.00) Data Table: Revenues C D Net Income eg shipping cost by weight, number of shipments eg utilities, salaries 11 0 12 50 13 100 14 150 15 200 16 250 17 300 18 350 19 400 20 450 21 500 22 550 23 600 24 650 25 700 26 750 27 800 28 850 29 900 30 950 31 1000 32 33 34 35 36 37 38 39 40 41 42 43 44 4 1 Variable Data Table 1 Variable Data Table Part 2 + H K L M N 0 Points Step Instructions Possible 1 Open the file Wk 05 One Variable Data Table Source file. 0 2 On the 1 Variable Data Table sheet, select A10:B31. Create a single variable 5 data table to calculate the Revenue based on Unit Sales 3 On the 1 Variable Data Table Part 2 sheet, select A10:C31. Simultaneously 5 create two single variable data tables to calculate the Revenue and Net Income based on Unit Sales 4 Save and close the Wk 05 One Variable Data Table Source file 5 Submit for grading