Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Why is it important to model / measure WIP (work in progress) in Manufacturing? Is this the only way to measure overhead costs?

Subscribe

Get notified when there's activity on this post

This question has been flagged
1 Reply
6529 Views
Avatar
Community Question

I have been told that we have to measure WIP to properly calculate the cost of our products, so we can properly come up with a selling price that makes enough money.

I am new to this concept and would appreciate an explanation of how WIP relates to Odoo.

1
Avatar
Discard
Avatar
Ray Carnes (ray)
Best Answer

Work In Progress represents the financial outlay (raw materials, labor, equipment/overhead costs) and “cost to date” of unfinished goods. 

The terms "work-in-progress" and "finished goods" differ from company to company. Finished goods for one company (sheet plywood from a lumber mill) may be considered a raw material for another company (a cabinet maker).

It is not necessary to measure anything you won’t use in your decision-making process.  So before investing in configuring Odoo to measure WIP, you should make sure you will regularly monitor WIP and make decisions after measuring it.

Finance – Odoo books all transactions having an impact on the General Ledger in real-time, including those in the warehouse and/or the production floor, so if your team discusses needing to accrue and report WIP, this is done automatically.

Project Management – If your company manufactures to order, WIP is a way of measuring how much inventory and labor and overhead (money) a particular order is “using”.  Any asset a company has should be used as effectively as possible. Cash flow is commonly affected by how long it takes an order to be completed (because when it is finished, you can ask your customer to pay for it).  If you work on too many orders at once, more of your capital might be tied up.  Since you can’t charge your customers until you finish, you might run out of money!

Profitability Margins – if you don’t measure WIP, you need to use other methods to understand the true cost of items you make.  You can allocate your non-administrative labor and overhead from time to time but measuring WIP can give you a more real-time measurement.  You don’t want to find out at the end of the month that everything you made (and probably already sold) lost you money.

Raw materials and direct labor are quite easy to understand.  The third component to WIP, overhead, can consist of things like:

  • indirect labor (such as security and cleaning personnel);

  • indirect materials (glues, tapes, repair parts, etc);

  • utilities (rent, water, gas, electricity, etc);

  • maintenance (machine repairs, tune ups, etc);

  • quality (inspections, rework, testing, etc);

  • downtime (machines or people waiting); and  

  • depreciation (on equipment and machines).

Overhead can sometimes be the largest "hidden" component of your product cost. 

In a Restaurant for example, the cost of making a meal can work out to look like:

Direct Costs – 50%

Overhead Costs – 35%

30% food

7% prep, managers, cleaning staff, greeters, etc.

20% kitchen cooking/wait staff.

3% menus, napkins, cutlery, cups, etc.

 

18% electricity, gas, rent

 

2% maintenance and quality

 

1% downtime

 

4% depreciation of furniture, technology, ovens, etc.

 

Without looking at all of these costs, you might think that with a food cost of 30% and a labor cost of 15% that the restaurant makes a profit margin / net profit of 50%.  Once you add in the overhead items the profit margin drops to 15%.  Quite a difference!

You don’t have to measure WIP to calculate a true profit margin.  You can, from time to time, review the overhead costs (like at the end of the month) and allocate them back into the cost of manufacturing based on product or quantity or other methods – so that your cost of goods (when you sell something) can be accurately estimated.

Note that due to the fact you might sell Inventory during the month, you need to evaluate if this is a good enough method for you. 

If you have a quicker turnaround for inventory, it might be better to set up manufacturing to manage WIP for you and to include overhead on your Bills of Materials, and even integrate Manufacturing with Timesheets. 

4
Avatar
Discard
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now