Hi
I was asked by my parents to create a suppliers price list for their company that would show how much we are paying out on materials. We have the suppliers list but are then given discounts by the supplier (i.e 94%, 85%) depending on products so these need to be applied to show what is paid out at a quick glance. We then get yearly percentage price increases for certain products. So I need the prices increases to go off the last price increase. I have created something but its too hard for other members of staff to use or update. I feel like there must be an easier formula/formulas to use for this. I will attach the price list. If anyone has any suggestions that would be greatly appreciated.
Bookmarks