Purchase Solution

How to make SUpply & Demand Graphs on Excel

Not what you're looking for?

Ask Custom Question

Question #4. Lawn mowing services are supplied by a host of individuals in the suburb of Westbrook. Demand and supply conditions in the perfectly competitive domestic for lawn mowing services are:
P = $75 - 1.75QD (Demand)
P = $2QS (Supply)
where P is price per lawn mowed and Q is quantity of lawns mowed per day.

a.) Algebraically determine the equilibrium industry price/output combination. I have already solved the problem, I need help with b.)

Equilibrium Price = $40
Equilibrium Quantity = 20

b.) Confirm this by graphing industry demand and supply curves (Using excel). For the graph, use prices: 10, 20, 30, 40, 50, 60, 70, 80, 90 and Quantities: 5, 10, 15, 20, 25, 30, 35, 40, 45.

Please provide a step by step illustration to graphing this problem in Excel.

Attachments
Purchase this Solution
Solution Summary

The solution will help you create Suppy & Demand Graphs using Excel. Contain a step by step explanation.

Solution Preview

Please find attached the Excel file.

Based on the Price and Quantity data (given) i have calculated the Demand and Supply from the formula using Excel.
P = $75 - 1.75QD (Demand)
P = $2QS (Supply)

The table generated contains all the data needed to plot the graph.

If you use MS ...

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

View More Free Quizzes
Related BrainMass Solutions

  • Demand & Supply Graphs

    Demand and supply graphs are depicted. The demand increases less than supply increases are examined.

  • Summer session Managerial Economics Week 5 Assignment

    Helpful Directions for drawing S and D graphs: To draw the supply and demand graphs in Excel, I suggest you create a table with 3 columns in Excel by following these basic steps: I-Label the columns in your table as: Price, Qd, Qs For the price column

  • Business Mathematics

    From the graph of this function we can derive accurate information on the following: What happens to the supply as the price increases? What happens to the demand as the price increases?

  • Supply and Demand Graphs: Watermelon Market

    Use a demand and supply graph to demonstrate how this is possible. Be sure to carefully label the curves in your graph and to clearly indicate the equilibrium summer price and the equilibrium winter price.

  • Calculating consumer and producer surplus

    How would this change the consumer and producer surplus? Suppose a price floor of $16 was imposed. How would this change the consumer and producer surplus? Please refer attached MS Excel file for graphs.

  • Production decisions given changes in demand and supply.

    See graphs below for demonstration. The following solution outlines how a firm makes production decisions to maximize profit by setting MR=MC. Given expected changes in demand and supply, I demonstrate how the firms output will be affected.

  • maximize utility

    This job shows how to maximize utility.

  • Determining equilibrium quantity and price

    Find the new equilibrium price and quantity, and show it on your graph. Please refer to the attached file for the complete solution. Graphs will not print here. Solution: Graph the supply and demand curves using Excel.

  • Ecomomics: Demand and Supply

    347182 Ecomomics: Demand and Supply Demand function Qd + 20 â?" P Supply Function: Qs = -10 + 2P Q1. Find the equilibrium price and quantity. Show your work Q2. Assume demand function has changed t0o Qd2 = 14-P.

View More Related Solutions