Bark’s Pet Company produces canned cat food called Meow Chow and canned dog food

Q: Bark’s Pet Company produces canned cat food called Meow Chow and canned dog food

Model: Decision Variables: Meow Chow Bow Chow Max Avail Horse Meat h1 h2 600 Ground Fish g1 g2 800 Cereal Additive c1 c2 1000 no of cans produced m b Constraints: m = h1+g1+c1 b = h2+g2+c2 g1 >= 0.5 m h2 >= 0.5 b h1+h2

ID: 469896 • Letter: B

Question

Bark’s Pet Company produces canned cat food called Meow Chow and canned dog food called Bow Chow. The company produces the pet food by blending horse meat, ground fish, and a cereal additive. Each week the company has 600 pounds of horse meat, 800 pounds of ground fish, and 1,000 pounds of cereal additive available to produce both kinds of pet food. Meow Chow must be at least half fish, and Bow Chow must be at least half horse meat. The company has 2,350 one pound cans available each week. A can of Meow Chow earns $1.10 in profit, and a can of Bow Chow earns $1.40 in profit. The company wants to create a model that will help to maximize its weekly profit.

Explanation / Answer

Model:

Decision Variables:

Meow Chow

Bow Chow

Max Avail

Horse Meat

600

Ground Fish

800

Cereal Additive

1000

no of cans produced

Constraints:

m = h1+g1+c1

b = h2+g2+c2

g1 >= 0.5 m

h2 >= 0.5 b

h1+h2 <= 600

g1+g2 <= 800

c1+c2 <= 1000

m+b <=2350

h1,h2,g1,g2,c1,c2 >= 0

Objective Function:

Maximize Profit

Profit = 1.10m+1.40b

Model SOlved in Excel Solver: