Inquiry to provide detail of average costs

Hi everyone, we are looking to present data on costs of goods sold to show the average costs of components included in the average costs of finished goods. Our raw materials are average cost, which are then used to produce WIP items (average costs) using production orders, which are then converted to FG (average costs) upon the addition of final components. It seems like this might be possible by drilling down into production orders that led to the final cost of the goods sold. I know average costs complicates this and it might be easier under the specific cost method, but does anyone have any experience with this particular scenario or any ideas to share? Thanks!