a. Create a solver model and find the optimal solution to help SP develop a distribution plan that will minimize costs to supply thecustomers' demand. (Enter your answers in terms of cost per 1,000 lbs and shipment quantities per 1,000 lbs. Round your answersto the nearest whole number.)From/ToPhiladelphiaAtlantaSt. LouisSalt Lake CityFrom/ToPhiladelphiaAtlantaSt. LouisSalt Lake CityReceivedNYCNYC529CombinedCosts Per 1,000 lbs.Birmingham Terre HauteSolution (* 1,000 lbs.)Birmingham Terre Haute418929DallasDallas604SpokaneSpokane329San DiegoSan Diego404 Problem 15-9 (Algo)Sycamore Plastics (SP) is a manufacturer of polyethylene plastic pellets used as a raw material by manufacturers of plastic goodsaround the U.S. SP currently operates four manufacturing centers in Philadelphia, PA; Atlanta, GA; St. Louis, MO; and Salt Lake City, UT.The plants have different capacities and production costs as indicated in the table below.PLANTPhiladelphiaAtlantaSt. LouisSalt Lake CityFROM/TOSP currently has six contract customers located in New York City; Birmingham, AL; Terre Haute, IN; Dallas, TX; Spokane, WA; and SanDiego, CA. Transportation costs between the plants and various customers, as well as contracted demand from each customer, areshown in the table below.PhiladelphiaTRANSPORT COSTS PER 1,000 LBS.BIRMINGHAM TERRE HAUTE DALLAS$54$584460KITTITI62527369929AtlantaSt. LouisSalt Lake CityMAXIMUM CAPACITY(x 100,000 LBS.)8.49.312.210.2Total Demand(x 1,000 lbs.)NYC$47575974PROD. COST(PER 1,000 LBS.)$329.00$279.00529$309.00$254.00418$64615659604SPOKANE SAN DIEGO$69715649329$88857363404

combined cost table (Production cost+ transportation cost):Formulas below:

Answered: a. Create a solver model and find the…

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

In this problem, your company is a distributor of products. You serve as an inventorymanager for the regional distribution center (DC) here in the Atlanta area. In this role,you schedule the purchase and shipment of products from various suppliers inbound to theAtlanta DC. Once you receive the products at the DC, they are stored in inventory untilthey are picked, packed, and shipped outbound to your company’s downstream customersin response to orders.For each of your products, you currently use a single, dedicated supplier. Each of yoursuppliers ships their products to you from their facility using trucking services, and theyprovide you with choices of different LTL or truckload trucking carriers depending on yourshipment size.Consider managing inventory now for product 101 produced by Supplier A. Currently,you face demand for product 101 of about 200 units per week. Each unit of product 101has a purchase cost p of $500 and you decide to value your inventory at the slightly higherrate…
In this problem, your company is a distributor of products. You serve as an inventorymanager for the regional distribution center (DC) here in the Atlanta area. In this role,you schedule the purchase and shipment of products from various suppliers inbound to theAtlanta DC. Once you receive the products at the DC, they are stored in inventory untilthey are picked, packed, and shipped outbound to your company’s downstream customersin response to orders.For each of your products, you currently use a single, dedicated supplier. Each of yoursuppliers ships their products to you from their facility using trucking services, and theyprovide you with choices of different LTL or truckload trucking carriers depending on yourshipment size.Consider managing inventory now for product 101 produced by Supplier A. Currently,you face demand for product 101 of about 200 units per week. Each unit of product 101has a purchase cost p of $500 and you decide to value your inventory at the slightly higherrate…
Using the center-of-gravity model, locate the X and Y coordinates of a warehouse to serve three different customers as follows:
2. By using the data below, use a transportation method to : COST in $ Assembly Plant Supply 210 Factory 2 A 8 9 400 10 6 12 8 190 Demand 120 620 60 A. Formulate this linear programming model B. If you are using VAM and NorthWest corner method, which solution is the best and how much is the best total cost ?
please answer quickly
The SCM term "reverse logistics" implies a.The heavy use of RFID b.Customers must be extremely happy c.The movement of materials from the back end of a supply chain to the front end d.Suppliers must be doing an excellent job e. the process of transporting returned materials
In this problem, your company is a distributor of products. You serve as an inventory manager for the regional distribution center (DC) here in the Atlanta area. In this role, you schedule the purchase and shipment of products from various suppliers inbound to the Atlanta DC. Once you receive the products at the DC, they are stored in inventory until they are picked, packed, and shipped outbound to your company's downstream customers in response to orders. For each of your products, you currently use a single, dedicated supplier. Each of your suppliers ships their products to you from their facility using trucking services, and they provide you with choices of different LTL or truckload trucking carriers depending on your shipment size. Consider managing inventory now for product 101 produced by Supplier A. Currently, you face demand for product 101 of about 200 units per week. Each unit of product 101 has a purchase cost p of $500 and you decide to value your inventory at the slightly…
2.) Your business provides technical support for very complex and specialized machinery used by companies throughout the country, and you currently have support centers at 5 locations. However, due to a poor market, you have been forced to close your centers in Houston and San Diego. You will have to relocate all of your technicians in these two centers to your other three centers in Cleveland, Seattle, and Charlotte. Due to the varying costs of living in each city, and travel and retraining times, the cost for relocating an employee varies depending on where the employee is moving. These costs are given in the following table: To: From: Cleveland Seattle Charlotte $5,000 | $7,000 $7,000 $4,000 $6,000 $8,000 Houston San Diego You currently have 40 employees in Houston and 55 employees in San Diego, which all need to be relocated. Cleveland is able to take in at most 35 relocated employees, Seattle can take in at most 32 employees, and Charlotte is able to take in at most 50 employees.…
The logistics manager of Hercules, a capital goods manufacturer, is trying to reviewtheir inventory strategy. Hercules has about 50 tier- 1 suppliers. The manager istrying to understand the relationship between ordering cost and inventory carryingcost. Kindly draw out a plan of how this relationship can be used to best advantageof his company.
Please solve this Optimization problem using VAM method manually

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