Designing a Proposed Scheduling Model in Logistics Company

Corp. is a company engaged in the logistics
industry that provides their clients with every logistics need,
including land transport. The company has received many
complaints regarding their on-time delivery. A new model of
scheduling must be implemented to provide and maintain good
on time delivery and truck cycle. A model of scheduling with
EDD method will be compared to the actual scheduling results by
random sample. Then, a program will be made by Excel VBA to
automate the scheduling process. The output of the program will
then be compared to the actual scheduling for the past 2 months.
Results show that EDD method is the most optimal method for
scheduling a model that is based on a due date. Compared to the
actual scheduling model, the scheduling program could improve
truck cycle by 15%. A better truck cycle means faster delivery
and more truck utility