For dollar amount, answer in two $(2)$ decimal points $($e$.$g$.24\mathrm{.}21).$ For quantity, answer in whole number $($e$.$g$.1234).$

A local jeweler store wants to invest in a new model wristband, which comes with three sizes small, medium and large. The table below provides

details on the required materials for wristband size as well as the profit contributions.

The shop has the following available inventory each week: $1,800$ beads, $480$ inches of thread, and $22$ ounces of glue.

In order for the store to make any profit on the small size wristband, they must make at least $30$ pieces. Since the large size requires a lot more

effort than the other two sizes, the owner does not want to make more than $25$ pieces.

Develop and solve a linear programming model using Excel Solver to find the profit for the owner. Using the solution from your developed model,

answer the following questions.

T$1.$he total profit is:

$2.$The number of small size wristband made is:

$3.$The number of medium size wristband made is:

$4.$The number of large size wristband made is:

$5.$The number of beads used is:

$6.$The amount of thread used is:

$7.$The amount of glue used is:

$\mathrm{.}8.$if the shop can change the materials required to make the wristband, in terms of its best contribution to the total profit, they should change the

$9.$

$.$ This is because the selected material has a

$10.$

shadow price. This also means that the dollar amount that the company can

Incorrect answer:

$($no answer$)$

is

Incorrect answer:

$($no answer$)$

for every additional unit added to the right$-$hand$-$side.