Dear All,
I have the following scenario:
My client is into Juice Manufacturing. I have 5L Juice produced and lying in stock. Due to lack of sale, I have to unpack this 5L juice into 300 ML & 200 ML bottles
- Each FG is measured in PCs such as 5L, 500ML, 330ML, 200ML bottles. Each bottle is a sperate SKU.
- Bulk Juice production is an intermediate product. Meaning, from Raw Fruit, it produces bulk Juice (Sub Formula) and fills into multi-size bottled (Main Formula).
- When I refill/repack into 330ML, 200ML (It could be any based on the demand in the shop floor), I should do the following:
- Unpack the 5L into a loose/Bulk Juice (The Cost of 5L Bottle & 5L Juice would have loaded onto this product and should be reallocated back). This bottle will be scrapped and the associated cost should be posted to a scrap account. So, cost of bulk juice should be remain on the intermediate product.
- Now, repacking/refilling of this 5L Bulk Juice - This can go into 330ML of 10 bottles and remaining into 200ML of 5 bottles (This is depends on the requirement).
- Cost of 330 ML Bottle should have the cost of juice+ 330ML Bottle
- Cost of 200 ML Bottle should have the cost of juice+ 200ML Bottle
Net Effect of this scenario:
- Cost of 5L Bottle - Scrap Account (Please note that, the Cost of this 5L bottle should also deduct from Bulk juice cost)
- Production Cost of 330ML (Equivalent Juice + 330ML Bottle Cost)
- Production Cost of 200ML (Equivalent Juice + 200ML Bottle Cost)
I cannot use a standard formula for this as 5L Bulk juice goes into multiple products. Other option would be to make 3 different steps:
- Reverse the 5L production into a bulk juice. Still I have a challenge to allocate scrap account. I do not want user to enter the cost manually.
- Create a new Batch order for 330 ML production and report the production.
- Create a new Batch order for 200 ML production and report the production.
Is there a better way to handle this?
