S7.12. The Federal Parcel Service wants to build a new distribution cen- ter in Charlotte, North Carolina. The center needs to be in the vicinity of uncongested Interstate-77 and Interstate-85 interchanges and the Char- lotte-Douglas International Airport. The coordinates of these three sites and the number of weekly packages that flow to each are as follows: 1-77 1-85 Airport X= 14 X= 20 X= 30 y = 30 y = 8 ソ=14 w = 17,000 w = 12,000 w = 9000 Determine the best site location using the center-of-gravity technique.

1. Huawei decided to expand in Africa. Three possible factory sites are available: Nairobi, Cape Town, and Accra. Factory building costs and transport costs to major customer zones from each site are given below. Production Cost/unit 60 Factory Site Building Cost (per million unit capacity) Cape Town Nairobi Accra 560,000 75 340,000 45 310,000 Customer Zone Demand/yr Transport Costs/unit Cape Town Nairobi Accra #1 # 2 18 million 12 15 million #3 7 9 million 26 million 16 #4 22 Huawei has a building budget of 40 million USD next year. Huawei does not wish annual logistics costs to exceed 40% of total production costs. Write a model that decides which factories will be built in what capacity while meeting annual demand and minimizing all costs. USE PARAMETERS BELOW! Parameters: TRC(ij): transport cost; D(j): demand for zone j; B(i): building cost per million capacity for site i; pr(i): production cost for site i Variables: Model:

We have four major customers, and want to find the location that minimizes the average distance traveled to deliver products to them. Customer X coord Y coord Demand A 10 10 100 B 15 40 20 C 35 12 20 D 38 40 150 What is the optimal X coordinate for our location?

LM.61 Boxmart needs to set up a new hub to distribute to a number of stores in four cities. The table below gives the map coordinates and number of weekly shipments for each city. City X Coordinate Y Coordinate Shipments A 5.1 2.0 18 5.2 0.5 40 C 1.0 5.4 10 1.2 1.5 16 What should be the center of gravity x-coordinate for the new hub? (Display your answer to two decimal places.) Number What should be the center of gravity y-coordinate for the new hub? (Display your answer to two decimal places.) Number

‏صورة

b

A larger and more modern main post office is to be constructed at a new location in Davis, California. Growing suburbs caused a shift in the population density from where it was 40 years ago, when the current facility was built. Annette Werk, the postmaster, asked her assistants to draw a grid map of the seven points where mail is picked up and delivered in bulk. The coordinates and trips per day to and from the seven mail source points and the current main post office, M, are shown in the following table. M will continue to act as a mail source point after relocation. Mail Source Point Round trips per day x, y, Coordinates (miles) 1 4 (4, 6) 7 (8, 4) (3, 14) (6, 10) (12, 11) (13, 5) (13, 6) (14, 10) 3 1 4 11 7 3 7 3 M 8 a. Calculate the center of gravity as a possible location for the new facility. (Enter your responses rounded to the nearest whole number.) The center of gravity "X" coordinate = The center of gravity "Y" coordinate =

Task 1: An oil refining company ships the following gasoline volumes from its refining plant in Long beach to its major distributors: Coordinates (x, y) 400, 150 450, 350 350, 400 25, 450 Distributor Gallons (in millions) Anaheim 150 LaHabra 350 Glendale 250 Thousand Oaks 450 The location coordinates of the refining plant in Long Beach are: (325, 75). Under a new proposed distribution setting, the company wants to setup an intermediate holding facility, such that gasoline will first get transported to this holding facility, and then, from there, to the distributors. What will be the ideal location (coordinates) for the intermediate holding facility? (Round to 2 decimal places.)

like this fill the boxes

please do it in excel BETTER PRODUCTS COMPANY has decided to start manufacturing four new products in three plants that currently have excess production capacity. The products require comparable production effort per unit, so the available production capacity in the plants is measured by the number of units of any product that can be manufactured per day. a)Formulate this problem as a transportation problem by constructing the appropriate parameter table. Note:One image is of the data and the other image is option 1 to solve the exercise.