02-09-2010, 07:45 AM
is that sound judgment to just interpolate the difference?
I can see where youre going with what you said. however its not something I could easily do. let me show you an example
PROD1 - uses A, B, C
PROD2 - uses A, D, E
PROD3 - uses A, C, D
"A" used in PROD1 will not cost the same as PROD2 or PROD3. You would think it would be coded differently but they arent. "A" used for either products will be costed differently according to their product group. So the only way to apply the new cost is to see each individual product lines. I could use a qualifier in excel to group the product with the material but the data is not in spreadsheet form.
I can see where youre going with what you said. however its not something I could easily do. let me show you an example
PROD1 - uses A, B, C
PROD2 - uses A, D, E
PROD3 - uses A, C, D
"A" used in PROD1 will not cost the same as PROD2 or PROD3. You would think it would be coded differently but they arent. "A" used for either products will be costed differently according to their product group. So the only way to apply the new cost is to see each individual product lines. I could use a qualifier in excel to group the product with the material but the data is not in spreadsheet form.