I. Transportation model (35 points) A campaign manager for a political candidate
ID: 2347349 • Letter: I
Question
I. Transportation model (35 points)A campaign manager for a political candidate must arrange the shipment of 300 cartons of
campaign buttons from three button producers to three campaign headquarters. Each supplier has
production capacity of 100 cartons. Demands at three headquarters are 80 cartons for HQ1, 130
cartons for HQ2 and 90 cartons for the third one. Unit shipping costs from each supplier to
different headquarters are listed in the table below,
HQ1 HQ2 HQ3
A $7 $8 $6
B $11 $6 $7
C $5 $8 $6
Based on information given, please,
a. Construct a standard (mathematical) LP model for managing the total shipping costs.
(15 points)
b. Using Excel Solver, find the optimal solutions and describe your solutions (Note, you must
copy and paste relevant parts of Solver setup and outputs to support your answers). (20 points)
Explanation / Answer
You need to break these up, you are asking too much. I would be glad to help if you do.