llate and solve the following questions using Excel solver. 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 1000 pounds; the pickup truck bed could hold at most 80 cubic feet of merchandise; and he had only $300 cash with him. He wants to load his truck with the mix of materials that will yield the greatest profit when he resells them. a. Write the algebraic formulation of the problem. b. Solve using Excel solver to maximize profit. Hint: There are three decision variables and three constraints. The objective is to maximize profit. Constraints: No more than the available space. No more than the available money. No more than the weight limit