PepsiCo Foods Canada- Business Consulting Project


Project Details

Project Client: PepsiCo Foods Canada
Project Description: Delivery Schedule Optimization
Students: Neil Raj, James Park, and Nick Kim
Term: Spring 2011
BCIT Program: Business Operations Management

Objective:

The purpose of the study was to determine an optimal delivery schedule to service all of the company’s large-format (higher volume) customers in a more effective manner. Primary goals included increasing delivery vehicle cube utilization and maximizing delivery resource allocation efficiency.

Analysis Method:

The study consisted of analysis of the current ordering and delivering process. This included gaining insight on the process by shadowing both PepsiCo’s Delivery drivers and Merchandisers as they perform their regular duties. Past sales volume data was also analyzed to identify trends in regards to peak periods and the current workload distribution throughout the week.

Opportunities Discovered:

Opportunities discovered were that the client’s current delivery model was ineffective leaving certain high volume stores under serviced and lower volume stores over serviced. The current workload distribution through the week also proved to have major imbalance with an increasing amount of overtime stemming from Saturday and Monday deliveries. An additional key finding was that deliveries were being made from Monday to Saturday, leaving a potential delivery day (Sunday) unused.

Recommendations and Benefits:

Alternatives were developed and evaluated resulting in recommendations being made to address the needs of PepsiCo Foods Canada, they were as follows:
By applying these recommendations, the issues of delivery efficiency, flexibility, and uneven distribution of workload are overcome.