3. LP formulation - Product mix: Coffee makers A manufacturing company produces two types of coffee makers. The Espresso maker requires $30 in materials and 2 labor hours to produce and it yields a profit of $150 per Espresso maker. The French Press requires $25 in materials and 1 hours to produce, and it yields a profit of $120 per French Press. The company has a budget of $20,000 to spend on materials. To ensure full employment, the firm wishes to keep all workers fully employed, so all 1,200 available labor hours must be used. What is the best combination of coffee makers to be produced? a) Please formulate this problem as a LP model. o. MUST define the decision variables firstl Then, write the objective function and constraints. b) Solve this problem using graphical method. c) Solve the problem using LINDO or Excel Solver and attach the output. d) Please explain the production plan based on your tP model's input and output. bor LP model and output, please use "Courfer New" tont. 3. LP formulation - Product mix: Coffee makers A manufacturing company produces two types of coffee makers. The Espresso maker requires $30 in materials and 2 labor hours to produce and it yields a profit of $150 per Espresso maker. The French Press requires $25 in materials and 1 hours to produce, and it yields a profit of $120 per French Press. The company has a budget of $20,000 to spend on materials. To ensure full employment, the firm wishes to keep all workers fully employed, so all 1,200 available labor hours must be used. What is the best combination of coffee makers to be produced? a) Please formulate this problem as a LP model. o. MUST define the decision variables firstl Then, write the objective function and constraints. b) Solve this problem using graphical method. c) Solve the problem using LINDO or Excel Solver and attach the output. d) Please explain the production plan based on your tP model's input and output. bor LP model and output, please use "Courfer New" tont