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

The following table represents the cost to ship from Distribution Center 1, 2, or 3 to Customer A, B, or C. Is this a "balanced" or "unbalanced" model? Customer B 6 DC 1 2 3 Demand. Obalanced. A 4 5 3 200 2 5 350 unbalanced O not enough information. O equal sources and destinations C 8 7 9 400 Supply 500 400 300
Jing's Pizza wants to know to whether customers will buy the new Fancy Feijoa pizza. You are the owner's son/daughter and your mum (the owner) knows you have just completed a paper in business analytics. She asks (or tells!) you to come up with a plan to answer her question. Luckily, she has a database of frequent customers in an excel spreadsheet. You go through your notes and decide that you will use clustering and find groups of similar customers in her spreadsheet. 1. Identify the data that might use for customers who will buy the new Pizza. 2. What plan or alternative plan might use to sell the pizza?11:35 AM
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 ?
Aa6. please solve with formulas not excell
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
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.…
1 3 Supply: 4 1 60 40 28 10 120 2 50 30 30 20 150 3. 43 20 20 10 160 Demand: 100 100 100 130 The transportation table of a company that sends products is given below. According to the least cost method what is the value for the first cell to be assigned ?
: x v fx C DE в F G H K M Consider the linear distribution and the from-to diagram shown in the figure. Assuming that the goal is to minimize the total distance traveled, determine the final distribution recommended by CRAFT using the peer-to-peer trading method. 30 m 30 m from A A B A 2 6 B 3 A В 80 m 20 m
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.
J 2 PLEASE SOLVE USING EXCEL SOLVER

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