Manufacturing Order Costs Report
The Manufacturing Order Costs report displays all costs associated with manufacturing orders over a specified time period, with details for each cost including its type, production stage, and linked accounting account, alongside a comparison between the expected and actual values. This report is used to track production costs, review variances between planned and actual costs, and analyze the performance of different production operations.
Steps to View the Report
- Click on the “Reports” menu.
- Click on “Manufacturing Reports“.
- From the page, select “Manufacturing Order Costs“.
- You can apply a number of filters before viewing the report:
- Manufacturing Order: Select one or more manufacturing orders to view their costs only. You can search by name or code. If no order is selected, the system will display the report for all manufacturing orders.
- Bill of Materials: Filter results to show orders linked to a specific bill of materials. You can search by name or code. If none is selected, the system will display all lists.
- Products: Filter results to show costs for a specific product only. You can search by name or code. If no product is selected, the system will display the report for all products.
- Account: Filter costs by their linked accounting account. If no account is selected, the system will display all accounts.
- Date From / To: Specify the time period for which you want to view costs.
- Type: Filter costs by type. Available types are:
- Received Materials: Raw materials issued to the manufacturing order.
- Scrap Items: Materials that were damaged or lost during the production process.
- Returned Materia: Materials returned to the warehouse from the manufacturing order.
- Direct Expense: Costs directly linked to the production process.
- Indirect Expense: Costs not directly linked to the production line.
- Manufacturing Operations: Costs of various production stages and operations.
- Production Stage: Filter results to show costs for a specific production stage only. If none is selected, the system will display all stages.
- Group By: Choose how to group the report data. Available options are: Manufacturing Order, Production Stage, Account, Products, Bill of Materials, Type.
- Once you’ve adjusted the filters, click “View Report” to refresh the results, or click “Clear Filter” to return to the default settings.
- You can switch between the “Summary” view to show totals per group only, or the “Details” view to show each cost entry individually.
- You can print the report using “Print” or export it using “Export” to: CSV, Excel, PDF.
Report Columns
The table displays costs grouped according to the option selected in “Group By.” When the Details view is selected, each cost entry appears individually within its group. The columns are as follows:
- Code: The manufacturing order number associated with this cost.
- Type: The cost type, such as direct costs, received materials, or manufacturing operations.
- Description: Additional details or notes associated with this cost.
- Production Stage: The production stage this cost was linked to.
- Account: The accounting account this cost was recorded under.
- Expected Value: The planned or estimated cost for this item.
- Actual Value: The actual cost recorded in the system.
A subtotal row appears at the end of each group summarizing the total expected and actual values for that group. A grand total row also appears at the bottom of the table, summing all costs across all groups for the entire period.