Orders and Returns Detailed Contract Summary

Hi Everyone,

Happy March Break!!!

Attached is a contract summary for a new customer program, that gives cash back on net orders!

There are a lot of rules I will post below but are included in the attached document. Please note everything under row 19 in the "answer" section should be formulas, if possible, to make my life easier! - as there will be 20+ contracts!

Rule:
1 Orders must be at => after start date (i.e 1/1/2022 or after for customer 100)
2 Returns are only counted if the returned serial number was purchased => start date (i.e 1/1/2022 or after for customer 100)
3 Orders and returns can happen on the same date since this is a customer product (returns are easy)
4 Volume commitments are counted as the NET # orders (orders - returns)
5 Cash back is counted on NET # orders (orders-returns)

This will make alot more sense when looking at the attached workbook.

Thank you guys SO MUCH!