MAT 540 WEEK 6 HOMEWORK LATEST

1 / 2

# MAT 540 WEEK 6 HOMEWORK LATEST - PowerPoint PPT Presentation

\nVisit Below Link, To Download This Course:\n\nhttps://www.tutorialsservice.net/product/mat-540-week-6-homework-latest/\n\nOr \nEmail us on\nSUPPORT@TUTORIALSSERVICE.NET\n\nMAT 540 Week 6 Homework Latest\nMAT540\nMAT 540 Week 6 Homework Latest\nPage 1 of 2\nChapter 2\n1. 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.\n

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about 'MAT 540 WEEK 6 HOMEWORK LATEST' - tutorialsservicesnet

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

MAT 540 WEEK 6 HOMEWORK LATEST

https://www.tutorialsservice.net/product/mat-540-week-6-homework-latest/

Or

Email us on

SUPPORT@TUTORIALSSERVICE.NET

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

4. 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