optimise trips

[missticktock]

Hi guys,

Appreciate some help with the following.

In this exercise, my objective is to optimise the number of deliveries, based on the various-sized trucks that i have.
I have the raw data of 'total number of pallets' by row, and i need to know in each row, what is the optimal size and amount of trucks to use for delivery.


Assume I have the following delivery options:
-20 pallet truck (20P)
-10 pallet truck (10P)
-4 pallet truck (4P)
-2 pallet truck (2P)
-1 pallet truck (1P)

If I need to deliver 5 pallets, I will use a 4P+1P truck.
If I need to deliver 14 pallets, I will use a 10P+4P truck.
If I need to deliver 15 pallets, I will use a 20P truck.
If I need to deliver 25 pallets, I will use 20P+10P truck
If I need to deliver 35 pallets, I will use 2*20P truck

For 'total pallets' that are x5 and above (i.e. 15 pallets, 25 pallets, 35 pallets...), it is usually assumed to use a 10P or 20P truck (instead of a 4P+1P)

Goal is to place yourself as the business owner- you want the most efficient way to deliver goods. So ideally, I want to minimise the total number of trips.

Attached is a sample.


Thank you so much!!