3.9 Extension 8: Subcontractors

Download Workbook: pdp_extension_8.xlsx.

Let us now consider the situation where Opturion Freight has the option to use subcontractors to make deliveries in addition to also using their existing fleet. Subcontractors are paid a flat rate of $25 per delivery.

We can model this situation by adding the subcontractor vehicles to the Fleet sheet and setting all of their costs to zero. We then add a new sheet, Order Vehicle Costs, to the workbook. Table x17-20001r1515 shows an excerpt from this new sheet.

Order Vehicle Cost
Order1 Sub_1 25
Order2 Sub_1 25
Order3 Sub_1 25
Order4 Sub_1 25
Table 15: Order-vehicle costs.

Each row of this sheet specifies a cost that is incurred if the order given in the Order column is assigned to the vehicle in the Vehicle column. The cost incurred is given by the Cost column.

In the accompanying workbook, we have set up a cost of $25 between every order and each of the two subcontractor vehicles, Sub_1 and Sub_2.

KPI Value
Total Cost 946.48
Total Distance 457.97
Work Time 29:49
Transit Time 10:14
Break Time 01:00
Idle Time 00:55
Assigned Orders 80 / 80
Fleet Usage 4 / 5
Table 16: Solution KPIs.

In Table 16, we can see that the Idle Time solution KPI is now non-zero for the first time. Idle time is time spent waiting for a pickup or delivery. It usually results from waiting for a time window. Previous solutions have avoided idle time. However, in this case, because the subcontractors are not paid an hourly rate, it is cheaper to assign some orders to them even though they will have to wait.