Question: please provide answer in excel format with any formulas or functions in appropriate cells to make the Solver tool work. Also provide the Solver parameters

Wood Walker Furniture Time Per Unit Model # Made Cutting Assemblin Painting 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. 598 Avaliable Hours Total Hours Used Demand Max Min 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 Total Profit Wood Walker Furniture Time Per Unit Model #Made Cutting Assemblin Painting 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, 2 3 598 Avaliable Hours Total Hours Used Demand Max Min 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 Total Profit
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
