I am trying to find a report to satisfy this user’s request:
“We don’t have a single cost sheet that we can print that includes material usage, average cost and total cost; Labor cost per process step (Hours and dollars) as well as some overhead allocation. We have to have something like this, how do we know how much the material cost and what to sell it for without this information?”
Any canned report that can help or does something have to be created?
Thanks!
There is the BOM COST report
Production management> Engineering > Reports.
BOM Cost is Good for looking at the material cost of a part, but it doesn’t roll any labor or overheads into the parts. Shows dollars for the parts, but not the units used.
you wont know the units used until a job is completed and material issued.
are you wanting to know the cost during the quoting phase or to know the actual cost of goods sold?
Sounds a lot like the BOM cost report under the Engineering > Reports menu.
Brad
The best thing you can do is create a job for a specific quantity or a quote for multiple quantities. The quote with multiple quantities will allow you to gauge the costs and selling margins.
Charlie
you can also use the costing workbench if the part is a standard cost part to view and post cost.
The only problem I have with using the costing workbench is that if you are looking at multiple quantities, it’s more work.
Now if quoting is an issue, then the workbench would be a good plan B.
Charlie
Production detail would give you the estimated costs, and actual costs (after the job is run).
Is there any documentation on using the costing workbench?
The user guide gives a basic walk-through. you can get that on EpicWeb.
Keep in mind. The workbench is calculating cost based on the Method of Manufacturing. so your resource groups will have to have a labor cost and the method will have to have hours to see the estimated labor cost for that part.