Pivot Table to show discrepancies

[MKLoveland]

Hey all,

I have a spreadsheet we pulled from one of our tracking system. The following are prices that correspond to each home we build. We have the square footage in the second row.

My goal is to put these into a pivot table and show me all the prices that are "Too High" given the Square Footage to price trend/ratio. A good example would be product 2 between E and F OR product 7 between C and D. The square footage is still increasing yet there is a drop in the price?
We have hundreds of these so I'd love an easy way to analyze the data!

Let me know your thoughts.
Snip.JPG
Home Type A B C D E F G H
SQ FT 2150 2360 2480 2575 2725 2875 3156
Product 1 600 1000 1000 1000 600 1000 600 600
Product 2 3170 3200 3465 3200 3244 2951 3159 3269
Product 3 3537 3121 3236 3700 3860 3438 3346 3514
Product 4 130 130 130 130 130 130 130 130
Product 5 211 197 314 248 219 240 228 228
Product 6 2850 2850 2850 2850 2850 2850 2850 2850
Product 7 1206 1088 910 1235 1235 1226 1292 1420