Shell has over 13,000 gas stations in the United States. In addition to gasoline, the gas stations also sell convenience items, such as snacks, non-alcoholic beverages, wine, beer, and hot food. Suppose you work for a gas station and your boss asks you to develop a pricing strategy for bottled local wine. The demand function is ? = 100 – 4?, where ? is the monthly quantity demanded of the bottled wine and ? is the price of the bottled wine. The marginal cost per bottle of wine is $5. Complete the following tasks: 1) (Calculating) In the worksheet “Q2 Calculations” of the provided Excel file, enter formulas in columns B-D to calculate Q (quantity demanded), MC (marginal cost), and MR (marginal revenue). Please round your results to one decimal place. Note that the inverse demand function is ? = 25 − 0.25? and that the MR function can be derived from the inverse demand function using the formula introduced in Module 5. You may find it helpful to review the Excel file for Chapter 11.
Shell has over 13,000 gas stations in the United States. In addition to gasoline, the gas stations also sell convenience items, such as snacks, non-alcoholic beverages, wine, beer, and hot food. Suppose you work for a gas station and your boss asks you to develop a pricing strategy for bottled local wine. The demand function is ? = 100 – 4?, where ? is the monthly quantity demanded of the bottled wine and ? is the price of the bottled wine. The marginal cost per bottle of wine is $5. Complete the following tasks:
1) (Calculating) In the worksheet “Q2 Calculations” of the provided Excel file, enter formulas in columns B-D to calculate Q (quantity demanded), MC (marginal cost), and MR (marginal revenue). Please round your results to one decimal place. Note that the inverse demand function is ? = 25 − 0.25? and that the MR function can be derived from the inverse demand function using the formula introduced in Module 5. You may find it helpful to review the Excel file for Chapter 11.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
