| Excel SOLVER |
| 1 | The demand curve for a good is: |
| | Y = - .01X+.05 |
| | A. At what price, Y, can 31,500 units be sold? Use X =31,500. |
| | B. What quantity, X is demanded when Y = $2? |
| 2 | The supply curve for the good in Question 1, above, is: |
| | Y = .01X + .05 |
| | A. What value must price, Y be for 19,500 units of the good to be supplied? |
| | B. What price results in no units of the good being supplied? Use X = 0. |
| 3 | Graph the demand and supply curves from Question 1 and 2, above on a scatter plot. |
| | Label the details. |
| 4 | Indicate the slope and y-intercept terms of the following equations: |
| | A. Y = 2X + 1 |
| | B. Y = 3 |
| 5 | Suppose that Total Revenue can be represented by: |
| | TR = P*Q |
| | P = 100.50 |
| | A. What is the revenue if 60 coats are sold? Use Q =60. |
| | B. How many coats must be sold to have a TR of $6,000,000? |
| 6 | A manufacturer has fixed costs of $2000 a month. The variable costs are $4 per unit. |
| | Cost, Y =2000 + 4X |
| | A. What is the cost of producing 150,000 units? Use X = 150,000. |
| | B. How many units must be produced to have a cost of $86,500 in a month? |
| 7 | A delivery service company delivers packages that costs the firm $3.95 to deliver. |
| | The fixed costs of delivery is $56 per day. If the company charges $11.95 per package, |
| | How many packages must be delivered to break-even? |
| | How many packages must be delivered to earn $10,500 in profit? |
| 8 | TR = 540X-3X^2 |
| | TC =90X+16200 |
| | Write the profit equation. |
| | Graph the profit equation. |
| | Determine the maximum profit by finding the vertex of the profit function. |
abdussamet akca
ECOUsingEXCELSOLVER2019.xlsx
