Distribute vehicles to dealers in proportion to their day’s supply gap for each type of vehicle.
In the example below 26 20X S-Hybrids will be divided up as follows: Sao Paulo 5, Rio De Janeiro 3, Salvador 3, Fortaleza 4, Manaus 1, Curitiba 3, Recife 4, Macelo 2

Dealer Allocation

20X S-HYBRID

26

Units

Variable

If DS Gap < 0 then Distribution Ratio = 0

Dealer Name

Inventory

Daily Retail Volume

Days Supply(Days)

Target DS

DS Gap

Distribution Ratio

Distribution volume

São Paulo

51

9

5.7

30

24.3

17.6%

5

Rio de Janeiro

94

8

11.8

30

18.3

13.2%

3

Salvador

126

10

12.6

30

17.4

12.6%

3

Brasília

203

5

40.6

30

-10.6

0.0%

0

Fortaleza

21

3

7.0

30

23.0

16.6%

4

Belo Horizonte

213

2

106.5

30

-76.5

0.0%

0

Manaus

231

10

23.1

30

6.9

5.0%

1

Curitiba

89

7

12.7

30

17.3

12.5%

3

Recife

79

7

11.3

30

18.7

13.5%

4

Porto Alegre

277

10

27.7

30

2.3

1.7%

0

Belém

185

3

61.7

30

-31.7

0.0%

0

Goiânia

267

8

33.4

30

-3.4

0.0%

0

Guarulhos

92

1

92.0

30

-62.0

0.0%

0

Campinas

98

3

32.7

30

-2.7

0.0%

0

São Luís

47

1

47.0

30

-17.0

0.0%

0

Maceió

40

2

20.0

30

10.0

7.2%

2

São Gonçalo

218

2

109.0

30

-79.0

0.0%

0