Business Logistics

Group 1 – Blog



EXERCISE: Inventory

By Raquel Amatriain

Inventory exercises

EXERCISE: Optimal stock problems

By Lluc Areny and Victor Garcia

Victor and Lluc – Excel Solutions

Victor and Lluc – Exercises

EXERCISES: Inventory

By Gemma Puig Esparch

Inventory exercises – Gemma Puig Esparch

EXERCISE: Transportation model + Gravity center method

By Andrea Guillén

Exercise – Transportation model

Exercise – Gravity center method

EXERCISE: Inventory

By Agnès Sosa

The last day, Helena said in class that there were only few exercises about inventories. Please, find attached an exercise about it. I will upload more about it!


Exercise – Inventory – Agnès Sosa

EXERCISE: Distribution Requirement Planning

By Jana Schmidt

Hey everyone,

I tried to create an exercise concerning the Distribution Requirement Planning we had in class, in the Inventoy Theory Lesson. I hope you have fun solving it….The solution is on the second page of the PDF document.

Exercise – Distribution Requirement Planning – Jana Schmidt

EXERCISE: Excel Solver practice

By Lluc Areny and Victor Garcia


EXERCISE: Gravity Center Method

By Magda Alonso

A Company has used the Gravity Center method to find the best coordinates of a new store that will open the next week.
We know these coordinates, X: 350 and Y: 180. We also know that the sum of the coordinate x multiplied by the volume of goods to deliver is 1.500.000.

What is the total volume of goods to deliver?


We are going to use the formula of the Gravity Center method:

Screen Shot 2015-10-26 at 5.45.36 pm

The total volume of goods to deliver is: 4.285’71

EXERCISE: Gravity Center Method & Weighted Factor Average

By Marta Abad

I came up with a new exercise about the topic of the first seminar. It combines both the Gravity Center Method and the Weighted Factor Average. Its aim is to show that you can use both simultaneously for the same case and benefit from the different perspectives it gives each of them.

For instance, I tried to join exercise number 1 with exercise number 2 (from seminar 1).
So, first you do exercise 2 as it says the instructions and then, when it comes to exercise 1, what you want to do is use the data from this exercise as if the distribution centers where located in each of the cities from exercise 2. In order to do this, note that you’ll have to eliminate distribution center number 5, since we have 5 distribution centers and only 4 cities. As a result, you are joining information from distribution center 1 as if it was located in the City A, and so forth.

As a consequence, you can see that each of the four cities, where the distribution centers are located, are analysed in two ways: one, using sales volume and the coordinates of the existing distribution centers and the other, measuring the importance of attributes of each possible location. In the first you find the point where you would locate exactly the distribution center (among the existing ones) whereas in the second method you will have a winner between the possible locations you have (city A, city B….).

After this, you can compare the results and if it was real life, choose one of the methods, depending on which you think if more relevant: taking into account quantitative factors (as in the Gravity Center Method) or more qualitative factors (as in the Weighted Factor Average).

Hope it is useful for you as it was for me.

Solution of the exercise:
We see that according to exercise 1 (taking only into account sales volume), the center would be located near to the distribution center number 1 (graphic), whereas according to exercise number 2 (taking into account other factors, such as nearby suppliers among others), the center would be located at the center number 2 or city B because it has de highest factors’ score.

Marta Abad Exercise Solutions

Blog at

Up ↑