Question

Eco 3020 HW 6 Name: 4. Use Excel and the data from problem "3." to construct 2 graphs. The first should contain the ATC, AVC, and MC curves. The second should contain FC, VC, and TC curves. Note, you will have to compute values for FC, VC, and TC. That said, please include these data points in your solutions (5 pts).

Answer 1

Output	ATC	AFC	AVC	MC	TC	VC	FC
1	160	120	40	40	160	40	120
2	95	60	35	30	190	70	120
3	70	40	30	20	210	90	120
4	55	30	25	10	220	100	120
5	47	24	23	15	235	115	120
6	43	20	23	23	258	138	120

Fixed cost = TC - VC

GRAPH 1: ATC, AVC, MC COST 35 2 3 4 OUTPUT - ATC — AVC — MC

GRAPH 2: TC, VC, FC 258 235 210 220 190 160 cost 138 120 120 P 120 on 120 100 120 115 51 output -TC — VC — FC