(BOM – Shop Rates)
Screen Details - Financial Transfer
These screen details apply when you are using the Financial Transfer accounting configuration.
Overview
What is the purpose of the Shop Rates screen?
The purpose of the Shop Rates screen is to maintain a single shop hourly rate for direct labor and a single shop hourly rate for manufacturing overhead. The hourly shop rates get applied to work center hourly rates where they can be factored up or down for exceptions.
What are the benefits of the Shop Rates screen?
Self adjusting shop rates are a true DBA innovation. The overall goal of the costing system is for your absorbed costs for labor and manufacturing overhead to offset your actual payroll costs for your production workers and your actual costs for your manufacturing overhead. Many competing systems attempt to tie down their payroll hours with job reported hours. Matching hours to hours is nearly impossible to do and does not lead to more accurate absorbed costs. You run into major problems addressing the following common issues: attempting to track non production time (down time), handling partially attended sequences, accommodating workers that can run more than one sequence at a time, handling labor for rework, the requirement for perfect accuracy of your cycle times, etc.
Instead of worrying about payroll hours, DBA takes your overall costs for a given period of time and compares that to the production hours reported for that same period of time. The strength of our approach is that you do not have to attempt to perfectly match your reported hours with actual clock hours. You can use standard completion hours for reported time and the self adjusting shop rate will automatically adjust accordingly. The end result will be that you will achieve reasonably accurate absorbed labor and manufacturing overhead costs without the need to be perfect in your labor time tracking.
How are shop rates determined?
The two shop rates are calculated using the following formulas from a recent date range of actual costs and reported labor hours. This enables future job labor transactions to be costed at hourly labor and overhead rates that fully absorb your actual costs into work in process, which ultimately flows into inventory value and cost of goods sold.
Actual Direct Labor Costs / Reported Job Hours = Shop Labor Rate
Actual Mfg Overhead Costs / Reported Job Hours = Ship Overhead Rate
You enter actual cost totals from your outside general ledger
The actual costs used in the above formulas are stored in your outside general ledger. So when you use the Shop Rates screen you will manually entering total actual direct labor cost and total actual manufacturing overhead cost for a specified date range.
We recommend quarterly updating
We recommend updating shop rates once a quarter. If you recently implemented DBA and are still refining your numbers, you may wish to update shop rates more frequently, such as each accounting period, until they stabilize.
Variances are normal and expected
Because hourly shop rates are a prediction of future costs and hours, there will always be an accounting variance between absorbed costs and your actual labor and overhead costs. Such variances are normal and expected and are automatically handled by the accounting system.
Advance Setup
Labor and manufacturing overhead costing is handled completely differently in a manufacturing chart of accounts than in a generic chart of accounts.
Generic Chart of Accounts
In a generic chart of accounts, labor and manufacturing overhead costs are handled by Expense accounts and shop expenses are often blended with general expenses. For example, payroll expenses for shop and office employees are often lumped together into shared expense accounts. Shop and office expenses for rent, utilities, insurance, maintenance, utilities and other costs are often lumped into shared expense accounts.
Manufacturing Chart of Accounts
By contrast, in a manufacturing chart of accounts, labor and manufacturing overhead costs are handled by Cost of Sales accounts. Shop-related costs are isolated from general and administrative costs. Job labor and manufacturing overhead transactions post to contra-accounts that offset actual costs and thus “absorb” labor and overhead costs into the inventory costs of the items you make.
You must restructure your labor and overhead accounts
To use your chart of accounts with financial transfer processes, you must restructure your labor and manufacturing overhead accounts to convert your generic chart of accounts into a manufacturing chart of accounts.
Your payroll system must isolate production workers and indirect labor
Your payroll system cost account assignments for benefits, taxes, and wages must isolate costa for production workers, which are direct labor costs, from indirect labor costs for shop managers, supervisors, and non-production workers, which are manufacturing overhead costs.
Labor and Overhead Accounts Setup
If you have not yet structured your chart of accounts and payroll system to isolate direct labor and manufacturing overhead accounts as Cost of Sales accounts, refer to the following chapter in the Financial Transfer guide for setup details.
Link:
Financial Transfer Guide – Labor and Overhead Setup
Shop Rates - Calculator Tab
Date Range
From Date, Thru Date
Each time you launch this screen, you are prompted to select a date range, which is displayed in this panel. The past three months are selected by default, but you can select any range of dates. The date range determines the costs and hours used in the shop rate calculations.
CAUTION: Do not select mid-month dates or a date range shorter than three months. Avoid mid-month dates because you can understate your overhead costs if some monthly costs have not yet been booked. Avoid short date ranges because the inclusion or exclusion of one payroll run can significantly overstate or understate your direct labor cost.
Direct Labor
Labor Cost
This field displays your total direct labor costs for the date range specified above. This cost is manually entered from information in your outside general ledger. Click the Enter Labor Cost button at right to populate this field.
Enter Labor Cost
Click this button to make an entry that populates the Labor Cost field. Refer to your outside general ledger to obtain your total direct labor costs for the same date range specified above. Do not include the Absorbed Labor account in the total amount. Enter the amount in the Enter Labor Cost field and click OK.
NOTE: See Advanced Setup above for details on how to structure direct labor cost accounts in your general ledger.
Absorbed Labor
This is your total absorbed cost for direct labor within this date range. This cost is extracted from your Absorbed Labor account in the DBA general ledger. You can click the search icon at right to get a listing of the underlying transactions behind this amount.
Variance %
This is the variance between direct labor cost and its absorbed cost, expressed as a percentage. If direct labor cost exceeds its absorbed cost, this is a positive percentage, which means that direct labor cost was under-absorbed. If direct labor cost is less than its absorbed cost, this is a negative percentage, which means that direct labor cost was over-absorbed. You can click the magnifying glass icon at right to see the actual calculation.
Mfg Overhead
Overhead Cost
This field displays your total manufacturing overhead costs for the date range specified above. This cost is manually entered from information in your outside general ledger. Click the Enter Overhead Cost button at right to populate this field.
Enter Overhead Cost
Click this button to make an entry that populates the Overhead Cost field. Refer to your outside general ledger to obtain your total manufacturing overhead costs for the same date range specified above. Do not include the Absorbed Mfg Overhead account in the total amount. Enter the amount in the Enter Overhead Cost field and click OK.
NOTE: See Advanced Setup above for details on how to structure manufacturing overhead cost accounts in your general ledger.
Absorbed Overhead
This is your total absorbed cost for manufacturing overhead within this date range. This cost is extracted from the Absorbed Mfg Overhead account in the DBA general ledger. You can click the search icon at right to get a list of the underlying transactions behind this amount.
Variance %
This is the variance between manufacturing overhead cost and its absorbed cost, expressed as a percentage. If manufacturing overhead cost exceeds its absorbed cost, this is a positive percentage, which means that manufacturing overhead cost was under-absorbed. If manufacturing overhead cost is less than its absorbed cost, this is a negative percentage, which means that manufacturing overhead was over-absorbed. You can click the lookup button at right to see the actual calculation.
Hours
Total Standard Hours
This is the total standard labor hours reported to jobs within this date range. Standard hours pertain to job routing sequences with an Hours Type setting of ‘Standard’ and are incurred as sequence quantities are entered or sequences are flagged as finished in the Job Labor screen. You can click the search icon at right to get a listing of the underlying transactions that comprise this amount.
Total Actual Hours
This is the total actual labor hours reported to jobs within this date range. Actual hours pertain to job routing sequences with an Hours Type setting of ‘Actual’ and are incurred when worker hours are entered in the Job Labor screen. You can click the search icon at right to get a listing of the underlying transactions that comprise this amount.
Total Labor Hours
This is the sum of the Total Standard Hours and Total Actual Hours.
Factored Labor Hours
Each labor transaction is adjusted by its work center’s setup and labor cost factors, using the formula below, and is totaled to arrive at the factored labor hours for this date range. You can click the search icon at right to get a listing of the underlying transactions that comprise this amount.
(Trxn Setup Hrs * WC Setup Cost Factor) + (Trxn Labor Hrs * WC Labor Cost Factor) = Trxn Factored Labor Hrs
Factored Overhead Hours
Each labor transaction is adjusted by its work center’s overhead cost factor, using the formula below, and is totaled to arrive at the factored overhead hours for this date range. You can click the search icon at right to get a listing of the underlying transactions that comprise this amount.
Trxn Total Hours * WC Overhead Cost Factor = Trxn Factored Hours
New Shop Rates
Current Labor Rate
This is the current hourly shop rate for absorbed labor.
Calculated Labor Rate
This field is populated when you click the Calculate button and is the calculated hourly rate for absorbed labor within this date range, based on this formula:
Labor Cost / Factored Labor Hours = Calculated Labor Rate
New Labor Rate
This field defaults to the Calculated Labor Rate value, but can be overridden if you expect an upward trend in business volume (in which case the rate would be adjusted downward) or a decrease in business volume (in which case the rate would be adjusted upward).
Current Overhead Rate
This is the current hourly shop rate for absorbed overhead.
Calculated Overhead Rate
This field is populated when you click the Calculate button and is the calculated hourly rate for absorbed manufacturing overhead within this date range, based on this formula:
Overhead Cost / Factored Overhead Hours = Calculated Overhead Rate
New Overhead Rate
This field defaults to the Calculated Overhead Rate value, but can be overridden if you expect an upward trend in business volume (in which case the rate would be adjusted downward) or a decrease in business volume (in which case the rate would be adjusted upward).
Calculate
After entering a date range and, when applicable, the total labor cost and overhead cost, click this button to populate the Calculated Labor Rate and Calculated Overhead Rate fields.
Save
Click this button to save the new shop rates. Work center hourly rates are updated by these formulas:
New Shop Labor Rate * WC Setup Cost Factor = New WC Setup Rate
New Shop Labor Rate * WC Labor Cost Factor = New WC Labor Rate
New Shop Overhead Rate * WC Overhead Cost Factor = New WC Mfg Overhead Rate
History Tab
Each time the shop rates are updated, a history record is recorded on this tab to provide you with a complete history of shop rate changes, including the user who made the change.
