Just find the constraints for this

B3. In a second worksheet labeled Pumpkin Grower's Dilemma, create a model to solve the Pumpkin Grower's Dilemma problem. Make your model as general as possible to facilitate the analysis of multiple scenarios. Set up the Base Case scenario with the variables and parameters below. (Hint: Copy and paste the parameter table from the lab instructions Word file in Moodle to your model spreadsheet.) Value 20 600 200 Model Parameters Price of Pumpkins (P) Cost of Non-Pollinator Inputs (C) Cost of Wild Habitat Maintenance (M) Cost of Managed Bee Colony Rental (R) Yield with No On-Farm Pollinators (Y) Wild Pollinator Adjustment Factor (aw) Managed Bee Adjustment Factor (an) Total Farm Acreage (AT) 150 40 500 2.5 100 Units $ per ton $ per hectare $ per hectare Sper colony tons per hectare tons per hectare per hectare tons per hectare per colony hectares Choice Variables Quantity of Wild Pollinator Habitat (Qw) Quantity of Managed Bee Colonies Rented (Qx) 0 0 hectares colonies Model Equations Increased Yield Due to Wild Pollinators (Yw) Increased Yield Due to Managed Bees (YM) Pumpkin Acreage (AP) Profit (1) In(1+aw Qw) tons per hectare In(1+an+Qx) tons per hectare Ar - Qw hectares ?? $ a. What is the Excel formula for your objective function? (10 points) b. What constraint(s) do you need? (5 points) + Total Revenue = Pricepumpkin * (Yieldoff-farm-pollinators Yield on-farm-wild + Yieldon-farm-managed) x Acreage pumpkin Units: $/ton x tons/hectare x hectares = $ Total Costs = CostNP-inputs X Acreagepumpkin + Costhabitat X Acreage habitat + Costcolony x Colonies Units: $/hectare x hectares + $/hectare x hectares + $/colony x colonies = $ + $ + $ = $ B3. In a second worksheet labeled Pumpkin Grower's Dilemma, create a model to solve the Pumpkin Grower's Dilemma problem. Make your model as general as possible to facilitate the analysis of multiple scenarios. Set up the Base Case scenario with the variables and parameters below. (Hint: Copy and paste the parameter table from the lab instructions Word file in Moodle to your model spreadsheet.) Value 20 600 200 Model Parameters Price of Pumpkins (P) Cost of Non-Pollinator Inputs (C) Cost of Wild Habitat Maintenance (M) Cost of Managed Bee Colony Rental (R) Yield with No On-Farm Pollinators (Y) Wild Pollinator Adjustment Factor (aw) Managed Bee Adjustment Factor (an) Total Farm Acreage (AT) 150 40 500 2.5 100 Units $ per ton $ per hectare $ per hectare Sper colony tons per hectare tons per hectare per hectare tons per hectare per colony hectares Choice Variables Quantity of Wild Pollinator Habitat (Qw) Quantity of Managed Bee Colonies Rented (Qx) 0 0 hectares colonies Model Equations Increased Yield Due to Wild Pollinators (Yw) Increased Yield Due to Managed Bees (YM) Pumpkin Acreage (AP) Profit (1) In(1+aw Qw) tons per hectare In(1+an+Qx) tons per hectare Ar - Qw hectares ?? $ a. What is the Excel formula for your objective function? (10 points) b. What constraint(s) do you need? (5 points) + Total Revenue = Pricepumpkin * (Yieldoff-farm-pollinators Yield on-farm-wild + Yieldon-farm-managed) x Acreage pumpkin Units: $/ton x tons/hectare x hectares = $ Total Costs = CostNP-inputs X Acreagepumpkin + Costhabitat X Acreage habitat + Costcolony x Colonies Units: $/hectare x hectares + $/hectare x hectares + $/colony x colonies = $ + $ + $ = $