Question

Instructions A jewelry store makes necklace and bracelets from gold and platinum. The store has 18 ounces of gold and 20 ounces of platinum. Each necklace requires 3 ounces of gold and 2 ounces of platinum, whereas each bracelet requires 2 ounces of gold and 4 ounces of platinum The demand for bracelets is no more than 4 A mecklace earns $300 n proft and a bracelet $400, The store wants to determine the number of and bracelets to make in order to masimine profe. Solve this model using POM/OM and answer the following questions

Answer 1

bsccelet y00 (I)七tou many nopic/ acer ahcald be poured. Neck lacesY (2) tbu many ba elcts sheul d be ptaduced C3) Th e manmum psoft that should he made repost Lohfeb means o increase op

9 o oullocoo,ble sh&h means pQof 0% necklace can be increase by 牛300, up mo change opt solulcn: o it necklaces earned $40 on ProRF, ц necklace, saoo/d6e r o duced. to fbcoto AlGobra fe foxmmlekos Dec允feo variades: No of necklace-t be PYeduced.Χ. Wo.o

Soker Paaete Ofanctio) Decisinn Variable eoid 18 demand for bract Number of necklaces to be produced Number of bracelets to be produced A B

1 2 3 Microsoft Excel 12.0 Sensitivity Report Worksheet: [Linear Programming.xlsx]2-var (2) Report Created: 7/26/2016 11:07:38 PM 6 Adjustable Cells Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease Cell Name 9 SD$23 Decision Variable x 10 SE$23 Decision Variable 100 400 200 200 12 Constraints 13 14 Cell 15 SF$26 gold LHS 16 SFS27 platinum LHS 17 SF$28 demand for bracelet LHS Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease Name 18 18 12 2.67 1E+30 20 75 20