Markup Problem
Grader - Instructions Excel 2016 Project
Chapter 6 Markup Problem 3 (v2)
Project Description:
In this problem, you will calculate the prices for products at a convenience store using the markup rule. You will determine the reason for the high price elasticity of gasoline and the relationship between elasticity and the amount of the markup.
Steps to Perform:
|
Step |
Instructions |
Points Possible |
|
1 |
Start Excel. Download and open the workbook named: Chapter_6_Markup_Problem_3_Start. |
0 |
|
2 |
In cell F7, by using cell references, calculate the price using the markup rule. Use cells D7 and E7. Copy the formula from cell F7 down the column to cell F14. |
1 |
|
3 |
In cells E16-F16, determine the likely cause of the high price elasticity of gasoline purchased from your store. |
1 |
|
4 |
In cell C18, determine whether the relationship between elasticity and the amount of the markup is positive, negative, or there is no relationship. |
1 |
|
5 |
Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. |
0 |
|
Total Points |
3 |
Created On: 07/05/2019 1 Chapter 6 Markup Problem 3 (v2)