Unknown said:

Does anyone know how to pull actual COGS costs and quantities (by product) for each of direct materials and direct labour?  Also, variable OH?  I need these actuals as a base to help me create an annual budget for COGS and standard costing (by product) for direct materials, direct labour, and overhead.

You didn't mention which Edition of Sage 50 Canadian you are using, and if you have any add-ons (such as MISYS for manufacturing)

Sage 50 allows entry of any conceivable Cost Accounting transaction, but does not really have the built-in functionality to automate cost accounting.  There is no workflow or calculation from time sheets through payroll and inventory costing, for instance. 

Unknown said:

No reports that I've run have this info including "Product Analysis Report", "Customer Analysis Report", "Inventory and Services Sales Report", etc.

Calculating Direct labour usage, overhead application rate, etc. would have to be done externally to the base Sage 50 software.  There is no 'job order' or 'work order' or 'time sheet' screen that will assist in planning, calculating, and recording costs for build-to-inventory transactions.

Unknown said:

I need these actuals as a base to help me create an annual budget for COGS and standard costing (by product) for direct materials, direct labour, and overhead.  Budgets have never been done before.

 - The Bill-Of-Material calculation of item costs is automatic (cannot be overridden) based on the individual inventory item cost + 'Additional Costs' to the G/L account that was manually entered into the BOM screen for the Inventory Item. 

- The Item Assembly calculation costs works the same as for a Bill-Of-Material entry, except item costs can be over-ridden and only one G/L account can be used for the entire company.   Recurring transactions will store any cost over-rides with the items.

If you have the reports (not in all Editions of Sage 50) 'Item Assembly Detail' and 'Bill of Materials Detail', they will show the Direct Material and Direct Labour ("Additional Costs") that were applied in prior transactions. 

The Bill of Materials Component List can calculate the Estimated Cost for future entries, based on the current inventory cost of materials, but the 'Additional Costs' is just the amount from a manually entered field in the Inventory ledger. 

I hope that helps, please post back.

Randy Wester