A company manufactures a product at its plants in C and D; then ships the product to its fourdistribution centers inK, L, M, and N.The transportation costs per unit (in dollars per unit) are as follows:from C to K, L, M, and N: 10, 5, 9, and 20.from D to K, L, M, and N: 2, 8, 30, and 10.The monthly demand from K, L., M, and N are: 3000, 1400, 4000, and 1200 units, respectively.On the other hand, the monthly capacity at plants C and D are: 4100 and 5800 units, respectively.Develop a linear programming model that can be used to determine the distribution plan thatwill minimize total monthly transportation cost. Use Excel Solver to find the optimal solutionThe optimal solution shows that the total monthly transportation cost isdollars.

Answered: A company manufactures a product at its…

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

(b)Consider a transportation model with m sources and n destinations. Describe briefly how you can resolve the following situations while solving the problem: (i) Total supply is greater than total demand,
14. In addition to cost, which of the following is a key factor to consider in transportation mode decisions? A. Performance against promised delivery times. B. Access to the mode, from both the supplier and customer perspectives. C. Special handling requirements. D. All of the above.
OCEAN: Mike plans to transport 30 pallets containing 53 cartons and an additional pallet containing 40 cartons from Montreal to Shanghai. Each pallet (including the 1 additional pallet) weighs 800kgs and measures 121cm x 90cm x 100cm. The rate is $92 w/m. Determine the Freight cost ($). 3106 2000 32.67 25.5 Others
Prescott Industries transports sand and stone extracted from its open-pit mines located in Odessa and Bryan to its concrete block manufacturing facilities in Abilene, Tyler and San Angelo. For the capacities, locations, and shipment costs per truckload shown in the tableau below, determine the shipping pattern that will minimize transportation costs. What are the estimated transportation costs associated with this optimal allocation pattern? Source Odessa Bryan Demand Source Odessa Bryan Abilene $90 Demand $45 4,500 Abilene $90 $45 Destination Tyler 4,500 $25 $90 Fill in the tableau below by indicating the optimal number of shipments from a source to a destination in each cell. (Enter your responses as whole numbers. A response of "0" is equivalent to no shipments being planned.) The corresponding optimal total cost is $ 8,400 Destination Tyler $25 $90 San Angelo $75 8,400 $50 6,100 San Angelo $75 $50 Capacity 6,100 8,400 10,600 Capacity 8,400 10,600 (Enter your response as a whole…
6. A large textile firm has two manufacturing plants, two sources of raw material, and three market centers. The transportation costs between the sources and the plants and between the plants and the markets are as follows: Source Plant A 1 $1/ton 2 $2/ton 1 A $4/ton B $3/ton Plant B $1.50/ton $1.50/ton Market 2 $2/ton $4/ton 3 $1/ton $2/ton Ten tons are available from source 1 and 15 tons from source 2. The three market centers require 8 tons, 14 tons, and 3 tons. The plants have unlimited processing capacity.
Grocery List is a service for students who live on campus that orders and delivers groceries. We understand that students are frequently preoccupied with schoolwork or simply do not feel like going grocery shopping; this is where our service comes in. They will place an order on our website, we will prepare their groceries, and we will transport their goods to their university housing. You must sell this concept to the university; thus, you must answer the following questions in order to create a Story Map for the university Eyes Opened to Opportunities or Problems: How were the character’s eyes opened to the need?
East Texas Seasonings began as a small business in Athens Texas. Over the years, the company's success has exceeded the capacity of this one location so Mr. Sass, the owner opened 3 additional branches. Each of these branches house a unique source of the company's secret blend. In an attempt to increase efficiency, the company is preparing to build one processing center to serve its four sources of seasonings. The 4 source locations are at the coordinates shown below. Also, the volume from each source is provided. X-coordinateY-coordinate Volume Athens, Texas 30 40 100 Beaumont, Texas 20 15 400 Carthage, Texas 55 60 150 Denton, Texas 20 70 250 b. Calculate the volume-weighted center of gravity.
In transportation problem, consider the following scenario:When the total units from the sources are less than total demand units, which operation is performed to make the given matrix as balance matrix?
What were the market conditions prior to MercadoLibre.com's launch? Were there ideal conditions for the company? Why or why not?
Solve 9 a and b
Cargo Loading. You are in charge of loading cargo ships for International Cargo Company (ICC) at a major East Coast port. You have been asked to prepare a loading plan for an ICC freighter bound for Africa. An agricultural commodities dealer would like to transport the following products aboard this ship:Commodity Tons Available Volume per Ton (cu.ft.) Profit per Ton ($)1 4,000 40 702 3,000 25 503 2,000 60 604 1,000 50 80You can elect to load any or all of the available commodities. However, the ship has three cargo holds with the following capacity restrictions: Cargo Hold Weight Capacity (tons) Volume Capacity (cu.ft.)Forward 3,000 100,000Center 5,000 150,000Rear 2,000 120,000More than one type of commodity can be placed in the same cargo hold. However, because of balance considerations, the weight in the forward cargo hold must be within 10 percent of the weight in the rear cargo hold, and the center cargo hold…
SRS Limited is a manufacturing company in Asia (China and India) specializing in bicycles that they sell to the USA, Canada, and Africa. Recently they acquired JAP Bicycle in Jamaica and supplying them with bikes and parts. They want to get in the automatic wheelchair for the physical challenge. SRS Limited contracted you as a transportation consultant to see their shipment from Asia to Canada, the East and West coast of the USA, Jamaica, and Africa. a. Differentiate the difference between intra-modal and inter-modal and why you will have recommended one over the other.

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