A fruit juice manufacturer has recently begun negotiations with brokers in the areas where it intends to distribute itsproducts. Before finalizing the agreements, however, the manager wants to determine shipping routes and costs.The firm has three plants with the capacities as shown below: Estimate demands in each of the warehouse localities are:PLANT CAPACITY (BOXES PER WEEK)DEMAND (BOXES PER WEEK)WAREHOUSEA12325,00045,00030.000The estimated ship cost per box for the various routes are:TOFROMABCDII245223323421Row/Column Opportunity CostDemandBCDRow/ColumnOpportunity CostCellTotal Cost10.00020,00040.00020.000SupplyCost of the above Test of unallocated Cellsallocation3.Amount

Answered: A fruit juice manufacturer has recently…

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...

See similar textbooks

Similar questions

Suppliers A, B, and C supply components to three plants -- F, G, and H via two transshipment facilities -- T1 and T2. It costs $4 to ship from T1 regardless of final destination and $3 to ship to T2 regardless of supplier. Shipping to T1 from A, B, and C costs $3, $4, and $5, respectively, and shipping from T2 to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. The Logistics Manager has come to you for help. Answer the following question: Which of these is not an element of the objective function? Group of answer choices 4D-T1 600T1 9T2-G 3C-T2 Plz do fast asap
solve the following LP MODELS
Supply Solve the following Transportation problem using best cell method What is the total cost? 1 2 3 4 A 25 3 10 5 9 Destination B 35 2 1 2 6 C 10 1 2 8 3 D 30 1 2 8 3 25 20 25 30
a company's business model was to operate through its facilities- Vancouver, Calgary, Winnipeg, Toronto(ontario), ottawa, Montreal and Halifax. Supply comes from South America, southeast Asia, and Florida. the company was shipping first to Toronto and then to each facility at a total cost of $23095.5 per week. The company is considering the possibility of opening a logistics facility in Miami. Toronto and Vancouver were already available as transshipment centres. What would be the cost savings if Miami centre was opened and what would be the optimal shipment plan?
E4
#4. The Pelican Company has four distribution centers (A, B, C, and D) that require 50,000, 40,000, 60,000 and 40,000 liters of diesel fuel, respectively, per month for their long-haul trucks. Three fuel wholesalers (1, 2 and 3) have indicated their willingness to supply as many as 60,000, 80,000, and 50,000 liters of fuel, respectively. The total cost (shipping and price) of delivering 1000 liters of fuel from each wholesaler to each distribution center is shown in the following table. Distribution center Wholesaler A B C D • 1 1700 1600 1600 1600 2 1500 1800 1600 1700 3 1800 1500 1800 1600 I. Determine the optimal solution. Check if all capacities have been exhausted and that all demands can be met with this solution. II. What is the total cost of the solution?
Given the dataset of a supply network in the following table: Location X co-ordinates Y co-ordinates Supply or demand Site 1 61 44 40 Site 2 12 16 Site 3 38 26 76 Site 4 6 22 72 63 22 54 Supplier 1 Supplier 2 26 8 77 18 62 37 Supplier 3 Supplier 4 8 65 43 Supplier 5 43 36 26 Supplier 6 8 41 68 a. Calculate the Euclidean distance from every potential site to every supplier b. Calculate the load-distance value for every potential site. c. Conclude on the best site with the lowest load-distance value.
Determine the suitable location of a distribution centre with the below data, minimizing the transportation dollars spent on managing inbound and outbound shipments. Plot the location of the Vendors, Customers and the location of the new DC in a chart Vendor V1 V2 V3 V4 Customer C1 C2 C3 C4 Rate $ per Ton Mile $ $ $ $ 4.75 3.75 3.15 4.75 Rate $ per Ton Mile $ $ $ $ 3.50 3.75 4.25 5.00 Volume in Tons 1000 1000 1600 1400 Volume in Tons 760 640 800 500 Vendor Location Coordinates (miles) Horizontal 525 600 412.5 300 Vertical 300 750 750 630 Customer Location Coordinates(miles) Vertical 450 900 1050 975 Horizontal 900 900 825 1050
A valve manufacturer is considering three alternative locations for a new plant for manufacturing ball valves for oil and gas industry. Since the plant ships nationwide, revenue is assumed the same regardless of plant location. The estimated annual fixed and variable costs for each site is shown in TABLE Location Costs A B C Fixed (RM) 700,000 1,000,000 $1,500,000 Variable (RM) $28 $18 $12 Identify the range of output for which each location provides the lowest total cost. Show necessary graph and calculation used in the analysis. Discuss on the finding(s).
Three orchards supply crates of oranges to four retailers. The daily demand amounts at the four retailers are 150, 150, 400, and 100 crates, respectively. Supplies at the three orchards are dictated by available regular labor and are estimated at 150, 200, and 250 crates daily. However, both orchards 1 and 2 have indicated that they could supply more crates, if necessary, by using overtime labor. Orchard 3 does not offer this option. The transportation costs per crate from the orchards to the retailers are given in Table 5.27. Formulate the problem as a transportation model. Solve the problem. How many crates should orchards 1 and 2 supply using overtime labor? Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure
An auto compant currently maintains plants in Cincinnati and Tulsa to supply two distributioncenters in Boston and Phoenix. The production and distribution costs, distribution demands aswell as facility capacities are given in the table attached Using the northwest-corner method, determine the initial allocated quantity for eachshipping route as well as the overall cost.

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

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

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS