Question

In: Operations Management

3. The Covington Paper Inc. would like to determine the location of its new DC which...

3. The Covington Paper Inc. would like to determine the location of its new DC which will serve their six manufacturing facilities in Midwest. Information is provided below.

  • Find the optimal location with median method. show your work
  • Find the optimal location with gravity method. show your work

Plants

x- coordinate

y coordinates

Production in terms of # of TLs /period

A

6

20

220

B

48

12

330

C

25

36

560

D

12

5

330

E

30

50

225

F

18

20

115

Solutions

Expert Solution

i. Finding the optimal location using the median method

Step 1:

The x-coordinates are rearranged in ascending order in a table corresponding to the production of the location.

And the cumulative production is calculated.

Plants x coordinates in ascending order Production of the plant Cumulative production
A 6 220 220
D 12 330 550
F 18 115 665
C 25 560 1125
E 30 225 1450
B 48 330 1780 = N

The median of the cumulative production can be found by N/2, (N/2)+1

N/2 = 890, (N/2)+1 = 891 these median values fall under the cumulative production range of 1125, therefore, the x-coordinate is 25.

Step 2:

The y-coordinates are rearranged in ascending order in a table corresponding to the production of the location.

And the cumulative production is calculated.

Plants y coordinates in ascending order Production of the plant Cumulative production
D 5 220 220
B 12 330 550
A 20 115 665
F 20 560 1125
C 36 225 1450
E 50 330 1780 = N

The median of the cumulative production can be found by N/2, (N/2)+1

N/2 = 890, (N/2)+1 = 891 these median values fall under the cumulative production range of 1125, therefore, the y-coordinate is 20.

The optimal location by the median method is (25,20)

b. )

Solution:

the optimal location formula is

Xp = xPr / Pr

Yp = yPr / Pr

x is the x coordinate of the plant location

y is the y coordinate of the plant location

And Pr is the production of each plant

Plants x y Pr xPr yPr
A 6 20 220 1320 4400
B 48 12 330 15840 3960
C 25 36 560 14000 20160
D 12 5 330 3960 1650
E 30 50 225 6750 11250
F 18 20 115 2070 2300
Pr = 1780 xPr = 43940 yPr = 43720

Xp = xPr / Pr

Xp = 43940 / 1780

Xp = 24.685

Yp = yPr / Pr

Yp = 43720 / 1780

Yp = 24.561

Therefore, the optimal location using center of gravity method is (24.685, 24.561)


Related Solutions

DC and Marvel would like to evaluate one of the product lines that they sell to...
DC and Marvel would like to evaluate one of the product lines that they sell to defense department. Every month the Stark and Company produce an identical number of units, although the sales in units differ from month to month. Selling price $111 109 Units in beginning inventory 400 360 Units produced 8,800 6900 Units sold 8,900 7200 Variable costs per unit:      Direct materials $34 29      Direct labour $37 31      Variable manufacturing overhead $3 2      Variable...
The management for a large grocery store chain would like to determine if a new cash...
The management for a large grocery store chain would like to determine if a new cash register will enable cashiers to process a larger number of items on average than the cash register they are currently using. Seven cashiers are randomly selected, and the number of grocery items they can process in three minutes is measured for both the old cash register and the new cash register. The results of the test are as follows: Cashier Old Cash Register Old...
The New Jersey teacher’s union would like to determine thevariability of the salaries earned by...
The New Jersey teacher’s union would like to determine the variability of the salaries earned by high school teachers in Cape May County. A random sample of 20 teacher salaries from that county was selected and it provided a sample standard deviation of $750. Construct a 95% confidence interval estimate of the population variance and standard deviation for the teacher salaries.I. The lower limit of the confidence interval of the population variance is?II. The upper limit of the confidence interval...
3. UTRGV researchers would like to determine if there is a significant difference between the grades...
3. UTRGV researchers would like to determine if there is a significant difference between the grades achieved in the fall versus spring semester. Grades were recorded for a group of 7 students in both semester and are listed below (α = .05). Participant Fall Spring 1 85 89 2 68 84 3 76 79 4 77 82 5 89 90 6 93 91 7 90 90 a. Will we need a one- or two-tailed hypothesis test? b. State your null...
The library would like to compare the regression and exponential smoothing models to determine which is...
The library would like to compare the regression and exponential smoothing models to determine which is a better predictor, using the mean absolute error | (books borrowed) – (model’s estimate)|/n as a measure of prediction quality. Select the best of the following four options for splitting the data: A. 15% for training, 15% for validation, 70% for test B. 15% for training, 70% for validation, 15% for test C. 70% for training, 15% for validation, 15% for test D. 55%...
DC-Marvel would like to evaluate one of the product lines that they sell to defense department....
DC-Marvel would like to evaluate one of the product lines that they sell to defense department. Every month the company produces an identical number of units, although the sales in units differ from month to month. Product B Selling price $109 Units in beginning inventory 360 Units produced 6,900 Units sold 7,200 Variable costs per unit:      Direct materials $29      Direct labour $31      Variable manufacturing overhead $2      Variable selling and administrative $7 Fixed costs:      Fixed manufacturing...
24. A hospital would like to determine the mean length of stay for its stroke patients....
24. A hospital would like to determine the mean length of stay for its stroke patients. They observe a random sample of 6 patients, the resulting length of stay of stroke patients are: 6, 7, 5, 8, 11, 2 (in days) Suppose the true length of stay follows normal distribution, a 95% confidence interval for population mean is ____. (4 decimal places) Use the information to answer Q25-27 A 98% confidence interval for the mean number of credit hours that...
An automotive company would like to install a new breaking system in a one of its...
An automotive company would like to install a new breaking system in a one of its least popular vehicles. The new breaking system promises to be more effective by stopping sooner. To test this claim, the company gathers a sample of 50 cars with the old breaking system and find that the mean stopping distance is 65 feet with a standard deviation of 4 feet. A different sample of the same car model was tested with the new breaking system....
select a store and choose a site location you would like to use for the store....
select a store and choose a site location you would like to use for the store. Describe the location using the following factors: A-Where is the location? For example, I might select a Smithtown shopping center on the corners of Route 25 and 111. B-How would you describe the population density for the location. C-Describe the quality of the location as you see it. D-Using the free zip code analysis found online, describe the demographics of the area including: average...
Can a transformer be operated by a DC waveform at its input? What would be the...
Can a transformer be operated by a DC waveform at its input? What would be the secondary voltage of a 1:5 transformer, if a 12V DC is connected at its input? Consider a transformer with a turn ratio of 2:5 that is connected to a 50-V AC source at its primary input. What is the average power delivered to a 100 kilo-ohm resistor connected to the secondary terminal of the of the transformer? Is there a direct electrical connection between...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT