Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you please help me with this questionPlant to warehouse unit production, shipping costs, plant fixed costs, capacities To Capacity Warehouse 1 Warehouse 2 Warehouse

Can you please help me with this questionPlant to warehouse unit production, shipping costs, plant fixed costs, capacities To Capacity Warehouse 1 Warehouse 2 Warehouse 3 Fixed cost (tons)From Plant 1 $600 $700 $500 $25,000 500 Plant 2 $700 $500 $700 $35,000 200 Plant 3 $800 $400 $900 $40,000 300 Plant 4 $500 $600 $700 $50,000 400 Plant 5 $700 $600 $500 $40,000 400Warehouse to customer unit shipping costs, warehouse fixed costs To Customer 1 Customer 2 Customer 3 Customer 4 Fixed cost From Warehouse 1 $60 $80 $40 $70 $30,000 Warehouse 2 $70 $40 $60 $80 $40,000 Warehouse 3 $50 $50 $50 $50 $30,000 Customer requirements (tons) Customer 1 Customer 2 Customer 3 Customer 4 400 300 250 350

image text in transcribed
A food company produces tomato sauce at five different plants. The tomato sauce is then shipped to one of three warehouses, where it is stored until it is shipped to one of the company's four customers. All of the inputs for the problem are given in the file P14_92.xlsx, as follows: The plant capacities (in tons) The cost per ton of producing tomato sauce at each plant and shipping it to each warehouse The cost of shipping a ton of sauce from each warehouse to each customer The customer requirements (in tons) of sauce The fixed annual cost of operating each plant and warehouse. The company must decide which plants and warehouses to open, and which routes from plants to warehouses and from warehouses to customers to use. All customer demand must be met. A given customer's demand can be met from more than one warehouse, and a given plant can ship to more than one warehouse. Hint: This is a two-echelon problem! a- Write the optimization model. b- Determine the minimum-cost method for meeting customer demands using Excel Solver

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Comparative International Accounting

Authors: Christopher Nobes, Robert Parker

14th Edition

1292296461, 978-1292296463

More Books

Students also viewed these Accounting questions

Question

13. Give four examples of psychological Maginot lines.

Answered: 1 week ago