Find the total transportation cost

Reference no: EM132342389

Problems: Transportation Analysis

Sweetland Sugar &Co. produces cane sugar in its four plants in Charlotte, Kansas City, Indianapolis and Flagstaff. These plants serve five major markets, New York, Chicago, St. Louis, Las Vegas and Seattle. The capacities of each plant, demands of each market and the transportation costs of sending a ton sugar from a plant to a market are given in the table below. The company seeks to develop a plan to minimize the transportation costs. Your task is to find the total transportation cost and the amounts of sugar sent from each plant to distribution centers and from each distribution center to markets using Excel Solver.

From Plants	To Markets					Supply (Tons)
From Plants	New York	Chicago	St. Louis	Las Vegas	Seattle	Supply (Tons)
Charlotte	$16	$13	$12	$22	$25	16
Kansas City	$20	$11	$6	$15	$18	17
Indianapolis	$10	$8	$8	$17	$19	13
Flagstaff	$25	$18	$15	$8	$15	19
Demand (tons)	15,000	12,000	9,000	14,000	13,000

Please Solve Problem using Excel Solver All the directions are in the problem. NOTE: The numbers shown as SUPPLY and DEMAND are CORRECT - Please solve with THESE inputs.

Reference no: EM132342389

Questions Cloud

Discuss how functional patterns help a nurse : Discuss how functional patterns help a nurse understand the current and past state of health for a patient. Using a condition or disease associated.

What are the strengths of the current regulatory scheme : What are the strengths and weaknesses of the current regulatory scheme for licensed professions? (refer to your text book). Write a 300 - word paper.

Advantages and disadvantages of both symmetrical : Evaluate the advantages and disadvantages of both symmetrical and master-slave multiprocessing systems in regards to computer processing speed

How do social media impact activism : How do social media impact activism by groups of college students? Researching examples of student activism on the Internet provides some answers.

Find the total transportation cost : Transportation Analysis - Your task is to find the total transportation cost and the amounts of sugar sent from each plant to distribution centers

Determining the denormalization functionality : Evaluate the need for denormalization within an organization. Provide at least three examples that prove denormalization is useful to data consumers.

Define the issue that elicits considerable disagreement : What is one issue that elicits considerable disagreement in your community or in the larger society? Can you think of more than two sides to this issue?

Optimizing database design : Identify at least two factors that should be considered in order to produce an optimal normalized set of tables when performing normalization

Take the actions that the software was designed : Software needs something to execute or take the actions that the software was designed to do. Matter of fact, without hardware, could we have created software?

User Account

All Pages