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.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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.
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
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?
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).
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.
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.
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.
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.
Which prozess is important for you? Stock-moving? Quality? Material effort to quantity of production?
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.
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
1
Jan 23
|
918 | ||
|
1
Dec 18
|
2460 | ||
|
4
Apr 24
|
475 | ||
|
1
May 23
|
1201 | ||
|
1
Mar 22
|
2395 |