Please use excel solver

A glassblower makes glass decanters and glass trays on a weekly basis, Each item requires 500 grams of glass, and the glassblower has 6 kilograrns 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 32 hours a week. The shop owner requires that at least 1 tray is produced each week. Additionally, the total number of items produced in a week must be at least 7 (ie. the number of decanters plus the number of trays must be at least 7). The profit from a decanter is P1.750 while the proft from a tray is P500. Determine the number of decanters and trays that the glassblower needs to produce in order to maximize profit. a. Assuming that all other resources are available, formulate an integer programming (algebraic) model to determine how many of each item should the glassblower produce to maximize profit. b. Using Solver. solve the model formulated in part (a) without the integer requirements. What is the optimal solution for the decanters and trays? What is the optimal proft? c. Round the decanter and tray values found in part (b). Is the solution feasible? Why? d. Truncate the decanter and tray values found in part (b) (i.e drop the fractional part of each value). is the solution feasible? Why? e. Add integer requirements to the model you constructed in part bi). What are the optimal number of decanters and trays that should be produced? What is the optimal profit