Share via

Excel template/example for cost accounting in a production environment?

Anonymous
2012-04-26T16:43:44+00:00

Hi all, I’m reviewing/updating the costing accounting process in our production shop. Our operation does not really warrant the expense and complexity of MRP software.

I would like to create one spreadsheet (file) per part/assembly that would contain a printable “production traveler” in one worksheet  and a second, connected worksheet for calculating the costing at each workstation in the process. Specifically, capturing costs like materials, machine cost, employee time, perishable tooling, etc...

Are there resources for templates like this out there?

I certainly could flesh this out myself but considering all of the Excel guru’s out there, I’m hoping there is a template available that I could easily adapt for our purposes.(and perhaps learn a thing or two about how others are doing cost accounting)

Thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-12-22T13:09:30+00:00

    Good day James

    May I know if you found one? Could you share me please?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2016-01-01T14:37:02+00:00

    Using Excel is the least expensive way to track cost, my advice is to creat a format for your cost system outside your existing accounting software.  First do 2 prior years then the upcoming year.  I have installed the large systems and you need to know what's possible to achieve what you want.  Make the system user friendly, with this type of system it's easy to create a budget which will introduce other to the system.  You can easily install a cash flow off this system.  That's why you usually see ads for a manger of cost and budgets.  the system you want and described is process cost.  Process cost is a universal costing system.  First you need to review various system which best meets your needs.  Look at cost system packages, what your looking at is a chart of accounts directory.  With that you can organize what you want into a spread sheet.  You need to be able to print this so you can show others how to use this tool.  That's all it is, a tool.  I don't have time to go into lengthily examples.  With this tool you need to be able other to interact with the system to use it correctly.  The nice part is that your existing system never get altered or changed.  In the past The system I installed were integrated, very expensive, ouch, using excel it's fast and cheap.  You need a clear understanding of process costing and how these systems work.  The difficulties arise because your existing accounting system is not compatible with a process system, this is not difficult for someone that has installed process cost systems, a little more difficult if you haven't.  All your questions, concerns, and information you need can easily be acquired with a excel costing system you describe.  Is this installation easy?  No, there is a lot do to, it but won't cost you much.  Cost analysis are the geeks of accounting.  Stick with excel and changes will be easy.

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2012-04-26T21:50:21+00:00

    Kinda limited, focusing on financial statements.

    Is there anyplace else?

    Thanks

    0 comments
  4. Anonymous
    2012-04-26T16:54:06+00:00

    Hi

    Do a search on this website.

    http://office.microsoft.com/en-us/templates/CL101829555.aspx

    HTH

    Cimjet

    0 comments