Currently, Periodic Costing uses the end results of accounting—which includes allocations for the production cost centers— to prorate for the labor and burden to absorb. Since PC uses the results of allocation, you manually collect the allocation numbers to send to Periodic Costing.

You can also upload WO component or operation adjustments to Periodic Costing using the method described in this section.

This information can be defined by department or by work center/machine using a specific rate or by defining the total amount to be applied to run times and/or setup times. For each cost calculation period, the work center rates on labor or burden can be calculated based on the amount of work assigned to a particular work center divided by the total hours of operation for that work center.

There should be an itemized account and sub-account for each type of cost—setup, labor, burden, and burden machine— and there may be more than one account or no account for each type of cost. The system checks the cost type against the language detail. Cost type can be:

Based on the product cost center setup, the system verifies all GL transactions of these cost centers, with the exception of the WO postings. You can generate a report to review before confirming that data be uploaded to Periodic Costing. The system uploads all the costs per cost type (LBR, BDN, and so on) and cost center data to Periodic Costing. The value related to add currencies (other than base currency) is converted based on the exchange rate of the period end date automatically.

To upload the data, you build a spreadsheet, then attach XML schema to the spreadsheet to upload the data to Periodic Costing. You find the rate or total for each cost center, then upload the actuals for labor and burden for each individual work center.

Once you upload the labor, burden, and other expenses data; Periodic Costing takes the totals from the accounts, locates the departments associated with centers and accounts, then via the transactions, determines the actual hours and costs. Totals, though, come from GL integration and the setup. From the totals, Periodic Costing then determines the details of the allocation.

You can use the example shown in Sample Spreadsheet to build a spreadsheet. Once you do, you collect the data for the spreadsheet, then attach an XML file with schema to the spreadsheet.

The following code depicts the schema in an XML file that you attach to the spreadsheet. Sample Spreadsheet shows the spreadsheet. The spreadsheet contains the actual data that you save in Microsoft Excel as a XML type document. This file is then the file that is uploaded.

Schema code to attach to the spreadsheet:

You can maintain the work center rate data in batch using the Import/Export File option on PC Work Center Rate Maintenance (30.5.3.1). The rate data is exported to an XML file that the system builds. You can modify the XML file in Microsoft Excel and import it back into QAD Enterprise Edition to finish the maintenance at one time for mass amounts of data.

In the exported XML file, you can edit and delete the existing records and add records. All the changes are not validated until you import the file into QAD Enterprise Edition.

To edit the exported data:

Use the following procedure to import work center rates.