The following questions address some of the price and output decisions faced by
ID: 1178832 • Letter: T
Question
The following questions address some of the price and output decisions faced by firms other than those found in perfect competition. Some numbers may be rounded.
Table 1
Average Fixed cost
Average Variable Cost
Average Total Cost
Marginal Cost
Price
Total Revenue
Marginal Revenue
0
$ 345.00
1
$ 180.00
$ 135.00
$ 315.00
$ 300.00
2
$ 90.00
$ 127.50
$ 217.50
$ 249.00
3
$ 60.00
$ 120.00
$ 180.00
$ 213.00
4
$ 45.00
$ 112.50
$ 157.50
$ 189.00
5
$ 36.00
$ 111.00
$ 147.00
$ 165.00
6
$ 30.00
$ 112.50
$ 142.50
$ 144.00
7
$ 25.71
$ 115.70
$ 141.41
$ 126.00
8
$ 22.50
$ 121.90
$ 144.40
$ 111.00
9
$ 20.00
$ 130.00
$ 150.00
$ 99.00
10
$ 18.00
$ 139.50
$ 157.50
$ 87.00
Questions:
Present your analysis in Microsoft Excel format. Enter non-numerical responses in the same worksheet using textboxes. If you want to learn how to use Microsoft Excel to create curves, refer to the Microsoft Excel tutorials.
Submit your documents to the W4: Assignment 2 Dropbox by Tuesday, September 10, 2013.
Output
Average Fixed cost
Average Variable Cost
Average Total Cost
Marginal Cost
Price
Total Revenue
Marginal Revenue
0
$ 345.00
1
$ 180.00
$ 135.00
$ 315.00
$ 300.00
2
$ 90.00
$ 127.50
$ 217.50
$ 249.00
3
$ 60.00
$ 120.00
$ 180.00
$ 213.00
4
$ 45.00
$ 112.50
$ 157.50
$ 189.00
5
$ 36.00
$ 111.00
$ 147.00
$ 165.00
6
$ 30.00
$ 112.50
$ 142.50
$ 144.00
7
$ 25.71
$ 115.70
$ 141.41
$ 126.00
8
$ 22.50
$ 121.90
$ 144.40
$ 111.00
9
$ 20.00
$ 130.00
$ 150.00
$ 99.00
10
$ 18.00
$ 139.50
$ 157.50
$ 87.00
Explanation / Answer
The link below has the excel file for this question. Please at least review the calculations to see that everything was added correctly.
https://www.dropbox.com/s/mczx5ob38e8gra4/COST%20PROBLEM.xlsx
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.