I need to take a price increase on some of my products. I am allowed
to take 4% per year - total. I have some products that do not need
increasing and some that do.

Example:
Item "A" - no increase
Item "B" - $0.25 per unit
Item "C" - $0.18 per unit
Item "D" - no increase
Item "E" - no increase
Item "F" - $0.11 per unit
etc

I am trying to create a spreadsheet which will allow me to put the
current selling price in one column, the proposed selling price in
another column, the percent increase in a third column, and the
weighted average increase in a final column. I'm hoping that this
column will update each time I put in a new price.

Thank you.