I can't find the answer to this anywhere and it seems so simple. I want to waterfall step two months total sales dollars by using volume and rate variances.

Volume = (current month volume-prior month volume)*prior month average price

Rate = (current month rate-prior month rate)*current month volume

Spreadsheet attached.