company has a total of 3 factories to produce steel and iron. Every month, the company must meet the following demands: 3200 tonnes of steel and 1000 tonnes of Iron. Each factory has a different shipping cost per tonne (£/tonne) for each product as shown in the table below: Factory Steel Iron 1 200 500 2 800 400 3 500 1000 The warehouses in Factory 1, Factory 2 and Factory 3 can store 2000 tonnes,1500 tonnes and 2500 tonnes of products, respectively. The company is seeking for a solution to minimise the shipping cost. a) Based on the table above, determine the optimal monthly assignment plan for the factory. That is, how many tonnes each factory needs to be shipped t

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

A company has a total of 3 factories to produce steel and iron. Every month, the company
must meet the following demands: 3200 tonnes of steel and 1000 tonnes of Iron. Each factory
has a different shipping cost per tonne (£/tonne) for each product as shown in the table
below:
Factory Steel Iron
1 200 500
2 800 400
3 500 1000
The warehouses in Factory 1, Factory 2 and Factory 3 can store 2000 tonnes,1500 tonnes and
2500 tonnes of products, respectively. The company is seeking for a solution to minimise the
shipping cost.
a) Based on the table above, determine the optimal monthly assignment plan for the factory.
That is, how many tonnes each factory needs to be shipped to fulfil the demand.
b) Suppose Factory 3 will not be available during the next few months. Keeping the same
demand, is the company able to fulfil the demands? What would be the revised assignment
plan to ensure demand is fulfilled?
c) The cost of raw materials in each factory is shown in the table below. Change the company
objective function to minimize all costs and find the optimal assignment plan. Does the new
solution change from the base case? If yes, how so?
Factory Steel raw material
cost
Iron raw material
cost
1 50 100
2 70 120
3 45 130
(20

Expert Solution
steps

Step by step

Solved in 5 steps with 14 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.