Your Perfect Assignment is Just a Click Away

We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!

glass
pen
clip
papers
heaphones

MAT540 Ashford Week 6 Graphical Analysis And Linear Programming Excelsheet

MAT540 Ashford Week 6 Graphical Analysis And Linear Programming Excelsheet

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)

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Homework Discussion only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Homework Discussion are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Homework Discussion is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Homework Discussion, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.