Calculating efficient order quantities

[isinagola]

I need to know what orders I should ask customers to place based on filling up a lorry, in order to be as efficient as possible. Can anybody help?

My data looks like this and I need the three numbers in red to be calculated by a formula if possible:

Customer	Order Qty	Full Pallet	Pallets/Lorry	Full Lorry	Total lorries	Order 1	Order 2	Order 3
Example	40,000	700	26	18,200	2.20	18,200	18,200	3,600

[#2]

@isinagola , the formatting did not come through so we can't see the red highlights. Can you upload the data in Excel without any confidential information please?