Background: Manufacturing Period Activity

Use the Manufacturing Period Activity (MPA) program to print a cost report for manufacturing orders worked on during a period of time. See Road Map for work flow.

You define the reporting period by entering two dates for the Trans date Selection options. The program lists all manufacturing orders with transactions that occurred within that Trans date range. The period can be a day, week, month, quarter, or any period you want to track.

The Cur units and Cur cost columns report transactions that occurred within the Trans date range. The Tot units and Total cost columns report the total quantity and costs of the component from the order start date to its completion date or the report run date.

This topic has these subtopics:

Report Header	Labor Costs
Purchased Material Costs	Adjustments
Stock Material Costs	Sales Order Detail
Outside Service Costs	Report Totals

Report Header

The report header includes this data:

Branch
Manufacturing order number

Order 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 number followed by the description
Engineering Change Level
Start date
Date completed
Planner
Quantity ordered
Quantity completed

Purchased Material Costs

If you selected the Include purchased material detail? Program option, The report includes this information for components purchased for this manufacturing order:

Item description entered on the purchase order
PO: Purchase order number
Vendor name
Current units: Quantity received during the Trans date range
Current cost: Quantity received x PO unit cost
Total units: Total quantity received to date or order completion
Total cost: Total received units x PO unit cost (includes current cost)
Total current units, current cost, total units, and total cost

Stock Material Costs

If you selected the Include stock material detail? Program option, the report includes this information for bill of material components that have been picked:

Item number followed by its description
Current units: Quantity picked during the first picking within the Trans date range
Current cost: Quantity picked x Standard unit cost
Total units: Total quantity picked to date or order completion
Total cost: Total quantity picked x Standard unit cost (includes current cost)
Total current units, current cost, total units, and total cost

Outside Service Costs

If you selected the Include outside services detail? Program option, the report includes this information for purchased labor for an purchased service operation for this manufacturing order:

Parent item number
PO: Purchase order number
Vendor number
Current units: Quantity received during the Trans date range
Current cost: Quantity received x PO unit cost
Total units: Total quantity received to date or order completion
Total cost: Total quantity received x PO unit cost (includes current cost)
Total current units, current cost, total units, and total cost

Labor Costs

If you selected the Include employee labor detail? Program option, the report includes this information:

Employee number and name
Department
Current hours: Hours recorded in the Labor Entry (LLE) or imported with the Labor Import (LEI) program during the Trans date range
Current cost: (Reported hours x Direct labor rate) + (Reported hours x Direct labor rate x Overhead percent x .01)
Total hrs: Total hours recorded to date or order completion
Total cost: (Reported hours x Direct labor rate) + (Reported hours x Direct labor rate x Overhead percent x .01) (includes current cost)
Total current hours, current cost, total hours, and total cost

Adjustments

If you selected the Include adjustment detail? Program option, the report includes this information for cost adjustments entered for this manufacturing order:

Type of adjustment
Sequence number for this cost adjustment
Adjustment code selected in the Manufacturing Cost Adjustments (MCA) program followed by its description
Current adj: Adjustment amount entered during the Trans date range
Total adj: Total adjustment amount to date or order completion
Total current adjustment amount and total adjustment amount

Sales Order Detail

If you selected the Include sales detail? Program option, the report includes this information for a manufacturing order linked to a sales order for which a shipment has been created:

Sales invoice number
Customer number and name
Quantity shipped
Price: Unit selling price
Current invoiced: Quantity shipped x Unit selling price (invoiced within the Trans date range)
Total invoiced: Total quantity shipped x Unit selling price
Total current invoiced and total invoiced

Report Totals

Manufacturing costs: Stock material + Purchased material + Outside service + Labor + Adjustment costs
Sales invoices: Invoiced in current period, total invoiced amount
Net: Sales invoices - Mfg costs