The Ortega Food Company needs to ship a tractor-trailer load of green chilies from its warehouse in San Diego to a global distributor in New York City. The route must stop once in the Denver transshipment point for "pepper servicing" reasons. If the company decides to ship directly to NY/NJ, then in must practice "en route" pepper servicing at a cost of $1,000. The company wants to determine which route to take in order to minimize the cost of transporting the chilies. The fully loaded bushel costs associated with shipping between various cities are detailed below: San Diego (Home base) LA (Txfr Ctr) Denver (Service Ctr) St. Louis (Txfr Ctr) Chicago (Txfr Ctr) San Diego LA 0 80 320 N.A. N.A. 80 Denver 130 0 120 0 190 140 N.A. 320 120 St. Louis Chicago Not Avail. N.A. (N.A.) 190 140 0 240 N.A. 320 240 0 NY/NJ (Destination) 1000 980 N.A. N.A. 170 Which route shipping option should Ortega choose? Use Linear programming to identify the path that minimizes the total cost and satisfies all the above-stated shipping and transportation requirements. Justify your response in detail with Excel cost estimates and illustrate the network on the Excel spreadsheet.

The Ortega Food Company needs to ship a tractor-trailer load of green chilies from its warehouse in San Diego to a global distributor in New York City. The route must stop once in the Denver transshipment point for "pepper servicing" reasons. If the company decides to ship directly to NY/NJ, then in must practice "en route" pepper servicing at a cost of $1,000. The company wants to determine which route to take in order to minimize the cost of transporting the chilies. The fully loaded bushel costs associated with shipping between various cities are detailed below: San Diego (Home base) LA (Txfr Ctr) Denver (Service Ctr) St. Louis (Txfr Ctr) Chicago (Txfr Ctr) San Diego LA 0 80 320 N.A. N.A. 80 Denver 130 0 120 0 190 140 N.A. 320 120 St. Louis Chicago Not Avail. N.A. (N.A.) 190 140 0 240 N.A. 320 240 0 NY/NJ (Destination) 1000 980 N.A. N.A. 170 Which route shipping option should Ortega choose? Use Linear programming to identify the path that minimizes the total cost and satisfies all the above-stated shipping and transportation requirements. Justify your response in detail with Excel cost estimates and illustrate the network on the Excel spreadsheet.

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

LVTLS was set up as a local cargo company in 1960 by Mason Delp in pick-up and delivery for numerous intergovernmental trucking businesses in Pennsylvania's Greater Lehigh Valley. The difference between Alentown and Philadelphia has been shown to Mason by enhancing the Interstate Highway System, by upgrading the Pennsylvania Turnpike system, which provides the corridors North-South and East-West together with other improvements and roads. Furthermore, Philadelphia has a certain population, with e-road extensions and renovations which allow transit connectivity to numerous municipalities. Mason's remarks were right and the area has transformed from agricultural to the manufacturers of products and services.The creation of a series of pharmaceutical production facilities and an agglomeration of firms and services to serve the industry have all been very significant developments. • These firms' expansion and success offered Mason Delp the chance to expand its engine carrier service, both…
Suppose that you own a freight forwarder company. One of your customers “ELAR A.Ş.” called you on JANUARY 2022 and asked for the freight offer for the transportation of five TEU (your cost object) products from location X to location Y.You are supposed to give a reasonable freight offer to your customer. Your profit margin is 25 %. First find the cost, then add 25 % profit margin to find the customer price. Use job costing and normal costing.a) Choose Location X and Y, explain your route and transportation modes. Explain whether the transportation is door to door or not. You can use one, two or three modes of transportation to carry out this transaction.b) Identify and LIST the direct costs of the job. Calculate the total direct costs of the job.c) Budget and LIST the indirect costs of your company for all jobs in 2022. Calculate the total indirect costs of your company for 2022. d) Select your allocation base and compute the allocation rate per unit. You may use multiple allocation…
In the original RedBrand problem, suppose the plantscannot ship to each other and the customers cannotship to each other. Modify the model appropriatelyand reoptimize. How much does the total cost increasebecause of these disallowed routes?
On Thursdays, Traxis Consolidated delivers liquid oxygento its industrial customers in northern Michigan. The tablebelow provides the driving time in minutes among allcustomers and the Traxis liquid oxygen depot location. a. Currently, Traxis travels from the depot (A) to (F) to (G) to(D) to (E) to (H) to (B) to (C), then returns to (A). What isthe total driving time using this route?b. Using the depot (A) as the beginning location, create aroute using the NN heuristic. What is the total driving timeusing this route?c. Use the NN heuristic to calculate seven routes, each start-ing from one of Traxis’s customer’s locations. What areyour conclusions?
A company has a contract to move 700 units of a product per day between three plants A, B, and C, and three destinations, X, Y, and Z. Cost (in hundreds of pesos) and volume information are given below. Compute the optimal transportation cost.
4. Companies A, B, and C supply components to three plants (F, G, and H) via two crossdocking facilities (D and E). It costs $4 to ship from D regardless of final destination and $3 to ship to E regardless of supplier. Shipping to D from A, B, and C costs $3, $4, and $5, respectively, and shipping from E to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. Crossdock facilities D and E can handle 600 and 700 units, respectively. Logistics Manager, Aretha Franklin, had previously used "Chain of Fools" as her supply chain consulting company, but now turns to you for some solid advice. Set up the solution in Excel and solve with Solver. What are total costs?
Your company offers a weekly consolidation service from Toronto to Frankfort , via Lufthansa Airways. The carrier has given you a 1000 kg (or less) buying rate of CAN $2.27/kg and a plus 1000 kg buying rate of CAN $1.85/kg. You sell this service to clients who ship 700 kg (or less) at a rate of CAN $2.95/kg and for clients who ship in excess of 700 kg at a rate of CAN $2.55/kg. A) Shipper: J&J Company 123 John Street Toronto, ON, Canada, L5R 2N3 Shipment: 140 cartons of books Total weight: 426 kg Dimensions of each carton: 15 cm x 49 cm x 47 cm B) Shipper: R&R Company 432 Avenue Road Toronto, ON, Canada, R2S 1A3 Shipment: 380 cartons of umbrellas Total weight: 700 kg Dimensions of each carton: 39 in x 18 in x 19 in What is the profit on this shipment? full calculation
Prescott Industries transports sand and stone extracted fromits open-pit mines located in Odessa and Bryan to its con-crete block manufacturing facilities in Abilene, Tyler, and SanAngelo. For the capacities, locations, and shipment costs pertruckload shown in the Figure 13.13, determine the shippingpattern that will minimize transportation costs. What are theestimated transportation costs associated with this optimalallocation pattern?
a) Use the Northwest Corner Rule to develop an initial solution. b) Apply the Stepping-Stone Method to find the minimum transportation cost. c) Calculate the total cost for this situation.
ART Contractors must locate an equipment staging area to serve three construction sites, located at coordinates (0,2), (0,4), and (5,5). Traffic between the staging area and each of the three sites will be equal. What is the best set of coordinates for the equipment staging area? Please show the math.
The Burger Doodle restaurant franchises in Los Angeles are supplied from a central warehouse in Inglewood. The location of the warehouse and its proximity, in minutes of travel time, to the franchises are shown in the following network: Trucks supply each franchise on a daily basis. Determine the shortest route from the warehouse at Inglewood to each of the nine franchises.
Determine an initial basic feasible solution to the following transportation problem by using (a) NWCM, (b) LCM, and (c) VAM