I have the following math problem which I'm a hardtime finding the best way to reflect/calculate.
If anyone can help I would really appreciated.
I have an agreement with a supplier that he will provide a bottle per case (12 bottles in a case) and I will provide a bottle per case. This deal will be passed on to my customer Which I'm asking them to order in increments of6 case quantities so that full case(s) can be shipped no charge on same order. What's the best way to show this special deal?
* My cost is $ 87.85 per case
* My Sales price is $ 114.00
Note: What makes this problem treaky is that the supplier wants to fund 6free bottles and I will fund the other 6 so ultimately this is passed down to the customer as a free case on every 6 cases ordered.