Question

Solve this linear programming question using Excel Solver. Bark's Pet Food Company produces canned cat food called Meow Chow and canned dog food called Bow Chow. The company produces the pet food from 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 per pound costs of the horse meat, ground fish, and cereal additive are $2, $1.4, and $0.6, respectively. The company has 2,250 16-ounce cans available each week. Meow Chow is sold at $3 per can, and a can of Bow Chow is sold at $4. The company wants to know how many cans of Meow Chow and Bow Chow to produce each week in order to maximize profit.

          Solve this linear programming question using Excel Solver.
Bark's Pet Food Company produces canned cat food called Meow Chow and canned dog food called Bow Chow. The company produces the pet food from 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 per pound costs of the horse meat, ground fish, and cereal additive are $2, $1.4, and $0.6, respectively. The company has 2,250 16-ounce cans available each week. Meow Chow is sold at $3 per can, and a can of Bow Chow is sold at $4. The company wants to know how many cans of Meow Chow and Bow Chow to produce each week in order to maximize profit.

Added by Andrew S.

Question

Please give Ace some feedback