Formula to work out Pellet Fills

Hi

I've been tasked with finding a way to optimizing some distribution.

in a nut shell we can fit 4 pallets onto a van 2 hold 32 Cases and 2 hold 40 cases and i need to find a way to work out how much of each product will go on each pallet.

Pallet 1 Holds = 32
Pallet 2 Holds = 32
Pallet 3 Holds = 40
Pallet 4 Holds = 40

Product 1 12 = Pallet 1
product 2 14 = Pallet 1
Product 3 36 = x6 Pallet 1 & X30 Pallet 2
Product 4 29 = x2 Pallet 2 & X27 Pallet 3
Product 5 38 = X13 Pallet 3 & X25 Pallet 4

Sorry if this looks like a GCSE question.

Cheers

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here. If you think you posted under the wrong topic, click Report Post under your post to request that we move it. Do not just make a duplicate in another topic.

Please see Forum Rule #2 about thread duplication.

I am closing this thread, but you may continue here in the other thread

Thread closed.