Use Excel Solver to find the best scenario.

WBB is a small wood shop that produces three types of bookshelves: Models A$,$ B and C$.$

$*$ Each model requires a certain amount of time for cutting each component, assembling them, and then staining. The labor time $($in hours$)$ for each phase of construction is shown to the left.

$*$ Each Model A produces $60$inprofit,eachModelBproduces$60$inprofit,eachModelBproduces$40$ and each Model C produces profits of $$75.$

$*$ There are $200$ hours of cutting, $700$ hours of assembling, and $550$ hours of staining available in the production period.

$*$ Due to demand forecasts, between $20$ and $50$ of each model needs to be produced.

How many of each Model should WBB produce if it wants to maximize profit?

Step $1$ of $9$:

What are the inputs for this problem?