# Mgt-455 module 8 chapter b problem set

Details:

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
graphically:

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
\$15 profit.

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
table:
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