(1) Integer Optimization: Guahan Carpet Co. has received an order for carpets for a new office building at Tamuning. The order is for 4,000 yards of carpet 4-feet wide, 20,000 yards of carpet 9-feet wide, and 9,000 yards of carpet 12- feet wide. Guahan can order two kinds of carpet rolls, which the company can cut to fill this order. One type of roll is 14-feet wide, 100-yards long, and costs $1,400 per roll. The other type is 18-feet wide, 100- yards long, and costs $1,400 per roll. The company needs to determine how many of the two types of carpet rolls to order and how they should be cut. It wants to do this in the least costly way possible. (a) Crete a spreadsheet model for this problem and solve it using Solver. What is the optimal solution? (15 points) (b) Suppose Guahan Carpet Co. wants to minimize waste. Would the solution change? (15 points)