Part Sales Report (Matrix)

[MattFMN]

Is there a report I'm missing, or is there a way I can export to .csv, that would divide up Parts Sales by range of the Parts Markup Matrix?

Where I'm going with this is I wish to know where the average cost of parts is and what range, in my matrix, do most of my sales occur. If I'm shooting for 55% GP on parts, but I'm selling the VAST majority of my parts in the 40% GP range (a hypothetical number I've conjured for sake of discussion) then I've really stacked the odds against myself to attaining 55% GP.

So a report that would divide those costs up, by ranges I've set in my matrix, by number or % would be of great benefit.


.....I think.....


Thanks!

Later, Matt.

[ricmorin]

Use the Materials Used Summary and export to Excel. Sort by Cost. Create calculation cells that give you total dollars sales by manually selecting by the ranges you've setup in Manager.

Edit: You'll need to create a new column that multiplies the quantity by the sale price.

Edit2: I did this for fun from some data back a few years. Most of my sales came from the 50 to 100 dollar sales division which was set very near my target margin.