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?

Let B = Number of units of Butadiene produced
P = Number of units of Polyisoprene produced

Max 20B + 26P
 s.t.
 2.75B + 3.5P £ 180
 3B + 4P £ 200

B, P ³ 0 and integer