2. Use the farm profitability spreadsheet to answer this question.

A. Fill in the cells highlighted in Note (yellow).

B, What will happen to profit if the price of the output falls to $ 2.10 per pound? Which cells (list the cell references in your answer) are impacted by this change?

C. What will happen to profit if the labor wages increase to $ 15.00 per hour? Which cells (list the cell references in your answer) are impacted by this change.Go back to the original values in part A before making the change in part C. After completing parts B and C, go back to the original values contained in part A. The spreadsheet you should submit is the one from part A.

Farm Profitability Production and Revenue Revenue/Cost Price per pound $ 2.95 Pounds per bushel 41.65 Acres Harvested 32 Wage per hour $ 11.25 Yield per acre 29.6 Fertilizer cost per pound $ 2.30 Total Bushels Government payment per harvested acre $ 34.65 Total pounds Crop Revenue Government payment Total Revenue Costs of Production Labor Hours 2000 Fertilizer Use 800 Equipment rental $ 4,532.00 Insurance S 1,167.00 Labor Costs Fertilizer | Cost Other Costs $ 23,555.00 Total Costs Total Profit