K 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 L 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 TP 0 12 26 41 55 68 80 91 101 110 118 125 131 136 140 143 145 146 146 MPP 0 12 14500 14 14500 14500 14500 14500 14500 15 14 13 12 11 FC 14500 1500 3000 4500 6000 7500 9000 14500 10500 10 14500 12000 13500 9 8 15000 6 5 4 3 2 1 0 14500 14500 7 14500 14500 14500 14500 14500 VLC 0 14500 14500 14500 16500 18000 19500 21000 22500 24000 25500 27000 VMC 0 540 1170 1845 2475 3060 TVC 0 2040 4170 6345 8475 10560 25060 27100 14595 29095 12600 16545 18450 5310 20310 5625 22125 5895 23895 6120 25620 27300 41800 103.5714286 154.5 28935 30525 258.0714286 43435 101.3986014 162.0629371 263.4615385 45025 100 170.4827586 270.4827586 32070 46570 99.31506849 179.8972603 279.2123288 33570 48070 99.31506849 190.479451 289.7945205 3600 4095 4545 4950 6300 6435 6525 6570 6570 TC AFC #DIV/0! AVTC #DIV/0! 128.75 ATC #DIV/0! 14500 MC #VALUE! 128.75 16540 1208.333333 1337.083333 18670 557.6923077 118.8461538 676.5384615 110.3571429 103 20845 353.6585366 113.0487805 466.7073171 22975 263.6363636 112.3636364 376 110.3571429 213.2352941 113.6029412 326.8382353 118.8461538 181.25 115.875 297.125 128.75 159.3406593 118.8461538 278.1868132 140.4545455 31045 143.5643564 122.3762376 265.9405941 154.5 32950 131.8181818 126.4090909 258.2272727 171.6666667 34810 122.8813559 130.9322034 253.8135593 193.125 36625 116 135.96 251.96 220.7142857 38395 110.6870229 141.5267176 252.2137405 257.5 40120 106.6176471 147.6838235 254.3014706 309 H ked Costs $5K interest and principle, insurance and property tax + $1 K Lawyer's retainer + $2K Government Regulation compliance manager + $1K HR/diversity compliance manager 386.25 515 772.5 1545 Column A: K units of capital Column B: L = units of labor per 40 hour week Column C: TP = Total Product = Quantity of output Column D: MPP = Marginal Physical Product Column E: FC = Fixed Cost Column F: VLC = Variable Labor Cost Column G: VMC = Variable Material Cost (parts ar Column H: TVC = Total Variable Cost VLC + VM Column I: TC = Total Cost = FC + TVC C Column J: AFC = Average Fixed Cost Fixed Cos Column K: AVTC = Average Variable Total Cost = Column L: ATC = Average Total Cost Total Cost Column M: MC = Marginal Cost = (Change in TCA (*: MC is really average MC per unit because we a
K 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 L 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 TP 0 12 26 41 55 68 80 91 101 110 118 125 131 136 140 143 145 146 146 MPP 0 12 14500 14 14500 14500 14500 14500 14500 15 14 13 12 11 FC 14500 1500 3000 4500 6000 7500 9000 14500 10500 10 14500 12000 13500 9 8 15000 6 5 4 3 2 1 0 14500 14500 7 14500 14500 14500 14500 14500 VLC 0 14500 14500 14500 16500 18000 19500 21000 22500 24000 25500 27000 VMC 0 540 1170 1845 2475 3060 TVC 0 2040 4170 6345 8475 10560 25060 27100 14595 29095 12600 16545 18450 5310 20310 5625 22125 5895 23895 6120 25620 27300 41800 103.5714286 154.5 28935 30525 258.0714286 43435 101.3986014 162.0629371 263.4615385 45025 100 170.4827586 270.4827586 32070 46570 99.31506849 179.8972603 279.2123288 33570 48070 99.31506849 190.479451 289.7945205 3600 4095 4545 4950 6300 6435 6525 6570 6570 TC AFC #DIV/0! AVTC #DIV/0! 128.75 ATC #DIV/0! 14500 MC #VALUE! 128.75 16540 1208.333333 1337.083333 18670 557.6923077 118.8461538 676.5384615 110.3571429 103 20845 353.6585366 113.0487805 466.7073171 22975 263.6363636 112.3636364 376 110.3571429 213.2352941 113.6029412 326.8382353 118.8461538 181.25 115.875 297.125 128.75 159.3406593 118.8461538 278.1868132 140.4545455 31045 143.5643564 122.3762376 265.9405941 154.5 32950 131.8181818 126.4090909 258.2272727 171.6666667 34810 122.8813559 130.9322034 253.8135593 193.125 36625 116 135.96 251.96 220.7142857 38395 110.6870229 141.5267176 252.2137405 257.5 40120 106.6176471 147.6838235 254.3014706 309 H ked Costs $5K interest and principle, insurance and property tax + $1 K Lawyer's retainer + $2K Government Regulation compliance manager + $1K HR/diversity compliance manager 386.25 515 772.5 1545 Column A: K units of capital Column B: L = units of labor per 40 hour week Column C: TP = Total Product = Quantity of output Column D: MPP = Marginal Physical Product Column E: FC = Fixed Cost Column F: VLC = Variable Labor Cost Column G: VMC = Variable Material Cost (parts ar Column H: TVC = Total Variable Cost VLC + VM Column I: TC = Total Cost = FC + TVC C Column J: AFC = Average Fixed Cost Fixed Cos Column K: AVTC = Average Variable Total Cost = Column L: ATC = Average Total Cost Total Cost Column M: MC = Marginal Cost = (Change in TCA (*: MC is really average MC per unit because we a
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
Related questions
Question
Can you please help me find the formula for colum C?
I have included how the formula's for colum J,K,L,M,N SHOULD input, but I think colum C row 2 keeps getting input wrong. I need to find the equation to input into Excel.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.Recommended textbooks for you
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education