Hi there,
I have a problem finding the right stock valuation model.
The company uses the SKD (Semi knocked down) production model. It buys semi finished vehicules. Those semi finished vehicules are delivered in boxes. Each box includes all the parts of a given vehicule. All the parts in one box have the same VIN (Vehicle identification number). Each semi finished item may have a different purchasing cost. Meaning:
Description of the item:
Item = Vehicule A
BOM of vehicule A = Part P01, Part P02
Purchasing:
We buy three semi finished item A. Those semi fished items are delivered in boxes.
Box/Kit number 1: Price = 100
Item A to be produced has a VIN Number = VIN01
All the parts of the item have the same VIN Number
Part P01 has a VIN = VIN01
Part P02 has a VIN = VIN01
Box/Kit number 2: Price = 200
Item A to be produced has a VIN Number = VIN02
Part P01 has a VIN = VIN02
Part P02 has a VIN = VIN02
Box/Kit number 3: Price = 300
Item A to be produced has a VIN Number = VIN03
Part P01 has a VIN = VIN03
Part P02 has a VIN = VIN03
Production:
Cost of production must reflect the actual cost of purchasing (through the VIN number).
We want to produce Item A with an identification = VIN02.
Consumption cost in production (in AX it's issue offset account) must be : 200 (purchasing cost) + (additional production fees)
We don't want to use any of the FIFO PMP or LIFO valuation models.