Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help me with this problem thanks!!! The LP problem whose output follows determines how many handbags, purses, perfume, and shoes (variables X1.X2, X3, and

image text in transcribed

please help me with this problem thanks!!!

image text in transcribedimage text in transcribed
The LP problem whose output follows determines how many handbags, purses, perfume, and shoes (variables X1.X2, X3, and X4, respectively) a retail store should stock. The objective function measures profit. It is assumed that every item stocked will be sold. Constraint 1 measures display space in units which has a maximum of 108 units. Constraint 2 measures time to set up the display in minutes where the maximum allowable time is 120 minutes. Constraints 3 and 4 are marketing constraints. The logic for constraint 4 indicates that the sum total of purses, perfume and shoes can be 50 or more. They make $100 for each handbag, $120 for each purse, $150 for each perfume and $125 for each set of shoes. MODEL OUTPUT FROM EXCEL: Original Cell Name Value Final Value SB$17 Z 7475 7475 Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $A$16 x1 [a]? 100 1E+30 12.5 $B$16 x2 -5.00 120 5.00 1E+30 $C$16 x3 17 150 12.5 25 $D$16 x4 33 [b]? 125 25 5.00 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$20 Constraint #1 108 75 108 15.75 8 $E$21 Constraint #2 57 [c]? 120 1E+30 63 $E$22 Constraint #3 25 25 25 33 17 $E$23 Constraint #4 [d]? -25 4 8.5Use what you know about linear programming to find the values for the four blanks (a, b, c and d) in the linear program computer printout: a) What is the missing value for [a]? b) What is the missing value for [b]? What is the missing value for [c]? What is the missing value for [d]? What is the value of slack/surplus for constraint #2? How much space will be left unused? How much time will be used? By how much will the second marketing restriction be exceeded? To what value can the profit on handbags drop before the solution would change? By how much can the profits on perfume increase before the solution would change? By how much can the amount of space decrease before there is a change in the profit? You are offered the chance to obtain more space. The offer is for 15 units and the total price is 1500. What should you do? Explain with calculations

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

Managerial Accounting

Authors: Stacey Whitecotton, Robert Libby, Fred Phillips

4th edition

1259964957, 1260413985, 1260565440, 978-1260413984

More Books

Students also viewed these Accounting questions