MAT540 Ashford Week 6 Graphical Analysis And Linear Programming Excelsheet

Please see attached question sheet for clarity & use the provided answer sheet to enter aswers to questions:
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 shouldinclude in each box of cereal to meet the minimum requirements of 45 milligrams of vitamin A and13 milligrams of vitamin B while minimizing cost. An ounce of oats contributes 10 milligrams ofvitamin A and 2 milligram of vitamin B, whereas an ounce of rice contributes 6 milligrams of Aand 3 milligrams of B. An ounce of oats costs $0.06, and an ounce of rice costs $0.03.
a. Formulate a linear programming model for this problem.
b. Solve the model by using graphical analysis.
2. A Furniture Company produces chairs and tables from two resources- labor and wood. Thecompany has 125 hours of labor and 45 board-ft. of wood available each day. Demand for chairs islimited to 5 per day. Each chair requires 7 hours of labor and 3.5 board-ft. of wood, whereas a tablerequires 14 hours of labor and 7 board-ft. of wood. The profit derived from each chair is $325 andfrom each table, $120. The company wants to determine the number of chairs and tables to produceeach day in order to maximize profit. Formulate a linear programming model for this problem.
a. Formulate a linear programming model for this problem.
b. Solve the model by using graphical analysis. (Do not round the answers)
c. How much labor and wood will be unused if the optimal numbers of chairs and tables areproduced?3. Kroeger supermarket sells its own brand of canned peas as well as several national brands. Thestore makes a profit of $0.28 per can for its own peas and a profit of $0.19 for any of the nationalbrands. The store has 6 square feet of shelf space available for canned peas, and each can of peastakes up 9 square inches of that space. Point-of-sale records show that each week the store neversales more than half as many cans of its own brand as it does of the national brands. The storewants to know how many cans of its own brand of peas of peas and how many cans of the nationalbrands to stock each week on the allocated shelf space in order to maximize profit.
a. Formulate a linear programming model for this problem.
b. Solve the model by using graphical analysis.
4. Solve the following linear programming model graphically:
Minimize Z=8X1 + 6X2
Subject to4X1 + 2X2 >/20
-6X1 + 4X2 /< 12 X1 + X2>/6
X1 , X2 >/0

“Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results.”
Attachments
20190510233248hw6_answer_sheet (14 kB)
20190510233249mat540_hw_wk6 (195 kB)