Linear Programming: Production Problem

profileprice.3
excel_template_to_be_used.xlsx

Sheet1

x1 x2 x3 x4 LHS RHS slack
Objective function 12 10 15 11 0
Material 5 3 4 2 0 = 240 240
Machine Time 0 = 0
Labor 0 = 0
Solution Values
0 0 0 0
Maximize Z = 12x1 + 10x2 + 15x3 + 11x4 (objective function for profit)

Sheet2

Sheet3