Complete problems B.1, B.5, B.7, B.11, and B.21 in the textbook.
Submit one Excel file. Put each problem result on a separate sheet in your file.
B.1 Solve the following linear programming problem
Maximize profit = 4X + 6Y
Subject to: X + 2Y ≤ 8
5X + 4Y ≤ 20
X, Y ≥ 0
Constraint A X + 2Y ≤ 8
Contraint B 5X + 4Y ≤ 20
B.5 Solve the following LP problem graphically:
Minimize cost = 24X + 15Y
7X + 11Y ≥ 77
16X + 4Y = ≥ 80
X, Y ≥ 0
Constraint A 7X + 11Y ≥ 77
Constraint B 16X + 4Y = ≥ 80
B.7 The Attaran Corporation manufactures two electrical
products: portable air conditioners and portable heaters. The
assembly process for each is similar in that both require a certain
amount of wiring and drilling. Each air conditioner takes 3 hours
of wiring and 2 hours of drilling. Each heater must go through
2 hours of wiring and 1 hour of drilling. During the next production
period, 240 hours of wiring time are available and up to
140 hours of drilling time may be used. Each air conditioner sold
yields a profit of $25. Each heater assembled may be sold for a
Formulate and solve this LP production-mix situation, and
find the best combination of air conditioners and heaters that
yields the highest profit.
B.11 The Sweet Smell Fertilizer Company markets bags
of manure labeled “not less than 60 lb dry weight.” The packaged
manure is a combination of compost and sewage wastes. To
provide good-quality fertilizer, each bag should contain at least
30 lb of compost but no more than 40 lb of sewage. Each pound
of compost costs Sweet Smell 5¢ and each pound of sewage costs
4¢. Use a graphical LP method to determine the least-cost blend
of compost and sewage in each bag.
B.21. Par, Inc., produces a standard golf bag and a deluxe
golf bag on a weekly basis. Each golf bag requires time for cutting
and dyeing and time for sewing and finishing, as shown in the following
HOURS REQUIRED PER BAG
PRODUCT CUTTING AND DYEING SEWING AND FINISHING
Standard bag 1/2 1
Deluxe bag 1 2/3
The profits per bag and weekly hours available for cutting and
dyeing and for sewing and finishing are as follows:
PRODUCT PROFIT PER UNIT ($) ACTIVITY WEEKLY HOURS AVAILABLE
Standard bag 10 Cutting and dyeing 300
Deluxe bag 8 Sewing and finishing 360
Par, Inc., will sell whatever quantities it produces of these two products.
a) Find the mix of standard and deluxe golf bags to produce per week that maximizes weekly profit from these activities.
b) What is the value of the profit? PX
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more