The capacities of each and every plant demands of each

Assignment Help Operation Management

Reference no: EM13388023

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

Reference no: EM13388023

Questions Cloud

Retailers like neiman marcus and rei have generous return : retailers such as neiman marcus and rei have generous return policies. other retailers provide price-match guarantees

Describe some specific examples of assets and liabilities : what are some specific examples of assets and liabilities?why do not-for-profit organizations use a fund accounting

Analyze the different ways of financing the health care : in light of the affordable health care act aca and the myriad of citizens using the new health care insurance system

Illustrate out the term accounting entity what are : 1. what is an accounting entity?2. what are the two most crucial aspects of this accounting entity

The capacities of each and every plant demands of each : sweetland sugar nbspampco. produces cane sugar in its four plants in charlotte kansas city indianapolis and flagstaff.

Describe why some consumers are attracted to such retailers : retailers such as neiman marcus and rei have generous return policies. other retailers provide price-match guarantees

What are the major factors considered in determining what : what are the major factors considered in determining what depreciation method to use? how often should you review these

What are strategies that companies have implemented or : how does diversity help to strengthen the workforceneed original fresh work in apa format w3-4 references 15 this

The manufacturing costs for these products are computed by : frigid air company produces three different types of industrial refrigerators a b and c. the production capacity of the

User Account

All Pages