The Acme Company operates four factories that ship products to five warehouses. The shipping costs, requirements capacities, and optimal allocations are shownbelow.Shipping Cost per Case to WarehousesFactoryСарacityW1W2W3W4W5$1.20$3.60| $4.80$6.00$7.20F140,00030,00010,000$2.40$2.40| $1.20$4.80$6.00F230,00025,0005,000$1.20$6.00$1.20$3.60$1.20F330,00010.00020,000$6.00$2.40$4.80$6.00$4.80F425,00025,000Demand30,00035,00025,00015,00020,000125,000What is the total cost of the optimal solution?Total cost = $ (Enter your response to the nearest dollar.)

Optimal Solution is a practical arrangement that is supposed to be optimal arrangement on the off…

Answered: The Acme Company operates four…

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

A company currently ships products from 5 plants to 4 warehouses. The company is considering the option of closing down one or more plants. This would increase distribution cost but perhaps lower overall cost. What plants, if any, should the company close? Transportation Costs (per 1000 products) Plant 1 Plant 2 Plant 3 Plant 4 Plant 5 Warehouse 1 $4,000 $2,000 $3,000 $2,500 $4,500 Warehouse 2 $2,500 $2,600 $3,400 $3,000 $4,000 Warehouse 3 $1,200 $1,800 $2,600 $4,100 $3,000 Warehouse 4 $2,200 $2,600 $3,100 $3,700 $3,200 Demand from warehouses are: Demand Warehouse 1 15,000 Warehouse 2 18,000 Warehouse 3 14,000 Warehouse 4 20,000 Capacity of plants are: Plant 1 Plant 2 Plant 3 Plant 4 Plant 5…
A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 How many supply nodes are present in this problem? Multiple Choice: 4 3 1 8 16
ABC pharmaceutical Company has four factories that ship supplies to four warehouses. The company’s management hires you as a consultant to determine a minimum-cost shipping plan for its monthly output to the warehouses. Factory capacities, warehouse demands, and shipping cost per box are shown below. Factory Supply or capacity (boxes) Warehouse Demand (boxes) Richmond 60 Chicago 100 Santa Fe 80 Jacksonville 90 Austin 120 Huntville 50 Vacaville 90 Fresno 70 Shipping Costs per box (In Dollars) From To Chicago To Jacksonville To Huntsville To Fresno Richmond 35 35 46 60 Santa Fe 65 40 35 25 Austin 50 50 80 90 Vacaville 40 40 66 75 Draw a diagram by showing factories, warehouses, and connecting arcs. Define variables, write the objective function and constraints.
The Toys-R-4-U Company has developed two new toys for possible inclusion in its productline for the upcoming Christmas season. Setting up the production facilities to beginproduction would cost $50,000 for toy 1 and $80,000 for toy 2. Once these costs arecovered, the toys would generate a unit profit of $10 for toy 1 and $15 for toy 2. Thecompany has two factories that are capable of producing these toys. However, to avoiddoubling the start-up costs, just one factory would be used, where the choice would bebased on maximizing profit. For administrative reasons, the same factory would be usedfor both new toys if both are produced. Toy 1 can be produced at the rate of 50 per hourin factory 1 and 40 per hour in factory 2. Toy 2 can be produced at the rate of 40 perhour in factory 1 and 25 per hour in factory 2. Factories 1 and 2, respectively, have500 hours and 700 hours of production time available before Christmas that could beused to produce these toys. It is not known whether these…
PLEASE USE EXCEL Paul Bergey is in charge of loading cargo ships for International Cargo Company(ICC) at the port in Newport News, Virginia. Paul is preparing a loading plan for an ICC freighter destined for Ghana. An agricultural commodities dealer wants to transport the following products aboard this ship.Commodity Amount Available Volume per Ton Profit per Ton (tons) (cubic feet) ($) A 4,800 40 70B 2,500 25 50C 1,200 60 60D 1,700 55 80 Paul can elect to load any and/or all of the available commodities. However, theship has three cargo holds with the following capacity restrictions.Cargo Hold…
n operations manager wants to use cost-profit-volume (CPV) analysis to decide the location of a new production facility. The total cost functions of the two alternative, Location A and Location B, are presented below. Given that the target production quantity (volume) is 10,000 units, which location the operations manager should choose and what is the corresponding total cost of this location Tca=260,000 +10Q Tcb=90,000 + 30Q Location B, $390,000 There is no difference between the two locations Location B, $360,000 Location A, $360,000 Location A, $390,000
The following tables show the relevant information for the distribution of products from the plants (A-C) to the warehouses (D-F) and on to the customers (G-I), along with the unit shipping costs and the maximum amount that can be shipped to/from the warehouses, using units of full truckloads. Also shown are each plant’s monthly output and the monthly requirements of each customer. Unit Shipping Cost Shipping Capacity Output D E F D E F A $420 $390 $560 125 140 150 400 B $510 $590 $470 150 170 190 500 C $450 $360 $480 175 160 200 300 Unit Shipping Cost Shipping Capacity G H I G H I D $75 $63 $81 100 150 100 E $125 $110 $95 125 150 155 F $68 $82 $95 150 200 145 Required 350 475 375 How many arcs does the network have? Group of answer choices 18 9 12 21
The following tables show the relevant information for the distribution of products from the plants (A-C) to the warehouses (D-F) and on to the customers (G-I), along with the unit shipping costs and the maximum amount that can be shipped to/from the warehouses, using units of full truckloads. Also shown are each plant’s monthly output and the monthly requirements of each customer. Unit Shipping Cost Shipping Capacity Output D E F D E F A $420 $390 $560 125 140 150 400 B $510 $590 $470 150 170 190 500 C $450 $360 $480 175 160 200 300 Unit Shipping Cost Shipping Capacity G H I G H I D $75 $63 $81 100 150 100 E $125 $110 $95 125 150 155 F $68 $82 $95 150 200 145 Required 350 475 375 How many demand nodes are present in this problem? Group of answer choices 9 6 2 3
A Manager has the problem of assigning four new machines to three production facilities.The respective profits derived are as shown. If only one machine is assigned to a productionfacility, determine the optimal assignment.Profits ($’000) production facilityMachine A B CA 10 10 14B 10 11 13C 12 10 10D 13 12 11(c) Use Simplex method toMaximize 1 2 Ζ = 4x +10xSubject to 1 2 2x + x ≤ 501 2 2x + 5x ≤1001 2 2x + 3x ≤ 901 2 x , x ≥ 0QUESTION TWO
. David’s Sport Supplies is a store that sells sports equipmentand gear for teenagers and young adults. David’s is in the processof assigning the location of storage areas in its warehouse (Figure10-16) to minimize the number of trips made to retrieve neededitems. Given here in Table 10-14 are the departments that needto be located, the number of trips made per week for eachdepartment, and the area needed by each department.
Direction: Analyze the given problem and show your complete solution. The GEM maker of jewelry makes two bracelet designs, heart design and flower design. The bracelets are made of gold and platinum. The store has 28 ounces of gold and 20 ounces of platinum. Each heart design bracelet requires 3 ounces of gold and 2.5 ounces of platinum and makes a profit of P2500, while each flower design bracelet requires 4.5 ounces of gold and 3 ounces of platinum and makes a profit of P3400. How many heart design bracelets and flower design bracelets should be produced to maximize the profit? Decision variables Tabulation Objective function and constraints Graph and solution Optimum solution Decision
The Johnny Ho Manufacturing Company inColumbus, Ohio, is putting out four new electronic components. Each of Ho’s four plants has the capacity to add one more prod-uct to its current line of electronic parts. The unit-manufacturing costs for producing the different parts at the four plants areshown in the accompanying table. How should Ho assign the newproducts to the plants to minimize manufacturing costs?ELECTRONICCOMPONENT PLANT123 4C53 $0.10 $0.12 $0.13 $0.11C81 0.05 0.06 0.04 0.08D5 0.32 0.40 0.31 0.30D44 0.17 0.14 0.19 0.15

SEE MORE QUESTIONS

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