Quiz6.xIsx [3awnweHHbin npocMOTp] - Excel BXOA X InaBHag BCTaBKa Pa3MeTKa CTpaHNubl DopMy/bl AaHHble PeleH3NPOBaHue BNA CnpaBKa 4TO Bbl XOTUTe CAenaTb? & nogenNTbCA 3AWNEHHbIN nPOCMOTP byAbTe OCTOPOXKaTb BNpycbl. ECAN BaM He Hy>KHO 3MeHATb 3TOT AOKyMeHT, nyuwe paboTaTb C HNM B pexMe sawINweHHOro npocMOTpa. PaspewNTb peakTupoBaHue X H75 X A B C D E F G H J K L M N O P Q R S T 1. Production function is given as: Q = 100*loge(L+1) 1 D W (Production is done only by labor) Fixed cost $400 Variable cost $200 per worker co 9 Input of la Production Marginal Average Cost 10 L Q Product Product Q Total Cost 11 0,0 0,0 0 400,0 12 69,3 69,3 69.3 10 13 20 14 30 40 5ON VOUAWN-O 50 60 18 70 19 80 20 90 21 100 22 23 (1) Production function is Q = f(L). Fill the cells in yellow. 24 25 (2) Cost function is C = f(Q). Fill the cells in yell (Hint: C(Q) = 400 + 200 * ( L ), where L = f (Q), the inverse function of the production function) 26 27 (3) Is the marginal production of labor decreasing? Prove it. 28 29 Hint: MPL = 6Q / 8L As L increases, does MP, decrease? 30 31 2. A computer manufacturing company shows its cost information as following: Homework Sheet1 + 115 6 11:30 O 1 6 ) PENG 24.03.2021Quiz6.xIsx [3awnweHHbin npocMOTp] - Excel BXOA X Davin InaBHag BCTaBKa Pa3MeTKa CTpaHNubl DopMy/bl AaHHble PeteH3upOBaHue BNA CnpaBka 4TO Bbl XOTUTe CAenaTb? & nogenNTbCA 3AWNEHHbIN nPOCMOTP byAbTe OCTOPO>kaTb BNpycbl. ECAN BaM He Hy>KHO 3MeHATb 3TOT AOKyMeHT, nywe paboTaTb C HNM B pexNMe sawNueHHoro npocMOTpa. PaspewNTb peakTupoBaHue X H75 X Vfx A B C D E F G H J K L M N O P Q R S T 29 Hint: MPL = 6Q / 8L As L increases, does MP_ decrease? 30 31 2. A computer manufacturing company shows its cost information as following: 32 33 Average Average Average total fixed variable 34 Quant ity of Fixed Variable Total Marginal cost of cost of cost of comp cost cost cost Cost pair pair pair 35 uters VC TC ATC = AFC = AVC = Q FC MC 36 TC/Q FC/Q VC/Q 37 0 108 0 108 38 108 12,0 120,0 IN- 39 108 48.0 156,0 40 3 108 108,0 216,0 41 4 108 192,0 300,0 42 5 108 300,0 408,0 43 6 108 432,0 540,0 44 7 108 588,0 696,0 45 00 108 768,0 876,0 46 9 108 972,0 1 080,0 47 10 108 1 200,0 1 308,0 48 49 (1) Fill the yellow cells 50 Homework Sheet1 (+) 115 6 1 71 7 ENG 11:30 8 24.03.2021Quiz6.xIsx [3awnweHHbin npocMOTp] - Excel BXOA X InaBHag BCTABKa Pa3MeTKa CTpaHNubl DopMy/bl AaHHble PeleH3poBaHue BNA CnpaBka 4TO Bbl XOTUTe CAenaTb? & nogenNTbCA X 3AWINWEHHbIN nPOCMOTP byAbre OCTOPOXHbl: Qawi/bl 3 NIHTepHeTa MoryT coAep>aTb BNpycbl. ECAN BaM He Hy>KHO N3MeHATb 3TOT AOKyMeHT, nywe paGOTaTb C HNM B pexNMe sawINweHHOro npocMOTpa. PaspewNTb peakTupoBaHue H75 : X V . A B C D E F G H K L M N O P Q R S T 42 108 300,0 408,0 43 6 108 432,0 540,0 44 7 108 588,0 696.0 45 8 108 768.0 876,0 46 CO 108 972.0 1 080,0 47 10 108 1 200,0 1 308,0 48 49 (1) Fill the yellow cells 50 51 (2) Draw a chart showing Marginal Cost and Average Total Cost. (If you don't know how to draw a chart in EXCEL, draw it somewhere else and copy the image here) 52 Check if : a) Marginal cost increases 53 b) Marginal cost curve goes through the minimum point of the average total cost 54 55 Hint: The chart should look like: 56 57 COST MC 58 300.0 ATC 59 250.0 60 200.0 61 8 150.0 62 100.0 63 50 0 64 65 0.0 4 5 6 7 8 9 10 66 Quantity of Computers 67 68 69 70 Homework Sheet1 + 115 6 11:30 8 X 1 6 ) PENG 24.03.2021