How to solve This problem in excelThe Donnor meat processing firm produces wieners from four…

How to solve This problem in excelThe Donnor meat processing firm produces wieners from four ingredients: clicken, beet, pork, and a cereal additive. The firm produces three types of wieners: regular, beel, and all-meat. The company has the following amounts of each ingredient avalable on a daily basis:
Pounda/Day
Cont/Pound
Cricken
200
80.20
Beet
300
0.30
Pok
150
0.50
Cereal addrive
400
0.05
Each type of wiener has certain ingredient specilications, as follows:
Specifications
Selling Price/Pound
Regular
Not more than 10% beof and pork combined
$0.90
Not less than 20% chicken
Boot
Not loss than 75% beot
1.25
Nilmeat
No coroal addilivo
1.75
Not more than 50% beet and pork combined
The firm wants to know how mary pounds of wieners of each type to produce to maximize profits.
a. Formulate a linear programming model for this problem.