Use excel solver. No paperwork please. make model step wise with formulas to understand so that i can do it easily.

a 7. (10 points) The Northern Ontario Pet Food Company produces dog and cat food. Each food is comprised of meat, soybeans and fillers. The company earns a profit on each product but there is a limited demand for them. The pounds of ingredients required and available, profits and demand are summarized in the following table. The company wants to plan their product mix, in terms of the number of bags produced in order to maximize profit. Profit per Product Demand for product Bag (5) Pounds of Meat per bag Pounds of Filler per bag Dog food Cat food 4 40 5 30 Material available (pounds) Pounds of Soybeans per bag 6 3 120 4 5 100 4 10 160 Formulate and solve the LP model for this problem using Solver