D E F G H 1 2 3 4 List_Price Market Share Market Size Percent_Discount S 6 40 30% 200 10% 36 Net Price Sales Volume Revenue Without Discount Revenue With Discount Net Cost of Discount 60 2400 2160 240 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 23 24 25 27 28 29 30 31 Denk With input values entered as follows List_Price = 40 (so, enter 40 in cell B3 which is the cell named List_Price) etc Market_Share = 30% Market_Size 200 Percent_Discount 10% The model calculates the following: Net_Price List_Price*(1-Percent_Discount) Sales_Volume = Market_Share*Market_Size Revenue_Without_Discount = List_Price*Sales_Volume Revenue_With_Discount = Net_Price*Sales_Volume Net_Cost_of_Discount = Revenue_Without_Discount - Revenue_With_Discount YOUR TASK: In cells D10:120 (the green area), create a data table which will calculate the Net_Cost_of_Discount for input values for market size of 100, 150, 200, 250, and 300, and input values of Percent Discount of 0%, 5%, 10%, 15%, 20%, 25%, 30%, 35%, 40%, and 45%. QUESTION 1: What formula should you put in cell D10? a) Leave it blank b) =Net_Cost_of_Discount c) =Profit d) =Sales_Volume*List_Price-Net_Price e) None of the above QUESTION 2: What value appears in cell F18? Hint: It is an integer (Enter the value, for instance, if your answer is that 1357 appears in cell F18 enter 1357 in the answer box with no spaces, no decimal point)