Tags Vs. Classes for a material supply business
I run a material supply company that sells construction materials to development projects. All of our sales are through various development projects. Sometimes we sell one category/item (Ex. Doors) to a project. Other times, we sell multiple categories (Ex. Doors, security cameras, electronic access, etc.).
First, we need to be able to track a given jobs overall profitability across all product categories (both revenue and expense - aka job costing).
Second, we'd like to track each categories profitability throughout a project. (Ex. Total revenue of doors versus total expenses of doors to see gross profit of door sales on a single project)
Third, we'd like to track each categories performance compared to others (Ex. how much revenue did we generate selling doors versus security cameras over a certain period of time)
I understand there are tags, classes, and projects that can be used for these functions, but I'm trying to understand where and how to use each feature relative to what I want to track.
Can someone make a suggestion on how to leverage these features for my specific business?
Thank you in advance for any help!