solve using excel and show formulation please

ABC, Inc., is a manufacturer of that anticipates nationwide demand for the next year to be in Market M1, M2, M3, and M4 as given in the table below. Managers at ABC are designing the manufacturing network and have selected four potential sites-S1, S2, S3, and S4. Plants could have a capacity of either 200,000 or 300,000 units. The annual fixed costs at the four locations are shown in the table below, along with the cost of producing and shipping one product to each of the four markets. Where should ABC build its factories and how large should they be? 3 S1 S2 S3 S4 Requirements Fixed Costs 200k 300k Variable Costs 6,000,000 9,000,000 5,000,000 8,000,000 5,000,000 8,000,000 6,000,000 9,000,000 200 240 220 M1 M2 M3 M4 230 250 300 250 240 215 270 310 285 275 230 110,000 200,000 130,000 100,000 290 230