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. \begin{aligned} & \\ & \\ & 11 \\ & \( >2\end{aligned} \) Use the output to solve and answer the following question. By how much will marketing restriction 1 be exceeded? \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ Variable Cells } \\ \hline & & Final & Reduced & Objective & Allowable & Allowable \\ \hline Cell & Name & Value & Cost & Coefficient & Increasa & Decrease \\ \hline \$B\$18 & Necklace & 8 & 0 & 100 & 1E+30 & 12.5 \\ \hline$C$18 & Bracelet & 0 & -5 & 120 & 5 & 1F+30 \\ \hline \$D\$18 & Ring & 17 & 0 & 150 & & \\ \hline & & & & & 12.5 & 25 \\ \hline \$E\$18 & Earrings & 33 & 0 & 125 & 25 & 5 \\ \hline \multicolumn{7}{|l|}{ 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 & Restriction & & & & & \\ \hline$B$26 & 1 & 25 & b25 & 25 & 33 & 17 \\ \hline$B$27 & \begin{tabular}{l} Restriction \\ 2 \end{tabular} & 50 & -25 & 50 & 4 & 8.5 \\ \hline \end{tabular} 4 1 0 3

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

Financial And Managerial Accounting For Decision Makers

Authors: Michelle Hanlon, Robert Magee, Glenn Pfeiffer, Thomas Dyckman

4th Edition

1618533614, 9781618533616

More Books

Students also viewed these Accounting questions