# MAT 540 Week 6 Homework Latest

\$22.00

Categories: , .

## MAT 540 Week 6 Homework Latest

MAT 540 Week 6 Homework Latest

MAT540

MAT 540 Week 6 Homework Latest

Page 1 of 2

Chapter 2

1. A Cereal Company makes a cereal from several ingredients. Two of the ingredients, oats and rice, provide vitamins A and B. The company wants to know how many ounces of oats and rice it should include in each box of cereal to meet the minimum requirements of 45 milligrams of vitamin A and 13 milligrams of vitamin B while minimizing cost. An ounce of oats contributes 10 milligrams of vitamin A and 2 milligram of vitamin B, whereas an ounce of rice contributes 6 milligrams of A and 3 milligrams of B. An ounce of oats costs \$0.06, and an ounce of rice costs \$0.03.
2. Formulate a linear programming model for this problem.
3. Setup the LP model for Excel Solver.
4. A Furniture Company produces chairs and tables from two resources- labor and wood. The company has 125 hours of labor and 45 board-ft. of wood available each day. Demand for chairs is limited to 5 per day. Each chair requires 7 hours of labor and 3.5 board-ft. of wood, whereas a table requires 14 hours of labor and 7 board-ft. of wood. The profit derived from each chair is \$325 and from each table, \$120. The company wants to determine the number of chairs and tables to produce each day in order to maximize profit. Formulate a linear programming model for this problem.
5. Formulate a linear programming model for this problem.
6. Setup the LP model for Excel Solver.
7. Kroeger supermarket sells its own brand of canned peas as well as several national brands. The store makes a profit of \$0.28 per can for its own peas and a profit of \$0.19 for any of the national brands. The store has 864 square inches of shelf space available for canned peas, and each can of peas takes up 9 square inches of that space. Point-of-sale records show that each week, the sales of its own brand is less than twice of the sales of the national brands. The store wants to know how many cans of its own brand of peas of peas and how many cans of the national brands to stock each week on the allocated shelf space in order to maximize profit.
8. Formulate a linear programming model for this problem.
9. Setup the LP model for Excel Solver

Page 2 of 2

1. Set up the LP model for Excel Solver:

Minimize Z=8X1 + 6X2

Subject to

4×1 + 2×2 ? 20

-6×1 + 4×2 ?12

x1 + x2 ? 6

x1,x2 ? 0