Formula help

[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.

 

[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