Question
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
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 follows.
Model 1(Units) | Model 2 (Units) | Model 3 (Units) | |
Plant 1 | 8000 | 4000 | 8000 |
Plant 2 | 6000 | 6000 | 3000 |
Plant 3 | 12000 | 4000 | 8000 |
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started