Given the information of a certain good (say chicken), consisting of the quantity of chicken in… 1 answer below »
Given the information of a certain good (say chicken), consisting of the quantity of chicken in different prices of its supply and demand, in the Excel file attached to this assignment. Rows 3, 4, and 5 in the Excel file exhibit the quantity of chicken, the price of chicken demand, and the price of chicken supply, respectively.
row3 Quantity 0 51 102 153 204 255
row4 Demand 306 255 204 153 102 51
row5 Supply 51 102 153 204 255 306
Students should insert their last two student numbers in Cell A1 in the Excel file to generate their own data, and then answer the following questions:

Draw the demand curve using the quantity and demand data of chicken provided in rows 3 and 4 of the Excel file? (1 mark)

Draw the supply curve using the quantity and supply data of chicken provided in rows 3 and 5 of the Excel file? (1 mark)

Write the demand curve equation of chicken where Y is the dependent variable, b is the slop of demand curve, and X is the independent variable? (1 mark)

Write the supply curve equation of chicken where Y is the dependent variable, b is the slop of supply curve, and X is the independent variable? (1 mark)

Calculate the market equilibrium point for Chicken? Determine the excess supply area on the figure and explain what the area tells us? (2 marks)

What is the opportunity cost of consuming additional one chicken? (2 marks)

What is the opportunity cost of paying additional one dollar for chicken?
(2 marks)

If the price of beef goes up, what happen for the market equilibrium point, price and quantity of chicken? Explain your answer (1 mark)

If the IT technology is applied to nurture chickens, what happen for the market equilibrium point, price and quantity of chicken? Explain your answer.
(1 mark)

Assume that intersection between the first quantity (cell B3 in Excel) and the first demand (cell B4 in Excel) is called as point A, the second quantity (cell C3 inExcel) and the second demand (cell C4 in Excel) is called as point B, the third quantity (cell D3 in Excel) and the third demand (cell D4 in Excel) is called as point C, and so on. We will have 6 points from A to F. Assume that we have the same fashion for intersection between quantity and supply so that the first quantity (cell B3 in Excel) and the first supply (cell B5 in Excel) is called as point I, the second quantity (cell C3 in Excel) and the second supply (cell C5 in Excel) is called as point J, the third quantity (cell D3 in Excel) and the third supply (cell D5 in Excel) is called as point K, and so on. We will have 6 points from I to N.
Calculate the elasticity of demand for chicken at point C when price move from point B to point C? What is the relation between changes in price and total expenditure at point C? (2 marks)
Calculate the elasticity of supply for chicken at point M when price moves from point L to point M? What is the relation between changes in price and total expenditure atpoint M?
Calculate consumer surplus? Interpret your result Calculate producer surplus? Interpret your result
(2 marks) (2 marks) (2 marks)
</pstyle=”boxsizing:>