Generating a Cost Report
Learn how to generate and interpret a Cost Report
Vânia Lourenço avatar
Written by Vânia Lourenço
Updated over a week ago

A report in Autodesk Prodsmart is, essentially, a list of a certain type of element defined by the user within a given time period of your choice.

It is very simple to generate a report. In the ‘Main Dashboard’ press “Reports” in the side menu.

A ‘Cost Report’ will list all Cost Records made during a given time span. You can also apply filters to narrow down the information, and some advanced options as detailed below.

Options

Before applying filters you can already customize parts of your report to include a lot of useful information:

Include Machine Downtime: the system will add a line in the report with all details for machine downtimes logged during this time span. The downtime will appear like in the image below:

Include consumed products: the report will show all the consumed products in the end of the report, like in the image below, with all details for quantities and total costs, separated by lots.

‘Time period’: refers to the time interval of the Sales Orders to be presented. You can either define it, by clicking on the clock symbol, in a basic (selecting start and end date) or relative way (for example, ‘Today’, or ‘Last 7 days’). If you choose a relative time period, you can also choose to schedule the report - learn more about it here. The time interval cannot exceed one month.

By default, in this panel, the start date is always the beginning of the present month and the end date is always today.

Filters and Grouping

Report Filters: you can filter by several elements that compose a production record for only a single product or by a single worker for example.

Report Grouping: when selected, a summary line will display on the bottom of the report, with the information grouped by the define entity.

Generating and reading the report

Generate Report

Finally, after choosing the report’s options that you want and their respective time interval press “Generate Report” to see your report.

The report itself can be sorted by clicking on the arrows in the header.

Reading the report

The report integrates different colors. Each one of them can be added to a line with a specific meaning. Below you can check the legend for each one of them.

A ‘Possible time or quantity error’ might mean that quantity for that record was 0, or that the record took less than 60 seconds.

You can also export it to either pdf or excel by pressing the export buttons at the top.

Regarding the time values given, here is what they mean:

  • Start time: Date - Time that a specific operation started.

  • End time: Date - Time that a specific operation ended.

  • Worker: Designated worker or group of workers that performed the operation.

  • Machine: Machine where the operation occurred.

  • Operation: Product Code.Operation Code .

  • Prod.Ord.: Code of Production order.

  • Productivity: The speed at which each work center works as a percentage of the optimal productivity for which it is designed to: Formula: Productivity = (Parts Produced * Optimal Cycle Time) / Produced Time.

  • QTY: Amount produced on the production record.

  • Unit of Measurement: Unit of measurement of the final product.

  • Cost - Work: The cost of work is the sum of the workers cost per hour with the machines cost per hour multiplied by the time consumed during production.

  • Cost - W/Ideal time: Calculated as Cost - Work cost but considering productivity was 100%.

  • Cost - Deviation: Difference between ‘Cost - W/Ideal time’ and ‘Cost - Work’.

  • Avg Pieces/Hour - Est.: Average number of finished products produced per hour, considering a productivity of 100%.

  • Avg Pieces/Hour - Actual.: Average number of finished products produced per hour.

If after reading this article you still have some doubts, feel free to reach out to us through our Live-chat feature, or directly to your CSM.

Did this answer your question?