Hi,
I maintain a product list spreadsheet and would like to create a formula to apply a per unit price to determine how much my cost is by category. The per unit price (col C) is relative to the supplier (col B) and is discounted by volume – the more I buy the cheaper it is etc.
The purpose of the spreadsheet is to identify how much my spend is on either beef or chicken. As a category, beef and chicken is then made up of different products, Angus, scotch, sirloin etc.
What I want to do is apply the per unit price by row relative to the count of “Beef” (or chicken) and by supplier, reflecting the tiered pricing as the count increases.
I have attached a spreadsheet example with a table of the outcome I am trying to achieve using formulas.
Data is illustrative; haven’t given an example for supplier 2; data assumes the same buy price for "beef" and "chicken"
Thanks
Bookmarks