Display Manufacturing Order Costs

Use the Manufacturing Order Cost Inquiry (MJI) program to display costs incurred to date and projected costs to complete a manufacturing order. See Background and Road Map for more information.

Note
If you accessed this program from another program, skip step 1.

Enter the manufacturing order number or click the Lookup icon and use the standard lookup options to select the manufacturing order from a list.

The program displays these fields for the manufacturing order:

Field Name

Displays

Mfg order no

The manufacturing order number that you entered or selected followed by its status:

Complete	The order quantity has been received into on-hand inventory
Closed by user	User clicked Close order in the Manufacturing Maintenance (MIM) program
Closed by rcv	Received less than quantity ordered and clicked Close order? in the Receiver Maintenance (IRC) program
In picking	Some components have been picked
Open	No components have been picked
Partial	Some have been received into on-hand inventory
Printed	Shop paper has been printed or queued for printing
Pending close	Order has not been received to stock with the Receiving and Inspection (IRI) program

Parent item no

The parent item number ordered on this manufacturing order

Description

The description of the parent item

ECL

The Engineering Change Level for this manufacturing order

RRL

The Routing Revision Level for this manufacturing order

Costing mth

Costing method: Material costs to date are based on your setting for the Costing method for job cost option in the System Options Maintenance (XM) program (Manufacturing Options) for your manufacturing branch:

Act: Actual unit cost
Avg: Average unit cost
Std: Standard unit cost

Qty ordered

The quantity of this parent item to be manufactured for this order

Qty scrapped

The quantity that has been scrapped

Qty received

The quantity received into on-hand inventory

Qty rejected

The quantity of this item rejected during inspection

Qty stocked

The quantity received into inventory in the stocking unit of measure; this quantity can differ from the Qty received if some are awaiting inspection

Released

The date the manufacturing order was created

Due

The date this manufacturing order is due to be completed

Picked

The date that components were picked for this order

Completed

The date that this order was completed and received into on-hand inventory

The program displays these Costs-to-date for the manufacturing order:

Field Name

Displays

Material

Standard

Total standard material cost of components required to build the quantity ordered:

Sum of components (Quantity per assy + (Scrap % x 0.01)) x Standard unit cost

The system captured the quantity required when you released the order. If the Qty received differs from the Qty ordered, the system updates the quantity required.

Act, Ave, or Std to date

Cost to date: (Quantity picked x Unit cost) + Material stock adjustments + Special purchase adjustments

Your setting for the Costing method for job cost option in the System Options Maintenance (XM) program (Manufacturing Options) determines the unit cost:

Setting	Label	Unit cost
A	Avg	Average
B	Act	Actual
S	Std	Standard

Variance

Cost to date - Standard

% Std

(Cost to date / Standard) x 100

Outside srv

Standard	For a purchased service operation: Cost per piece x Quantity required
Cost to date	(PO unit cost x Quantity received) + Outside service adjustments
Variance	Cost to date - Standard
% Std	(Cost to date / Standard) x 100

Labor

Standard

Total standard cost to build the quantity ordered depends on the operation type:

Type	Setups	Calculation
Regular	1	(Hours per piece x Quantity ordered x Direct labor rate) + (Setup time x Setup labor rate)
Regular	Multiple	Quantity ordered / Standard lot size = Number of setups rounded up to the next integer (Hours per piece x Quantity ordered x Direct labor rate) + (Number of setups x Setup time x Setup labor rate)
Unattended	1	Setup time x Setup labor rate
Unattended	Multiple	Quantity ordered / Standard lot size = Number of setups rounded up to the next integer Number of setups x Setup time x Setup labor rate
Batch		Quantity ordered / Pieces per batch = Number of batches rounded up to the next integer ((Hours per batch / Pieces per batch) x Good pieces) + ((Good pieces / Pieces per batch) x Setup time) (Number of batches x Hours per batch x Direct labor rate) + (Number of batches x Setup time x Setup labor rate)

Cost to date

Total labor cost for completed operations + Labor adjustments

If you enter pieces completed with the WIP Movement (WIPM) program for a regular operation: (Good pieces + Scrap pieces) x (Hours per piece x Direct labor rate)

For a batch operation: ((Hours per batch / Pieces per batch) x (Good pieces x Direct labor rate)

If you enter reported hours with the Labor Entry (LLE) program or import them with the Labor Import (LEI) program for labor codes D (Direct), I (Indirect), O (Other), R (Rework), and U (Setup): (Regular hours + Overtime hours) x Direct labor rate

The system updates labor when you complete operations. See Background.

Variance

Cost to date - Standard

% Std

(Cost to date / Standard) x 100

Labor ovhd

Standard	Total labor overhead cost to build the quantity ordered: (Labor cost x Overhead percentage
Cost to date	If you entered pieces completed with the WIP Movement (WIPM) program: (Good pieces + Scrap pieces) x (Hours per piece or batch x Direct labor rate) + (Number of setups x Setup time x Setup labor rate) x (Total overhead rate for work center x .01) + Labor overhead adjustments If you entered actual hours with the Labor Entry (LLE) program or imported them with the Labor Import (LEI) program: (Regular hours + Overtime hours x Direct labor rate) x (Total overhead rate for work center x .01) + Labor overhead adjustments The system updates labor overhead when you complete operations. See Background.
Variance	Cost to date - Standard
% Std	(Cost to date / Standard) x 100

Machine ovhd

Standard	For an unattended operation: ((Setup hours x Machine rate) / Standard lot size) + Hours per piece x Machine rate) + ((Setup hours x Machine rate) / Standard lot size) + (Hours per piece x Machine rate) x Overhead percentage) Machine labor rate is from the Machine lbr cd field in the Work Center Maintenance (WCM) program. If this field is blank, the program uses the Setup labor cd field for the unattended operation in Routing Maintenance (RTM) program.
Cost to date	For an unattended operation: (Setup hours x Machine rate) / Standard lot size) + Hours per piece x Machine rate) + ((Setup hours x Machine rate) / Standard lot size) + (Hours per piece x Machine rate) x Overhead percentage) + Machine overhead adjustments The system updates machine overhead when you complete an unattended operation.
Variance	Machine overhead - Burden applied
% Std	(Cost to date / Standard) x 100

