A company has four distribution centers, located in Atlanta, Lexington, Milwaukee, and Salt Lake City,and ships to 12 retail stores, located in Seattle, San Francisco, Las Vegas, Tucson, Denver, Charlotte,Minneapolis, Fayetteville, Birmingham, Orlando, Cleveland, and Philadelphia. The company wants tominimize the transportation costs of shipping one of its products. The per-unit shipping cost from eachdistribution center to each retail location and the amounts currently in inventory and ordered at each retaillocation are shown in the accompanying table. Develop and solve an optimization model to minimize thetotal transportation cost and answer parts a and b.Click here to view the shipping data.....a. What is the minimum cost of shipping?Total Cost = S(Type an integer or a decimal. Do not round.) on centers, located in Atlanta, Leington. Milwaukee, and Salt Lake City, and ships to 12 retal sturos, located in Seattle, San Franciaco, Las Vegan, Tucson, Denver, Charlotte, Minneapolia, Fayetevile, Bimingham, Orlanants to minimize the transportation costs of shipping one of s products The per unit shipping cost from each distribution center to each retail location and he amounts currently in invantory and erdered at each retal locaelop and solve an optimization medel to mininize the total transportation cost and answer parts and b.ipping dataCost of shipping data- XAtlantaLexingtonMilwaukeeSalt Lake CityDemandSeattle$2.15$1.95$1.7050.604,500San FranciscoLes VegasTucsonDenver$2.10$2.00$1.85S0.5517,000f shipping?$1.75$1.70$1.5050 354,500$1.50$1.53$1.41$0.60S0 40S0.954,000$1 20S0 65$0.90De nat round)$1.10S0.954.300CharlotteS0 55S0 407.5003.500MinneapolisFayettevilleBirminghamS0 60$1.05$0.40$1.00$0.95$1.109.000$0 35S0.15S0 70$1.353,30012,000OrlandoS0.5010.70$1.60ClevelandPhiladelphieSupplyS0.60$0.25S0 35$1.609,500$0.5050 3035,000$0.4015.100$1.7016.00040.30017.000PrintDone

Shipping costs is known as the cost of transporting the goods from one place to other. Contingent…

Answered: A company has four distribution…

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

