solve problems in excel please

7. A glassblower makes glass decanters and glass trays on a weekly basis. Each item requires 1 pound of glass, and the glassblower has 15 pounds of glass available each week. A glass decanter requires 4 hours of labor, a glass tray requires only 1 hour of labor, and the glassblower works 25 hours a week. The profit from a decanter is $50, and the profit from a tray is $10. The glassblower wants to determine the total number of decanters (x1) and trays (x2) that he needs to produce to maximize his profit. a. Formulate an integer programming model for this problem. b. Solve this model by using the computer. 11. The owner of the Consolidated Machine Shop has $10,000 available to purchase a lathe, a press, a grinder, or some combination thereof. The following 0-1 integer linear programming model has been developed to determine which of the three machines (lathe, x; press, xz; or grinder, xz) should be purchased to maximize annual profit: maximize Z = 1,000x + 700x2 + 800xz (profit, $) subject to $5,000x; + 6,000x2 + 4,000x3 = 10,000 (cost, $) X1, X2, X3 = 0 or 1 Solve this model by using the computer. 19. The Avalon Floor Cleaner Company is trying to determine the number of salespeople it should allocate to its three regions-the East, the Midwest, and the West. The company has 100 sales people that it wants to assign to the three regions. The annual average unit sales volume achieved by a salesperson in each region is as follows: Region East Midwest West Units per Salesperson 25,000 18,000 31,000