SAJMS - South Asian Journal of Management Sciences

Using Excel Solver to solve braydon farms' truck routing problem: A case study

This case study is based on Braydon Farms LLC, floral distribution complexity analysis in Alabama, US. This study utilized excel solver to determine effective distribution to the 14 stores at least cost for Braydon Farms clients. The integer programming model was used to estimate the optimal configuration for the distribution to 14 stores for seven daily routes. Furthermore, for the 14 stores, the total shortest distance was configured that the record of sales in the floral distribution truck should be loaded by store and flower types for the first full season. It is recommended to the company to further optimize the distribution with one big truck for all stores overage versus two small trucks for the upcoming season.

Share this paper