Instructions:

This lab assignment set has 1 Problem. The total credit for this homework set is 5.

Problem 1: (5 Points)

Please revisit the Max. problem in Chapter 2. The company is still producing two types of products: bowl and mug. Each bowl needs to have 2 hours of labor, and 4 pounds of clay, which can earn 100 dollars per unit. For each mug, it needs to have 3 hours of labor, and 1 pounds of clay, which can earn 20 dollars per unit. The total number of available labor is 80 hours, and the total number of available clay is 100 pounds.

Please use EXCEL SOLVER to find the optimal solutions and the optimal value of the objective function.

That is,

1. What is the optimal number of bowls to produce?
2. What is the optimal number of mugs to produce?
3. What is the optimal value of the objective function?
4. Please attach a screenshot of your EXCEL showing the results given by Solver.