Use Python, Pyomo, and data frames from excel to answer the following question:

The Chalet nut mix is required to have no more than 25 percent peanuts and no less than 40 percent almonds. The Chalet mix sells for 80 cents per pound.

The Hovel mix can contain no more than 60 percent peanuts and no less than 20 percent almonds. Hovel sells for 40 cents per pound.

At most, 700 pounds can be mixed per month.

The nuts available, their prices, and their availabilities this month are as follows:

Nut Price Availability

Peanuts 20/lb. 400 lbs.

Walnuts 35/lb. No limit

Almonds 50/lb. 200 lbs.

The expected situation next month is:

Nut Price Availability

Peanuts 19/lb. 500 lbs

Walnuts 36/lb. No limit

Almonds 52/lb. 180 lbs.

Next month you anticipate Chalet to sell for 81/lb, and Hovel to sell for 39/lb.

It cost 2 cents per pound to store nuts (plain or mixed) for one month. Because of a contract commitment, at least 200 pounds of Chalet mix must be sold next month.

What is your business decision? What is the associated profit?