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 |
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 |
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.

