Problem 4 (7.5 points) 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 cash with him. He wants to load his truck with the mix of materials that will yield the greatest profit when he resells them. Cubic Price Weight Item feet per per unit Can resell for per unit unit 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