Please Solve

Firm :1 {thousands of bu] 0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 5 55 If 15 8 &5 9 $5 10 TC 3000 3123 3505 9133 10010 11138 12515 14143 15020 13148 20525 23153 25030 29158 32535 35153 40040 44158 43545 531?3 53050 FC VC ATE AFC AW: Show all your calculations in Excel spreadsheet in answering the following questions. MC a} Using the market data provided, create a market supply and demand graph which includes both 001 and C1021 bl What are the market equilibrium price and quantity before and after the demand shift? c]- Using the firm cost and quantity estimates, find FC, VC, ATE, AFC, AVC, and MC. d: Based on your answers in part c and b, between which quantities should the farm aim to produce before and after the demand shift? why? e] Using the lower of these two quantities, estimate TR, TC, and Profithoss before and after the demand shift. fl Will farms enter this market, leave the market, or remain constant after the demand shift? Fin 621 Chapter 5 Mini Case The Weinandt Family Farm in Wynot, NE raises livestock and grows crops. Commonly grown crops in Nebraska are com and soybeans. Suppose you are helping a farm similar to the Weinandt Farm make decisions about how much corn to grow this year. As an agricultural product, the market for corn meets the reduiremen ts of a perfectly competitive market. Original market demand [0m] and market supply [05: are given. Suppose market demand shifts {032] because, in addition to being used as a food product, corn is now used for ethanol production. 001 [millions of bu} 0 200 400 500 800 1000 1200 1400 1500 1800 2000 2200 2400 2500 2800 3000 3200 3400 3500 3800 4000 an [millions ofbul- 400 800 1200 1500 2000 2400 2800 3200 3500 4000 4400 4800 5200 5500 5000 5400 5800 2200 2500 8000 8400 Q: [millions ofbu} 5000 5200 5400 5100 4800 4500 4200 3900 3500 3300 3000 2200 2400 2100 1800 1500 1200 900 500 300 D Pricelbu 10.5 10 3.5 9 8.5 3 2.5 2' 5.5 5 5.5 5 4.5 4 3.5 3 2.5 2 1.5 l D