KPI for Multiple Values with differing target values

I'm attempting to create a KPI in PowerPivot that contains different targets corresponding to different values that all belong to the same field. I have a field that contains all manufacturers of our products, however each manufacturer has it's own fulfillment target. E.g., the target for Detroit is 95%, while the target for Nashville is 98%. I have thus far been unable to create a single KPI that meets this criteria. Attached is an file that provides a visualization of the problem. Specifically, how can I get measure "All Products OT" to give an accurate KPI based on the values given in "FR Target" all in one column/field on the pivot located in the performance tab?

Much appreciated!

The KPI should show the relationship of the on-time number of deliveries for each supplier compared to their target rate. E.g., there were 159 on time deliveries out of 161 total deliveries for Atlanta, which totals 98.76% and exceeds their target of 96%. Therefore, the KPI would show as "Green" for Atlanta but "Red" for all others. I forgot to redo the formula to correctly identify the on time shipments for Nashville; it's corrected in the attached. FYI, the two columns in the pivot that are "count of ..." is how the "All Products OT" measure is calculated. FYI2 - This is not a real database; I obviously can't release the database because of confidentiality.

A side note, I am not sure why the relationship between Table 2 (Manufacturer Target) and the Sales Data table is not working correctly. I think it may have to do with the values being numbers and not text. I created some measures a while back that I would think have worked but did not because of the relationship problem. Furthermore, the only reason why I added the target to each row in the Product Data tab is in attempt to remedy this relationship; a target for each row may not be needed and may not even be the correct way of doing it since the target is an overall figure and makes no sense when applying it to each product (i.e., it's impossible for a single product to be delivered 97% on time).

MUCH APPRECIATED OCHIMUS!