Question: Subject : Operational Research Question) A factory is making tables and chairs out of oak and pine woods.It has 750 meters oak and 500 meters
Subject : Operational Research Question) A factory is making tables and chairs out of oak and pine woods.It has 750 meters oak and 500 meters pine wood. For a table 3 meters oak+1 meter pine wood is required. For a chair 1 meter oak+ 2 meter pine wood is required. Chairs and tables will be sold one by on or as sets. First set includes 6 chairs+1 table; Second set includes 8 chairs+1 table. In this factory 30 workers works 8 hours a day. For a table 3 hours of work is required. For a chair 2 hours of work is required. Demand list for one week. PRODUCTS | DEMANDS
Single chair >>>> 100 Single table >>>> 10 6 chairs+1 table >>>> 50 8 chairs+1 table >>>> 30 Profit from every chair is 10 Euro. Profit from every table is 30 Euro. Factory wants to maximize the profit for one week.Calculate the problem for maximizing profit for one week. A) Write the decision model for that problem; -Write Decision Variables (i.e x1 is amount of 1 products will be produced) -Write Constraints (i.e 2*x1+3*x2<=100 amount of table and chair cannot exceed 100 --its an example!) -Write objective function (i.e Max z=3*x1+4*x2) B)Find the optimal solution by using excel solver. -Write the values of (x1,x2,z etc. x1=20 x2=30 z=50)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
