Please solve how to use in Excel, use model in last photo!!!

6-26 A manufacturer has acquired four small assembly plants, located in Charlotte, Tulsa, Memphis, and Buffalo. The plan is to remodel and keep two of the plants and close the other two. The table at the top of the next page provides the anticipated monthly capac- ities and the monthly fixed costs for operating plants at each potential site. It is estimated that the costs to remodel and/or close the plants are equivalent. Because of union considerations, if the plant in Buffalo is kept open, the plant in Tulsa must also be kept open. If the objective is to minimize total fixed and shipping costs, which two sites should be selected to continue assembly? Table for Problem 6-26 CHARLOTTE TULSA MEMPHIS BUFFALO 7,000 6,500 7,250 7,500 $32,000 $30,000 $35,000 $34,000 Monthly capacity (units) Monthly fixed cost ($) Shipping to Region 1 ($/unit) Shipping to Region 2 ($/unit) Shipping to Region 3 ($/unit) $ 5 $ 8 $ 3 $ 2 $ 4 $ 5 $ 3 $ 9 $ 5 $ 3 $ 4 $ 10 REGION 1 REGION 2 REGION 3 Monthly demand (units) 3,000 4,000 6,500 1 Problem 6-26 3 Regular variables T3 M1 Binary variables T M C1 C2 C3 T1 T2 M2 M3 B1 B2 B3 C B $5 $4 $5 $8 $5 $3 $3 $3 $4 $2 $9 $10 $30,000 $35,000 $34,000 $32,000 1 1 1 1 1 1 Capacity 7000 6500 7250 7500 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 LHS Sign RHS 5 Solution values S Cost Constraints: Char capacity 3 Tulsa capacity 0 Memp capacity 1 Buff capacity 2 Buffalo : Tulsa 3 Reg1 demand 4 Reg2 demand 5 Reg3 demand 6 2 plants 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2