Use Excel. Write the linear program, optimal solution and objective function value on the worksheet.  A small backpack manufacturer carries four different models of backpacks, made of canvas, plastic, nylon, and leather.  The bookstore, which will sell the backpacks exclusively, expects to be able to sell between 15 and 40 of each model.  the store has agreed to pay $35.50 for each canvas backpack, $39.50 for each plastic backpack, $42.50 for each nylon backpack, and $69.50 for each leather backpack that can be delivered by the end of the week.  One worker can work on either canvas or plastic, can complete a backpack in 1.5 hours, and will charge $7.25 per hour to do the work.  This worker can work a maximum of 90 hours durin the week.  another worker can sew backpacks made of nylon fabric.  He can complete a bag in 1.7 hours, will charge $8.25 per hour to work, and can work 42.5 hours in the next week.  A third worker has the ability to sew leather.  He can complete a backpack in 1.9 hours, will charge $9.25 per hour to work, and can work 80 hours during the next week.  the following table provides additional information about each backpack.  What is the best combination of backpacks to provide the store to maximize the profit?  Model              Material Required       Material Available     Cost/Square Yd Canvas                  2.15                            200                            $4.25 Plastic                    2.30                            350                           $4.50 Nylon                    2.00                             700                           $7.50 Leather                 2.50                             550                            $9.50

Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
icon
Related questions
icon
Concept explainers
Topic Video
Question

Use Excel. Write the linear program, optimal solution and objective function value on the worksheet.  A small backpack manufacturer carries four different models of backpacks, made of canvas, plastic, nylon, and leather.  The bookstore, which will sell the backpacks exclusively, expects to be able to sell between 15 and 40 of each model.  the store has agreed to pay $35.50 for each canvas backpack, $39.50 for each plastic backpack, $42.50 for each nylon backpack, and $69.50 for each leather backpack that can be delivered by the end of the week.  One worker can work on either canvas or plastic, can complete a backpack in 1.5 hours, and will charge $7.25 per hour to do the work.  This worker can work a maximum of 90 hours durin the week.  another worker can sew backpacks made of nylon fabric.  He can complete a bag in 1.7 hours, will charge $8.25 per hour to work, and can work 42.5 hours in the next week.  A third worker has the ability to sew leather.  He can complete a backpack in 1.9 hours, will charge $9.25 per hour to work, and can work 80 hours during the next week.  the following table provides additional information about each backpack.  What is the best combination of backpacks to provide the store to maximize the profit? 

Model              Material Required       Material Available     Cost/Square Yd

Canvas                  2.15                            200                            $4.25

Plastic                    2.30                            350                           $4.50

Nylon                    2.00                             700                           $7.50

Leather                 2.50                             550                            $9.50

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Application of Algebra
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, advanced-math and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Basic Technical Mathematics
Basic Technical Mathematics
Advanced Math
ISBN:
9780134437705
Author:
Washington
Publisher:
PEARSON
Topology
Topology
Advanced Math
ISBN:
9780134689517
Author:
Munkres, James R.
Publisher:
Pearson,