Assignment 3 NOTE: Incorporate VLOOKUP function make demand sensitive to price. (1) What is the profit under each of the following scenarios: - cenario 1 {most likelyl: discount rate is 8%, fixed cost $20,_ _ _(NOTE: Fixed cost is based on LAST THREE digits of your SUID), and unit cost is $3.00 - Scenario 2 (best case]: discount rate is 6%, fixed cost $18, _ _ _(NOTE: Fixed cost is based on LAST THREE digits of your SUID), and unit cost is $2.90 - cenario 3 (worst case]: discount rate 11%, fixed cost is $22, _ _ _(NOTE: Fixed cost is based on LAST THREE digits of your SUID), and unit cost is $3.20 Before you do (2) below, LABEL (define) cells so their names appear in the summary report. (2) Use Excel's SCENARIO MANAGER to set the three above scenarios and generate a summary report showing the scenario assumptions and the profit. (3) Assuming scenario (1), use a one-variable DATA TABLE to show how profit varies as the discount rate varies between 6% and 11% in increments of 1%. (4) Assuming scenario (1), use a two-variable DATA TABLE to show how profit varies as the discount rate varies from 6% to 11% in increments of 1% and the unit price varies from $3.30 to $3.70 in increments of 10 cents. (5) Assuming scenario (1), use GOAL SEEKING to find what discount rate would yield a profit of $000. Goal seek set agg profit to $500 by changing the disc rate