Complete the calculations using the “Sensitivity” Spreadshee…

Complete the calculations using the “Sensitivity” Spreadsheet. Part 1:  In the initial spreadsheet, complete a data table to test NPV sensitivity to the following: Sale price per shelf between $20 and $30 in $2 increments. Variable cost per shelf between $12.50 and $17.50 in $0.50 increments. Format this data table so that your audience will understand it without explanation.   Part 2: Copy the first spreadsheet and name it “Goal”.  The company has a goal of an NPV of $25,000 as a minimum for this project.  How many units will you have to sell to hit that target?