Question: Using EXCEL, complete the following question: The total costs for Morris Industries are summarized in the following table. Q FC VC TC AFC AVC ATC
Using EXCEL, complete the following question:
The total costs for Morris Industries are summarized in the following table.| Q | FC | VC | TC | AFC | AVC | ATC | MC | |
| 0 | 1000 | |||||||
| 10 | 2000 | |||||||
| 20 | 2500 | |||||||
| 30 | 3800 | |||||||
| 40 | 6000 | |||||||
| 50 | 10,000 | |||||||
| 60 | 16,000 |
a. Complete the table.
b. Graphically illustrate the MC and price line.
c. If the price of the product is 300, what is the profit maximizing output level (illustrate on your graph)?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
