3.1 Your company produces breakfast cereal at five different plants. The monthly capacity (in tons) of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
3.1 Your company produces breakfast cereal at five different plants. The monthly capacity (in tons) of each plant is given below. The cereal is stored at one of the three warehouses. The per ton cost of producing cereal at each plant and shipping it to each warehouse is given below. You have four customers. The cost of shipping a ton of cereal from each warehouse to each customer is also given below. Each customer must receive the amount (in tons) of cereal given below. The annual fixed cost of operating each plant and warehouse is also given below. Your goal is to minimize the annual cost of meeting customer demands. Which plants and warehouses should be open, and what is the optimal shipping plan? Capacities (tons) 1 2 3 4 5 Plant 300 200 300 200 400 Customers 1 2 3 4 Requirements (tons) 200 300 150 250 Shipping Costs To Warehouses To Customers 1 2 3 1 2 3 4 Fixed Cost Plant 1 $800 $1000 $1200 $35,000 Plant 2 $700 $500 $700 $45,000 From Plant 3 $800 $600 $500 $40,000 Plant 4 $500 $600 $700 $42,000 Plant 5 $700 $600 $500 $40,000 Warehouse 1 From Warehouse 2 Warehouse 3 1 1 1 $40 $80 $90 $50 $40,000 $70 $40 $60 $80 $30,000 $80 $30 $50 $60 $50,000 3.1 Your company produces breakfast cereal at five different plants. The monthly capacity (in tons) of each plant is given below. The cereal is stored at one of the three warehouses. The per ton cost of producing cereal at each plant and shipping it to each warehouse is given below. You have four customers. The cost of shipping a ton of cereal from each warehouse to each customer is also given below. Each customer must receive the amount (in tons) of cereal given below. The annual fixed cost of operating each plant and warehouse is also given below. Your goal is to minimize the annual cost of meeting customer demands. Which plants and warehouses should be open, and what is the optimal shipping plan? Capacities (tons) 1 2 3 4 5 Plant 300 200 300 200 400 Customers 1 2 3 4 Requirements (tons) 200 300 150 250 Shipping Costs To Warehouses To Customers 1 2 3 1 2 3 4 Fixed Cost Plant 1 $800 $1000 $1200 $35,000 Plant 2 $700 $500 $700 $45,000 From Plant 3 $800 $600 $500 $40,000 Plant 4 $500 $600 $700 $42,000 Plant 5 $700 $600 $500 $40,000 Warehouse 1 From Warehouse 2 Warehouse 3 1 1 1 $40 $80 $90 $50 $40,000 $70 $40 $60 $80 $30,000 $80 $30 $50 $60 $50,000
Expert Answer:
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date:
Students also viewed these general management questions
-
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 companys four...
-
The Fleek Corporation has 5 warehouses designated A-E from which they supply 6 customers numbered 1-6.The table below gives the shipping cost in dollars per ton from each warehouse to each customer...
-
A bank reconciliation takes time and must balance. An employee was struggling in balancing the bank reconciliation. Her supervisor told her to plug (make an unsupported entry for) the difference,...
-
Godfreid Company has accounts receivable of $95,400 at March 31, 2019. Credit terms are 2/10, n/30. At March 31, 2019, there is a $2,100 credit balance in Allowance for Doubtful Accounts prior to...
-
Determine Zi Zo, and Vo for the network of Fig. 8.77 if Vi = 0.1 mV. +15 V 3.3 k
-
The following schematic diagram for a solar-driven irrigation pump was developed by Battelle Memorial Institute and uses tracking PTCs. Solar energy is used to heat the water in the collectors to...
-
On April 1, 2001, Rowe Tool Company authorized the sale of $5,000,000 of 6% convertible bonds with interest payment dates of April 1 and October 1. The bonds were sold on July 1, 2001, and mature on...
-
John Smith and Mary Jones are in a partnership which provides consulting services in the bio - tech industry. John and Mary share profits and losses on a 2 : 3 ratio. On December 3 1 , 2 0 2 3 , they...
-
BestValue Corporation's Trial Balance at December 31, 20XX is presented below. All 20XX transactions have been recorded eNcept for the items described on the next page. Debit Credit Cash 109,890...
-
QUESTION 2 Ignore Vat Antique Porcelains is a porcelain doll making company. Antique Porcelains has caught the attention of many larger porcelain doll manufacturers who have offered the owner a...
-
QUESTION 2 You are in charge of making forecasts and preparing budgets. You have been supplied with cost and revenue forecasts and details of payment as follows: 1. Forecast of revenue and costs for...
-
Question 2. Consider an 5-node network (with 0 as the depot vertex and 4 other vertices) where the travel cost matrix and the demands are as follows: 0 1 2 3 4 1 2 279 420 0 0 279 0 420 256 0 288 349...
-
Q-1) Exercise on Data-Flow Coverage: Given the following code: begin read(x, y, z, w); if (z >= 0) then w = z; //L-II while w 0 do begin //L-I Z := Z * w; W:= z; //L-III end; if (x < 0) then z++;...
-
PROBLEM THREE $400,000 4% bonds are issued at 97.67708575 for $390,708.34 when the market rate for similar bonds is 5%. Regular interest payments are June 30th and December 31st each year. Complete...
-
Crowl Corporation is investigating automating a process by purchasing a machine for $801,900 that would have a 9-year useful life and no salvage value. By automating the process, the company would...
-
Explain the differences and similarities between fringe benefits and salary as forms of compensation.
-
In the optimal solution to the Great Threads model, the labor hour and cloth constraints are both bindingthe company is using all it has. a. Use SolverTable to see what happens to the optimal...
-
The file P07_02.xlsx contains data on the 1995 students who have gone through the MBA program at State University. You can consider this the population of State Universitys MBA students. a. Find the...
-
A construction company has to complete a project no later than three months from now or there will be significant cost overruns. The manager of the construction company believes that there are four...
-
The Private Securities Litigation Reform Act of 1995 and the U.S. Supreme Court's decision in Central Bank of Denver v. First Interstate Bank of Denver represent major victories in the profession's...
-
What are heuristics, and why are they of concern to auditors?
-
Identify and briefly describe the major files that are typically maintained separately from audit working papers.
Study smarter with the SolutionInn App