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 = 80Q1 + 7Q12 + 93 Spartanburg: Cost = 20Q2 + 3Q22 + 147

WhereQ1 = number of Chairs produced at Aynor

Q2 = Number of Chairs produced at SpartanburgAndalus needs to Manufacture a total of 40 Kitchen Chairs to met an order just received. Howmany chairs should be made at Aynor and how many should be made at Spartanburg in order tominimize production costs.

Min + 100) + s. t. Q1 + Q2 = 40Q1, Q2≥0

a. Using Excel Solver What is the optimal solution for this problem

Question

Business

Beasley

31 January, 09:30

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 = 80Q1 + 7Q12 + 93 Spartanburg: Cost = 20Q2 + 3Q22 + 147

WhereQ1 = number of Chairs produced at Aynor

Q2 = Number of Chairs produced at SpartanburgAndalus needs to Manufacture a total of 40 Kitchen Chairs to met an order just received. Howmany chairs should be made at Aynor and how many should be made at Spartanburg in order tominimize production costs.

Min + 100) + s. t. Q1 + Q2 = 40Q1, Q2≥0

a. Using Excel Solver What is the optimal solution for this problem

+4

Answers (1)

Know the Answer?

Abdullah Bradley · Answer 1

9 in Aynor and 31 in Spartanburg

Explanation:

we need to build the following:

A B C

units COST

Aynor 9 = 93 + 80*B2 + POWER (B2; 2) * 7

Spartanburg 31 = 147 + 20*B2 + POWER (B2; 2) * 3

=b2 + b3 = c2 + c3

We stablish that we want to minimize c3

changing cell b2 and b3

with the restriction that must be integer solution and b4 should equal 40