Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

The following questions address some of the price and output decisions faced by

ID: 1178907 • 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.


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

give me your email id. I will mail you the solution.


Thanks