Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The LP problem whose output follows determines how many necklaces, bracelets, rings, and earrings a jewelry store should stock. The objective function measures profit; it
The LP problem whose output follows determines how many necklaces, bracelets, rings, and earrings a jewelry store should stock. The objective function measures profit; it is assumed that every piece stocked will be sold. Constraints measure display space in units, time to set up the display in minutes and two marketing restrictions. Variable Cells \begin{tabular}{|lrrrrrrr} \hline Cell & Name & Value & Cost & \begin{tabular}{r} Final \\ Coefficient \end{tabular} & \begin{tabular}{r} Reduced \\ Increase \end{tabular} & \begin{tabular}{r} Objective \\ Decrease \end{tabular} \\ \hline \$B\$18 & Necklace & 8 & 0 & 100 & 1E+30 & 12.5 \\ \hline \$C\$18 & Bracelet & 0 & -5 & 120 & 5 & 1E+30 \\ \hline \$D\$18 & Ring & 17 & 0 & 150 & 12.5 & 25 \\ \hline \$E\$18 & Earrings & 33 & 0 & 125 & 25 & 5 \\ \hline \end{tabular} Constraints \begin{tabular}{|c|c|c|c|c|c|c|} \hline & & Final & Shadow & Constraint & Allowable & Allowable \\ \hline Cell & Name & Value & Price & R.H. Side & Increase & Decrease \\ \hline$B$24 & Space & 108 & 75 & 108 & 15.75 & 8 \\ \hline$B$25 & Time & 57 & 0 & 120 & 1E+30 & 63 \\ \hline & Restriction & & & & & \\ \hline$B$26 & 1 & 25 & 25 & 25 & 33 & 17 \\ \hline & Restriction & & & & & \\ \hline$B$27 & 2 & 50 & -25 & 50 & 4 & 8.5 \\ \hline \end{tabular} 74757230715080000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started