Suppose that the market for video games is competitive with demand function Qd = 130 − 4p + 2Y + 3pm − 2pc, where Qd is the quantity demanded, p is the market price, Y is the monthly budget that anaverage consumer has available for entertainment, pm is the average price of a movie, and pc is the price of a controller that is required to play these games. Given that Y = $100, pm = $30, and pc = $30, use Excel to calculate quantity demanded for p = $10 to p = $80 in $5 increments. Use Excel’s charting tool to draw the demand curve. Let Y = $100, pm = $30, and pc increase to $40. Recalculate the demand schedule in part 1 and use Excel to draw the new demand curve.

Micro Economics For Today
10th Edition
ISBN:9781337613064
Author:Tucker, Irvin B.
Publisher:Tucker, Irvin B.
Chapter6: Consumer Choice Theory
Section: Chapter Questions
Problem 4SQ
icon
Related questions
Question

Spreadsheet exercises.


Suppose that the market for video games is competitive with demand function Qd = 130 − 4p + 2Y + 3pm − 2pc, where Qd is the quantity demanded, p is the market price, Y is the monthly budget that anaverage consumer has available for entertainment, pm is the average price of a movie, and pc is the price of a controller that is required to play these games.

  1. Given that Y = $100, pm = $30, and pc = $30, use Excel to calculate quantity demanded for p = $10 to p = $80 in $5 increments. Use Excel’s charting tool to draw the demand curve.
  2. Let Y = $100, pm = $30, and pc increase to $40. Recalculate the demand schedule in part 1 and use Excel to draw the new demand curve.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 6 images

Blurred answer
Knowledge Booster
Equilibrium Point
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Micro Economics For Today
Micro Economics For Today
Economics
ISBN:
9781337613064
Author:
Tucker, Irvin B.
Publisher:
Cengage,