top of page
  • Writer's pictureAmi Tharayil

Logistics

A small trucking company approached RCOR with the goal of improving their delivery process. The company has 10 vehicles, each making several deliveries a day, and they have route planning software to plan deliveries. However, the software plans every palette separately, even if they are being delivered to the same customer. This made it difficult for drivers to know how many palettes they were delivering to each customer, and it was not clear to management how many locations each truck was visiting each day. RCOR determined that the source of the data was a fixed table containing vehicle tags, delivery addresses, and times from the route planning software. They used Excel to manipulate the data and consolidate each customer's information into a single line. However, they recognized that tables may not be easy to read when on the go, so they asked the client how drivers would like to see their schedules. The client indicated that drivers wanted a simple list of times and locations, along with the number of items to be delivered at each site. RCOR added code to an Excel spreadsheet to produce these schedules from the original data with a single button click. They also implemented a feature that allows the schedules to be sent straight to the printer at the depot, ready for drivers to pick up every morning. Overall, the solution developed by RCOR has helped the small trucking company improve their delivery process by providing drivers with a clear and easily readable schedule, and enabling management to track the locations visited by each truck.

24 views0 comments

Recent Posts

See All

API Integration

Introduction: RCOR was approached by a retail company that operates a number of brick-and-mortar stores and an e-commerce platform. The company wanted to improve the customer experience by personalizi

Sales Management System

Introduction: RCOR was approached by a manufacturing company that was struggling to keep track of its sales pipeline and forecast future sales accurately. Sales reps were using a patchwork of spreadsh

Automobile Repair Shop

Introduction: An automobile repair shop approached our company, RCOR, with the goal of streamlining their communication with clients and improving the efficiency of their repair process. The repair sh

Comments


bottom of page