Manufacturing Orders: Cost Extension
by CLuedoo https://www.cluedoo.com/shop/lic-clu-set-ppo-0015-manufacturing-orders-cost-extension-6302$ 99.68
ODOO'S FUNCTION
Odoo's standard Manufacturing (MRP) module doesn't provide detailed cost breakdowns in the Stock Valuation under the Manufacturing field.
Odoo's limitation makes it challenging for businesses to get a comprehensive understanding of their manufacturing expenses within the stock valuation, leading to less accurate cost control and profitability analysis.
CLUEDOO'S FUNCTION
CLuedoo extends Odoo's functionality by adding fields for Component Cost, Operation Cost, Subcontract Cost, and Unit Cost directly into the Stock Valuation under the Manufacturing field.
CLudedoo's enhancement provides a detailed and clear view of all the expenses related to manufacturing, helping businesses accurately calculate their production costs. By integrating these detailed costs into the valuation layer, CLuedoo's feature ensures that companies can manage their manufacturing processes more efficiently, with better insights into cost allocation, and make more informed decisions for optimizing profitability.
|
1. Go to Manufacturing > Operations > Manufacturing Order > Create a New one > Fill in Product field . |
|
|
2. Go to Work Orders tab and fill it if there are any > Confirm . |
|
|
3. Go to Manufacturing Orders list view > The system provides the valuation of:
|
|
|
4. Material Cost & Operation Cost on Bill of Materials
The Material Cost and Operation Cost fields are displayed directly on the Bill of Materials.
The calculation is as below. |
|
|
Material Cost is the total cost of all components defined in the BoM, calculated as:
Material Cost = Σ (Component Unit Cost × Component Quantity)
Example:
Therefore: Material Cost = (11 × 2) + (10 × 3) = $52
|
|
|
Operation Cost = Operation Cost on BOM Overview
Note that Operation Cost is derived from the cost configuration of each Work Center, including Cost per Work Center/Employee, Default Duration, and Employee Capacity defined in Operations. |
|
|
5. Standard Material Cost & Standard Operation Cost on Manufacturing Order List View New columns are added to the MO list view: Standard Material Cost Type, Standard Material Cost, and Standard Operation Cost.
where
Standard Operation Cost on MO = (Operation Cost on BOM / Qty on BOM) x Qty on MO |
|
|
There are 3 calculation methods available for Standard Material Cost Types
To select a method: open the MO list view → select the MO → choose the desired
Standard Material Cost Type
.
|
|
Standard Material Cost
= (Material Cost on BOM / Qty on BOM) x Qty on MO
Example (Ceramics Cup, MO Qty = 3)
Standard Material Cost = 52 / 1 x 3 = 156
|
|
|
b. Standard Material Cost on BOM Quantity Standard Material Cost = (∑BOM Line Qty/BOM Finished Qty x Component Unit Cost) x MO Finished Qty
Example (Ceramics Cup, BoM qty = 2, MO Qty = 3)
Standard Material Cost
= (2/2x11 + 3/2x10) x 3 = 78
Note that: If the BoM Qty is changed, Standard Material Cost is recomputed and updated immediately. |
|
|
c. Standard Material Cost on BOM Price
Standard Material Cost
= Σ (MOL Consumed Qty × Product Price)
For example,
Standard Material Cost on MO for Ceramics Cup = 8 x11 + 12x10 = 208
Note that: - If component quantities are changed on the MO → finish the MO → Standard Material Cost is recalculated correctly. - If the product cost is changed manually on the product form or recomputed from the BoM → Standard Material Cost is updated immediately on the MO list view. |
|
|
6. A Server Action is available to refresh the Standard Material Cost and Standard Operation Cost on the MO list view whenever there are changes in calculation of Operation Cost & Material Cost on BOM |
|
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Manufacturing (mrp)
• Inventory (stock) • Discuss (mail) • Invoicing (account) |
| Lines of code | 447 |
| Technical Name |
fal_mrp_manufacturing_cost |
| License | OPL-1 |
| Website | https://www.cluedoo.com/shop/lic-clu-set-ppo-0015-manufacturing-orders-cost-extension-6302 |
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module