Manufacturing Part Productivity BAQ

Does anyone have any experience with a Part level productivity BAQ report?

Our manufacturing area would like the report to be at the Part level (not the operation level) and include the Production Standard time (for all operations combined together) compared to the daily finished quantity and labor hours.

I am thinking that the Part level Production Standard time would need to be a custom field added to the Parts table, but I am unsure how to get everything else to connect. The labor information seems tied to the Job rather than the associated part.

Anyone ever do this before?