Description
Instructions
Output | Total Variable Cost |
0 | $ 0 |
1 | $ 50 |
2 | $ 90 |
3 | $120 |
4 | $160 |
5 | $220 |
6 | $300 |
7 | $400 |
8 | $520 |
9 | $670 |
10 | $900 |
- Given the above variable cost data and assuming fixed costs equal the value of the last three digits of your MDC student ID, create a file using Excel that lists Output, Fixed Cost, Variable Cost, Total Cost, Average Fixed Cost, Average Variable Cost, Average Total Cost, and Marginal Cost. The Excel table should be constructed using formulas wherever calculations are required. An example of the table for guidance is presented on page 254 of your textbook. The formulas required are summarized on page 262.
- Using Excel, plot FC, VC, and TC in Graph A and AFC, AVC, ATC, and MC in Graph B.

Explanation & Answer

Hello, we were able to compute the Cost Measurements with the given data. Graph A and B are located at separate worksheets. Thank you for choosing Studypool. I am hoping to work with you again soon.
Output
0
1
2
3
4
5
6
7
8
9
10
Variable
Cost
0
50
90
120
160
220
300
400
520
670
900
Fixed Cost
654
654
654
654
654
654
654
654
654
654
654
Various Measures of Cost
Total Average Fixed
Average
Average Total
Cost
Cost
Variable Cost
Cost
654
704
654,00
50,00
704,00
744
327,00
45,00
372,00
774
218,00
40,00
258,00
814
163,50
40,00
203,50
874
130,80
44,00
174,80
954
109,00
50,00
159,00
1054
93,43
57,14
150,57
1174
81,75
65,00
146,75
1324
72,67
74,44
147,11
1554
65,40
90,00
155,40
Marginal C...
