A company produces two types of tables, Round and Square. It takes 2 hours to produce the parts of one unit of Round, 1 hour to assemble and 2 hours to polish. It takes 4 hours to produce the parts of one unit of Square, 2.5 hour to assemble and 1.5 hours to polish. Per month, 7000 hours are available for producing the parts, 4000 hours for assembling the parts and 5500 hours for polishing the tables. The profit per unit of Round is $90 and per unit of Square is $110. Due to an old contract with a supplier, the number of Round tables must be less than 40% the number of Square tables. How many of each type of tables should be produced in order to maximize the total monthly profit?
A company produces two types of tables, Round and Square. It takes 2 hours to produce the parts of one unit of Round, 1 hour to assemble and 2 hours to polish. It takes 4 hours to produce the parts of one unit of Square, 2.5 hour to assemble and 1.5 hours to polish. Per month, 7000 hours are available for producing the parts, 4000 hours for assembling the parts and 5500 hours for polishing the tables. The profit per unit of Round is $90 and per unit of Square is $110. Due to an old contract with a supplier, the number of Round tables must be less than 40% the number of Square tables. How many of each type of tables should be produced in order to maximize the total monthly profit?
Solve using MS Excel Solver, and round you answer to the nearest whole number.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
