Consider a firm that has just built a small plant, which cost $4,000. Each unit requires $2.00 worth of materials. Each worker costs $7.00 per hour. Based on this information and using Excel, fill in the missing information in the table below.

Number of worker hours Output Fixed Cost TVC TC MC AFC AVC ATC
0 0
50 400
100 900
150 1300
200 1600
250 1800
300 1900
350 1950

Given the following table and I need to calculate the above.... have the answers and want to make sure I did this right
Total output Cost TFC TVC AFV AVC ATC MC
0 $20
10 $40
20 $60
30 $90
40

1.If MC is increasing, what is happening to the ATC? Why is this happening?
a. What does the law of diminishing returns have to do with the shape of the AVC andATC curves? Explain why those curves are U-shaped.
b. Why does the ATC curve always lie above the AVC curve? Why does the two curves move closer together, but

3. Economists estimated the following cost function for X Corporation
C = 50 + 16 Q - 2 Q² + 0.2 Q³
C = Total Cost
Q = Quantity produced per period
a. Plot the TFC, TFC and TC for the values of Q = 0, 1, 2, 3,.......... 10
b. Calculate the ATC, AVC and MTC and plot on another graph.
c. Explain the relationships betw

Suppose a business experiences a sudden increase in its fixed costs. For example, suppose property taxes increase dramatically. What impact, if any, will this have the firm's AFC (average fixed cost), AVC (average variable cost), ATC (average total cost) and MC (marginal cost) and therefore these cost curves? Why?

(See attached file for full problem description with chart and diagram)
---
1. Relationship between the costs
Exhibit 2 shows a firm's costs of production in the short run. First, complete Table 2 below. Based on the Table, answer the following:
a. Find TC, TFC and TVF for an output level of 3 units and 6 units.
b.

During the last few days the Company ABC has been running into problems with its computer system. The last run of the production cost schedule resulted in the incomplete listing shown below. From your knowledge of cost theory, fill in the blanks.
Q TC TFC TVC ATC AFC AVC MC
0 40 _____

Using the given table, find the quantity where MC = ATC. Find the quantity where ATC is at its minimum.
Find the quantity that is the most efficient operating point for the firm.
The table
Output Costs TFC TVC AFC AVC ATC MC
0 $100
1 $150
2 $225
3 $230
4 $300
5 $400

A firm has fixed costs of $60 and varable costs as indicated in the table below. Complete the table.
(a) Graph total fixed cost, total varable cost, and total cost. Explain how the law of diminishing returns influences the shapes of the variable-cost and total-cost curves.
(b) Graph AFC, AVC ATCand MC. Explain the derivat