A large retail sporting-goods chain desires to purchase 300, 200, 150, 500, and 400 tennis racquets of
Question:
A large retail sporting-goods chain desires to purchase 300, 200, 150, 500, and 400 tennis racquets of five different types. Inquiries are received from four manufacturers who will supply not more than the following combines quantities of racquets. M1: 600; M2: 500; M3: 300; M4: 400
The store estimates that its profit per racquet will vary with the manufacturer as shown below:
racquet manufacturer | R1 | R2 | R3 | R4 | R5 |
M1 | 5.5 | 7 | 8.5 | 4.5 | 3 |
M2 | 6 | 6.5 | 9 | 3.5 | 2 |
M3 | 5 | 7 | 9.5 | 4 | 2.5 |
M4 | 6.5 | 5.5 | 8 | 5 | 3.5 |
We have 3 workgroups, which can work 8 hours each. They have to manage 7 orders which take 2,2,11,2,1,3, and 2 hours to be finished. Moreover, every workgroup has its own abilities, which means that the first workgroup can work on order 3,4,5 and 6, the second on 1,2,3,5,6 and 7, and the third on 1,2,3 and 5.
Define the Decision Variables and solve it using solver (must be done in excel)
What is the interpretation of shadow prices associated with the flow constraints