Solve using Solver in Excel. Please do not post the answer that was already posted on Chegg as it is wrong. Please shoe all steps. Thank you.

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-5Q 100 Spartanburg Cost2.5Q 150 Where Q2 Number of Chairs produced at Spartanburg Andalus needs to Manufacture a total of 40 Kitchen Chairs to met an order just received. How many chairs should be made at Aynor and how many should be made at Spartanburg in order to minimize production costs. Min 100) + s.t. Q1 Q2 40 Q1,Q220 a. Using Excel Solver What is the optimal solution for this problem. 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-5Q 100 Spartanburg Cost2.5Q 150 Where Q2 Number of Chairs produced at Spartanburg Andalus needs to Manufacture a total of 40 Kitchen Chairs to met an order just received. How many chairs should be made at Aynor and how many should be made at Spartanburg in order to minimize production costs. Min 100) + s.t. Q1 Q2 40 Q1,Q220 a. Using Excel Solver What is the optimal solution for this