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

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!