Question: 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.

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:

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

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...

General Electric currently has four 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...

General Electric currently has four 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...

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...

maximum volume details are given as below. Formulate a mixed - integer programming model to identify which two factories the management should retain to fulfill the estimated demand while minimizing...

ormulate a mixed - integer programming model to identify which two factories the management should retain to fulfill the estimated demand while minimizing the cost. Solve the model in Excel and...

How should the control volume method be implemented at an interface between two materials with different thermal conductivities? Illustrate with a steady, one-dimensional example. Neglect contact...

Pat invested a total of $3,000. Part of the money was invested in a money market account that paid 10% simple annual interest, and the remainder of the money was invested in a fraud that paid 8%...

When actual performance results are better than what the plan called for, managers should: Question 3 Answer a . issue more stock options to employees b . sell more products c . ignore it d ....

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...