首页    期刊浏览 2024年11月09日 星期六
登录注册

文章基本信息

  • 标题:Using Excel Solver to solve braydon farms' truck routing problem: A case study
  • 本地全文:下载
  • 作者:Duan ; C. J Hu J ; Garrott
  • 期刊名称:South Asian Journal of Management Sciences
  • 印刷版ISSN:2074-2967
  • 出版年度:2016
  • 卷号:10
  • 期号:1
  • 页码:38-47
  • DOI:10.21621/sajms.2016101.04
  • 出版社:Iqra University
  • 摘要:This case study is based on Braydon Farms LLC, floral distributioncomplexity analysis in Alabama, US. This study utilized excel solver todetermine effective distribution to the 14 stores at least cost for BraydonFarms clients. The integer programming model was used to estimate theoptimal configuration for the distribution to 14 stores for seven daily routes.Furthermore, for the 14 stores, the total shortest distance was configured thatthe record of sales in the floral distribution truck should be loaded by storeand flower types for the first full season. It is recommended to the company tofurther optimize the distribution with one big truck for all stores coverageversus two small trucks for the upcoming season.
  • 关键词:Floral industry logistics and distribution; excel solver; Travelling Salesman;problem (TSP); Truck Dispatching Problem (TDP); Vehicle Routing Problem (VRP).
国家哲学社会科学文献中心版权所有