Explore BrainMass
Share

# Market Forms and Cost & Profit Calculations

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Complete Table

1. Summarize your calculations and use Microsoft Excel.

2. Using Excel, draw one graph showing average fixed costs, average variable costs, average total costs, marginal revenue, and marginal costs.

3.Using the data in the table and on your graph, what is the profit maximizing, or loss minimizing level of output? Explain and justify your answers.

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

https://brainmass.com/economics/output-and-costs/market-forms-and-cost-profit-calculations-551523

#### Solution Preview

1. See the attached file.
Summary of calculations:
TFC = AFC when Q = 1, so TFC = 180
AFC = TFC/Q
AVC = TVC/Q
ATC = ...

#### Solution Summary

This solution gives a detailed explanation of all the calculations required to complete a Costs table for a firm and graph it in Microsoft Excel. The solution also explains how to determine the firm's profit-maximizing output.

\$2.19

## Market forms and optimal plant size

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

Output Average Fixed cost Average Variable Cost ATC 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:
1. Complete Table 1. Summarize your calculations and use Microsoft Excel.
2. Using Excel, draw one graph showing average fixed costs, average variable costs, average total costs, marginal revenue, and marginal costs.
3. Using the data in the table and on your graph, what is the profit maximizing, or loss minimizing level of output? Explain and justify your answers.
4. What is a normal profit? What is an economic profit? Explain your answer using examples. Are normal profits being earned in this example? Are economic prfits present for this firm in this example? Explain your answers.
5. Given the data in the table and the graph, how could you determine or identify the optimal plant size?
6. What is the difference between explicit and implicit cost? Explain your answers.
7. How would we determine if a cost is a fixed cost or a variable cost?

View Full Posting Details