ManEx KB

1. Job Costing (OPTIONAL Module)

1.1. Prerequisites for Job Costing

Prerequisites for Running a New Job Costing:

ManEx’s standard module configuration allows most users to accomplish their daily tasks. For those users wanting to get more from ManEx by leveraging the total solutions, this is one of the optional modules available for purchase. The Job Costing Module is used to record the details of the costs associated with a particular job or work order. To place an order or to learn more about this specific module or any of the other optional modules please contact us at http://manex.com\contactus.aspx

After activation, "Job Costing" access for each user must be setup in the ManEx System Security module. Users with “Supervisor Rights” will automatically have access.

*Customer*	A customer must exist in the Customer Information module.
Product number	The part number must exist for a product or part in the Inventory Control module.
*BOM*	The Bill of Materials components must be entered in the Inventory Control module.
*Work Order*	The Work Order must exist in the Work Order Mgmt module.
*Work Center and Activities*	Work Center and Activities must be setup for the product in the Work Order Traveler Setup module.
*Standard Times*	The standard times for each Work Center in the Product’s routing must be set up in Work Order Traveler Setup module.
*Hourly Charge Rate*	Hourly Charge Rate for each Work Center must be set up in Production Work Centers & Activities module.
*Sales Order*	A Sales Order must exist in the Sales Order module.
*Kitting, Allocation*	The order must be kitted in the Kitting & Shortage Management module.
*Time Card and Time &* *Attendance*	The worker must log in and out of each job (Work Order).
*Purchase Order*	The Work Order must be referenced in the Purchase Order if the user wishes to use the Purchase Order allocated to the specific Work Order method of costing for the actual.

1.2. Introduction for Job Costing

