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. Now, Y increases to $120. Recalculate the demand schedule in part 1. Use Excel’s charting tool to draw the new demand curve in the same diagram. 3. Let Y = $100 and pc = $30 again, but let pm increase to $40. Recalculate the demand schedule in part 1. Use Excel’s charting tool to draw the graph of the new demand curve. 4. 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.
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. Now, Y increases to $120. Recalculate the demand schedule in part 1. Use Excel’s charting tool to draw the new demand curve in the same diagram.
3. Let Y = $100 and pc = $30 again, but let pm increase to $40. Recalculate the demand schedule in part 1. Use Excel’s charting tool to draw the graph of the new demand
curve.
4. 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.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 6 images