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. 20. Create a two-variable data table as follows to calculate gross profit as the price and unit sales change:
Reading books is a great way to learn. Here are some of the books we recommend.
To create a two-variable data table in Microsoft Excel, you can follow these steps:
Select the range of cells that you want to use for the data table, which in this case is D4:K9.
On the Ribbon, go to the Data tab and click the What-If Analysis button. This will open a drop-down menu with various options for performing What-If analyses in Excel.
From the drop-down menu, select the Data Table option. This will open the Data Table dialog box.
In the Column Input Cell field, enter the cell reference for the column that you want to use as the input cell for the data table. In this case, the column input cell is B5, which is the cell containing the price per unit.
In the Row Input Cell field, enter the cell reference for the row that you want to use as the input cell for the data table. In this case, the row input cell is B6.
Click OK to create the data table. This will generate a two-variable data table in the selected range of cells, with the price per unit as the input cell for both the rows and the columns.