90.2K

Verified Solution

Link Copied!

Current Attempt in Progress

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.

Answer each of the below questions in an Excel file. Answer questions $2,3$ and $4$ by documenting the answer to the question under the Microsoft Solver

solution output. Upload the Excel File.

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?

Answer & Explanation Solved by verified expert

See Answer