Please note that the egg cooker metal materials is 1.5 lbs not .15

BADM 3963 Linear Programming Resource Requirements Metal Materials/unit 3.11b Waffle Maker Egg Cooker Toaster 1.5lb Plastic Materials/unit sib 71b 3b Labor hours/unit 17 1 5 2 Olb Resources cost are $5 per pound of metal 52 90 per pound of plastic and 510.00 per hour for labor Available resources are 200 pounds of metal 250 pounds of plastic and 350 hours of labor Based on the market research, the company expects the maximum demand for waffle makers is 50 and for egg cookers is 75. The company has a contract to supply 25 tonsters to local department store Waffle makers will be sold for S24 99, egg cookers will be sold for $1999 and Toasters will sell for $14.99 The company wants to know the optimal products mix that will maximize profit Part A Write the Linear Programming formulation for this problem to help determine the best production mix of the three appliances that will maximise profit Part 3: Set up run the problem in Excel Solver Report the optimal solution and profit result