How can we transfer the waste/rejection cost to the Sales order?
We are working in a make-to-order environment. (A Mill industry that manufactures BOPP films)
Scenario: There are 4 different Sales orders and for each of them we have a production orders as shown below:
SlsOrd Slordqty Prdord Prdordqty FSG wasteqty
1000000010 1000kg 200001 1000kg 1000kg 0 kg
1000000020 1500kg 200002 1500kg 1500kg 0 kg
1000000030 2000kg 200003 2000kg 1900kg 100kg
1000000040 1500kg 200004 1500kg 1350kg 150kg
Now the question is that how we can divide this 250 kg waste cost on above mentioned 4 different sales order in month end propotionally? We can not move the wastematerial cost on productionorder neither can we confirm the waste material cost via activity type on production order because we have to move this waste material to Waste stock on Zero value.
Solution required: Some how I have to move the waste material to waste stock on zero value with the waste cost still being charged on the sales orders.