Wood Built Bookshelves $($WBB$)$ Production Problem

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$ in profit, each Model B produces $$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?

Resource Limitations & Production Requirements

Profit per unit & Resource Limitations

Cutting, Assembling, & Staining

Cutting, Assembling, Staining, Profit per Unit, Resource Limitations, & Production Requirements

Number of Bookshelves to Make