Question: **Draw Graph! ** 3. LP formulation - Coffee makers A manufacturing company produces two types of coffee makers, Espresso Maker and French Press. The Espresso

 **Draw Graph!** 3. LP formulation - Coffee makers A manufacturing company

**Draw Graph!**

3. LP formulation - Coffee makers A manufacturing company produces two types of coffee makers, Espresso Maker and French Press. The Espresso maker requires $25 in materials and 2 labor hours to produce and it yields a profit of $100 per each Espresso maker. The French Press requires $22 in materials and 1 hours to produce, and it yields a profit of $90 per French Press. The company has a budget of $20,000 to spend on materials, and 1200 hours of labor available. The company already received the order of Express maker, 350, so the company needs to make more than 350 of Express maker in next period. Based on the previous sales records, the company wants to make no more than 300 of French Press. Based on this given information, the company wants to make the production plan for next period. What is the best combination of coffee makers to be made? Please formulate as a linear program. a) Please formulate this problem as a LP model. - MUST define the decision variables first! Then, write the objective function and constraints. b) Solve the problem using LINDO or Excel Solver and attach the output. c) Please explain the production plan based on your LP model's input and output

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!