We’re producing steel products where we issue billets to a job and then roll each billet into a part. All quantities reported in pounds.
So, I’m using coparts in a couple of instances:
The finished part doesn’t pass inspection for the “prime” part number, is a lesser quality, but is still a valid part–but with a different part number. It should have the same cost as a prime part.
Trimmings and damaged product. Gets reported to a valid part number with a part description of “scrap.” It should have the same cost per pound as the prime part.
Total pounds reported = total pounds of billet weight.
The customization adds coparts as needed to the job, because part numbers can vary, based on quality downgrades.
A job might be set up to produce 100,000 pounds, but yield 85,000 pounds of prime product, 10,000 pounds of quality downgraded parts, and 5,000 pounds of trimmings and damaged parts. They should all report with the same part per pound.
I’ve tried leaving the labor and material cost factors at 1, changing them all to zero, etc. with varying results, but not adding up to the material cost of the billets plus labor and burden. Best results so far are at all zeroes, but no ringing of the bell.
Have you tried salvaging the material instead? At the end of the Job, receive ethe good to stock and then receive the salvage to stock? That might be an easier way to get the costs to line up.
To me, it sounds like you would want to use salvage as a person can determine what downgraded part it is.
You have a Job for Part # 12345.
When reporting quantity at the end, you claim all 100,000 pounds as good.
You Receive to Inventory 85,000 of 12345.
You Salvage to Inventory 7,500 of 12345-GradeB
You Salvage to Inventory 2,500 of 12345-GradeF
You Salvage to Inventory 5,000 of 12345-Scrap
This would then split the cost appropriately across all of the grades of material.
