Hi all, i have a scenario here which i need some advise. the scenario is as below;
NAV5, Native DB.
To make thing simple, lets assume the FG uses 1 unit of each RM. As i understand from the manufacturing costing, it uses roll-up cost for the finished goods.
-
FG = RM1, RM2, RM3. where
RM1 cost = $1
RM2 cost = $1
RM3 cost = $1. -
2 work center where cost for each WC as below
WC1 = $0.50
WC2 = $0.20
WC3 = $1.00 -
As for the scenario of producing 100 unit. i need to keep track of the rejected quantity and cost for each WC. As i go through the WC1, i have a reject of 10% of the 100 unit. Which means, 90 unit(good) and 10 unit(rejects). i have calculated my cost from the WC1 to be $45(good) and ($5(reject).
-
when it goes to the WC2, i will only process the (Good), but not the (Reject). so the scenario as follow for WC2 will be 85unit(Good), 5unit(bad). my cost from this WC2 will be $17(Good) and $1(Reject).
-
When i complete the whole process. i completed only 85unit to be (Good) and 15 unit to be (Rejects). my cost from WC3 will be $85(Good) and $15(Reject).
As i understand. The consumption of the RM double entries will be CR Stock(RM), DR WIP.
And my WC cost will be CR Direct Cost/Indirect Cost/Overhead Cost, DR WIP.
The output journal will be DR Stock(FG), CR. WIP to absorb the cost from the RM and WC.
I need the system to absorb all the Reject Costs to a different location. so i created another Inv Posting Group of Reject Location with a different Inv. GL A/C.
for FG(Good) Dr. Stock(FG), Cr. WIP
for FG(reject) Dr. Stock(Reject), Cr. WIP
but for the FG(Good) the cost will be RM= (85+85+85) = 255
WC = (45 + 17 + 85) = 147
FG(Good) = 255+147 = 402
FG(Reject) = RM(15+15+15) + WC(5+1+15) = 45+21 = 66
so my cost for each unit will be (402+66)/100 = $4.68/unit(this is how Navision derrive with the cost per unit)
what if i need to derrive as FG(Good) per unit = 402/85 = $4.7294/unit
FG(Reject) per unit = 66/15 = $4.40/unit
is there any way to do it? help from anyone will be much appreciated. thanks in advance!