A fertilizer manufacturer has to fulfill supply contracts to its two main customers (650 tons to Customer A and 800 tons to Customer B). It can meet this demand by shipping existing inventory from any of its three warehouses. Warehouse 1has 400 tons of inventory onhand, Warehouse 2 (W2) has 500 tons, and Warehouse 3 (W3) has 600 tons. The company would like to arrange the shipping for the lowest cost possible, where the per-ton transit costs are as follows:W 1W 2W 3$7.50$6.75$6.25$7.00$6.50$8.00Customer ACustomer BWrite the objective function and the constraint in equations. Let V;= tons shipped to customer i from warehouse j, and so on. For example, VA1 = tons shipped to customer A from warehouse W1.This exercise contains only parts b, c, d, e, and f.b) The objective function for the LP model =Minimize Z =$7.50+ $6.25+ $6.50(shipping cost to customer A)V +$6.75+ $7.00+ $8.00(shipping cost to customer B)c) Subject to:Customer A's demandCustomer B's demandWarehouse 1's supplyWarehouse 2's supplyWarehouse 3's supplyFor all Vj 20non negativity condition

VA1 = tons shipped to customer A from warehouse 1VA2 = tons shipped to customer A from warehouse…

Answered: A fertilizer manufacturer has to…

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

es Problem 11-4 (LO2) An appliance manufacturer has a plant near Toronto that receives small electric motors from a manufacturer located in Winnipeg. The demand for motors is 118,000 units per year. The cost of each motor is $125. The motors are purchased in lots of 3.400 units. The ownership of motors transfers to the appliance manufacturer in Winnipeg. The question is which mode of transportation, truck or train, the appliance manufacturer should use to bring the motors from Winnipeg to Toronto. The railroad company charges $3 per motor. and it takes approximately seven days by train. The trucking company charges $5 per motor, but it takes only three days. The appliance manufacturer will keep 1,400 units as safety stock if a truck is used and 2.500 units as safety stock if a train is used for transportation. Assume 365 days per year. If the holding cost rate is 25 percent of unit cost per year, which mode of transportation will minimize total transportation and in-transit and safety…
Select the true items related to performance indicators and targets. Select only the four correct answers Performance indicators and targets should cover attributes that are important to transport users. Performance indicators and targets must be expressed in quantitative terms. Performance target is used to denote any level of performance for a specific, defined performance indicator. Performance indicators and targets should be biased towards a particular transport mode or towards infrastructure. Performance indicator is used to monitor performance in terms of progress towards a specific defined objective. Performance indicators and targets should reflect a broader stakeholder perspective. Performance target is used to denote the desired level of performance for a specific, defined performance indicator. Performance indicator is used to show performance when a specific objective cannot be defined.
Walmart designs its networks so a distribution center supports several large retail stores. Explain how the company can use such a network to reduce transportation costs while replenishing inventories frequently..
On a daily basis, the Vampire Van is dispatched from Maplewood Hospital to pickup blood and platelet donations made at its local donation centers. The distances in miles between all locations may be found in Table.a. The Vampire Van travels from Maplewood Hospital (A) to (B) to (C) to (D) to (E) and then returns to the hospital (A). What is the total number of miles that the van must travel using this route?b. Using Maplewood Hospital as the beginning location, create a route using the NN heuristic. What is the total number of miles that the van must travel using this route?c. Using Valley Hills (E) as the beginning location, create a route using the NN heuristic. What is the total number of miles that the van must travel using this route?
Cars-to-Dealers Logistics Inc. is the exclusive logistics provider for the Summit Motor Co. and has responsibilityfor transporting cars from Summit’s 3 manufacturing plants in Toledo, OH; Charlotte, NC and Savannah, GA tothe 7 regional dealer locations as in the tables provided in your dataset. To do this, Cars-to-Dealers uses threetransshipment facilities and all cars in the distribution network pass through these transshipment facilities.Dataset also contains the information about the capacities of each of these transshipment facilities, the demandrequirement at each of the regional dealer locations and the unit cost to ship one car between the variouslocations.In addition to supply of cars (manufacturers) and demand for cars (dealers) there are two types of constraintsfor each transshipment facility:1. Balance flow constraints: dictate that all cars flowing into a transshipment facility should also flow out of thetransshipment facility – i.e. no inventory of cars should remain at…
Jersey City, NJ to Foster City, CA on "Freight R Us" Trucking (see appropriate rate table). The tollowing rate tabie is for "Freight R Us" Trucking. Rales are iti dollars per CWT. MC = 145.00 07304 Jersey City, NI 94404 Foster City, CA Class Rating 50 400 300 250 200 L5C M5C M1M M2M M5M M10M M20M 684.61 554.60 472.26 397.12 345.33 283.06 248,51 547.69 443.68 377.82 410.77 332.76 283,37 238.27 207,20 169.84 149,10 342.31 277.30 236.14 198.56 172,67 141.53 124.25 273.85 221.84 317.69 276.27 226.45 198.81 158.85 165.30 138.99 141.68 119.14 103,60 183.91 138.13 113,22 99.07 120.87 99.40 86,98 175 239.62 194.11 205.38 166.38 171.16 138.65 150.61 122.01 136.92 110.92 128.02 103.71 150 74.55 62.13 54.67 84.92 125 110 118.07 99.28 87.37 86.34 70.77 103.90 75.97 62.27 56.61 52.93 49.11 45.06 41.87 100 94.46 79.42 74.26 68.89 63,21 58.75 55.25 69.07 49.70 46.47 92 88.32 64.58 85 77.5 70 65 60 55 50 118.77 96.21 88.28 82.04 77.17 81.93 75.10 69.86 59.91 43.11 39,56 36.76 108.98 101.28 95.26 90.28…
DM Office Products (DMOP) is a wholesale supplier of office products with one facility in Pennsylvania. They have decided to build a new distribution warehouse in the state of New York to help serve the growing demand in that market. They have four major customers located in Buffalo, Syracuse, Albany, and New York City. Though New York City is the largest market, it also has the greatest competition and DMOP is not a major player there. When DMOP ships an order to a customer they use their own small fleet of two trucks to deliver, so the cost of delivery is essentially the same for a full or partially full truck. The expected number of annual shipments to each city and their coordinates on an x, y grid is shown in the following table. CITY Buffalo Syracuse Albany New York x-COORDINATES 370 1,465 2,345 2,320 y-COORDINATES 895 945 675 70 NUMBER OF SHIPMENTS 96 100 140 80 Use the centroid method to recommend a location for the new warehouse for DMOP (Round your answers to 1 decimal…
Please do not give solution in image format thanku
QL (“Quebec Lumber”) is a logging and wood processing firm in a remote part of the Canadian province of Quebec. They have recently acquired a remote track of timber that is located ten miles from their processing facility. Normally, this is not a problem as they are able to simply cut the timber and haul it using trucks to their processing facility. However, this track of forestland is ten miles to their north, and there are no roads connecting the tract of land to their facility. They have also acquired a narrow (120 foot wide) ten-mile strip of land connecting this tract of timber to their processing facility. QL considered building their own road between the two points, and have log trucks haul the logs to the processing facility. However, they have decided instead to go with a less expensive option, a narrow gauge railroad. The narrow gauge railroad would require the laying of ties and steel tracks, and will require a custom-built locomotive and rolling stock (train cars that will…
In the standard vSphere Switches, every server will have its virtual switch called to handle the traffic within the network at the host level and another virtual switch called which acts as a single virtual switch among many associated hosts as they travel across one or more hosts.
ABC pharmaceutical Company has four factories that ship supplies to four warehouses. The company’s management hires you as a consultant to determine a minimum-cost shipping plan for its monthly output to the warehouses. Factory capacities, warehouse demands, and shipping cost per box are shown below. Factory Supply or capacity (boxes) Warehouse Demand (boxes) Richmond 60 Chicago 100 Santa Fe 80 Jacksonville 90 Austin 120 Huntville 50 Vacaville 90 Fresno 70 Shipping Costs per box (In Dollars) From To Chicago To Jacksonville To Huntsville To Fresno Richmond 35 35 46 60 Santa Fe 65 40 35 25 Austin 50 50 80 90 Vacaville 40 40 66 75 Draw a diagram by showing factories, warehouses, and connecting arcs. Define variables, write the objective function and constraints.
A manufacturer has two shipments to make from Minneapolis to Chicago. Both shipments weigh 8500 pounds. The two shipments can be shipped separately to Chicago at a cost of $2.00 per mile for a total of 409 miles and will take one day for each shipment. The company has a warehouse in Milwaukee where they can consolidate the freight. It would take two LTL shipments at $2.00 per mile to get the freight to Milwaukee for 337 miles and then one full TL shipment from Milwaukee to Chicago at $1.50 per mile for 92 miles. The consolidation cost in Milwaukee is $200 and it takes two days for the trip through Milwaukee. What is the lowest cost to ship the freight and which approach would you select?

SEE MORE QUESTIONS

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