Machine Supply Co. plans to open a new branch in Houston, TX to provide local support to its customers in the area. The company currently considers two locations (small and large) for its new branch. While the small location can store up to 500 units of product, the large one can store up to 1200 units (more than these amounts cannot be stored at any time). However, the large location costs an additional $1000 per month to rent compared to the small location. Transportation companies charge different amounts for small and large locations as provided in the table below. The expected demand in the greater Houston area is 52000 units and each unit costs $300. The inventory holding rate per year is 24%. Given the below information about two locations and transportation company. Which branch location should be chosen by Machine Supply CO.? NOTE: It is expected that the average inventory level in Memphis, TN (the source facility) will not be affected by these decisions. If you need any…
Machine Supply Co. plans to open a new branch in Houston, TX to provide local support to its customers in the area. The company currently considers two locations (small and large) for its new branch. While the small location can store up to 500 units of product, the large one can store up to 1200 units (more than these amounts cannot be stored at any time). However, the large location costs an additional $1000 per month to rent compared to the small location. Transportation companies charge different amounts for small and large locations as provided in the table below. The expected demand in the greater Houston area is 52000 units and each unit costs $300. The inventory holding rate per year is 24%. Given the below information about two locations and transportation company. Which branch location should be chosen by Machine Supply CO.? NOTE: It is expected that the average inventory level in Memphis, TN (the source facility) will not be affected by these decisions. If you need any…
The information needed is on the second Image
Oranges are grown, picked and then stored in warehouses in Tampa, Miami, and Fresno.Theses warehouses supply oranges to markets in New York, Philadelphia, Chicago, and Boston.The following table shows the shipping costs per truckload (in hundreds of dollars), supply, anddemand. Because of an agreement between distributors, shipments are prohibited from Miamito Chicago:To (cost, in $100)From New York Philadelphia Chicago Boston SupplyTampa 9 14 12 17 150Miami 11 10 6 10 250Fresno 12 8 15 7 200Demand 110 250 140…
Romans Food Market, located in Saratoga, New York, carries a variety of specialty foods from around the world. Two of the store's leading products use the Romans Food Market name: Romans Regular Coffee and Romans DeCaf Coffee. These coffees are blends of Brazilian Natural and Colombian Mild coffee beans, which are purchased from a distributor located in New York City. Because Romans purchases large quantities, the coffee beans may be purchased on an as- needed basis for a price 10% higher than the market price the distributor pays for the beans. The current market price is $0.47 per pound for Brazilian Natural and $0.62 per pound for Colombian Mild. The compositions of each coffee blend are as follows: Blend Bean Regular DeCaf Brazilian Natural 75% |40% Colombian Mild 25% 60% Romans sells the Regular blend for $3.60 per pound and the DeCaf blend for $4.40 per pound. Romans would like to place an order for the Brazilian and Colombian coffee beans that will enable the production of 1000…
The following network describes a transportation scenario in which there are four sources A, B, C, and D, and three destinations P, Q, and R. (The numbers next to each arrow represent the cost of transporting one unit from that particular source to the destination located at the other end of that arrow). Write the mathematical formulation of the problem. Use the Excel Solver to solve the problem. Generate the answer and sensitivity reports in Excel, and submit your Excel workbook as a separate attachment. Provide the solution obtained in the space provided. What is the optimal cost of transportation?
9-7 The management of the Executive Furniture Corporation decided to expand the production capacity at its Des Moines factory and to cut back the production capacities at its other two factories. It also recognizes a shifting market for its desks and revises the requirements at its three warehouses. The table on this page provides the requirement at each of the warehouses, the capacity at each of the factories, and the shipping cost per unit to ship from each factory to each warehouse. Find the least-cost way to meet the requirements given the capacity at each factory.
Farmers Groceries To You (FGTY) is a fast-growing company started by JMU alumni, which delivers fresh groceries collected in Virginia farms to families in the Shenandoah region. As part of an expansion plan, FGTY is considering approaching the northern Virginia market through printed product lists (PLs) containing deals, coupons and customers testimonies. The initial plan is to send 200,000 PLs to households in Fairfax and Arlington, expecting new customers to place orders. The company estimates to incur a fixed cost of $30,000 associated with design, printing setup and transportation contracting. Beyond this, the average transportation cost per PL is ¢20, while the printing cost per PL is ¢10. Also, FGTY incurs in an average cost of ¢25 for processing each order placed by a customer using the PL’s promotion codes. The expected size of an order is $50, and FGTY’s variable cost per order (mainly product costs labor) is close to 80% of the order’s average. You’ve been hired to help FGTY…
The 23,000-seat Air East Arena houses the local professional ice hockey, basketball, indoor soccer, and arena football teams as well as various trade shows, wrestling and boxing matches, tractor pulls, and circuses. Arena vending annually sells large quantities of soft drinks and beer in plastic cups with the name of the arena and the various team logos on them. The local container cup manufacturer that supplies the cups in boxes of 100 has offered arena management the following discount price schedule for cups: Order Quantity (boxes) Price per Box 2000-6999 $47 7000-11,999 43 41 12,000-19,999 20,000+ 38 The annual demand for cups is 2.3 million, the annual carrying cost per box of cups is $1.90, and ordering cost is $320. Determine the optimal order quantity and total annual inventory cost. a. Find the economic order quantity Q* for each group b. Find the total annual cost TC for each group for the values of Q* found in (a). c. From (a) and (b) state the economic order quantity that…
A retail has 8 stores supplied from 4 suppliers, where each supplier supplies different goods. Delivery from the Supplier is in trucks with a capacity of 40,000 units at a cost of $1100 per load plus $100 per delivery to the store. Inventory costs are $0.2 per unit per year. The Supply Chain Manager is considering whether to use direct shipping or Milk Run delivery for 4 stores for each truck in one shipment a) if annual sales in each store are 1000,000 units, which shipping method provides the lower cost b) if the annual sales in each store are 200,000 units, which shipping method provides the lower cost
Waikato Farm Machinery Ltd (‘WFML’), is a well- established business, with the main base of its operations in Te Rapa, Hamilton. Its business is the importation and distribution of farm machinery such as tractors, loaders, diggers, bulldozers as well as farming equipment such as disc ploughs, rotovators, grain silos including machinery used by dairy farmers in milking sheds. The imported equipment is then sold at wholesale prices to smaller businesses in other centres in the Waikato and King Country regions, that on sell them to farmers. WFML has developed a formidable reputation as a supplier of such goods for at least two reasons. First, it imports machinery and equipment of the highest quality such as John Deere tractors from the United States and International Harvester tractors from Germany. Secondly, it has consistently stood by the goods it sells and efficiently attends to any difficulties experienced by retailers such as the repair of any defects. More importantly it is able to…

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