Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

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. MAXN+2B+2R+2E3N+5B+EN+RIB+R+E100N+120B+150R+125E=50MarketRestriction2 Use the output to solve and answer the following question. To what value can the profit on necklaces drop before the solution would change? Variable Cells \begin{tabular}{|c|c|c|c|c|c|c|} \hline Cell & Name & \begin{tabular}{l} Final \\ Value \end{tabular} & \begin{tabular}{c} Reduced \\ Cost \end{tabular} & \begin{tabular}{l} Objective \\ Coefficient \end{tabular} & \begin{tabular}{l} Allowable \\ Increase \end{tabular} & \begin{tabular}{l} Allowable \\ 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 \multicolumn{7}{|c|}{ Constraints } \\ \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$B$26 & \begin{tabular}{l} Restriction \\ 1 \end{tabular} & 25 & 25 & 25 & 33 & 17 \\ \hline$B$27 & \begin{tabular}{l} Restriction \\ 2 \end{tabular} & 50 & -25 & 50 & 4 & 8.5 \\ \hline \end{tabular} 7092.58587.5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing and Assurance services an integrated approach

Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Chris E. Hogan

16th edition

978-0134075754, 134075757, 134065824, 978-0134065823

More Books

Students also viewed these Accounting questions

Question

Explain all drawbacks of application procedure.

Answered: 1 week ago