Sage 100

 View Only
  • 1.  Production Management Costing

    Posted 06-12-2024 19:15

    Hi there

    I have a client using PM and has brought up the following:

    1. The problem I did find was that the transacted cost of the partially completed work orders was not accurate.  I believe this was the same problem we were investigating previously and suspected it to be FIFO inventory.   Turns out it was not FIFO.  Looking at WO#52 again, the projected cost per unit was $16.74 but the transacted cost was actually $14.71.  This was surprising since we had issued the right amount of labor and had selected the 'Relieve WIP as a percent of completion' box.  After some digging I figured out the transacted cost was equal to the current cost divided by the quantity planned.  That is not at all intuitive to me.  I expected it to be the current cost divided by the quantity completed.  I still don't have a clear explanation as to why the system would calculate that way.For me the next steps would be to complete the remaining quantities on WO 52 & 53, and look at the variances and transacted costs.  Then, I would repeat the test with new WOs but uncheck the 'Relieve WIP based on percent of completion' box to see if that has any positive effect.

    Can any one either confirm or deny that PM when PM does costing for the completed parts, it uses "costs/quantity planned" versus "costs/quantity completed"?  I seem to remember this with Work Order for partial completions, but i could be wrong.



    ------------------------------
    Douglas Luchansky
    ACI Consulting
    ------------------------------


  • 2.  RE: Production Management Costing

    Posted 06-13-2024 12:35

    I can confirm that is correct and working as designed (IMHO).

    When you check the box for "Relieve WIP as a percentage of completion", you are telling Sage to calculate the unit cost as total of all costs entered divided by the planned quantity. This is designed for manufacturing that issues all the costs up front, either using "Automatic" as your labor and material issue method, or if you are consuming all materials and labor in one of the first steps of the work ticket. This leaves WIP on the work ticket for the remaining un-completed items. When you do subsequent completions that WIP will be used to calculate the unit cost on those transactions using the same formula until you have completed all that are planned.  If you don't complete enough units to match the quantity planned, the that remaining WIP will go to Scrap account when you close the work ticket.

     

    If you manually entering your materials and labor and have only entered the materials and labor relative to the number of units that you are completing, you would want to uncheck the box for "Relieve WIP as a percentage of completion". With that setting turned off, Sage will calculate the unit cost as the total of all costs entered and divide that by the qty completed on that entry.

     

     

     

    Don't miss out on the 2024 Intermediate Crystal Reports for Sage 100 Online Training: View the details

     

     

     

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    260.399.8655 Direct

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     

    A black background with white text  Description automatically generated

     






  • 3.  RE: Production Management Costing

    Posted 06-13-2024 12:37

    David,


    Thank you very much.

     

     

    Thank you,

     

    Douglas Luchansky

    ACI Consulting

    p 714.282.0378

    d 714 694-4194

     

    douglas@ACIconsulting.com