you MUST upload the word file and supporting Excel workbooks that are named by each question.

When submitting the assignment, you MUST upload the word file and supporting Excel workbooks that are named by each question. (You can alternatively submit only one Excel file in which each question is solved in a different worksheet.) Only one member of the group should submit the assignment. Question 1) (20 points) Consider a pottery workshop that produces bowls, mugs, and plates. The number of labor hours and amount of clay needed to produce a unit of these products is presented in table below: Labor Clay (hr/unit) (1b/unit) Plate 3 7 Bowl 2 8 Mug 4 6 There are 80 hours of labor and 240 pounds of clay available on each day. The revenue generated by selling a unit of plate, bowl, and mug is $35, $40, and $50, respectively. 1- Write a linear optimization mathematical model to determine the number of plates, bowls, and mugs that needs to be produced in order to maximize the total revenue. The model must consider the restrictions of total labor hours and clay available during a day. Clearly define decision variables, objective function, and constraints for the optimization model. 2- Use Excel to solve the optimization model. How many of each product should be produced to maximize the total revenue