ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> A
http://www.istechforum.com/YaBB.pl?num=1123096268

Message started by John_Howard on 08/03/05 at 11:11:08

Title: A
Post by John_Howard on 08/03/05 at 11:11:08

Due to some consolidation in our workforce we are now having a salaried supervisior occasionally work on a machine in the direct manufacturing of a of our products. We want to show this cost in the manufacturing process so as not to distort the product costs.

The supervisor turned in a time card for the time he spent on a machine and the payroll persons recorded his time in hours to the appropriate work orders.

I was horrified to find at the end of the month that all his time was multiplied by his salaried rate in the costing process. A part that normally might cost 50 cents was now showing a last cost of $95.00.

I have several questions. First what is the best way to get the supervisors labor into the product. Should we set up another employee number for the supervisor in the hourly employee category and use this number to enter time to the work orders?

Questions two thru 10 are how best to correct the problem. We show over $100,000 worth of labor going into the costing system when the true total should a 10th of that.

What should we do about all the parts that now have an inflated last and/or average cost.

In General, what is the best way to handle our situation?

respectfully,

John Howard
Tri-Tec Company

Title: Re: A
Post by JNAPIER on 08/03/05 at 12:28:09

If your STD. costs are correct run UT-K-F to set last and avg to std. You might need to enter the correct std cost first.

John

Title: Re: A
Post by aricon on 08/04/05 at 04:13:56

And set up the supervisor with a 2nd code that has an appropriate hourly cost that any production time he does will be entered under.

Title: Re: A
Post by Lynn Pantic on 08/04/05 at 05:32:37

UT-K-F will correct the on-hand unit costs but make no GL postings. You will also need to make GL entries, probably between Inventory, absorbed labor, and COGS assuming some of the overcosted items have already shipped out. You may also need to make corrections to remove labor cost from WIP for any work orders he vay have worked on that have not had Finished Production entered.

As an alternative to creating a second employee entry, you could change all salaried employees to hourly with a pay rate equall to 1/40th of weekly salary and simply always pay them for a 40 hour week. This approach also makes it easier to split out a sick day or vacation day when running payroll assuming you use DBA payroll.