The Job Costing Module is used to record the details of the costs associated with a particular job or work order. The actual material(actual can be standard, Purchase Order allocated to the specific Work Order or the Weighted Purchase Cost of the last 5 Purchase Orders) and labor costs are compared with the standard or “budgeted” costs and provision is made to include miscellaneous charges. The user may also compare the standard (budget 0 to items purchased specifically for the Work Order (please see the Purchasing Management procedures) or to the weighted average of the last 5 purchases. A variance is calculated and also the variance %.

Once a Work Order is created, the user may preview the “budget” information for both material and labor.

Time card information and kitting forward into Job Costing. As each component of the Work Order is completed, the Job Costing Module captures the required information. Please refer to the Time Card and Time & Attendance Management procedures.

1.3. Fields & Definitions for Job Costing

1.3.1. Job Cost Summary

Job Cost Field Definitions

Work Order	The number assigned to the selected Work Order.
Customer	The name of the customer for which this Work Order applies.
Build Qty	The number of units which must be completed for selected Work Order.
Balance Qty	The number of units which still must be completed
% Complete	The percentage of units already completed.
WO Kit Status	The status of the Work Order kit.
Sales Order	The number of the Sales Order to which this Work Order applies.
Product #/Rev	The number of the make part to be assembled and the revision number pertaining to the part number.
Class	The classification of the product to be assembled.
Type	The type with the classification of the product to be assembled.
Description	The description of the part to be assembled.
WO Status	The status of the Work Order “Job Status”

Budgeted

Material Calculation of the BOM Qty information, Std cost, Setup Scrap & Scrap %

Labor Calculation based on the Hourly Rate (applied to each Work Center within the System Setup), Setup & Run Times (entered within the WO Traveler Setup)

Actual - The actual is taken from the first time the parts are issued to the kit. The cost is gathered from inventory issue table

Material
Calculation based on the actual parts issued to the Kit (Over-issues, Shortages, etc . . .) and the parts Standard Cost (Std Cost is setup within the Inventory Control) The cost is gathered from inventory issue table. The table saves the standard when the issue record is created.

Labor
Calculation based on the standard Hourly Rate and total time recorded (Reg and OT) per each user through the Time & Attendance/Time Card Modules.

Other Other Costs added to the Work Order.

Variance

Material
Calculated difference between the Budgeted and Actual Material

Labor Calculated difference between the Budgeted and Actual Labor

Var%

Material Variance amount divided by the Budgeted Material amount

Labor Variance amount divided by the Budgeted Labor amount

Selling Price

Standard Standard pricing information pulled from the Standard Price List Information module

SO Price Actual Sales Order Total entered in the SO Module (Order qty x Price each

Variance Actual Sales Order Total entered in the SO Module (Order qty x Price each

Var% Variance amount divided by the Standard

Actual Costed By:

Standard Cost Is based on the standard cost of the components at the time of issue.

PO for the Current WO In order to get the “real” costs of the components, the user must place the Purchase Orders for the components and pre-allocate them to the specific work order.

Weight Cost - Last 5 Is based on the weighted cost of the components at the time of issue.

Graph show:

$ Amount Select this radio to display the graph by the total $$ amount

% (Tot Budget-100%) Select this radio to display the graph by percentage

1.3.2. Other Costs

Other Cost Field Description

Work Order	The number assigned to the selected Work Order.
Cost Description	This selection is setup within the Quote Defaults module.
Amount	Total Amount of Other Costs
Save Date	When record is saved the date will defaultin
Save By	When record is saved the initials of the user will default in

1.4. How To ...... for Job Costing

1.4.1. Find a Job Cost Record

Enter Production/Job Costing Module

The following screen will appear:

Depress the Find button.The following screen will appear:

Select the desired Search by method by clicking on the applicable radial.

The graphics for that Work Order will appear:

Select between Standard Cost, PO for the Current WO or Weighted Cost – Last 5. The actual material cost display will change.

Job Cost Material Detail

To view the Job Cost Material Detail, highlight the green graph bar display and click. The following detail will become available: If you would like to see the formula's used to calculate the budget information see Article 2159.

Job Cost Labor Detail

To view the Job Cost Labor Detail, highlight the green graph bar display and click.The following detail will become available:

Percentage Radial

To see percentages rather than dollars display, select the Percentage radial in the Graph View section. The following view will become available:

Other Cost

To enter an Other Actual Cost, depress the Other Cost tab. The following will open:

To add a cost, highlight the Cost Description Field. Select from among the following:

This selection is setup within the Quote Defaults module.

Enter in the amount.

To add another Cost, depress the "down arrow" key and the program will add a new record automatically.

Once all changes and adds are complete, depress the Save record icon to save changes, or depress the Abandon changes icon to abandon changes.

1.4.2. Formula's used to Calculate Information

IF Exclude Scrap and Setup Scrap

QtyReqTotal= WoBldQty x BomQty

ELSE

QtyReqTotal = WOBldQty x BomQty+(WoBldQty*BomQty*BomScrap)/100

ENDIF

Ext_cost_total=QtyReqTotal X Stdcost

IF Exclude Scrap and Setup Scrap

SetupScrap_cost = 0

ELSE

SetupScrap_cost = Setupscrap/StdBldQty x Stdcost

ENDIF

Total Budget cost = SUM of Ext_cost_total + (SUM of SetupScrap_cost x WoBldQty)

How is the Actual Labor time calcualated within the Job Costing Module - It is actually controlled from the Prod WC/Activity Setup screen. Here you assign a hourly rate to each work center. Then within the T&A log the users can select the Work order and therefore the WC from the routing. The Job Costing will then take the hours entered * WC hourly rate. The T&A Setup Types do not have an option to assign any value to it – so this does not dictate any Value within the Job costing module.

1.5. Reports - Job Costing

To obtain Job Costing Reports, depress the Reports icon.

The following reports are available in Job Costing Module.

Highlight the report of interest, and depress the Option tab:

Labor Cost Review Rpt

The following screen will appear: Select the desired radial option and required selections, then enter in the Closed After Date.

Radial Selection Definitions: Customer List: Will display a list of customers in the Customer Select box. Highlight the customer of interest and depress the > button. If you want to select all the customers depress the >>. The report will display all the work orders that have "Kit Closed Date" empty or kit was closed after the date entered by the user. Kit Rel After: WIll display all the work orders that had "Kit Released" after the date entered by the user. Closed WO After: Will display all the work orders that had "Kit Closed" after the date entered by the user. WO List: Will display a list of Work Orders to select from. Highlight the Work Order(s) of interest and depress the > button. If you want to select all the Work Orders depress the >>. The the report will display the data only for the Work Orders selected that have "KIt Closed Date" empty or kit was closed after the date entered by the user.

Note: That the system will list all Work Order numbers. If the user selects a "Cancelled" work order from the listing the system will then display a "No Records Match Criteria Entered" message. This is because the reports are setup not to pull cancelled work orders forward.

Depress the Ok button. The following report will be displayed.

There is also a Labor Cost Summary Review Rpt available:

Material Cost Review Rpt

The following screen will appear: Select the desired radial option and required selections, then enter in the Closed After Date.

Radial Selection Definitions: Customer List: Will display a list of customers in the Customer Select box. Highlight the customer of interest and depress the > button. If you want to select all the customers depress the >>. The report will display all the work orders that have "Kit Closed Date" empty or kit was closed after the date entered by the user. Kit Rel After: WIll display all the work orders that had "Kit Released" after the date entered by the user. Closed WO After: Will display all the work orders that had "Kit Closed" after the date entered by the user. WO List: Will display a list of Work Orders to select from. Highlight the Work Order(s) of interest and depress the > button. If you want to select all the Work Orders depress the >>. The the report will display the data only for the Work Orders selected that have "KIt Closed Date" empty or kit was closed after the date entered by the user.

Note: That the system will list all Work Order numbers. If the user selects a "Cancelled" work order from the listing the system will then display a "No Records Match Criteria Entered" message. This is because the reports are setup not to pull cancelled work orders forward.

Depress the Ok button. The following report will be displayed.

There is also a Material Cost Summary Review Rpt available:

Miscellaneous Cost Detail Review Rpt

Depress the Ok button. The following report will be displayed.

There is also a Miscellaneous Cost Summary Review Rpt available:

Performance Detail Review Rpt

Depress the Ok button. The following report will be displayed.

There is also a Performance Summary Review Rpt available:

1.6. ManEx Minutes (JC)