Answer these questions on excel please :). The first one is done. Show working out! (formulas)
TC TR MR P Effect (a.) Q Effect (a.) MC The demand schedule and the total cost of production of a firm is defined by the following table, where the quantity (Q) 30 0 0 0 0 30 0 is measured in thousand units and TC is measured in hundred Euros: 29 102,2 28 VOU AWN -OD 102,2 29 29 106,2 56 27 28 4 a. Find the quantity and price effects for each price and quantity given in the table. 27 111,4 81 25 -2 27 5,2 26 117,6 104 23 - 3 26 6,2 25 124,6 125 21 -4 25 7 b. What is the profit-maximizing price and quantity when the firm enjoys market power? What is the profit of the firm? 24 132,3 144 19 -5 24 7,7 23 140,7 161 17 - 6 23 8,4 22 8 149,8 176 15 -7 22 9,1 c. Find the consumer and producer surplus under a monopolistic market. 21 159,4 189 13 - 8 21 9,6 20 10 169,6 200 11 - 9 20 10,2 19 11 180,3 209 -10 19 10,7 d. What is the price and quantity under perfect competition? What is the profit of the firm? 18 12 191,5 216 -11 18 11,2 17 13 203,1 221 -12 16 14 215,2 224 JU W H H W U V 6 17 11,6 -13 16 12,1 e. Find the consumer and producer surpluses under monopoly and perfect competition. What is the deadweight loss generated by the monopoly? 15 15 227,8 225 -14 15 12,6 13 14 16 240.8 224 -15 14 13 17 254,2 221 -16 13 13,4 f. Calculate the elasticity of the firm and the Lerner Index of monopoly power under monopoly and perfect competition. 18 268 216 -17 12 13,8 12 11 19 282,2 209 -7 -18 11 14,2 20 296,8 -9 -19 10 14,6 g. Propose a regulated price to minimize the deadweight loss without generating a negative economic profit to the monopolist. 10 200 O - NW A U O OO 60 21 311,7 189 -11 -20 9 14,9 22 327 176 -13 -21 8 15,3 23 342,7 161 -15 -22 15,7 h. Calculate the producer and consumer surplus under perfect first degree discrimination. What is the profit of the monopolist? 24 358,7 144 -17 -23 6 16 25 375 125 -19 -24 16,3 26 391,7 104 -21 -25 16,7 27 408,7 81 -23 -26 17 28 426 56 -25 -27 17,3 29 443,6 29 -27 -28 - NW AUT 17,6 30 461,5 -29 -29 17,9