Simple Data Tables - Two Input One Output
- 01:43
Learn to build a two input, one output data table
Transcript
You can also use data tables to measure the effect on a single output when two inputs are used. Okay, so in this example, what we're going to do is link our profitability into this corner cell here. So that is my 57,950 from earlier on.
We're already sensitizing on the price from $3.50 up to $4.50, like we did before. But this time, we're also going to sensitize on the unit cost. So we are gonna take that from 0.35 up to 0.55, and our original assumption was 0.45. So for this to happen, we need to select the entire range. Again, we've got to include all of our sensitivity variables. This time, we've got two sets. We've got those on the left-hand side. These are our column input cells. And across the top, we've got our row input cells, as well as the calculation or the number that we want to sensitize. The shortcut, again, Alt + D + T. Okay, the row input cell is what we're sensitizing horizontally. So that's going to be the unit cost. The column input cell is what we're sensitizing vertically, so that's gonna be the price. When I press Enter, we should see that we have a full range of profitability. Okay, I'm just gonna highlight the central cell. Okay, so basically, when we've got a standard assumption of $4 for the price and 0.45 for the unit cost, it's giving us our profitability of 57,950. As the unit cost goes down, the profitability goes up, as you would expect, and same way, as the price goes up, the profitability also goes up.