Use Solver to find the solution:

Please show solutions and steps involved in process (screenshots of the steps in involved preferred).

Use Solver in Excel

Wood Walker Furniture Time Per Unit Model # Made Cutting A B Assembling Painting 1 2 4 2 4 4 2 3 3 3 7 5 Wood Walker Furniture is a company that specializes in tables. They have four popular options. They want to know how many of each table to make to optimize their overall profits. They can't schedule their workers more than the available amount of hours. Also, for some crazy reason, they can't work partial hours; only full hours. They need to make at least the minimum demand, but don't want to make more than the maximum demand. D 598 Avaliable Hours Total Hours Used Min A B :c D Profit/Unit Cost/Unit Sales Price $ 15.00 $ 15.00 $ 30.00 $ 22.00 $ 23.00 $ 45.00 $ 20.00 $ 20.00 $ 40.00 $ 27.00 $ 28.00 $ 55.00 Demand Max 20 15 10 5 60 55 40 20 Total Profit