Adjustments

Cost to date

Type X (Miscellaneous) entered in the Manufacturing Cost Adjustments (MCA) program

Note
Other types of adjustments are added to the appropriate costs:

Adjustment type	Added to
M (Material stock) P (Special purchase)	Material
S (Outside service)	Outside srv
L (Labor)	Labor
O (Labor overhead)	Labor ovhd
U (Machine overhead)	Machine Ovhd

Click Adjustment to display a list of all adjustments.

Variance

Actual adjustments

Totals

Standard	Total standard cost to build the quantity ordered: Material + Outside services + Labor + Labor overhead + Machine overhead
Act, Std, or Ave to date	Total cost to date to build the quantity completed: Material + Outside services + Labor + Labor overhead + Machine overhead + Adjustments
Variance	Cost to date - Standard
% Std	(Cost to date / Standard) x 100

For open orders, the program displays these Projected costs for the completion of the manufacturing order:

Field Name

Displays

Material

To complete

The cost of the materials to be picked for this manufacturing order; if Costing method for job costs option is:

If	The program calculates
A	Qty to pick x Average unit cost
B	Qty to pick x Actual unit cost
S	Qty to pick x Standard unit cost

Total

Total material cost incurred to date plus the cost of the quantity that remains to be picked; if Costing method for job costs option is:

If	The program calculates
A	Average cost to date + Cost to complete
B	Actual cost to date + Cost to complete
S	Standard cost to date + Cost to complete

Standard

Standard material cost of components required to build the quantity ordered: Qty ordered x Standard unit cost

Variance

Total - Standard

% Std

(Total / Standard) x 100

Outside srv

To complete	Remaining outside service costs to be incurred to complete the manufacturing order: Standard - Cost to date
Total	Total actual outside service cost to date plus the remaining standard outside service cost required to complete: Standard - Cost to date
Standard	Standard outside service cost required to build the quantity ordered
Variance	Total - Standard
% Std	(Total / Standard) x 100

Labor

To complete	Remaining labor costs to be incurred to complete the manufacturing order: Standard - Cost to date
Total	Total labor cost to date plus the remaining standard labor cost required to complete: Cost to date + To complete
Standard	Standard labor cost to build the quantity ordered based on the operation sequences
Variance	Total - Standard
% Std	(Total / Standard) x 100

Ovhd

To complete	Remaining labor and machine overhead to be incurred to complete the manufacturing order: (Standard labor overhead + Standard machine overhead) - (Labor overhead to date + Machine overhead to date)
Total	Standard labor overhead + Standard machine overhead
Standard	Standard labor overhead + Standard machine overhead
Variance	Total - Standard
% Std	(Total / Standard) x 100

Totals

To complete	Material + Outside srv + Labor + Ovhd
Total	Actual cost to date plus remaining cost to complete: Cost to date + To complete
Standard	Total standard cost to make the quantity ordered
Variance	Total - Standard
% Std	(Total / Standard) x 100

Choose the appropriate options:

To	Do This
Review your options for this program	Click Prog opts. See Set Options for Reports and Inquiries.
Display notes about this item	Click Notes.
Display material costs for components	Click Materials. See Display Component Costs. Click OK to return to this program.
Display purchases for this manufacturing order	Click Matl/OS. See Display Purchases for a Manufacturing Order. Click OK to return to this program.
Display work in process	Click WIP status. See Display Work in Process Information. Click OK to return to this program.
Display cost adjustments	Click Adjustment. See Display Manufacturing Cost Adjustments. Click OK to return to this program.
Display labor costs	Click Labor. See Display WIP Labor Costs. Click OK to return to this program.
Display pickings for this order	Click Picks. See Display Picking for a Manufacturing Order. Click OK to return to this program.
Display receivers for this order	Click Receipts. See Display Receivers for Orders. Click OK to return to this program.
Display the supply orders for this manufacturing order	Click Supply. See Display the Supply Order. Click OK to return to this program.
Display the linked demand orders	Click Demand. See Display the Demand Order. Click OK to return to this program.
Change data in custom fields your company uses	Click User field. See Enter Data in User or Shadow File Fields. Note This button displays only if you have set up user fields for this program in the User Fields Maintenance (XMO) program.
Print the display	Click Print. See Print an Inquiry.
Display serial numbers assigned to this parent item	Click Pre-assign. See Display Pre-Assigned Control Numbers. Click OK to return to this program. This button displays only if the Pre-assigned ctrl no? field is selected in the parent item's record in the Enterprise Item Maintenance (IM) program.
Specify a different manufacturing order	Click OK.
Exit the program	Click Exit.