Jackson Hole Manufacturing is a small manufacturer of plastic products used in the automotive and computer industries. One of its major contracts is with a large computer company and involves the production of plastic printer cases for the computer company's portable printers. The printer cases are produced on two injection molding machines. The M-100 machine has a production capacity of 25 printer cases per hour, and the M-200 machine has a production capacity of 40 cases per hour. Both machines use the same chemical material to produce the printer cases; the M-100 uses 40 pounds of the raw material per hour and the M-200 uses 50 pounds per hour. The computer company has asked Jackson Hole to produce as many of the cases during the upcoming week as possible and has said that it will pay $18 for each case Jackson Hole can deliver. However, next week is a regularly scheduled vacation period for most of Jackson Hole's production employees; during this time, annual maintenance is performed for all equipment in the plant. Because of the downtime for maintenance, the M-100 will be available for no more than 15 hours, and the M-200 will be available for no more than 10 hours. However, because of the high setup cost involved with both machines, management has a requirement that, if production is scheduled on either machine, the machine must be operated for at least 5 hours. The supplier of the chemical material used in the production process has informed Jackson Hole that a maximum of 1000 pounds of the chemical material will be available for next week's production; the cost for this raw material is $6 per pound. In addition to the raw material cost, Jackson Hole estimates that the hourly cost of operating the M-100 and the M-200 are $50 and $75, respectively.
Formulate a linear programming model that can be used to maximize the contribution to profit.
1- On excel do the sensitivity report
2- Provide the range of value for the decision variable coefficient
3- Identify constraints that have slack, and the range of the slack