Your profitability report is calculated as follows:
(Sales Revenue + Other Income) - (Cost of Goods + Indirect Labor Costs + Overhead) = Profit Margin
Sales revenue is broken into separate line items for each item type and referral source. For this reason you should have an item type for each revenue stream that you want to analyze separately.
Currently, the only number that feeds into this is restock fees. You can set restock fees for each catalog item. A restock fee is charged to the customer for returned items.
Cost of Goods
Cost of goods is the sum of direct labor and parts.
When you create an item type with the "labor" checkbox enabled, all of the catalog items you add underneath the item type will be treated as direct labor costs. For each catalog item you create, you are able to enter the "cost" associated with that service.
When you create an item type with the "part" checkbox enabled, all of the catalog items you add underneath the item type will contribute to cost of goods. For each catalog item you create, you are able to enter the "cost" associated with that service. In addition, for each inventory item you add, you can specify the cost of the part.
In your location settings, there is a field to enter your "overhead rate." Here is how we recommend you calculate this number:
Keeping in mind there are 24 hours in a day, this is calculated for an hourly rate:
- Add up all of your monthly bills for a location, i.e. rent, utilities, internet, cleaning, etc.
- If you have any bills/expenses that are not billed monthly, divide them down to a monthly equivalent.
- Add the monthly pay of any salaried employees.
- Divide that sum by the total number of hours in a month (730). This number was calculated by:
- 24 hours in day, multiplied by 365 days in a year: 8760
- Divide that by 12 months: 730
- This number is your hourly overhead rate; plug this into the "Overhead Rate" field. We have found somewhere in the vicinity of $10-20 to be the industry average.
RepairQ calculates all of this for you. You need to do 2 things:
- Enter the salary rate for each staff member, and make sure the "require timesheet" is checked on their staff profile.
- Train your employees to clock-in/out in RepairQ.
To get indirect labor cost, RepairQ calculates non-billable hours per staff member (see below) and then multiplies the non-billable hours by the staff hourly rate(s). Then RepairQ sums the Indirect Labor for each staff member to determine the total Indirect Labor.
- Total hours (per staff) = Total number of hours during the reporting period in which the staff member is clocked in.
- Billable hours (per staff) = Total number of hours during the reporting period which were recorded as labor on any ticket regardless of ticket status.
- Non-billable hours (per staff) = Total hours less Billable hours.
- Indirect Labor (per staff) = Non-billable hours x Staff hourly rate.
- Indirect Labor (*everyone) = Sum of all Indirect Labor per staff.