Skip to Content
Menu
This question has been flagged
4 Replies
4284 Views

Hello,

I am setting up Odoo v12 CE for pressing and bottling seed oil. Different seeds produce different amount of oil, also many times the same seed same amount produces different end result. How can I manufacture oils?

Thank you for your help.

Avatar
Discard
Best Answer

Here is a way you could set up Odoo that might work for you:

Since Odoo can't convert between Weight and Volume, you will need to create your own Unit of Measure category that contains the Weight measurements that you use for the seeds and the Volume measurements that you use for the oil.  In this example, I have used seed lb(s) and oil fluid oz(s) within a new Category called Pressing.

Create a Bill of Materials using the average measure of seeds to produce the average measure of oil and enter what you actually consume and produce during each Manufacturing Order.



Here, on average we get 475 oz from 30 lbs of Kernels.


Manufacturing Orders can be created in Odoo for 475oz, or any higher amount, including other units (like oil gallons) as long as you enter them and the conversion factors. 


For an example Manufacturing Order to press 1 Gallon:



You simply adjust the actual produced amount in the Manufacturing Order:


In this example, the press resulted in 120 oz from 8 lbs of kernels.  You can that after we changed the 128 to 120, Odoo readjusted the expected quantity of kernels needed to match the Bill of Materials but it will still let us enter what we actually used when we click PRODUCE:



Inventory Moves for this Manufacturing Order show the expected 7.58 seed lb(s) plus the extra 0.42 seed lbs (for a total of 8 seed lbs) Consumed and the 120 fluid oil oz(s) produced:



Cost Analysis (products only, because we are not using Work Orders for machine or worker time) for this Manufacturing Order shows a unit cost of 9 cents per fluid oil ounce (based on a cost of $1.35 per seed pound of kernels) :



This approach gives you:

  • a single Bill of Materials for Pressed Oil

  • a way to generate and/or enter Manufacturing Orders for any initial estimated quantity

  • a place to record actual production

  • a place to record actual consumption

  • correct Inventory Moves

  • correct Pricing

Avatar
Discard
Author

Thank you so much for this detailed example. Could you help me with creating the UoM, I cannot add two UoM to the same Category.

"cannot" - what happens when you try? Do you get an error message?

Author

Yes, I create the UoM Category Pressing: Type of Measure I leave empty, because if I put weight or volume it says: You can have only one category per measurement type.

Then I attach it to Seed Measure which works, but if I create Oil Measure and I want to attach it, it says: UoM category Pressing should only have one reference unit of measure.

You can create a new Category if you need to. One of the measurements will be the reference - the other will need to be bigger or smaller than the reference (so Odoo can convert between the two).

Author

Thank you, now I understand, I tried it out also just using Unit measure for both and doing the same procedure as you described and it worked out.

Author

Where do you have the Cost Analysis, I use the Compute cost from BoM plugin which only calculates the cost from the BoM, not the manufacturing order, which would be more significant, since you would want to know exactly how much your product values.

Best Answer

So not any improvement in V12 on this.  Work orders will not do you any good.  You will have to note down consumption and produced qty outside of ODOO, and then create or modify the manufacturing order according to what has been processed.  Then confirm that. Your stock will be updated.

Avatar
Discard
Author

Thank you, I was thinking about the same to always change the BoM and then I will have the correct price. I was hoping that there is something implemented that could solve this problem.

Thank you, I appreciate the help.

I would recommend to have the BOM as an average of what you expect. That will give the MRP some figures to what you need. But you can change the qty in the manufacturing order - before you confirm the process.

For the manufacturing price, you might consider to use FIFO pricing. You set it om the Product categories. The value of your stock and the cost, will be your latest manufatcuring cost.

Best Answer

Hope this video will help you: https://www.youtube.com/watch?v=TXl7ET2dggE

Avatar
Discard
Best Answer

Which prozess is important for you? Stock-moving? Quality? Material effort to quantity of production?

Avatar
Discard
Author

I think it would be the stock moving, since I want to have the right amount in the stock. From how much I used to how much I produced.

Related Posts Replies Views Activity
1
Jan 23
918
1
Dec 18
2460
4
Apr 24
475
1
May 23
1201
1
Mar 22
2395