Pallet loading on truck

[Hardesh]

Hello all,

need help loading cargo pallets on a truck and how many truck will be needed.

example all trucks have max 5 spaces for pallet sizes.
Pallet A takes up 3 spaces on the truck
Pallet B takes up 2 spaces
Pallet C takes 1 space
Max space per truck is 5 after which will need additional truck.

can’t get my head round how to arrange excel ?
On a average day we can have up to 40-50 pallets all varied sizes,
Appreciate any help
Thanks

 

[Krayna]

Can you post sample spreadsheet to demo how data structured please.

 

[mamady]

Hello all,

need help loading cargo pallets on a truck and how many truck will be needed.

example all trucks have max 5 spaces for pallet sizes.
Pallet A takes up 3 spaces on the truck
Pallet B takes up 2 spaces
Pallet C takes 1 space
Max space per truck is 5 after which will need additional truck.

can’t get my head round how to arrange excel ?
On a average day we can have up to 40-50 pallets all varied sizes,
Appreciate any help
Thanks

Can you please check if the below satisfy your requirement?

Book1
	A	B	C	D	E
1	Truck Capacity	5	Spaces per Truck
2
3		Sizes
4	Pallet A	3	Spaces
5	Pallet B	2	Spaces
6	Pallet C	1	Space
7
8		Qty at hand
9	Pallet A	10
10	Pallet B	10
11	Pallet C	20
12
13
14	Number of Trucks required		14
Sheet1

Cell Formulas
Range	Formula
C14	C14	=ROUNDUP(SUMPRODUCT(B9:B11,(B4:B6/B1)),0)

Regards

 

[Hardesh]

Many thanks worked perfectly made my job a lot easier!!!!

 

[mamady]

Many thanks worked perfectly made my job a lot easier!!!!

Most welcome, I am glad to assist