Zen Nail Spa in Albuquerque stocks four colors of nail polish, pink (Pi), white (W), blue...
Zen Nail Spa in Albuquerque stocks four colors of nail polish, pink (Pi), white (W), blue (B), and purple (Pu). Depending on the color requested, the client pays a different price due to drying times and need to touch up coverage. The pink color yields a profit of $100, white $150, blue $120, and purple $125. Bottles of pink nail polish take up one unit of shelf space and all other colors take up two units each. The total shelf space available in the storage cabinet and display is 108 units. Three of the colors (all except blue) require some mixing time. Pink takes three minutes, white takes five minutes, and purple takes a minute. The mixing technician can devote only two hours to these duties as she also runs the register at the Spa and the laser tag next door. Past demand has demonstrated that demand for pink and blue do not exceed 25 units each per week. However, the minimum weekly demand for white, blue and purple colors must be at least 50 units The sensitivity report appears below: Variable Cells Final Reduced ObjectiveAllowable Allowable Cell Name Value Cost Coefficient Increase Decrease SC$5 Pink SDS5 White SES5 Blue SFS5 Purple 1E+30 23.57142857 20.625 20.625 15.75 0 150 17.25 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SGS6 Shelf Space 108 SG$7 Mving120 625 15.75 108 69 120 Pink & 13.8 25 SG$8 Blue SG59 W.B&Pu50 4125