Saint MBA550 week 6 Assignment 2019 Question # 00598255 Subject: Education Due on: 02/18/2019 Posted On: 02/18/2019 06:00 AM Tutorials: 1 Rating: 4.7/5

Week-6 Chapter 4

11.BettyMalloy, owner of the Eagle Tavern in
Pittsburgh, is preparing for Super Bowl Sunday, andshe must determine how much beer to stock.
Betty stocks three hrand_s of beer—Yodel_s
Shots.,and Rainwater.
The cost per gallon (to the tavern owner) of each brand is as follows:

Brand	CostiGalion
Yodel	$1.50
Shotz	0.90
Rainwacer	0.50

Thetavern has a budget of S2,000 for beer for Super Bowl Sunday. Betty sells
Yodel at arateof $3,00 per gallon, Shotz at $2.50 per
gallon, and Rainwater at $1,75 per gallon. Based onpastfootball games. Betty has determined the maximum customer demand to be
400 gallons ofYodel, 500
gallons of Shatz, and 30(3 gallons of Rainwater. The tavern has the capacity to
stockLOCO gallons of beer; Betty wants
to stock up completely. Betty wants to determine the numberof gallons of each brand of beer to order so
as to maximize profit.

a.
Formulate a
linear programming model for this problem.

b.
Solvethemodel by using the computer_

14. The Hickory Cabinet and Furniture Company
produces sofas, tables, and chairs at its plantin Greensboro, North Carolina_ The plant uses
three mainresources to make furniture—wood,upholstery, and
labor. The resource requirements for each piece of furniture and the totalresources available weekly are as follows:

Resource Requirements

	Wood (board ft.)	Upholstery (yd.)	Labor (hr.)
Sofa	7	12	6
Table	5		9
Chair	4	7	5
Total available resources	2.250	1,000	240

The furnitureis produced on a weekly basis and stored in a
warehouse until the end of the week,when it is shipped out. The warehouse has a total capacity of 650 pieces
of furniture. Each sofaearnss400 in profit, each table, $275, and each
chair, $190. The company wants to know how many pieces of each type of
furniture to make per week to maximize profit.

a.
Formulate a
linear programming model for thisproblem.

b.
Solve the model
by using the computer.

34. Joe Henderson runs a small metal parts
shop. The shop contains three machines—a drillpress, a lathe, and a grinder. Joe has three
operators, each certified to work on all threemachines_ However. each operator performs
better on some machines than on others, Theshop has contracted to do a big job that requires all three machines. The
times required bythe various
operators to perform the required operations on each machine are summarized asfollows:

Operator	DrillPress(mirt,)	Lathe (min_)	Grinder (min.)
1	22	18	35
2	41	30	28
3	25	36	18

Joe Henderson wants to assign one operator to each machine so that the
total operating time for all three operators is minimized.

a. Formulate a linear programming model for this problem.

b„ Solve. the model by using the computer.

c. Joe’s brother. Fred, has asked him to hire
hiswife,Kelly, who is a machine operator. Kellycan perform each of the three required machine
operations in 2C minutes. Should Joe hire hissister-in-law?

14_ The athletic boosters club for
Bea.conville has planned a 2-day fund-raising drive to purchaseuniforms for all the local high schools and to
improve. facilities. Donations will be solicitedduring the day and night by telephone and
personal contact. The boosters club has arrangedfor local college students to donate their
time to solicit donations s. The averagedonationfrom each type
of contact and the time fora volunteer to
soliciteach type of
donation are asfollows:

Average Interview

Average Donation (5) Time (min.)

Phone Personal Phone Personal

Day $16 $33 13

Night 17 37 7 19

The boosters club has gotten several businesses and car dealers to
donate gasoline andcarsfor the college students to use to make a
innaxitratat of 575 personal contacts dailyduringthe
fund-raising drive. The college students will donate a total of 22 hours during
thedayand43 hours at night during the drive..

Thepresident of the boosters club its to know how many different types of
donor con­tacts toschedule
during the drive to maximise total donations. Formulate and solve an integerprogramming model for this problem. What is
the difference in the total maximum value of dona­tions between the integer and non-integer
rounded-down solutions to this problem?

2.2_ Harry and Melissa Jacobson producehandcrafted furniturein a workshopOntheir farm_ Theyhave obtained
a load of 6013 boardfeet of birch
from a neighbor and are planning to produce roundkitchen tables
and ladder-back chairsduring thenext 3months_ Each table will require30 hoursoflabor, each chair will require18 hours, and
between them they have a total of 480 hoursoflabor available. A table requires 40 board feet of wood to make, and a
chair requires 15 board feet. A table earns the couple $575 in profit, and a
chair earns $120 in profit. Most people who buy a table also want four chairs
to go with it, so for every table that is produced, at least fourchairs must
also be made, although additionalchairs can alsobe sold separately. Formulate andsolve an
integer programming model to determine the number of tables and chairs the
Jacobsonsshould make to maximize profit.