In: Operations Management
Pet Food
Your company manufactures two products, bird food and dog food. You have two departments: blending and packaging. The requirements in each department for manufacturing a ton of either product are shown in hours in the following table:
Hours per Tons of Product
Blending Packaging
Bird food 0.25 0.10
Dog food 0.15 0.30
Each department has 8 hours available per day.
Bird food is made from the three ingredients: seeds, ground stones, and cereal. Dog food is made from the three ingredients: meat, fishmeal, and cereal. Descriptions of these five materials are as follows.
Descriptions of Materials in Percents
Protein |
Carbohydrates |
Trace Minerals |
Abrasives |
Cost (in $/ton) |
|
Seeds |
10 |
10 |
2 |
1 |
700 |
Stones |
0 |
0 |
3 |
100 |
100 |
Cereal |
3 |
30 |
0 |
0 |
200 |
Meat |
12 |
10 |
1 |
0 |
600 |
Fishmeal |
20 |
8 |
2 |
2 |
900 |
The minimum composition requirements of the two products in percents are as follows:
Composition Requirements of the Products in Percents
Protein |
Carbohydrates |
Trace Minerals |
Abrasives |
Seeds |
|
Bird food |
5 |
18 |
1 |
2 |
10 |
Dog food |
11 |
15 |
1 |
0 |
0 |
Bird food sells for $750 per ton while dog food sells for $980 per ton. What should be the composition of bird food and dog food and how much of each should be manufactured each day?
What is the resulting daily profit?
Please show and explain using solver