M
mparish
Guest
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
Continue reading...
Continue reading...