WIP Cost Inquiry

This tab presents the general information for the Works order (WO) :

 The site

The WO number

 The tracking type (WO, product or miscellaneous)

 The adjustment pro rata

 The quantities (Planned, Actual, Rejects and remaining)

 The dates (Start, End, First tracking and last tracking)

It should be noted that all the tracking types load the WIPCOST and MFGWIP tables. In this latter, for the production tracking by WO, there will be a record by order. In the case of miscellaneous type tracking, there will be a record by work center and by period. Finally, for the product type tracking, there will be a record by routing and by period for the operations and a record by period for the material tracking.

This tab displays all the accumulations for each cost type :

 Material

 Labor

 Machine

 Subcontracting

 Overheads

 Totals

Balance : this line is entered when the WO is closed.

"Actual cost" column

The "Actual cost" column displays what has been consumed for each cost type. The material costs are obtained by adding the actual value of the issue movement transactions. For the Subcontract cost, it is based on what has been invoiced and for the Labor and Machine, it is based on what has been calculated from the valuation dimensions.

"Standard cost" column

The "Standard cost" column displays the detail of what has been entered to stock. This receipt to stock can be carried out at standard price, revised standard price or order price (provisional standard cost or provisional release cost) according to the valuation method. All these costs are detailed by material, labor, machine..... and this detail is then stored in the production reporting records in the WIPCOST table. Therefore in the "Standard cost" column the sum of all these movements can be found.

"Rejects" column

Once the production cost calculation is carried out, the value of the rejects that have been declared is displayed in this column.

The calculation of the cost of the rejects declared for an operation is based on the cost of the operation and the components that are attached to it.

For example:

Data for the example

Intermediate grid

The amount for component A1, which is not attached to an operation, is distributed across all of them.

The operation reject amount for operation 5 is 20: 5% * 400

The operation reject amount for operation 10 is 136: 16,6% * (400 + 300 - 20)

The A1 reject amount on operation 5 is 3.75: 5% * 75

The A1 reject amount on operation 10 is 24.38: 16,6% * (75+75 - 3,75)

The A2 reject amount on operation 5 is 12.5: 5% * 250

The A2 reject amount on operation 10 is 39.58: 16,6 * (250 - 12,5)

"Variance" column

The differences found between planned and actual are found in the "Variance" column.

The Totals (acctg) tab contains the same lines and columns as the Accumulations tab. It presents the values that have been transferred to accounting for each cost type.

This tab presents the costs that have been declared in production. There is a line for each released product (that has been the object of a tracking record). For each of these there is:

The completed quantity

 The actual amount as well as that transferred to accounting

 The actual overheads as well as those transferred to accounting

 The adjustment value

A right click on the line provides access to the "Product cost detail". This screen presents similar information but by detailing each tracking report. From this there is the possibility to zoom to the original tracking record or the accounting document that has been generated.

Product cost detail

This tab displays the costs from the material tracking. There is a line by component (that has been the object of a tracking record). For each of these there is:

The completed quantity

 The actual amount as well as that transferred to accounting

 The actual overheads as well as those transferred to accounting

A right click on the line provides access to the "Material cost detail". This screen presents similar information but by detailing each tracking report. From this there is the possibility to zoom to the original tracking record or the accounting document that has been generated.

Material cost detail

This tab presents the costs for the labor reporting. There is a line by operation (that has been the object of a tracking record). For each of them there is:

The completed quantity

 The actual set-up and operation times

 The actual amount as well as that transferred to accounting

 The actual overheads as well as those transferred to accounting

Aright click on the line provides access to the "Labor cost detail". This screen presents similar information but by detailing each tracking report. From this there is the possibility to zoom to the original tracking record or the accounting document that has been generated.

Labor cost detail

This tab presents the machine tracking costs. There is a line by operation (that has been the object of a tracking record). For each of them there is:

The completed quantity

 The actual set-up and operation times

 The actual amount as well as that transferred to accounting

 The actual overheads as well as those transferred to accounting

A right click on the line there provides access to the "Machine cost detail". This screen presents similar information but by detailing each tracking report. From this there is the possibility to zoom to the original tracking record or the accounting document that has been generated.

Machine cost detail

This tab presents the subcontract tracking costs. There is a line by operation (that has been the object of a tracking record). For each of them there is:

 The actual quantity and the reject quantity

 The actual set-up and operation times

 The actual amount as well as that transferred to accounting

 The actual overhead costs

A right click on the line provides access to the "Subcontract costs". This screen presents similar information but by detailing each tracking report. From this there is the possibility to zoom to the original tracking record or the accounting document that has been generated.

Subcontract cost detail

This tab displays a summary of the overhead costs by nature. For each of theses there will be:

 The material costs

 The labor costs

 The machine costs

 The subcontract costs