### Using excel solver to find the minimal cost

Andalus Furniture Company has two manufacturing plants, one at Aynor and another at Spartanburg. The cost in dollars of producing a kitchen chair at each of the two plants is given here. Aynor Cost = 75Q_1+ 5Q2/1 + 100 Spartanburg Cost = 25Q_2+ 2.5Q2/2+ 150 Where Q1 = number of Chairs produced at Aynor Q2 = Number of