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

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
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. 

12345678
se
C2
9
10
11
12
13
14
15
5
<
Undo
AK
K
1
1
1
1
1
1
1
1
1
1
1
1
1
Paste
1
1
Clipboard
BLO
1
2
234
3
4
5
6
7
8
9
10
11
12
13
♫
14
15
16
17
18
OPONEEEEE
X ✓ fx
TP
0
12
26
41
55
68
80
91
101
110
118
125
131
136
Arial
140
143
145
146
146
B I U
MPP
0
12
14
15
14
13
12
11
10
9
8
7
6
5
0
4
3
2
1
0
Font
E
FC
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
✓ 10
14500
14500
14500
14500
14500
♡
A^ A
F
VLC
0
1500
3000
4500
6000
7500
9000
10500
12000
13500
15000
16500
18000
19500
21000
22500
24000
25500
27000
<
N
|||||||
VMC
0
540
1170
1845
2475
3060
3600
4095
4545
4950
5310
5625
5895
6120
16
17
18
19
20
21
22 Fixed Costs =
23
24
25
26 Variable Costs = $1500 per week per worker + $45 parts and utilities per mower
6300
6435
6525
6570
6570
||||||||
= « »
%
Alignment
H
TVC
0
2040
4170
6345
8475
10560
12600
14595
16545
18450
20310
22125
23895
25620
27300
28935
30525
32070
33570
♫
186698899
General
V
% 95.00
Number
✈0
$5K interest and principle, insurance and property tax + $1 K Lawyer's retainer
+ $2K Government Regulation compliance manager + $1K HR/diversity compliance manager
+ $2.5K accountant + $3K principal's opportunity cost
5
J
AFC
TC
14500
ATC
#DIV/0!
1337.083333
22975 263.6363636 112.3636364
29095
K
M
AVTC
MC
#DIV/0!
#DIV/0!
#VALUE!
16540 1208.333333 128.75
128.75
18670 557.6923077 118.8461538 676.5384615 110.3571429
20845 353.6585366 113.0487805 466.7073171
103
376
110.3571429
25060 213.2352941 113.6029412 326.8382353 118.8461538
27100
181.25
115.875
297.125
128.75
159.3406593 118.8461538 278.1868132 140.4545455
143.5643564 122.3762376 265.9405941 154.5
131.8181818 126.4090909 258.2272727 171.6666667
122.8813559 130.9322034 253.8135593 193.125
116
135.96
251.96 220.7142857
110.6870229 141.5267176 252.2137405 257.5
106.6176471 147.6838235 254.3014706
103.5714286 154.5 258.0714286
101.3986014 162.0629371 263.4615385
170.4827586 270.4827586
99.31506849 179.8972603 279.2123288
48070 99.31506849 190.479451 289.7945205
31045
32950
34810
36625
38395
40120
309
41800
43435
45025
100
46570
Conditional Format as Cell
Formatting Table Styles
Styles
386.25
515
772.5
1545
N
Insert
Delete
Format
Cells
V
Σ
AY
Sort & Find &
Filter Select ✓
Editing
Analyze
Data
Analysis
R
S
>
>
Column A: K = units of capital
Column B: L = units of labor per 40 hour week
Column C: TP = Total Product = Quantity of output per
Column D: MPP = Marginal Physical Product
Column E: FC = Fixed Cost
Column F: VLC = Variable Labor Cost
Column G: VMC = Variable Material Cost (parts and uti
Column H: TVC = Total Variable Cost = VLC + VMC
Column I: TC = Total Cost = FC + TVC
Column J: AFC = Average Fixed Cost = Fixed Cost/TP
Column K: AVTC = Average Variable Total Cost = VTC/
Column L: ATC = Average Total Cost = Total Cost/Q
Column M: MC = Marginal Cost = (Change in TC/Char
(*: MC is really average MC per unit because we are ch
Transcribed Image Text:12345678 se C2 9 10 11 12 13 14 15 5 < Undo AK K 1 1 1 1 1 1 1 1 1 1 1 1 1 Paste 1 1 Clipboard BLO 1 2 234 3 4 5 6 7 8 9 10 11 12 13 ♫ 14 15 16 17 18 OPONEEEEE X ✓ fx TP 0 12 26 41 55 68 80 91 101 110 118 125 131 136 Arial 140 143 145 146 146 B I U MPP 0 12 14 15 14 13 12 11 10 9 8 7 6 5 0 4 3 2 1 0 Font E FC 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 ✓ 10 14500 14500 14500 14500 14500 ♡ A^ A F VLC 0 1500 3000 4500 6000 7500 9000 10500 12000 13500 15000 16500 18000 19500 21000 22500 24000 25500 27000 < N ||||||| VMC 0 540 1170 1845 2475 3060 3600 4095 4545 4950 5310 5625 5895 6120 16 17 18 19 20 21 22 Fixed Costs = 23 24 25 26 Variable Costs = $1500 per week per worker + $45 parts and utilities per mower 6300 6435 6525 6570 6570 |||||||| = « » % Alignment H TVC 0 2040 4170 6345 8475 10560 12600 14595 16545 18450 20310 22125 23895 25620 27300 28935 30525 32070 33570 ♫ 186698899 General V % 95.00 Number ✈0 $5K interest and principle, insurance and property tax + $1 K Lawyer's retainer + $2K Government Regulation compliance manager + $1K HR/diversity compliance manager + $2.5K accountant + $3K principal's opportunity cost 5 J AFC TC 14500 ATC #DIV/0! 1337.083333 22975 263.6363636 112.3636364 29095 K M AVTC MC #DIV/0! #DIV/0! #VALUE! 16540 1208.333333 128.75 128.75 18670 557.6923077 118.8461538 676.5384615 110.3571429 20845 353.6585366 113.0487805 466.7073171 103 376 110.3571429 25060 213.2352941 113.6029412 326.8382353 118.8461538 27100 181.25 115.875 297.125 128.75 159.3406593 118.8461538 278.1868132 140.4545455 143.5643564 122.3762376 265.9405941 154.5 131.8181818 126.4090909 258.2272727 171.6666667 122.8813559 130.9322034 253.8135593 193.125 116 135.96 251.96 220.7142857 110.6870229 141.5267176 252.2137405 257.5 106.6176471 147.6838235 254.3014706 103.5714286 154.5 258.0714286 101.3986014 162.0629371 263.4615385 170.4827586 270.4827586 99.31506849 179.8972603 279.2123288 48070 99.31506849 190.479451 289.7945205 31045 32950 34810 36625 38395 40120 309 41800 43435 45025 100 46570 Conditional Format as Cell Formatting Table Styles Styles 386.25 515 772.5 1545 N Insert Delete Format Cells V Σ AY Sort & Find & Filter Select ✓ Editing Analyze Data Analysis R S > > Column A: K = units of capital Column B: L = units of labor per 40 hour week Column C: TP = Total Product = Quantity of output per Column D: MPP = Marginal Physical Product Column E: FC = Fixed Cost Column F: VLC = Variable Labor Cost Column G: VMC = Variable Material Cost (parts and uti Column H: TVC = Total Variable Cost = VLC + VMC Column I: TC = Total Cost = FC + TVC Column J: AFC = Average Fixed Cost = Fixed Cost/TP Column K: AVTC = Average Variable Total Cost = VTC/ Column L: ATC = Average Total Cost = Total Cost/Q Column M: MC = Marginal Cost = (Change in TC/Char (*: MC is really average MC per unit because we are ch
Formulas for spreadsheet
Variable Labor Cost--VLC--->Column F Row 2 --> =1500*B2
Variable Material Cost--VMC--> Column G Row 2 --> =45*C2
Total Variable Cost = VLC+VMC=TVC--> Column H Row 2--> =F2+G2
Total Cost = Fixed Cost + Total Variable Cost = TC --> Column | Row 2 --> =E2+H2
Average Fixed Cost = Fixed Cost/Total Product = AFC ---> Column J Row 2 --> =E2/C2
Average Variable Total Cost = Total Variable Cost/Total Product --> Column K Row 2 ---> =H2/C2
Average Total Cost = Total Cost/Total Procuct --> Column L Row 2 --> =12/C2
Marginal Cost = (Change in Total Cost)/(Change in Total Product)= (Change in Total Cost)/MPP --> Column M Row 2 --> =(12-11)/D2
Transcribed Image Text:Formulas for spreadsheet Variable Labor Cost--VLC--->Column F Row 2 --> =1500*B2 Variable Material Cost--VMC--> Column G Row 2 --> =45*C2 Total Variable Cost = VLC+VMC=TVC--> Column H Row 2--> =F2+G2 Total Cost = Fixed Cost + Total Variable Cost = TC --> Column | Row 2 --> =E2+H2 Average Fixed Cost = Fixed Cost/Total Product = AFC ---> Column J Row 2 --> =E2/C2 Average Variable Total Cost = Total Variable Cost/Total Product --> Column K Row 2 ---> =H2/C2 Average Total Cost = Total Cost/Total Procuct --> Column L Row 2 --> =12/C2 Marginal Cost = (Change in Total Cost)/(Change in Total Product)= (Change in Total Cost)/MPP --> Column M Row 2 --> =(12-11)/D2
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Customer Sorting Rules
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
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)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
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-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education