Stoneware Pottery Company wants to determine how many bowls and mugs should be produced per day in order to maximize profit given the labor and material constraints. The unit profit value for Bowls is $40 per unit, for mugs the unit profit value is $50 per unit. There are 40 hours of labor and 120 pounds of clay available per day. Each bowl requires 1 hour of labor and 4 pounds of clay to produce, each mug requires 2 hours of labor and 3 pounds of clay to produce.
a) Formulate a linear programming model for this problem to determine how many bowls and how many mugs should be produced in order to maximize the total profit.
b) Solve this problem by using the graphing method OR by using Excel Solver.
c) What is the optimal solution?
d) Which constraints are binding?