Benicio has already calculated that the gross profit for the new product could be nearly $295,000 based on a unit price of $159.99 and unit sales of 22,000. He wants to see how the gross profit changes if the price or unit sales are different.
Create a two-variable data table as follows to calculate gross profit as the price and unit sales change:
For the range D4:K9, create a two-variable data table using the price per unit (cell B6) as the Row input cell.
Use the units sold (cell B5) as the Column input cell.