I have a question regarding pricing products.
Let’s say I have a product, price=x
But now it has increased by 5%, so p=x+(x*5%)
How to deal with this change in price, since we have got it with x and now it’s x + 5% or any amount.
What should I record in excel for that product price?
x OR x+(x*5%) ?
IF x why not x+(x*5%) ?
IF x+(x*5%) why not x ?
While I’m not exactly sure what your Excel spreadsheet is being used for, but I have found it extremely important to track price (MSRP) changes over time.
Orig. Price Date Orig. Price % increase Adj. date New Price
Item Jan 1 $100 5% Feb 25 $105
I now have the ability to see my price increase, the new price and when they were both effective.
Obviously, this would be an internal document.
