Directions
Each week, you will view a video that shows how to plot data in Excel. The video provides “how to do” the various parts in each problem and should only be used as a guide in completing each problem. Upon viewing the video, use the following Excel template to complete your response to each problem and submit.Make sure you incorporate the feedback from your instructor that you receive each week into your final version.
Click the link below for the Excel template:
https://www.youtube.com/watch?v=w-R4BDNxSLU
Week 2: Market Forces of Supply and Demand on: Surplus and Shortage
Problem #1
Due Date: Due by the end of Week 2 at 11:59 pm, ET.
In any market, demand is used to study the behavior of buyers, and supply is used to study the behavior of sellers and producers. In order to study the behaviors of buyers and sellers, you will use the beans market for your Portfolio Project to determine the market demand and market supply.
Demand and supply curves explain the relationship between price and quantity. Because there is a law that guides market demand and supply, the demand and supply curve shifts. This law of demand and supply assumes that every factor that affects market demand and market supply, other than price, is constant. Factors that are held constant for market demand are: income, price of related good, tastes, expectations, and number of buyers. For supply market, they are: input prices, technology, expectations, and number of sellers.
In Problem #1, you need to plot graphs in Excel to show how the demand and supply curve shifts when quantity increases or decreases at given prices.
Supply and Demand: The Beans Market
View this video to complete the problem below: https://www.youtube.com/watch?v=w-R4BDNxSLU
Answer the questions below by using the following schedule for the beans market:
Table 1 Data for Problem 1
Price
Quantity Demanded
Quantity Supplied
$5
50
20
$6
45
25
$7
40
30
$8
35
35
$9
30
40
$10
25
45
$11
20
50
$12
15
55
- Part A: Use the Excel template to graph the demand and supply curves based on the values given in the Table 1. Properly label and format the graph.
- Part B: Assume that the quantity demanded for beans rises by 30 million pounds per month for specific given price. Compute the change in demand. Plot the initial demand and supply curves on a single graph based on given values in the above table. Add the new demand curve to the graph given by this change.
- Part C: Relative to the values given in the above table, let’s assume that the quantity demanded falls by 30 million pounds per month between $5 and $10 per pound; between $10 and $12 per pounds, and the quantity demanded become zero. Plot initial the demand curve given by this change on a single graph. Graph the new demand curve given by this change.
- Part D: Assume that the quantity supplied for beans rises by 30 million pounds per month for specific given price, at the time the value for quantities supplied remain the same as shown in the table above. Plot initial demand and supply curves on a single graph based on given values in the above table. Graph the new supply curve given by this change.
- Part E: Relative to the values given in the table above, let’s assume that, the quantity supplied falls by 30 million pounds per month at prices above $8, at a price of $8 or less per pound and the quantity supplied becomes zero. Plot the initial demand and supply curves based on the values given in the table above and new supply curve given by this change on a single graph.
- PART B
- In your own words and from your learning, how can market forces of supply and demand affect interest rates and the economy.
0 comments