Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
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
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)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/66aa3ca978818_68166aa3ca9191cf.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/66aa3caa30543_68166aa3ca9ba523.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started