Problem Flair Furniture produces inexpensive tables and chairs. Processes are similar, both require carpentry work and p

[answerhappygod]

Problem Flair Furniture Produces Inexpensive Tables And Chairs Processes Are Similar Both Require Carpentry Work And P 1 (61.67 KiB) Viewed 28 times

Problem Flair Furniture produces inexpensive tables and chairs. Processes are similar, both require carpentry work and painting and varnishing - Each table takes 4 hours of carpentry and 2 hours of painting and varnishing - Each chair requires 3 of carpentry and 1 hour of painting and varnishing - There are 240 hours of carpentry time available and 100 hours of painting and varnishing - Each table yields a profit of $70 and each chair a profit of $50 The company wants to determine the best combination of tables and chairs to produce to reach the maximum profit Flair Furniture Company Data Department Tables Chairs Available Hours T с This week 3 240 hours 2 100 hours 70 Carpentry (hrs/unit) Painting and varnishing (hrs/unit) Profit per (S/Unit) 4 1 50 Decision Variables: T = number of tables to be produced per week C = number of chairs to be produced per week Objective Function: Maximize profit = $70T + $50C Non-Negativity T20;C20 Page 1 of 3 Constraints: Carpentry time used s Carpentry time available 4T + 30 240 (hours of carpentry time) Painting and varnishing time used s Painting and varnishing time available 2T + 10 100 (hours of painting and varnishing time) Question 1: Solve the above Model using Excel solver. 17 Marks)