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...


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.



Jun 01, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here