Open Forum

Expand all | Collapse all

Standard costing by location

  • 1.  Standard costing by location

    Posted Aug 06, 2019 11:25 AM
    We have a small basic manufacturing operation that is ideal for standard costing and not conducive to other costing options. We also ship our manufactured product to multiple locations to be sold out of. Is there a way to set a different standard cost for each location?

    IE: Location 1 - manufacturing plant has a standard cost of $100/unit
    Location 2 - distribution point, incurs trucking costs of $50/unit to get here, total landed cost is then $150

    I'd prefer to keep the item numbers the same if possible.

    Any help is appreciated.

    Thank you,

    ------------------------------
    Darren Mitchell
    Wayfinder Corp
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Standard costing by location

    Posted Aug 06, 2019 11:38 AM
    Darren

    Have you thought about using "Stock keeping Units" to separate the inventory and apply different costs?

    It's driven by locations:



    Good Luck!


    ------------------------------
    Alfredo Zelaya
    Sr. Systems Analyst
    Megadyne Americas LLC
    Fairfield NJ
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Standard costing by location

    Posted Aug 06, 2019 07:54 PM
    Hi Darren,

    You can only have 1 Standard Cost per Item.  You can increase the standard cost by adding an Indirect Cost to the Item Card but it's still just 1 Standard Cost per Item, especially since they don't want to make new Item Numbers.  This would require a modification from your VAR.



    ------------------------------
    Matthew Cullen
    Technology Management Concepts
    El Segundo, CA 90245
    mcullen@tmc-la.com
    ------------------------------

    Conference-BCNAVUG_200x200


  • 4.  RE: Standard costing by location

    GOLD CONTRIBUTOR
    Posted Aug 07, 2019 08:27 AM
    SKUs will not help here. You can still only have one standard cost per item. Having a standard cost per item per location is a very large customization.

    In your case it sounds like this would be fine though. Location 1 is the standard for $100, and it sounds like location 2 is also $100, but with $50 of freight added. Item Charge the freight for Location 2.The $50 becomes a variance.

    ------------------------------
    Kyle Hardin
    NAV Developer
    ArcherPoint Inc.
    Duluth GA
    ------------------------------

    Conference-BCNAVUG_200x200


  • 5.  RE: Standard costing by location

    Posted Aug 07, 2019 12:57 PM
    I might have done something wrong, but by using the stock-keeping units I was able to generate two different standard costs for the same item, based on different locations. I will make sure to provide an update if I come across any issues in the future.

    Thank you all for the suggestions and help!

    ------------------------------
    Darren Mitchell
    Wayfinder Corp
    ------------------------------

    Conference-BCNAVUG_200x200


  • 6.  RE: Standard costing by location

    TOP CONTRIBUTOR
    Posted Aug 07, 2019 01:16 PM
    I always thought that it was possible using stockkeeping units.

    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    ------------------------------------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

    Twitter: @RosenbergL
    LinkedIn: https://www.linkedin.com/in/rosenbergl
    ------------------------------------------------------------------------

    NAVUG/BCUG Summit (navugsummit.com)
    Orlando, FL - October 15-18, 2019
    ------------------------------

    Conference-BCNAVUG_200x200


  • 7.  RE: Standard costing by location

    Posted Aug 07, 2019 03:23 PM
    Darren

    That's the expected result.

    ------------------------------
    Alfredo Zelaya
    Sr. Systems Analyst
    Megadyne Americas LLC
    Fairfield NJ
    ------------------------------

    Conference-BCNAVUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role