Question
A furniture manufacturer employs 6 skilled and 11 semi-skilled workers and produces two products: study table and computer table. A study table requires 2 h
A furniture manufacturer employs 6 skilled and 11 semi-skilled workers and produces two products: study table and computer table. A study table requires 2 h of a skilled worker and 2 h of an unskilled worker. A computer table requires 2 h of a skilled worker and 5 h of an unskilled worker. As per the industrial laws, no one is allowed to work for more than 38 h per week. The manufacturer can sell as many tables as he can produce. If the profit for a study table is $100 and for a computer table $160, how many study and computer tables should the manufacturer produce in a week in order to maximize the overall profit? Formulate a linear programming model and solve it by using both Excel Solver and Gurobi.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started