QUESTION 3 Suria Company Sdn. Bhd. has three production plants, each of which produces three different models of a particular product. The daily capacities of the three plants are as follow :

...refer to table in picture...

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 RM55,000, for Plant 2 is RM60,000, and for Plant 3 is RM60,000. By using the 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 might have to prepare a report for proposing an optimal solution by using quantitative analysis techniques.

Note: I need to see solution step-by-step based using Solver in Microsoft Excel 2016. I've tried many times but didn't get the desired answer.

75% QUESTION 3 (TOTAL 25 MARKS Sura Company Sdn Bhd has three production plants, each at which produces three different models of a particular product. The day capacities of the three plants are as follows Model 3 (Units) Plant am 3.000 5,000 TOO 128000 4000 The total demand for More 20.000 units for Model 2 172,000 units and for Models 249.500 units Moreover, the daily operating cost for Panti RM6.000 for Plant 2 RANDO and twPlant 30.000 By using the ExcelSolver, determine the number of to shout sachi plant operated near to fill the total mand, and how the operating som How to report Dropounganisho by in 75% QUESTION 3 (TOTAL 25 MARKS Sura Company Sdn Bhd has three production plants, each at which produces three different models of a particular product. The day capacities of the three plants are as follows Model 3 (Units) Plant am 3.000 5,000 TOO 128000 4000 The total demand for More 20.000 units for Model 2 172,000 units and for Models 249.500 units Moreover, the daily operating cost for Panti RM6.000 for Plant 2 RANDO and twPlant 30.000 By using the ExcelSolver, determine the number of to shout sachi plant operated near to fill the total mand, and how the operating som How to report Dropounganisho by in