Tom is a habitual shopper at garage sales. Last Saturday he stopped at one where there were
Question:
Tom is a habitual shopper at garage sales. Last Saturday he stopped at one where there were several types of used building materials for sale. At the low prices being asked, Tom knew that he could resell the items in another town for a substantial gain. Four things stood in his way: he could only make one round trip to resell the goods; his pickup truck bed would hold only 1200 pounds; the pickup truck bed could hold at most 80 cubic feet of merchandise; and he had only $190 in cash with him. He wants to load his truck with the mix of materials that will yield the greatest profit when he resells them.
Item | Cubic feet per unit | Price per unit | Weight per unit | Can resell for |
Studs | 1 | $0.10 | 5 pounds | $0.80 |
Plywood | 0.5 | $0.50 | 10 pounds | $3.00 |
Concrete blocks | 2 | $0.25 | 20 pounds | $5.75 |
Formulate (define objective function and constraints) and solve this problem (using excel solver) as a linear program.