Suria Company Sdn. Bhd. has three production plants, each of which produces three different models of a particular product. The daily capacities (in thousands of units) of the three plants are as follows. 

	Model 1	Model 2	Model 3
Plant 1	8	4	8
Plant 2	6	6	3
Plant 3	12	4	8

The total demand for Model 1 is 300,000 units, for Model 2 is 172,000 units, and for Model 3 are 249,500 units. Moreover, the daily operating cost for Plant 1 is $55,000,   for Plant 2 is $60,000, and for Plant 3 is $60,000. By using the Simplex Method in Excel Solver, determine the number of days should each plant be operated in order to fill the total demand, and keep the operating cost at a minimum.

 

Note: You have to prepare a report for proposing an optimal solution by using quantitative analysis techniques.

Answer rating: 100% (QA)

NOTE The Daily capacities in Thousands of the three piants Let plant ... View the full answer