Previous  Next          Contents  Index  Glossary  Library

Discrete Job Value Report - Average Costing

The Discrete Job Value Report - Average Costing assists you in analyzing your standard discrete jobs and non-standard asset jobs in project and non-project environments. You can submit the WIP Value Report before submitting this report to review total variances and charges for your jobs. Then, you can submit this report to analyze a summary of the transactions behind the charges and variances for each job.

This report includes summarized information on all cost transactions including material, resource, move and resource-based overheads, scraps, completions, and job close variances. The report also lists period-to-date and cumulative-to-date summary information, as well as complete job header information.

You can run this report for all project jobs, non-project jobs, or all jobs. You must specify a cost group when running this report for project jobs.

You can also list information for a group of jobs by specifying a job name range, an accounting class range, an assembly range, and/or a particular job status. Costs are grouped and subtotalled by transaction type. You can further restrict yourjob selection criteria by cost group.

This report provides you with all the information you need to reconcile your standard and non-standard asset jobs before closing them.

Attention: This report does not include expense non-standard jobs. Use the Expense Job Value Report to analyze expense non-standard jobs.

Report Submission

In the Submit Requests window, select Discrete Job Value Report in the Name field.

This report is automatically submitted when you close standard discrete and project jobs.

You can also submit this report using the Close Discrete Jobs window, which you navigate to using the Submit Request menu option, and selecting any of the following Report Types: Summary, Detail using planned start quantity, or Detail using actual completion quantity. See: Closing Discrete Jobs Using Submit Requests.

Report Parameters

Job Selection

Choose one of the following options:

Project Jobs Only If the Project References Enabled organization parameter is set, you can choose to report costs for only project jobs. If it the parameter is not set, you cannot access this field. See: Organization Parameters Window and Defining Project Information.
Choose this option to report costs for only project jobs. See: Project Jobs.
Non-Project Jobs Only Report costs for non-project standard discrete and non-standard asset jobs.
Project and Non-Project Jobs Report costs all standard discrete and non-standard asset jobs.

Cost Group

If your Job Selection option is Project Jobs only, select a cost group. The default is the Common cost group.

Sort By

Choose one of the following options:

Assembly, Job Sort by assembly and then by job within the assembly.
Class, Assembly, Job Sort by WIP accounting class, then by assembly within the WIP accounting class, and then by job within the assembly.
Job Sort by job.

Report Type

Choose one of the following options:

Detail using actual completion quantity Lists each job using the actual completion quantity of the job to calculate the material usage variance. A detail report includes the following: job header, material, resource, resource-based and move-based overhead costs, completion, scrap, and job close variance transactions. It also includes period-to-date and cumulative-to-date summary information.
If you push material to a job or backflush material at operation completion and have not completed the assemblies that consumed the material, your material usage variance is overstated. If you backflush material at assembly completion, or you have completed all of the assemblies, any material usage variance is accurate.
Use this option if you backflush your requirements at assembly completion, or if you have already completed most of your assemblies.
Detail using planned start quantity Lists each job using the planned start quantity of the job to calculate the material usage variance. A detail report includes the following: job header, material, resource, resource-based and move-based overhead costs, completion, scrap, and job close variance transactions. It also includes period-to-date and cumulative-to-date summary information.
If you have not transacted each of the items and resources required to produce your assemblies, your variances are understated (you have a favorable variance). You can use this option to analyze the total cost requirements for a job by cost element, based on your planned assembly completions.
Summary Lists each job and includes job header, period-to-date summary, and cumulative-to-date summary information. The system also lists summary elemental account values for each job.

Class Type

Choose one of the following options:

Asset non-standard Report costs for jobs with a WIP accounting class type of asset non-standard.
Standard discrete Report costs for jobs with a WIP accounting class type of standard discrete.

Include Bulk

Select Yes to indicate whether to include bulk-supplied material requirements. If you have already issued to a particular bulk requirement, the system lists the requirement, regardless of what you select here.

Include Supplier

Select Yes to indicate whether to include supplier-provided material requirements. If you have already issued to a particular supplier requirement, the system lists the requirement, regardless of what you select here.

Classes From/To

To restrict the report to a range of accounting classes, select a beginning and an ending accounting class.

Jobs From/To

To restrict the report to a range of jobs, select a beginning and an ending job. If your Job Selection option is Project Jobs Only, you can only select project jobs.

Status

Select a status. The available options are Unreleased, Released, Complete, Complete-No Charges, On Hold, Cancelled, Closed, Pending Close, and Failed Close jobs. See: Discrete Job Statuses.

Attention: If you run the Discrete Job Value Report for closed jobs and have changed your standard costs, the transaction summary information uses the latest standard cost and does not balance to the period or cumulative-to-date summaries.

Assemblies From/To

To restrict the report to a range of assemblies, select a beginning and an ending assembly.

Attention: For discrete jobs, any difference between the cumulative single level variances and the material usage or efficiency variance subtotals is from configuration or method variances. The cumulative-to-date summary compares the costs incurred for the job with the standard bill/routing requirements for completions out of the job. Therefore, the difference between the cumulative variances and the usage/efficiency variance is due to the difference between the standard bill/routing requirements and the work in process bill/routing requirements. To find the configuration variance, you should compare the material usage variance with the single level material variance. To find the methods variance, you should compare the efficiency variance with its corresponding single level variance. For example, you would compare the resource efficiency variance with the single level; resource and outside processing variance added together. You would add the resource-based and move-based overhead efficiency variances and compare it with the single level overhead variance.

See Also

Overview of Discrete Job Close

Overview of Discrete Manufacturing

Expense Job Value Report

Submitting a Request


         Previous  Next          Contents  Index  Glossary  Library