Associations at different levels of granularity

[bcr123psu]

Hello!  I'm running into an issue that I'm sure is pretty common but I haven't been able to resolve on my own yet.  We have a very basic app that needs to be built that shows sales rep performance vs. quota for specific targeted accounts.  The files consist of the Quota (Rep, Month, Type, Quota), Sales (Customer, Month, Type, Amount), and Customer (Customer, Customer Contact, State, Rep).  At the end of the day, we need to roll up the sales by type and compare it to the quota by type for each rep.  Mockups of each table are attached and examples are below.

The issue that I see is that quota is not set at the customer level, the customer data doesn't contain a month or type field, and the sales data doesn't contain the rep.  So I'm left with a circular association (below) that still doesn't return what I'm looking for.  Any feedback on how to approach this is greatly appreciated.  Thanks!

Quota:

Rep	Month	Type	Quota
Jim	July	Commercial	100000
Jim	August	Commercial	110000
Jim	September	Commercial	120000
Jim	July	Residential	50000
Jim	August	Residential	60000
Jim	September	Residential	70000
Jim	July	Industrial	55000
Jim	August	Industrial	55000
Jim	September	Industrial	55000

Sales:

Customer	Sale Month	Type	Amount
185188	July	Commercial	10900
107227	July	Commercial	20888
157811	July	Commercial	2282
148966	July	Residential	4913
118633	July	Industrial	16446
197725	July	Industrial	2398
114268	July	Industrial	7265
133108	July	Industrial	23461
191580	July	Residential	11848
173991	July	Commercial	20506

Customer:

Customer	Customer Contact	State	Rep
185188	Isis Hellman	ME	Kawal
107227	Alesia Mains	LA	Kawal
157811	Lindsy Lew	NV	Denise
148966	Racquel Gregor	NM	Jim
118633	Harriet Neathery	VA	Denise
197725	Rosita Ransome	NH	Kawal
114268	Deedra Candler	KS	Kawal
133108	Linwood Coursey	HI	Jim
191580	Hsiu Mento	NM	Kawal
173991	Gaynell Henkel	DE	Jim