EX $3\mathrm{.}17($L$05,6)$ Data Managerial Accounting Linear Optimization Tiana's Jewel Design, Inc.

designs and manufactures mass produced metal jewelry and custom designed silver$-$plated jewelry.

Currently, the owner designs and produces three lines of custom jewelry: necklaces, bracelets, and earrings

$($decision variables$).$ The contribution margin and the resource requirements for each product follows.

They would like to maximize the contribution margin $($objective function$).$ However, the owner has

these constraints:

A contract to produce at least ten pairs of custom earrings a month.

They can sell all the custom necklaces and custom earrings that are produced

Demand for custom bracelets is only $30$ a month.

Each month $800$ ounces of silver plate can be purchased.

Two designers work a total of $120$ hours a month.

An estimated $80$ hours of machining time are available each month.

Use Microsoft Excel Solver to create a linear optimization model.

How many of each product should be produced to maximize the contribution margin?

Are any of the constraints binding?

Based on the output from the answer report, what advice would you give the owner?