PhD Macroeconomics question

Cost of a firm is an outlay of funds for productive resources. Costs are derived function and are derived from production function.

From the given data in the attachment, please complete the remaining cost variables. Complete this assignment in word document and excel. Do not use AI. 

See all the attachments for notes and data.

1. Below is a list of the relationships between various costs.

     1. TVC + TFC = TC

     2. AVC = TVC/Q

     3. AFC = TFC/Q

     4. ATC = TC/Q

     5. MC = change in TC/change in Q.

2. Plot the ATC and MC on the graph and explain their relationship.

3. Why MC is key indicator of cost function analysis?