Inventory - Shipping in Inventory cost price
When I order Goods for inventory the cost of shipping is charged by the seller to me and itemised on the bill. From my perspective, this forms part of the cost of the products purchased on the same bill.
The COST price ought include specifically the shipping on inwards inventory (averaged over all the items on a bill) to calculate the cost price when the items are entered on inventory items.
How I do it today : I make a complex calculation of all overheads including shipping which is manually added to the cost price plus profit margin to make the selling price. Its pretty laborious, and subject to errors in calculations.
But technically, the inwards shipping is part of the actual cost of the product, and separate to general overheads.
I would like the option to prorate a shipping charge on a bill by value across all the non-shipping items on a bill to determine the cost price entered into inventory by way of a form control added to the billing form.
This would act to transact shipping costs directly attributable to inventory assigned directly to inventory costs, as they are not really overhead expenses. It will make the reported cost of inventory more accurate.
Then, other overheads (Advertising, Power, Internet etc) and profit margin are later added to the cost price to form the selling price.
Further, it ought to be possible for Xero to automatically have a set of rules to calculate overheads and margins that are automatically used to adjust selling price, perhaps a periodical batch process. Is this even possible ?