cathyh
Active Member
   

I used to be indecisive; now I'm not so sure......
Posts: 1210
Gender:
|
I am not sure if this is what others are looking for.... In my world labor is only contained in items finished by work orders and there are several places where this can be seen in DBA for a given month (e.g. WIP summary, BS). The problem is when you finish production, the cost of a built item goes as a lump sum (actual cost or standard cost) into a GL asset account, and therefore has to come out as a lump sum to go into COGS. In a given time period though the information is available-- I use Access and Excel to compile it. In Access, I use the WORKORD, WOREC, and MTICMSTR files. My excel spreadsheets are done (by hand so to speak!) using actual job cost summaries. We always finish at actual cost, and we do not have a lot of Accessories and Finished Goods Inventory (we generally sell what we finish in a given month) so this works for me. In my excel spreadsheet, I take the total absorbed labor and subtract the change in labor in asset accounts to come up with a total COGS labor. The accuracy of this of course is dependent on the accuracy of your labor data entry and what you set your labor costs to if you do not use actual hourly wage cost. I would not mind sharing this if anyone is interested. However, from reading topics in this forum, I am sure there are others out there who could create a report in Crystal Reports or Access that works way better to summarize the data that I am collecting.
|