Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Health Care Management

Authors: Sharon B. Buchbinder, Nancy H. Shanks

3rd Edition

128408101X, 9781284081015

Students also viewed these Accounting questions