Skip to main content

Suppose that the demand curve for chocolate covered ants (CCA) is P=50-5QD, where P is the Price per pound (in dollars) of CCA and QD is the...

We're specifically asked to draw the diagram in Excel charts. To do that, we need to first make a spreadsheet in Excel, then use the charting function to actually make our charts.

Excel likes to draw charts as scatter plot graphs; so we need to find a way to draw our supply and demand curves as scatter plots.

A good way to do that is to first make a column of values for our independent variable (quantity), over a suitable range. Since the demand is P = 50 - 5 Q, it makes sense to go from Q = 0 to Q = 10, and steps of 1 make sense. (If it had been 500 - 5 Q for example, we might have wanted to do Q = 0 to Q = 100 in steps of 10 instead.) Let's make that column A.

Then make a column for supply and a column for demand, and enter the supply and demand curves as formulas, and copy those into each cell in the appropriate column.

For supply the equation "P = 5 Q" becomes the Excel formula "= 5*A2".

For demand the equation "P = 50 - 5 Q" becomes the Excel formula "= 50 - 5*A2".

As you copy-paste the formula from cell to cell, notice how it changes the "A2" to "A3", etc. as necessary to make it correspond to the column next to it. Excel will do this automatically; if you don't want it to do this, use dollar signs, e.g. "$A$2".

Now graph these, and the result should come out something like the first part of the image I posted (it may vary depending on your precise graph settings and colors). Make sure to choose a line graph and set the first column as the label.

Now we want to add the price ceiling. That should be drawn as a flat line at P = 10, so just make a whole column for the price ceiling that is 10 all the way down. The result should look like the second part of the image I posted.

To complete our diagrams, we should also add some labels, which we can do right within Excel using text boxes. I've put the word "equilibrium" at the point which is the equilibrium quantity and price. These versions form the third and fourth part of my image.

Customize these graphs by changing the color schemes or adding more labels.

In terms of the actual economics, notice how the price ceiling reduces the quantity sold from 5 to 2 while reducing the price from $25 to $10. It also creates a shortage, because the demand at $10 is 40 but only 5 are actually available for sale. This is in general what a binding price ceiling will do; it reduces the quantity sold and creates shortages.

Comments

Post a Comment

Popular posts from this blog

What is the meaning of "juggling fiends" in Macbeth?

Macbeth is beginning to realize that the three witches have been deceiving him since he first encountered them. Like jugglers, they have kept changing their forecasts in order create confusion. This is particularly apparent when the Second Apparition they raise in Act IV,   Scene 1 tells him that no man of woman born can overcome him in hand-to-hand battle--and then Macbeth finds himself confronted by the one man he has been avoiding out of a... Macbeth is beginning to realize that the three witches have been deceiving him since he first encountered them. Like jugglers, they have kept changing their forecasts in order create confusion. This is particularly apparent when the Second Apparition they raise in Act IV,   Scene 1 tells him that no man of woman born can overcome him in hand-to-hand battle--and then Macbeth finds himself confronted by the one man he has been avoiding out of a sense of guilt, and that man tells him: Despair thy charm. And let the angel whom thou still hast serve...
Post a Comment
Read more

In Martel's Life of Pi, how does writing a diary help Pi Patel build on his leadership skills?

At the end of chapter 73, Pi first divulges the fact that he had started a diary after about a week alone at sea. Pi claims that he wrote about "practical stuff" (208) such as what he caught for food, foreseeable problems and solutions, Richard Parker, and reflections about specific events that occurred. In a sense, Pi is the captain of his ship; therefore, he must take responsibility for himself and his crew. He can... At the end of chapter 73, Pi first divulges the fact that he had started a diary after about a week alone at sea. Pi claims that he wrote about "practical stuff" (208) such as what he caught for food, foreseeable problems and solutions, Richard Parker, and reflections about specific events that occurred. In a sense, Pi is the captain of his ship; therefore, he must take responsibility for himself and his crew. He can do this by writing down events, problems and solutions, and reflections to look back on when confronted with repeated problems. It can ...
Post a Comment
Read more

Why did Tybalt attack and kill Mercutio instead of Romeo, who he had originally been targeting?

Though Tybalt's quarrel is with Romeo, he begins the momentous duel in Act 3 by fighting with and killing Mercutio instead. Tybalt ultimately attacks Mercutio because the garrulous and hot-headed character insults Tybalt and goads him into a duel to protect Romeo's honor. From the beginning of the encounter in Act 3, Scene 1, it's clear that Mercutio is itching for a fight. For instance, when Tybalt signals that he wants to talk to Mercutio... Though Tybalt's quarrel is with Romeo, he begins the momentous duel in Act 3 by fighting with and killing Mercutio instead. Tybalt ultimately attacks Mercutio because the garrulous and hot-headed character insults Tybalt and goads him into a duel to protect Romeo's honor. From the beginning of the encounter in Act 3, Scene 1, it's clear that Mercutio is itching for a fight. For instance, when Tybalt signals that he wants to talk to Mercutio and Benvolio, Mercutio responds "And but one word with one of us?/ Couple it w...
Post a Comment
Read more