CSMT

Carrier Scheduling and Management Tool

Carrier Scheduling and Management Tool is a multi-purpose program to handle incoming inventory deliveries of raw materials for use in manufacturing. In it's primary application, it is meant to be used to track incoming roll stock deliveries in the corrugated manufacturing industry.

Existing System

Carrier scheduling is now entered in an analog system (pen and paper). Each carrier is recorded along with the following:

• Vendor
• Roll Width
• Roll Grade
• Delivery Time, as follows:
• 30 minute intervals between 7am - 9am
• 15 minute intervals between 9am - 1pm
• 30 minute intervals between 1pm - 6:30pm
• AM Delivery confirmation number (starting with 1-5 depending on day of the week. eg:
• AM1234 Monday
• AM2123 Tuesday
• AM3456 Wednesday
• etc
• Load # if applicable

Areas of Opportunity

While this process has been in place for years, it leaves some inefficiencies that can be fixed

CSMT can rectify these inefficiencies by solving a few issues that arise from using an analog system

1. The pen and paper system is outdated - transitioning to a digital system will ultimately reap more benefits
2. Digital system can allow for automatic tracking of late deliveries and reschedules, as opLoadsed to whiting out and copying information from day to day
3. CSMT will remove multiple points of failures that can occur from reducing the chance of duplicate Load's and AM delivery numbers by restricting each delivery to have one AM number and one Load number automatically generated by the system, reducing human error

Tasks CSMT Must Complete

1. Must schedule incoming deliveries
1. Assign Vendors to Carriers
2. Assign Load #'s to Carriers
3. Assign one and onlt one AM # per delivery
4. Schedule one carrier per time slot as outlined below
1. 30 minute intervals, 7-9am
2. 15 minute intervals, 9am-1pm
3. 30 minute intervals, 1pm - 6:30pm
4. NO Deliveries between 12-1230pm
5. Saturday deliveries stop at 2pm, 30 minute intervals 8am-2pm
2. Need to generate a report for the day
1. Should be in csv format or excel
2. 7 columns needed -> Load#, AM#, Vendor, Roll Width, Roll Grade, Time, Carrier
3. Documents
1. Must contain help documents (like pydocs) that can be accesed from within

Optional Future Updates

• Database support to enable user logins and permissions
• Database support to save historical delivery data (for analysis and reports)
• Ability to create custom reports based on a number of parameter combinations
• Shift from and create a GUI