Light-Twilight Inc. currently has three factories where light bulbs are manufactured, but budget cuts are forcing the company to limit production to only two of the factories. Once produced, the light bulbs are shipped to five distribution centers. The cost demand, and maximum volume details are given as below. Shipping cost/1000 bulbs (S) Warehouse Factory 1 2 Maximum Volume (in 1000's) Fixed Cast (S) A 78 25 90 32,700 49 72 15 35,000 40.0XIO C 31 90 Na Demand (in 1000's) 401 Formulate a mixed-integer programming model to identify which two factories the management should retain in order to fulfill the estimated demand while minimizing the cost. Solve the model in Excel and answer the following questions: 1. What is the uplimal solution for the Number of light bulbs shipped from factory A to Warehouse 1? 2. What is the optimal solution for the Number of light bulbs shipped from factory A to Warehouse 2? 3. What is the optimal solution for the Number of light bulbs shipped from factory B to Warehouse I? 4. What is the optimal solution for the Number of light bulbs shipped from factory B to Warchouse 2? 5. What is the optimal solution for the Number of light bulbs shipped from factory C to Warchouse I? 6. What is the optimal solution for the Number of light bulbs shipped from factory Cto Warehouse 2? 7. Which factories should be selected? and 3. What is the optimal total cost?