From plantsExisting plantsAtlantaTulsaProposed locationsNew OrleansHoustonForecast demandTo Distribution CentersLos Angeles$8$4$5$4800New York$5$7$6$61200Production capacity6009005005002000Unit production cost$6$5$4 (anticipated)$3 (anticipated)Williams Auto Top Carriers hasdecided to open a third plant in oneof the two cities - New Orleans andHouston. Based on the informationbelow, which of the new location incombination with the existing plantsand distribution centers, yields alower cost for the firm?Find the total transportation cost,and the optimal product quantitiesfor each routes.

Decision Variables: Suppose-Xij be the quantities transported from plant i to distribution center j…

Answered: From plants Existing plants Atlanta…

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

Monczka-T rcnt Shipping is t he logistics vendorfor Handfield Manufacturing Co. in Ohio. Handfield has dailyshipments of a power-steering pump from its Ohio plant to an autoassembly line in Alabama. The value of the standard shipment is$250,000. Monczka-Trent has two options: ( I) its standard 2-dayshipment or (2) a subcontractor who will team drive overnightwith an effective delivery of one day. The extra driver costs $175.Handfield's holding cost is 35% annually for this kind of inventory.a) Which option is more economical?b) What productio n issues a re not included in the datapresented?
4.- A building materials company with production facilities in Reno, Spokane and Tacoma ships boxes to three distribution centers with costs per box as shown in the table. Get the cost of transportation by northwest corner method. From Center 1 Reno $3 Spokane $4 Tacoma $3 Demand 30 Center 2 $3 $2 $2 30 Center 2 $2 $3 $3 35 Capacity 25 40 30
Assign trucks to delivery routes so that total costs are minimized, given the cost data shown. Whatis the total cost?ROUTEA B C D E1 4 5 9 8 72 6 4 8 3 5Truck 3 7 3 10 4 64 5 2 5 5 85 6 5 3 4 9
1. A company would like to develop an aggregate plan and evaluate its cost using the transportation method. Solve using Excel of the QM software. Note: do not do this manually Related data are shown in the tables below Demand forecast Period Demand (Unit) 1 80 2 90 3 40 Supply Capacity available (units) Regular time 40 65 30 Period 1 2 3 Other Data Beginning Inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit Carrying cost Overtime 20 12 10 30 R 100 R 150 R 200 R 5 Subcontract 10 5 5
Find Initial Basic Feasible Solution: Plant € 1 2 3 Demand (i) (ii) Least Cost Method North-West Corner Method A 8 4 4 80 Vogel's Approximation Method B 14 6 20 90 Warehouse C 7 4 8 120 D 1 16 10 160 Supply 100 200 150
Weighted factor methodUse the table to calculate the most ideal X coordinate for supermarket Point Quantity offered/requested Transportation costs Coordinate X Coordinate Y Supermarket 1 3,000 0.04 4 8 Supermarket 2 3,500 0.04 7 2 Supermarket 3 2,000 0.07 3 5 Supermarket 4 1,500 0.07 7 4 Supermarket 5 1,200 0.07 6 8
Table I Projects Warehouse A B Supply 200 300 200 1,500 1,500 300 200 100 2 500 1,500 2.000 300 200 200 3. 1.000 1.000 Demand 2.000 1.500 1.000 4,500 Solve and find Uie lowest transoorLalion.cost Show your solutionns,
↓ ← M Gmail UNILUS | E X ChatGPT X YouTube GBS 660_A X Maps GE News C + File C:/Users/nemet/Desktop/UNILUS/2024/GBS%20660_Assignment%20Distance%20January%202024%20(1).pdf Translate GBS 660_Assignment Distance January 2024 (1).pdf Production X Lusaka Times-Zamb... R Browse Map | Rulac Item cost per Unit Setup cost 4 / 4 2 80 6-Hour D X Inventory carrying cost per year Weekly Net Requirement 1 105 3 130 QUESTION 2: The determination of lot sizes in an MRP system is a complicated and difficult problem. Lot sizes are the part quantities issued in the scheduled receipt and planned-order release sections of an MRP schedule. For parts produced in-house, lot sizes are the production quantities of batch sizes. For purchased parts, these are the quantities ordered from the supplier. Consider the following data relevant to an MRP lot-sizing problem: 4 50 Membersh X b Answered: X G The detern X 100% + # $25 $100 20.8% 5 Building a Better Re... 0 6 200 Get involved in hum... 7 125 8 100 Use the…
summanzed below: WAREHOUSE FACTORY F1 9 12 7 18 6 8 13 9 21 20 7 10 11 12 7 F3 14 15 22 Factory output and warehouse supplies that must be maintained are as follows: Eachory Mnits produced/day Warehouse Daily Supply #1 35 1 15 #2 25 2. 12 #3 40 3. 22 24 32 4. 30 5. 20 Determine; a. The best possible factory-to-warehouse shipping program using Vogel's Approximation Method. b. What is the cost of this shipping program?
Need answer for no.4 pls, thank you! 4. What are the logistics issues?
The Transportation Simplex Method Using Minimum Cost From Plant 1 Plant 2 Plant 3 Demand (Million kwh) City 1 $8 $9 $14 45 City 2 $6 $12 $9 20 City 3 $10 $13 $16 30 To City 4 $9 $7 $5 30 Supply (Million kwh) 35 50 40
4. In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,100 radials each year. In the past 2 years, 220 and 250, respectively were sold in fall, 360 and 300 in winter, 150 and 160 in spring, and 320 and 440 in summer. With a major expansion planned, Kelle projects sales next year to increase to 1,300 radials. Part 2 Based on next year's projected sales, the demand for each season is going to be (enter your responses as whole numbers): Season Demand Fall __________

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