P22 1 2 3 4 5 6 7 8 。 9 10 11 Undo 12 13 14 15 A K 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Clipboard …I v I B L 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 C TP 0 12 26 41 55 68 80 91 101 110 118 125 131 136 140 143 145 fx 146 146 D MPP 0 12 14 15 14 Font E FC 14500 14500 14500 14500 14500 14500 13 12 14500 F VLC 0 1500 3000 4500 6000 7500 9000 11 14500 10 14500 14500 14500 9 8 7 14500 6 14500 5 14500 4 14500 21000 14500 22500 3 2 1 24000 14500 14500 25500 0 14500 27000 10500 12000 13500 15000 16500 18000 19500 G VMC 0 45 90 135 180 225 270 315 360 405 450 495 540 585 630 675 720 765 810 Alignment 16 17 18 19 20 21 22 | Fixed Costs = $5K interest and principle, insurance and property tax + $1 K Lawyer's retainer 23 H TVC 0 1545 3090 J AFC Number 24 25 26 Variable Costs = $1500 per week per worker + $45 parts and utilities per mower I TC 14500 1337.083333 128.75 4635 6180 7725 9270 16045 1208.333333 128.75 17590 557.6923077 118.8461538 676.5384615 110.3571429 19135 353.6585366 113.0487805 466.7073171 103 20680 263.6363636 112.3636364 376 110.3571429 22225 213.2352941 113.6029412 326.8382353 118.8461538 23770 181.25 115.875 297.125 128.75 10815 25315 159.3406593 118.8461538 278.1868132 140.4545455 12360 26860 143.5643564 122.3762376 265.9405941 154.5 13905 28405 131.8181818 126.4090909 258.2272727 171.6666667 15450 29950 122.8813559 130.9322034 253.8135593 193.125 16995 31495 116 135.96 251.96 220.7142857 33040 110.6870229 141.5267176 252.2137405 257.5 34585 106.6176471 147.6838235 254.3014706 309 21630 36130 103.5714286 154.5 258.0714286 23175 37675 101.3986014 162.0629371 263.4615385 24720 39220 100 170.4827586 270.4827586 26265 40765 99.31506849 179.8972603 279.2123288 27810 42310 99.31506849 190.479451 289.7945205 18540 20085 386,25 515 772.5 1545 + $2K Government Regulation compliance manager + $1K HR/diversity compliance manager +$2.5K accountant + $3K principal's opportunity cost K AVTC F Formatting Table Styles Styles L ATC M MC N Format Cells O Filter Select Editing P Q 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

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
Related questions
Question

ONLY NEED QUESTIONS 

10, and 13

