undefined

B D E F G H J K M 1 Two-Variable Data Table Lesson Fees 135 140 145 130 150 155 160 Golf Lesson Pricing 2 Total Clients 80 3 Lesson Fee $160.00 4 Gross Revenue $12,800.00 5 Fixed Costs $10,509.51 6 Variable Costs $942.46 7 Net Income $1,348.03 55 60 65 701 8 75 9 80 10 Client Demand 85 11 90 12 95 13 100 105 14 15 16 17 110 115 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Break-Even Analysis LoanConditions FeesAnd Demand + 21 3 A two-variable data table that calculates revenue can help in the analysis of various client demand and lesson fee scenarios. On the FeesAnd Demand worksheet, begin to create a two-variable data table by referencing the cell that calculates net income in cell E3. 22 Apply a custom format to cell E3 so that the formula result of the referenced cell is hidden. 4 23 Finish the two-variable data table to see how the net income changes when lesson fees and client demand vary. 5 24 6 Conditional formatting will add emphasis and increase the readability of the data table. Format the cells F4:L16 as Currency. Apply conditional formatting to the range to highlight cells with a light red fill with dark red text if the value is less than 0 and apply a green fill with dark green text formatting if the values are greater than 3500. 25 0 Save and close Excel_Ch10_Prepare_Expansion Analysis_10f2. Exit Excel. Submit your files as directed Please note: This project continues in part B, which can be found in the Product Shared Library