A Manufacturer Makes Two Types of Rubber, Butadiene and Polyisoprene

Essay

A manufacturer makes two types of rubber, Butadiene and Polyisoprene. The plant has two machines, Machine-1 and Machine-2, which are used to make the rubber strips. Manufacturing one strip of Butadiene requires 2.75 hours on Machine-1 and 3 hours on Machine-2. Processing one strip of Polyisoprene, takes 3.5 hours on Machine-1 and 4 hours on Machine-2. Machine-1 is available 180 hours per month, and Machine-2 is available 200 hours per month. Formulate an all-integer spreadsheet model that will determine how many units of each type of rubber should be produced to maximize profits if the profit contributions of Butadiene and Polyisoprene are $20 and $26, respectively.
How many units of each type of rubber will maximize profits?
​