Formula help

M

M.

Is there a form to calculate the average cost of a good if
the customer is offered a 1 on 8? For instance, cost of
an item is $44 per case. If they purchase 8 they get 1
additional free = $4.33 cs.

Thanks,
M.
 
B

Bernie Deitrick

M,

The average unit cost would then be 8/9 of the original unit price. The
calculation depends on the number of units per case.

HTH,
Bernie
MS Excel MVP
 
Top