Profit and Productivity Analysis

The purpose of the Profit and Productivity Analysis processing is to collect specific order and purchasing statistics and to produce reports with the resulting information. These reports are then used to update productivity and profitability analysis spreadsheets.

Statistics are collected as part of End-of-Month processing and/or can be collected on demand from the Profit and Productivity Analysis menu. The reports are run on demand from the Product and Productivity Analysis menu. Data is collected and stored on a fiscal period basis and includes the current year and up to four of the previous years.

Initial preparation needed before data collection and reporting

Before the system can collect order and purchasing statistics, you need to perform some file maintenance. The following summary reviews the files and fields that affect profit and productivity data collection.

Vision Configuration (Vision GUI)

The Order/PO Status Collection check box on the Vision Configuration tab in Vision GUI indicates whether the data for order and purchasing statistics should be collected. If you select this check box, then order and purchasing statistics are collected during End-of-Month processing; you can generate reports showing these statistics in Vision Back Office. If you do not select this check box, then order and purchasing statistics are not collected and the Metrics Profit and Productivity Analysis programs do not operate.

For instructions on how to set this check box, refer to Specify in Vision GUI whether order and purchasing stats should be collected.

Business Type Maintenance (Vision Back Office)

Order statistics collection is based on business type. Use Business Type Maintenance in Vision Back Office to set up and maintain business types. Each business type has a three-digit business type code used to identify business segments within your company.

To access Business Type Maintenance

  1. On the main menu in Vision Back Office, select File Maintenance.

  2. Select Company Related Files.

  3. Select Code Maintenance Menu.

  4. Select Business Type Maintenance.

Salesperson Maintenance (Vision Back Office)

The Slsperson Type field of the Salesperson Maintenance in Vision Back Office is used by the End-of-Month statistics collection and reporting processes to determine how to classify an account. The valid classifications are inside, outside, house, and overhead.

To access Salesperson Maintenance

  1. On the main menu in Vision Back Office, select File Maintenance.

  2. Select Customer Related Files.

  3. Select Salesperson/Commission Menu.

  4. Select Salesperson Maintenance.

Ship Route/Driver Maintenance (Vision Back Office)

The Inside Cartage Flag and Business Type fields of the Ship Route/Driver Maintenance in Vision Back Office are related to the collection of Order and Purchasing Statistics.

To access Ship Route/Driver Maintenance

  1. On the main menu in Vision Back Office, select File Maintenance.

  2. Select Customer Related Files.

  3. Select Ship Route/Driver Maintenance.

Product Class maintenance (Vision GUI)

The Business Type field of the Product Class maintenance in the Vision GUI is used to determine into which business category the system will accumulate statistics data for orders delivered by an outside carrier.

To access the Product Class maintenance

  1. On the Vision Configuration tab, click the System Configuration button. The System Configuration screen appears.

  2. Click Product Information folder to expand its contents.

  3. Click the Product Class subfolder.

For more information, refer to Field and button descriptions on the Product Class screen.

Buyer Maintenance (Vision Back Office)

A buyer is a person responsible for a product's or part's inventory levels for one or more selected companies within a district. Buyer Maintenance in Vision Back Office lets you set up buyer codes and their associated names.

All Vendor Master records require a buyer code. Vendor Detail records can contain this code, and, if present, the Vendor Detail Buyer Code overrides the Vendor Master Buyer Code.

To access Buyer Maintenance

  1. On the main menu in Vision Back Office, select File Maintenance.

  2. Select Buyer Maintenance.

— or —

  1. On the main menu in Vision Back Office, select File Maintenance.

  2. Select Accounts Payable And General Ledger Files.

  3. Select Buyer Maintenance.

Vendor Master Maintenance (Vision Back Office)

The Buyer field of the Vendor Master Maintenance in Vision Back Office is used to associate the appropriate buyer with a vendor. This Buyer field is a required field; it is used to determine for which purchasing buyer statistics are to be collected.

If a buyer has been selected for a vendor in Vendor Detail Maintenance, it takes precedence over the buyer selected for the vendor in Vendor Master Maintenance.

To access Vendor Master Maintenance

  1. On the main menu in Vision Back Office,, select File Maintenance.

  2. Select Vendor Master Maintenance.

— or —

  1. On the main menu in Vision Back Office, select File Maintenance.

  2. Select Accounts Payable And General Ledger Files.

  3. Select Vendor Maintenance.

Vendor Detail Maintenance (Vision Back Office)

The Buyer field of the Vendor Detail Maintenance in Vision Back Office is used to associate the appropriate buyer with a vendor. This field is not a required field; it is used to determine for which purchasing buyer statistics are to be collected.

If a buyer has been selected for a vendor in Vendor Detail Maintenance, it takes precedence over the buyer selected for the vendor in Vendor Master Maintenance.

To access Vendor Detail Maintenance

  1. On the main menu in Vision Back Office, select File Maintenance.

  2. Select Vendor Detail Maintenance.

— or —

  1. On the main menu in Vision Back Office, select File Maintenance.

  2. Select Accounts Payable And General Ledger Files.

  3. Select Vendor Detail Maintenance.

G/L Product Class Maintenance (Vision Back Office)

For the Business Metrics Report to be generated, each product class must be assigned a business. (For more information about this report, refer to Business Metrics Report.) Sales of products in a class without an associated business are not reflected in the report. The Business field of the G/L Product Class Maintenance in Vision Back Office is where you associate a business with a product class.

To access G/L Product Class Maintenance

  1. On the main menu in Vision Back Office, select File Maintenance.

  2. Select G/L Product Class Maintenance.

— or —

  1. On the main menu in Vision Back Office, select File Maintenance.

  2. Select Accounts Payable And General Ledger Files.

  3. Select Integrated G/L Menu.

  4. Select G/L Product Class Maintenance.