File Home Insert Draw Page Layout
12345678
2
P22
9
10
11
12
13
14
15
Undo
A
----AD
K
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Paste
Clipboard N
BLO2
1
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
OPONENTES
X ✓ fx
12
26
41
55
68
80
91
101
110
118
125
131
136
Arial
140
143
145
B I U
146
146
D
MPP
0
12
14
15
14
13
12
11
10
9
8
7
6
5
4
3
2
1
0
Font
E
FC
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
14500
10
Formulas Data Review
A^ A
F
VLC
0
1500
3000
4500
6000
7500
9000
10500
12000
13500
15000
16500
18000
19500
N
21000
22500
24000
25500
27000
||||||||
G
VMC
0
45
90
135
180
225
270
315
360
405
450
495
540
585
630
675
720
765
810
|||||||
Alignment
H
TVC
0
1545
3090
4635
6180
7725
9270
10815
12360
13905
15450
16995
18540
20085
View Automate Help
21630
23175
24720
26265
27810
1
16
17
18
19
20
21
22 Fixed Costs = $5K interest and principle, insurance and property tax + $1 K Lawyer's retainer
23
24
25
26 Variable Costs = $1500 per week per worker + $45 parts and utilities per mower
26860
28405
29950
√
31495
33040
34585
**A* *888
General
J
AFC
% 95.00
Number
TC
14500
20680 263.6363636 112.3636364
22225
23770
25315
16045 1208.333333 128.75 1337.083333 128.75
17590 557.6923077 118.8461538 676.5384615 110.3571429
19135 353.6585366 113.0487805 466.7073171 103
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
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
110.6870229 141.5267176 252.2137405
106.6176471 147.6838235 254.3014706
103.5714286 154.5 258.0714286
101.3986014 162.0629371 263.4615385
39220
100 170.4827586 270.4827586
40765 99.31506849 179.8972603 279.2123288
42310 99.31506849 190.479451 289.7945205
220.7142857
257.5
309
36130
37675
K
AVTC
+ $2K Government Regulation compliance manager + $1K HR/diversity compliance manager
+ $2.5K accountant + $3K principal's opportunity cost
Conditional Format as
.00
Cell
→→→0
Formatting Table ✓ Styles
Styles
5
ATC
M
MC
386.25
515
772.5
1545
Insert
EX Delete
Format
Cells
N
V
O
M
V
Comments
=
AY
Sort &
Find &
Filter Select ✓
Editing
Analyze
Data
Analysis
R
Share
S
>
=
units of capital
units of labor per 40 hour week
Column A: K
Column B: L =
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:File Home Insert Draw Page Layout 12345678 2 P22 9 10 11 12 13 14 15 Undo A ----AD K 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Paste Clipboard N BLO2 1 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 OPONENTES X ✓ fx 12 26 41 55 68 80 91 101 110 118 125 131 136 Arial 140 143 145 B I U 146 146 D MPP 0 12 14 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 Font E FC 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 10 Formulas Data Review A^ A F VLC 0 1500 3000 4500 6000 7500 9000 10500 12000 13500 15000 16500 18000 19500 N 21000 22500 24000 25500 27000 |||||||| G VMC 0 45 90 135 180 225 270 315 360 405 450 495 540 585 630 675 720 765 810 ||||||| Alignment H TVC 0 1545 3090 4635 6180 7725 9270 10815 12360 13905 15450 16995 18540 20085 View Automate Help 21630 23175 24720 26265 27810 1 16 17 18 19 20 21 22 Fixed Costs = $5K interest and principle, insurance and property tax + $1 K Lawyer's retainer 23 24 25 26 Variable Costs = $1500 per week per worker + $45 parts and utilities per mower 26860 28405 29950 √ 31495 33040 34585 **A* *888 General J AFC % 95.00 Number TC 14500 20680 263.6363636 112.3636364 22225 23770 25315 16045 1208.333333 128.75 1337.083333 128.75 17590 557.6923077 118.8461538 676.5384615 110.3571429 19135 353.6585366 113.0487805 466.7073171 103 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 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 110.6870229 141.5267176 252.2137405 106.6176471 147.6838235 254.3014706 103.5714286 154.5 258.0714286 101.3986014 162.0629371 263.4615385 39220 100 170.4827586 270.4827586 40765 99.31506849 179.8972603 279.2123288 42310 99.31506849 190.479451 289.7945205 220.7142857 257.5 309 36130 37675 K AVTC + $2K Government Regulation compliance manager + $1K HR/diversity compliance manager + $2.5K accountant + $3K principal's opportunity cost Conditional Format as .00 Cell →→→0 Formatting Table ✓ Styles Styles 5 ATC M MC 386.25 515 772.5 1545 Insert EX Delete Format Cells N V O M V Comments = AY Sort & Find & Filter Select ✓ Editing Analyze Data Analysis R Share S > = units of capital units of labor per 40 hour week Column A: K Column B: L = 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 ▶
File Home Insert Draw Page Layout
Undo
P22
Paste
Clipboard N
V
Arial
B I U
V
✓10
Font
V
Formulas Data Review View
A^ A
F
√
Alignment
A
B
22 Fixed Costs =
23
24
25
26 Variable Costs = $1500 per week per worker + $45 parts and utilities per mower
27
Automate Help
General
$ % 9
X ✓ fx
C
E
G
H
$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
Number
J
.00
←.0
.00 →0
K
28 1. Fill out all the blank cells in the table based on the information given.
29 2. At what level of the variable input does Diminishing Returns set in?
30 3. At what level of output (Total Product) does increasing Marginal cost set in?
31 4. What is the rule for maximizing profit for a competitive firm?
32 5. If the competitive market price for lawn mowers was $145, calculate the profit or loss the firm would experience.
33 6. Would the firm produce lawn mowers if the price of lawn mowers was $145? Why or why not?
34 7. If the competitive market price for lawn mowers was $170, calculate the profit or loss the firm would experience.
35 8. Would the firm produce lawn mowers if the price of lawn mowers was $170? Why or why not?
36 9. If the competitive market price for lawn mowers was $420, calculate the profit or loss the firm would experience.
37 10. Would the firm produce lawn mowers if the price of lawn mowers was $420? Why or why not?
38 11.At approximately what price/output combination is this firm's shut down point?
39 12.At approximately what price/output combination is this firm's break even point?
40 13.Describe this firm's short run supply curve from the data in the spreadsheet.
41
5
Conditional Format as Cell
Formatting Table Styles
Styles
V
M
N
Insert
Delete
Format
Cells
O
Comments
AY
Sort & Find &
Filter Select ✓
Editing
P
Analyze
Data
Analysis
R
Share
S
▶
Transcribed Image Text:File Home Insert Draw Page Layout Undo P22 Paste Clipboard N V Arial B I U V ✓10 Font V Formulas Data Review View A^ A F √ Alignment A B 22 Fixed Costs = 23 24 25 26 Variable Costs = $1500 per week per worker + $45 parts and utilities per mower 27 Automate Help General $ % 9 X ✓ fx C E G H $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 Number J .00 ←.0 .00 →0 K 28 1. Fill out all the blank cells in the table based on the information given. 29 2. At what level of the variable input does Diminishing Returns set in? 30 3. At what level of output (Total Product) does increasing Marginal cost set in? 31 4. What is the rule for maximizing profit for a competitive firm? 32 5. If the competitive market price for lawn mowers was $145, calculate the profit or loss the firm would experience. 33 6. Would the firm produce lawn mowers if the price of lawn mowers was $145? Why or why not? 34 7. If the competitive market price for lawn mowers was $170, calculate the profit or loss the firm would experience. 35 8. Would the firm produce lawn mowers if the price of lawn mowers was $170? Why or why not? 36 9. If the competitive market price for lawn mowers was $420, calculate the profit or loss the firm would experience. 37 10. Would the firm produce lawn mowers if the price of lawn mowers was $420? Why or why not? 38 11.At approximately what price/output combination is this firm's shut down point? 39 12.At approximately what price/output combination is this firm's break even point? 40 13.Describe this firm's short run supply curve from the data in the spreadsheet. 41 5 Conditional Format as Cell Formatting Table Styles Styles V M N Insert Delete Format Cells O Comments AY Sort & Find & Filter Select ✓ Editing P Analyze Data Analysis R Share S ▶
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Payoff Matrix
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