allocate freight costs across multiple SKUs?

Hey there, I’ve been selling for a few years, and I have always had trouble allocating supplier invoices, freight bills, etc manually, each shipment take hours. That was without the tariff shifting. For those who do multi-SKU shipments, what’s your allocation method – weight, volume, or something else? any excel template I can find around here? thanks!