Improvement of Transportation Routes Skin Cream: Case Study ABC (Thailand) Co.,Ltd.

Abstract

The objective of this cooperative report was to study adaption of product plan delivery route. This company is medium entrepreneur of cosmetic product. Currently, company don't have proper method for planning delivery route. Current plan is base on drivers' experience. This study provide suggestion to improve delivery route base on service zoning of Traveling Sales Problem theory and Linear programming theory. Users input delivery data and applied conditions to Microsoft EXCEL SOLVER program compute. The study result is as below. Current delivery route is 542 km which is equal 3,978 baht delivery fee. After user make delivery plan by Microsoft EXCEL SOLVER, the delivery distance is 480.6 km which is equal 3,698 baht. The distance improvement is 61.4 km which is about 11.33% and total cost improvement is 280.5 baht which is about 7.05%