Business, 30.03.2021 17:00 haileesprague1578

The LP problem whose output follows determines how many necklaces (X1), bracelets (X2), rings (X3), and earrings (X4) a jewelry store should stock. The objective function measures profit; it is assumed that every piece stocked will be sold. Constraint 1 measures display space 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<108
2) 3X1+5X2+X4<120
3) X1+X3<25
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 1.00E+30 12.5
$G$4 x2 (bracelets) 0 -5 120 5 1.00E+30
$G$5 x3 (rings) 17 0 150 12.5 25
$G$6 x4 (earrings) 33 0 125 25 5

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 1.00E+30 63
$E$7 usage marketing1 25 25 25 33 17
$F$7 usage marketing2 50 -25 50 4 8.5

Required:
a. What is the optimal solution and what profit will it return?
b. How much would you be willing to pay to reduce the setup time restriction by 20 minutes?
c. If the profit for 1 unit of necklace were to drop by $10 what impact will this have?
d. Do the same for earrings?

Answers: 3

Show answers

Another question on Business

Business, 22.06.2019 07:30

Awell-written business plan can improve your chances of getting funding and give you more free time. improved logistics. greater negotiating power.

Answers: 1

Answer

Business, 22.06.2019 11:30

Leticia has worked for 20 years in the public relations department of a large firm and has been the vice-president for the past ten years. it is unlikely she will ever be promoted to the top executive position in her firm even though she has directed several successful projects and is quite capable. her lack of promotion is an illustration of (a) the "glass ceiling" (b) the "glass elevator" (c) the "mommy track" (d) sexual harassment

Answers: 3

Answer

Business, 22.06.2019 16:20

There are three factors that can affect the shape of the treasury yield curve (r* t , ip t , and mrp t ) and five factors that can affect the shape of the corporate yield curve (r* t , ip t , mrp t , drp t , and lp t ). the yield curve reflects the aggregation of the impacts from these factors. suppose the real risk-free rate and inflation rate are expected to remain at their current levels throughout the foreseeable future. consider all factors that affect the yield curve. then identify which of the following shapes that the us treasury yield curve can take. check all that apply.a. downward-sloping yield curveb. upward-sloping yield curvec. inverted yield curve

Answers: 1

Answer

Business, 22.06.2019 20:40

Asmall town wants to build some new recreational facilities. the proposed facilities include a swimming pool, recreation center, basketball court and baseball field. the town council wants to provide the facilities which will be used by the most people, but they face budget and land limitations. the town has $400,000 and 14 acres of land. the pool requires locker facilities which would be in the recreation center, so if the swimming pool is built the recreation center must also be built. also, the council has only enough flat land to build the basketball court or the baseball field. the daily usage and cost of the facilities (in $1,000) are shown below. which facilities should they build? facilityusagecost ($1,000)landswimming pool4001002recreation center5002003basketball court3001504baseball field2001005

Answers: 1

Answer

You know the right answer?

The LP problem whose output follows determines how many necklaces (X1), bracelets (X2), rings (X3),...

Questions