Done using Excel Solver

AB.... come Insert Draw Page Layout utoSave OFF Paste 1 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 In Unit Revenue Fixed Cost 31 32 33 34 Fixed Charge Homework Tennessee Computers owns four production plants at which personal computers can be produced. TC can sell up to 20,000 computers per year at a price of $3,500 per computer. For each plant production capacity, production cost per computer, and new equipment/setup costs (fixed) for each plant are given in the table below. Determine which plants TC should use for computer production and how many each plant used should produce in order to maximize profits. 35 Times New Roman 12 30 37 BIU 38 40 A. Set up and solve the problem to maximize total profit for Tennessee Computers. (HINT: Since we know the capacities for the plants, use them for "Z" in the capacity constraints) B. Format the problem to be presentation-ready. Plant 3 Plant 4 $3,500 $3,500 $5,000,000 $3,000,000 $1,000,000 Unit Production Cost $1,000 $1,700 $2,900 $2,300 9,000 Capacity 10,000 8,000 6,000 The optimal objective function value should be $25,600,000. fx Fixed Charge Homework IT Plant 1 $3,500 Formulas A A A. $9,000,000 Plant 2 $3,500 D Fixed Charge Data 11 E Review 11 di % || View Developer Wrap Text Merge & C