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

Operations
No.	Unit	Qty	Rej Q	Amount
5	One	20	1	400
10	Kg	3	0,5	300

 

Components
Name	Oper	Qty	Amount
A1	0	3	150
A2	5	4	250

Intermediate grid

Oper no.	%reject	Amount	Amnt A1	Amnt A2
5	5%	400,00 €	75 €	250,00 €
10	16,6%	300,00 €	75 €	- €

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

Oper no.	Oper rej amnt	Reject A1	Reject A2	Total
5	20,00 €	3,75 €	12,50 €	36,25 €
10	113,33 €	24,38 €	39,58 €	177,29 €

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.