Need help - developing weighted averages with variable ranges

Attached is a set of sample data that we frequently have coming out of our sales database.  We would like to create a separate table with a weighted average (example is the table to the right).   T...