Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Could you show me how to get the correct answers by formulas not on excel please

ID: 453676 • Letter: C

Question

Could you show me how to get the correct answers by formulas not on excel please? Thank you! Problem 3 .Technological data: Production of table requires 5 ft pine, 2 ft oak, 3 hrs labor labor labor employees (each works 40 hrs) I chair requires I ft pine, 3 t oak, 2 hrs l chair requires 1 ft pine, 3 ft oak, 2 hrs 1 desk requires 9 ft pine, 4 ft oak, 5 hrs Capacities for 1 week: 1500 ft pine, 1000 ft oak, 20 . Market data table chair desk profit S12/unit S5/unit sis/unit demand 40 130 30 Goal: Using Integer Linear Programming find a production schedule for 1 week that will maximize the profit.

Explanation / Answer

Maximize - 12x + 5y + 12z Eqn 1 1500 = 5x+1y+9z 2 1000 = 2x+3y+4z 3 80 = 2x+3y+5z