Reference no: EM131134081
The LP problem whose output follows determines how many necklaces, bracelets, rings, and earrings a jewelry store should stock (measured in stocking units). The objective function measures profit; it is assumed that every piece stocked will be sold. Constraint 1 measures display space capacity in units, constraint 2 measures time to set up the display in minutes. Constraints 3 and 4 are marketing restrictions.
|
MAX
|
100X1+120X2+150X3+125X4
|
|
1) X1+2X2+2X3+2X4
|
|
2) 3X1+5X2+X4
|
|
3) X1+X3
|
|
4) X2+X3+X4>50 plus nonnegativity
|
|
|
|
|
|
|
|
|
Target Cell (Max)
|
|
|
|
|
|
|
|
|
|
Cell
|
Name
|
Final Value
|
|
|
|
|
|
|
|
|
$B$9
|
profit
|
7475
|
|
|
|
|
|
|
|
Adjustable Cells
|
|
|
|
|
|
|
|
|
|
|
|
Final
|
Reduced
|
Objective
|
Allowable
|
Allowable
|
|
|
|
|
Cell
|
Name
|
Value
|
Cost
|
Coefficient
|
Increase
|
Decrease
|
|
|
|
|
$G$3
|
x1 (necklaces)
|
8
|
0
|
100
|
1E+30
|
12.5
|
|
|
|
|
$G$4
|
x2 (bracelets)
|
0
|
-5
|
120
|
5
|
1E+30
|
|
|
|
|
$G$5
|
x3 (rings)
|
17
|
0
|
150
|
12.5
|
25
|
|
|
|
|
$G$6
|
x4 (earrings)
|
33
|
0
|
125
|
25
|
5
|
|
|
|
Constraints
|
|
|
|
|
|
|
|
|
|
|
|
Final
|
Shadow
|
Constraint
|
Allowable
|
Allowable
|
|
|
|
|
Cell
|
Name
|
Value
|
Price
|
R.H. Side
|
Increase
|
Decrease
|
|
|
|
|
$C$7
|
usage space
|
108
|
75
|
108
|
15.75
|
8
|
|
|
|
|
$D$7
|
usage setup time
|
57
|
0
|
120
|
1E+30
|
63
|
|
|
|
|
$E$7
|
usage marketing1
|
25
|
25
|
25
|
33
|
17
|
|
|
|
|
$F$7
|
usage marketing2
|
50
|
-25
|
50
|
4
|
8.5
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Use the output to answer the questions:
What is the optimal solution and what profit will it return?
How much would you be willing to pay to reduce the setup time restriction by 20 minutes?
If the profit for 1 unit of necklace were to drop by $10 what impact will this have?
Do the same for earrings?
What if the profit for necklaces and the profit for rings were both to drop by $5? What could we say then?
The jewelry store is considering having watches as well. Watches take up 3 units of space and one unit of set up time. They also contribute one unit to each of the marketing restrictions (rhs decreases by 1 for each). How much profit would be needed to make it worthwhile to store watches?
You are offered the chance to obtain more space. The offer is for 15 units and the total price is 1000. What should you do? How about 16 units for the same price?
How would the solution change if the profit for bracelets was to increase to 122/unit? What about profit?
|
Write a letter to the director of graduation funds
: Write a letter to the Director of Graduation Funds with the Department of Education asking for either a block grant or categorical grant to improve those rates.
|
|
How to use primavera
: Buyer of this manual will learn each and everything about the primavera like project management, making new projects
|
|
Review the following paragraph
: Review the following paragraph and check for grammatical errors.- This paragraph is about Adventures of Huck Finn by Mark Twain.
|
|
What her expected profit in first-price sealed-bid auction
: Again assuming the stamp collector values the stamp at $11, what is her expected profit in the first-price sealed-bid auction
|
|
The profit for necklaces and the profit for rings
: The LP problem whose output follows determines how many necklaces, bracelets, rings, and earrings a jewelry store should stock (measured in stocking units).
|
|
Propose a plan that includes one leadership theory
: Propose a plan that includes one leadership theory, two leadership styles, and two leadership characteristics that you would use in order to motivate from staff and other stakeholders.
|
|
Determine the rate of entropy production in the turbine
: Air enters a 3600-kW turbine operating at steady state with a mass flow rate of 18 kg/s at 8008C, 3 bar and a velocity of 100 m/s. The air expands adiabatically through the turbine and exits at a velocity of 150 m/s. The air then enters a diffuser..
|
|
Create a venn diagram to reflect the data
: In a survey of 125 dancers, 73 knew the ballroom dances, 62 knew the Latin dances, and 49 knew the swing dances. Of these, 23 knew the ballroom and swing dances, 35 knew the ballroom and Latin dances, and 29 knew the Latin and swing dances. Twelve da..
|
|
What is strategic leadership
: What is strategic leadership, who has primary responsibility for strategic leadership, and what are the five key strategic leadership actions?provide examples with your response ?
|