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