12-31-2016, 09:58 AM

It would be very useful if you could set up an automatic pricing strategy which would be a certain "base" price, plus shipping charges.

However, it is complicated to calculate shipping because different factories produce different amounts and it isn't always clear which factory will end up supplying which branch.

One solution is to pick up the shipping charges for last month in this months prices. Assuming sales are somewhat smooth, it should all (roughly) balance out.

Basically, take the total amount of shipping divided by the number of cars sold at that branch and add that number to the base price. If you don't want one type of car subsidizing another, then do that calculation for each model of car sold at that branch (probably a better approach).

If it turns out that this strategy produces "spikey" sales where lots of cars are sold one month and none the next (as nobody can afford the horrendous shipping charge) which then resets the shipping charge, producing sales again, you can smooth things over by averaging across the last 3 months (quarter).

However, it is complicated to calculate shipping because different factories produce different amounts and it isn't always clear which factory will end up supplying which branch.

One solution is to pick up the shipping charges for last month in this months prices. Assuming sales are somewhat smooth, it should all (roughly) balance out.

Basically, take the total amount of shipping divided by the number of cars sold at that branch and add that number to the base price. If you don't want one type of car subsidizing another, then do that calculation for each model of car sold at that branch (probably a better approach).

If it turns out that this strategy produces "spikey" sales where lots of cars are sold one month and none the next (as nobody can afford the horrendous shipping charge) which then resets the shipping charge, producing sales again, you can smooth things over by averaging across the last 3 months (quarter).