I am trying to create a two variable table but I am unsure of how to do it. in this case the table will be used to show how a company how their net income would be affected by various levels of of sales and expenses. if the company increases operations, they would also have to spend more on expenses, so this table would allow them to see what levels of sales and expenses they would need in order to reach targeted net income. I need to know what I need to do.

I am using the blank table on the right to try and do this using data from the table on the left.

utoSave On BITS211 Starter File-2020 Grimes (version 1) - Saved. Developer Help 21 et Home Insert Page Layout Formulas Data Review View From TextCSV Recent Sources Queries Connections From Web Existing Connections Refresh Properties From Table/Range A- Edit Links Get Transform Data Queries & Connections TH Stocks 219 YC Geography Sort Filter Steel Advanced DataTypes Tett ta Columns - Data Tools Whe Analysis Forecast Sort & Filter 1 f SUM(814:319) B D F F Sales H of Sales K Totalles 1.10 18 800 999 1048 TO 1 Cost of Goods Sold Main Store 2.000 1.500 3.500 % of Cost of Goods 579 131 1001 Total Cost of Goode sol Gross Profit 5 15.300 Expenses % of Expenses 5 raun 900 000 15 Inace laps 5 5 3 30 Net Income Goal is to decrease Leasingespense from 58% to 50% Gel Am Data Sheet Data Sheet Goal Seeker ar Documentation et Turmet Type here to search o 199