Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
The worksheet tab named Problem 1 and 2 from Supplement Spreadsheet contains a model which takes as inputs the following variables: List_Price Market_Share Market_Size Percent_Discount
The worksheet tab named "Problem 1 and 2 from Supplement Spreadsheet contains a model which takes as inputs the following variables: List_Price Market_Share Market_Size Percent_Discount As discussed in class, you can do this by putting the names you want to use in one column, for instance, you could write List Price in cell A3, and then select the cell with the name you entered and the cell to its right (so select cells A3:83), then select Formulas, Create from selection, Create names from the values in the left column. Then write Market Share in cell A4, select cells A4 84 and again select formulas and create names from values in the left column, etc. 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_ShareMarket_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:20 (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 O% 5%, 10%, 15%, 20%, 25%, 30%, 35%, 40%, and 45%. QUESTION 1: What formula should you put in cell 0107 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). a
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started