Sample Software Package Analysis

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS PACKAGE ANALYSIS - SAMPLE Business Area

Functional Area Sales & Distribution Contract Maintenance

Req # *** Client Name *** Requirement

GAP Yes/No Yes

1.1.1

Create contracts with associated production locations.

Sales & Distribution Contract Maintenance

1.1.2

Create contracts that define pricing for all order/invoice components (product, freight, etc.)

Sales & Distribution Contract Maintenance

1.1.3

Sales & Distribution Contract Maintenance Sales & Distribution Contract Maintenance Sales & Distribution Contract Maintenance

1.1.3 cont'd 1.1.4

Contracts must support the following components for Yes determining product price: market price rate (order date, make date, or ship date), margin, freight, brokerage, allowance, miscellaneous premiums. Price is determined by calculating the deviation of date effective market price. Price is guaranteed for a definable number of days. Ability to print separate line items for price components.

1.1.5

Assign a price book to a contract.

Yes

Sales & Distribution Contract Maintenance Sales & Distribution Contract Maintenance Sales & Distribution Contract Maintenance Sales & Distribution Contract Maintenance Sales & Distribution Contract Maintenance

1.1.6

Maintain price books for *** Client Name *** and outside vendor products. Support multiple price books by product, by customer/product, and by geographic area. Assign effective dates to prices.

Yes

1.1.10

Support deviation from standard prices listed in weekly price tables. Maintain multiple price lists (450+). Yes

Sales & Distribution Contract Maintenance

1.1.11

Retain price book data for 5 years.

Sales & Distribution Contract Maintenance Sales & Distribution Contract Maintenance

1.1.12

Ability to categorize customers.

1.1.13

Specify broker association with a contract if the customer was introduced by a broker.

Sales & Distribution Contract Maintenance

1.1.14

Track broker commissions (paid on cents per pound or percentage by product type).

Sales & Distribution Contract Maintenance Sales & Distribution Contract Maintenance

1.1.15

Maintain product market prices and price histories.

Yes

1.1.16

Allow pricing to be as per contract or spot price.

Yes

1.1.7 1.1.8 1.1.9

Yes

Yes Yes

Yes

MDE21SM1.xls

SW Package Module/Function Datalogix - Sales Order Processing & Datalogix Sales > Sales Order Datalogix - Inventory, Costing & Sales

How Functionality is to be Satisfied Production locations are set up as customers. Contracts become Sales Orders Custom Workaround Required Set up separate codes for components. Products are Items in GEMMS( Inventory > Items ) which have established costs ( Costing>Cost Details or Inv.>Items>Edit>Costing ). Freight are ancillary charges attached to a Sales Order. Custom Workaround Required

Datalogix - Sales > Pricing Need pricing module. GEMMS can support a pricing schedule for items being shipped. This can be done for specific customers. However, to include this level of detail may require customized programming. Custom Workaround Required Datalogix - Sales > Sales Order Datalogix - Sales Order Processing, & Datalogix Inventory > Items Oracle - Vendor Master & Datalogix - Sales > Pricing Oracle - Vendor Master & Datalogix - Sales > Pricing Oracle - Vendor Master & Datalogix - Sales > Pricing Datalogix - Sales > Sales Order Datalogix - Sales Order Processing & Datalogix Sales > Pricing Datalogix - Sales Order Processing & Datalogix Sales > Pricing Datalogix - Sales > Customer Class Code Datalogix - Sales > Sales Rep & Commission Codes

Sales Order Entry ( Sales ) will support many line items for a give order. Set up separate codes / pricing tables. Items pricing can be associated with one or all customers ( Sales > Customers ) Pricing Engine Customization Establish *** Client Name *** pricing book table. Pricing Engine Customization Establish separate code for each. Pricing Engine Customization Data entered will be date and time stamped. Pricing Engine Customization Price can be overridden at time of entry. Set up item pricing by customer. Pricing Engine Customization Based on system capability and archiving policies. Pricing Engine customization

Customer can be assigned Customer Class Codes ( Sales > Customer Class Codes ) and reported against such. Set up Sales Rep ( Sales > Sales Rep ) & Commission Codes ( Sales Commission Codes ) and report against it by Sales Order only Datalogix - Sales > Sales Set up Sales Rep ( Sales > Sales Rep ) & Commission Codes Rep & Commission Codes ( Sales Commission Codes ) and report against it by Sales Order only Datalogix - Sales > Pricing Set up pricing tables ( Sales > Pricing ) Pricing Engine Customization Datalogix - Sales > Pricing Set up pricing tables ( Sales > Pricing ) Pricing Engine Customization

Page 1

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Sales & Distribution Contract Maintenance

1.1.17

Sales & Distribution Contract Maintenance Sales & Distribution Contract Maintenance

1.1.18

Sales & Distribution Contract Maintenance Sales & Distribution Contract Maintenance Sales & Distribution Contract Maintenance Sales & Distribution Contract Maintenance Sales & Distribution Contract Maintenance

1.1.20

Sales & Distribution Contract Maintenance

1.1.25

Sales & Distribution Contract Maintenance

1.1.26

Sales & Distribution Contract Maintenance Sales & Distribution Contract Maintenance Sales & Distribution Contract Maintenance

1.1.27

On-line visibility to finished product costs.

1.1.28

Volume discounts for "even days" deliveries (based upon the smallest daily volume received for the week). Gross margin/product profitability analysis by product and by customer.

Sales & Distribution Contract Maintenance

1.1.30

Calculate customer rebates based on volume of sales for all their branches and cut checks for these rebates.

Sales & Distribution Contract Maintenance Sales & Distribution Contract Maintenance

1.1.31

Track distributed versus undistributed rebates.

Yes

1.1.32

Support maintenance of 150 contracts and 1000 deals/schedules.

Yes

Sales & Distribution Sales Order

1.2.1

Support sales to customers in multiple customer masters (customer, member, non-member, employee).

Datalogix - Sales Order Processing

Sales & Distribution Sales Order

1.2.2

Support 3600 customers.

Datalogix - Sales Order Processing

Sales & Distribution Sales Order

1.2.3

Scan in customer orders.

Yes

Sales & Distribution Sales Order

1.2.4

Receive customer orders using EDI.

Yes

1.1.19

1.1.21 1.1.22 1.1.23 1.1.24

1.1.29

Multiple product pricing options based upon date of order, Yes date of make, date of ship, and date of delivery (all dates are plus or minus a given number of days). Price fluid milk from multiple point of sale options (point of Yes contract, point of order, point of delivery). Support for additional pricing premiums (moisture content, Yes grade, etc.). Base moisture premium calculation on brackets or the USDA Yes formula. Choose 1 of 2 moisture premium pricing methods per deal per customer. Define/update customer specific invoicing requirements by Yes contract. Change prices by product and price list and automatically Yes update the corresponding contracts. Assign promotional allowances, built-in finance charges, and other costs related to international marketing efforts to the product price list. Identify and list international marketing related costs, individually or as a combined amount, apart from the domestic product price. Maintain foreign country requirements for invoicing and bill of lading.

Datalogix - Sales > Pricing Set up pricing tables ( Sales > Pricing ) Pricing Engine Customization Datalogix - Sales > Pricing Set up pricing tables ( Sales > Pricing ) Pricing Engine Customization Datalogix - Sales > Charge Set up additional codes and include as ancillary charges to a Class sales order ( Sales > Charge Class ). Pricing Engine Customization Pricing Engine Customization Datalogix - Sale > Charge Class Datalogix - Sales Order Processing

Datalogix - Sales > Charge Set up additional codes and include as ancillary charges to a Class sales order( Sales > Charge Class ). Datalogix - Sales > Charge Set up additional codes and include as ancillary charges to a Class sales order( Sales > Charge Class ). Datalogix - Customer Master & Sales > Sales Order > Edit > Additional Information Datalogix - Costing > Cost Detail Datalogix - Sales > Pricing

Customer Master set up & Sales Order ( Edit > Additional information ).

Oracle Data Browser

Using Data Browser query Sales Price ( Sales > Order Entry ) and / or product cost ( Costing ) and manipulate data as desired. Using Data Browser query Sales History for a particular customer ( Shipments ) manipulate data as desired and issue a credit memo. Needs custom applications.

Oracle Data Browser

MDE21SM1.xls

Set up additional codes and include as ancillary charges to a sales order( Sales > Charge Class ). Set up as part of the customer master. Custom Workaround Required Pricing Engine Customization

Datalogix - Sales > Sales Order

Costing Module fills this need. Set up pricing tables ( Sales > Pricing )

Contracts can be setup as Sales Order. GEMMS allows unlimited sales orders. Limited by system hardware capacity. Custom Workaround Required Customer Master is set up in Oracle and is the same for all users in the system. Customers, members, non - member, and employees are set up as customer. Customer class / customer trade class. Oracle will support unlimited customers. Limited by disk space availability. Other application will be designated to fill . Clarification needed on requirement. ( API ) Other application will be designated to fill. ( API ) STERLING.

Page 2

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Sales & Distribution Sales Order

1.2.5

On-line order entry, maintenance, and inquiry capabilities.

Sales & Distribution Sales Order

1.2.6

Automated validation of customer account number to prevent order creation for customers on credit hold.

Datalogix - Sales> Sales Order Datalogix - Sales Order Processing

Sales & Distribution Sales Order

1.2.7

Ability to override credit holds on customer orders with proper authorization.

Datalogix - Sales Order Processing

Sales & Distribution Sales Order

1.2.8

On-line access to a common product file for all regions.

Sales & Distribution Sales Order

1.2.9

Support 11,000 products.

Sales & Distribution Sales Order

1.2.10

Sales & Distribution Sales Order

1.2.11

Provide a list of the items a customer usually orders to speed up the data entry process (order history). Support order entry in U.S. and metric volumes.

Sales & Distribution Sales Order

1.2.12

Support order quantities in tanker loads (when exact weight is unknown at time of order), gallons, and pounds.

Sales & Distribution Sales Order

1.2.13

Track and report quantities using multiple units of measure (gallons, pounds, etc.) throughout the entire manufacturing process. Support conversion between these units.

Sales & Distribution Sales Order

1.2.14

Sales & Distribution Sales Order

1.2.15

Allow entry of product age and requested moisture content when entering an order. Apply user defined charges by product and customer.

Sales & Distribution Sales Order

1.2.16

Sales & Distribution Sales Order

1.2.17

Sales & Distribution Sales Order

1.2.18

Datalogix - Inventory > Items Datalogix -Inventory > Items Datalogix - Sales > Sales Items can be customer specific and can be identified by Order > Edit > Line Items customer generic products. Datalogix - Inventory > Items can be in various units of measure ( UOM ). Units of Measure Datalogix - Inventory / Dual Order can call for a given quantity and a different quantity Unit of Measure can be shipped. i.e. when shipping a tank wagon and you don't know the quantity being shipped until the tanker is weighed. Datalogix - Inventory / Dual Items can have various units of measure and GEMMS supports conversions which are item specific. i.e. convert Unit of Measure from gallons to pounds, using units of measure conversion as well as convert gallons to liters. Datalogix - Sales > Sales System allows for visibility of test results for determining if Order & Quality inventory meets customer requirements. Datalogix - Sales > Sales Ancillary charges can be allocated to an order. Pre - defined Order codes. Datalogix - Customer & Customer number can be up to 32 characters long, same for Item Master item number. Datalogix - Sales > Sales GEMMS allows for unlimited capabilities. Order Datalogix - Sales Order Information is part of the customer master. Access available Processing based on security.

Sales & Distribution Sales Order

1.2.19

Sales & Distribution Sales Order

1.2.20

On-line access to inventory status (scheduled, on-order, onhand, committed, available, analytical test, etc.).

Datalogix - Inventory > Item Inquiry

Sales & Distribution Sales Order

1.2.21

Commit inventory at the time of order creation.

Sales & Distribution Sales Order

1.2.22

Immediate on-line visibility to new orders.

Datalogix - Sales > Sales Order Datalogix - Sales > Sales Order

Sales & Distribution Sales Order

1.2.23

Automated calculation of order cancellation penalties based upon the proximity of the cancellation date to the requested shipment date.

Support 8 digit customer numbers and 10 digit product numbers. Support entry of 4800 sales orders a month. On-line access to customer data including customer sales terms (contract, commitment levels, or spot orders), A/R, sales history, and credit. On-line access to manufacture information (date, vat, etc.) by product, region, plant, or warehouse.

Datalogix - Production > Batch

Yes

MDE21SM1.xls

GEMMS strength. Sales Order Entry allows online visibility after the order is saved. GEMMS provided, will not allow processing of sales order if customer has a credit hold ( Customer Master Credit Limit and Sales > Order Hold Mnt ). GEMMS provided through security management allowing someone to override HOLD (Customer Master Credit Limit and Sales > Order Hold Mnt). Products are viewed as ITEMS and GEMMS supports on common Item Master. Unlimited based on hardware limitations.

Access to inventory based on security. Set up by region, warehouse, item. Date, vat, etc. can be incorporated into the date code. Inventory Summary allows visibility of items in inventory to include quantity ( on hand, available ), status & locations as well as committed and pending production. GEMMS supports item allocation both manually and automatically. GEMMS allow for on line visibility of open orders. Possible work around by setting up a query in Data Browser which will list Order Canceled, Date Order Requested Date and the data can be manipulated to calculate the penalty, however it will not be done automatically.

Page 3

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Sales & Distribution Sales Order

1.2.24

Automated notification to sales personnel of customers who have placed orders larger than their regular orders.

Yes

Sales & Distribution Sales Order

1.2.25

Automated notification to sales personnel of customers who have not yet placed their regular orders.

Yes

Sales & Distribution Sales Order

1.2.26

Sales force performance tracking including sales volumes and commissions earned.

Sales & Distribution Sales Order

1.2.27

On-line visibility to sales by marketing area.

Sales & Distribution Sales Order

1.2.28

Sales & Distribution Sales Order

1.2.29

Sales statistics and financial forecasting including sales trend information, visibility to 5 weeks of sales (4 previous and 1 projected), and a rolling 12 month summary. On-line access to customer profitability based upon production costs or market value.

Sales & Distribution Sales Order

1.2.30

On-line access to estimates of sales by customer and type of product.

Sales & Distribution Sales Order Sales & Distribution Sales Order

1.2.31 1.2.32

Sales & Distribution Sales Order

1.2.33

Retain 2 years of on-line order data history. Perform multiple tasks concurrently on a single workstation without the loss of previously entered work. Automated feed of orders to production scheduling.

Sales & Distribution Order Fulfillment Sales & Distribution Order Fulfillment

1.3.1

Sales & Distribution Order Fulfillment

1.3.3

Automated order hold (credit holds, etc.) processing which prevents pick list generation.

Sales & Distribution Order Fulfillment Sales & Distribution Order Fulfillment Sales & Distribution Order Fulfillment Sales & Distribution Order Fulfillment

1.3.4

Automated truck load pick list sequencing.

Yes

1.3.5

Automated dock/truck load sequencing.

Yes

1.3.6

On-line entry of items and volumes actually picked.

1.3.7

Real-time maintenance to inventory balances based upon order selection.

Sales & Distribution Order Fulfillment Sales & Distribution Order Fulfillment Sales & Distribution Order Fulfillment

1.3.8

Automated freight costing.

1.3.9

Allow for multiple manifest and bill of lading formats based Yes upon customer requirements. Visibility to raw milk and finished goods test results and specifications.

1.3.2

1.3.10

Datalogix - Sales > Sales Rep, Sales > Commission Codes & Oracle Data Browser Datalogix - Sales & Oracle Data Browser Datalogix - Sales & Oracle Data Browser

Possible work around by setting up a query in Data Browser which will list history and flagged those orders which exceed established parameters. Possible work around by setting up a query in Data Browser which will list history and flagged those orders which exceed established parameters. Set up Sales Rep. and Sales Rep Commission and query through Data Browser the necessary information to the established parameters. Sales History Detail Report & query through Data Browser the necessary information to the established parameters. Sales History Detail Report & query through Data Browser the necessary information to the established parameters.

Datalogix - Sales, Costing & Oracle Data Browser

Calculate order fulfillment dates based upon lead times from the bill of materials and production scheduling systems. Automated pick list generation based upon information from the order entry and route scheduling systems.

Yes

MDE21SM1.xls

Query through Data Browser the necessary information to the established parameters. Export to other spreadsheet applications. Datalogix - Sales & Oracle Sales History Detail Report. Query through Data Browser the Data Browser necessary information to the established parameters. Item pricing / costing and calculate margins. Export to other spreadsheet applications. Limited by system storage capability and archiving policies. Can open various screens and close accordingly. Toggle? and use of hot keys. Datalogix - Sales > Sales In the event of lack of inventory a Batch can be enter, etc. Order or Production > Release Batch / MPS / MRP. Batch Datalogix - MRP > P/MRP MRP can recommend a start date for the batch or recommend Run an availability date for the production. Datalogix - Inventory > Pick list is generated based on the shipping screen by ship Warehouse Rules > Report date / order / customer. > Trial Pick List Datalogix - Sales Order See 1.2.6. Processing & Datalogix Sales > Sales Order Oracle Data Browser No, however, can report orders to be shipped by customer, order, zip code. Oracle Data Browser No, however, can report orders to be shipped by customer, order, zip code. Datalogix - Sales > GEMMS allows for entry of the quantity shipped in the Shipping shipping screen. Datalogix - Sales > Items can be allocated at order entry and the inventory Shipping > Action > allocated will be decremented during shipment release. Release Shipment Other application will be designated to fill . Other application will be designated to fill . Datalogix - Quality > Cust / Test results for established items visible in Quality Module. Vendor Results

Page 4

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Sales & Distribution Order Fulfillment Sales & Distribution Order Fulfillment

1.3.11 1.3.12

Track raw materials, finished products, and their association with shipping documents to support recall. Automated back order processing.

Sales & Distribution Order Fulfillment Sales & Distribution Order Fulfillment Sales & Distribution Invoicing

1.3.13

Retain history data for carrier, route, and rate.

1.3.14 1.4.1

File transfer capability which creates a file for export to PC spreadsheet and word processing packages. EDI invoicing to *** Client Name *** customers.

Yes

Sales & Distribution Invoicing

1.4.2

Invoice internal customers (support all payroll deductions).

Yes

Sales & Distribution Invoicing

1.4.3

Sales & Distribution Invoicing

1.4.4

Sales & Distribution Invoicing

1.4.5

On-line invoice review and maintenance with the ability to reprint the invoice if necessary. Allow multiple invoices for a single order (blanket orders over extended time period). Allow multiple shipments to the same customer over a period of time to be combined on a single invoice.

Sales & Distribution Invoicing

1.4.6

Consolidate invoices to the parent company.

Sales & Distribution Invoicing

1.4.7

Sales & Distribution Invoicing

1.4.8

Allow multiple shipping addresses on a single invoice (consolidate shipments from multiple plants). Automated pricing calculations.

Sales & Distribution Invoicing

1.4.9

Ability to override price list with proper authorization.

Sales & Distribution Invoicing

1.4.10

Track daily shipment volumes for the week and calculate weekly volume discount based upon the lowest day's volume.

Sales & Distribution Invoicing

1.4.11

Automated application of volume discounts.

Sales & Distribution Invoicing

1.4.12

Track special customer billing instructions such as those for diverted milk.

Sales & Distribution Invoicing

1.4.13

Ability to re - bill an order to another customer.

Sales & Distribution Invoicing Sales & Distribution Invoicing

1.4.14 1.4.15

Sales & Distribution Invoicing

1.4.16

Generate invoices and purchase vouchers on demand. Allow customization of invoice format and contents to display product test results and specifications. Prevent invoice generation and provide notification if market Yes price has varied more than x% between the date the order was priced and the invoice generation date, and the order was priced more than y days ago. x and y should be in set up tables.

Yes

Datalogix - Quality > Where to and where from lot / sub - lot traceability. Production Results Datalogix - Customer If insufficient inventory is available to ship against an order Master & Sales > Shipping the shipping screen prompts if you want to backorder. >Shipping Line Selection >Line Detail Other application will be designated to fill . Oracle Data Browser

MDE21SM1.xls

Export to other applications.

As stated in the RFP response, Oracle has established strategic alliance partnerships with a number of firms which have developed EDI ( STERLING ) interfaces. ( API ). Interface must be developed Handled through Oracle Invoicing. with Payroll system Oracle Receivables provides numerous ways to query an invoice for viewing, maintenance or reprint. Oracle Receivables provides capability to generate recurring Oracles Receivables invoices. Oracle Receivables provides the ability to generate customer Oracles Receivables statements reflecting invoice activity for the same time period onto one statement. Oracle Receivables allows for unlimited customer Oracles Receivables relationships to be established. The software allows multiple shipments to be invoiced on a Oracle Receivables single invoice. Datalogix - Costing > Cost This is calculated in GEMMS and exported to Oracle Roll Up Receivables. Datalogix - Oracle GEMMS exports invoice pricing to Oracle Receivables. Receivables & Sales > Sales Oracle Receivables will allow overriding pricing that is Order imported. Datalogix - Oracles Data required for this requirement is available in either Receivables Sales > Sales GEMMS or Oracle Receivables. A custom report would need History Detail Report to be developed to provide the appropriate information. Datalogix - Sales Order Volume discounts are calculated in GEMMS. Processing Oracle Receivables & GEMMS and Oracle Receivables allow for Unlimited text Datalogix - Sales > Sales and special notes as applied to customers, orders, and Order invoices. Oracle Receivables The original invoice would have to be adjusted and a new invoice generated. Oracle Receivables Invoices are generated on demand. Oracle Receivables The Oracle receivables invoice print file can me modified to accommodate desired format and content. Oracle Alert can be used to trigger notification of exceptions. However, a custom pricing engine must be developed to accommodate pricing changes and activity. Oracles Receivables

Page 5

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Sales & Distribution Invoicing

1.4.17

Ability to override invoice holds with proper authorization.

Oracle Receivables

Sales & Distribution Invoicing

1.4.18

Adjustment invoices for product grading adjustments.

Oracle Receivables

Sales & Distribution Invoicing

1.4.19

Automated check requests for customer rebate accruals.

Oracle Alert

Sales & Distribution Invoicing

1.4.20

Oracle

Sales & Distribution Invoicing

1.4.21

Process 7000 invoices (each invoice has approximately 25 line items) per month. Automated journal entry for invoice sales including pounds, customer number, state, and invoice number.

Sales & Distribution Invoicing

1.4.22

Credit memo functionality and automated journal entry for credit memos.

Oracle Receivables

Sales & Distribution Invoicing

1.4.23

Trend analysis for this year’s and last year’s monthly customer sales activity.

Yes

Oracle Receivables and GEMMS

Raw Milk Accountability

Route Scheduling

2.1.1

Maintain plants, producers, pick-up/delivery points, and customer sites.

Yes

Manugistics - Routing & Scheduling

Raw Milk Accountability

Route Scheduling

2.1.2

Maintain hauler data.

Yes

Manugistics - Routing & Scheduling

Raw Milk Accountability

Route Scheduling

2.1.3

On-line visibility and maintenance to freight information and Yes rates.

Manugistics - Routing & Scheduling

Raw Milk Accountability

Route Scheduling

2.1.4

On-line visibility to order destination information.

Yes

Manugistics - Routing & Scheduling

Raw Milk Accountability

Route Scheduling

2.1.5

Ability to reroute haulers.

Yes

Manugistics - Routing & Scheduling

Raw Milk Accountability

Route Scheduling

2.1.6

Automated load scheduling and route optimization (based on Yes producer volumes and plant locations) for pickup and delivery of finished goods, raw milk, and outbound fluids to plants and customers (handlers) for a zone, plant, division, or region.

Manugistics - Routing & Scheduling

Oracle Receivables

MDE21SM1.xls

The system allows for various levels and types of invoice holds. Oracle Receivables allows the user to separately adjust different aspects of an invoice. Oracle Alert can be used to update Oracle Payables based on a user defined event. This is limited by the size of the database and the capacity of the disk space available to the application. Oracle Receivables is tightly integrated with Oracle General Ledger, allowing the transfer of financial and statistical information. Oracle Receivables allows application of credit memos and on-account credits to open invoices, debit memos and chargebacks. This activity is transferred to the Oracle General Ledger. Information required for the generation of trend analysis reporting is available from GEMMS and/or Oracle Receivables. Custom reporting will have to be developed to provide this information. Requirement may be fulfilled by Manugistics - Routing & Scheduling which handles transportation planning. Matches transportation resources such as private fleet to transportation requirements to include inbound and outbound shipments. See Appendix B. Requirement may be fulfilled by Manugistics - Routing & Scheduling which handles transportation planning. Matches transportation resources such as private fleet to transportation requirements to include inbound and outbound shipments. See Appendix B. Requirement may be fulfilled by Manugistics - Routing & Scheduling which handles transportation planning. Matches transportation resources such as private fleet to transportation requirements to include inbound and outbound shipments. See Appendix B. Requirement may be fulfilled by Manugistics - Routing & Scheduling which handles transportation planning. Matches transportation resources such as private fleet to transportation requirements to include inbound and outbound shipments. See Appendix B. Requirement may be fulfilled by Manugistics - Routing & Scheduling which handles transportation planning. Matches transportation resources such as private fleet to transportation requirements to include inbound and outbound shipments. See Appendix B. Requirement may be fulfilled by Manugistics - Routing & Scheduling which handles transportation planning. Matches transportation resources such as private fleet to transportation requirements to include inbound and outbound shipments. See Appendix B.

Page 6

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Raw Milk Accountability

Route Scheduling

2.1.7

Track buying and selling of milk from/to other regions and coops.

Raw Milk Accountability

Route Scheduling

2.1.8

Track freight charges and freight movement costs.

Raw Milk Accountability

Route Scheduling

2.1.9

Automated backhaul scheduling.

Raw Milk Accountability Raw Milk Accountability Raw Milk Accountability

Route Scheduling Route Scheduling Route Scheduling

2.1.10

Raw Milk Accountability Raw Milk Accountability

Route Scheduling Federal Order Pooling

2.1.13

Automated order hold processing based upon customer credit status. Automated warnings when supply or demand varies by a Yes defined percentage or fixed amount. Flexible presentation format (such as calendar view) for scheduling, load assignment (assigned/unassigned loads), and order fulfillment (filled/unfilled orders). Hauling cost analysis comparing internal rates to hauler rates. Yes

2.2.1

Federal Order tracking and maintenance including pooling of Yes milk, reclassification of milk, and diverting milk.

Raw Milk Accountability

Federal Order Pooling

2.2.2

Cost-benefit analysis of hauling milk further to associate it with a higher order price.

Raw Milk Accountability

Federal Order Pooling

2.2.3

Optimize the diverting of milk to maximize *** Client Name Yes *** total milk value.

Raw Milk Accountability

Federal Order Pooling

2.2.4

Ability to edit automatic pooling when a producer is qualified Yes under two orders.

Raw Milk Accountability

Federal Order Pooling

2.2.5

Automated warning when a producer is not qualified.

Raw Milk Accountability

Federal Order Pooling

2.2.6

On-line access to daily receipt and disposition information for use in preparation of Federal Order documentation.

Raw Milk Accountability

Federal Order Pooling

2.2.7

Raw Milk Accountability

Federal Order Pooling

2.2.8

Generate Federal Order reports including FMMA pool statement, milk not pooled, milk pooled, pounds summary, and Federal Order pricing worksheets. Track Producer Settlement Fund (PSF) deposits and draws.

Raw Milk Accountability

Internal Pooling 2.3.1

Automated summarization of Federal Order settlement Yes information, producer volumes, plant receipts, and operating expenses for use in calculation of producer pay price.

Raw Milk Accountability

Internal Pooling 2.3.2

On-line producer pay price maintenance and reporting including creation of location differentials and zone prices.

2.1.11 2.1.12

Yes

Datalogix - Purchasing & Datalogix - Sales Order Processing Datalogix - Purchasing > Purchase Order Entry & Sales > Sales Order Manugistics - Routing & Scheduling

Datalogix - Sales Order Processing Datalogix - Sales > Sales Order & MPS

Yes Datalogix - Purchasing > Purchase Order Entry & Receipts

Yes

Yes

MDE21SM1.xls

Requirement may be fulfilled by Manugistics - Routing & Scheduling which handles transportation planning. Matches transportation resources such as private fleet to transportation requirements to include inbound and outbound shipments. See attachment I. See section 1.2.6. Requirement need to be handled by another application.

Yes

Yes

Set up vendors and customer through the use of Purchasing & Sales Order, buying & selling can be tracked via use of Data Browser reports. Purchase Order acquisition costs can be tracked. Sales Order ancillary costs can tracked.

As orders are entered ( SALES ) visibility exists through MPS ( Master Production Schedule ), Sales History, Sales Open Orders & Back Orders Requirement needs to be handled by another application. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Federal Order Pooling. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Federal Order Pooling. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Federal Order Pooling. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Federal Order Pooling. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Federal Order Pooling. Set up members as suppliers ( vendors ) and thru receipts query information. CUSTOMIZATION PROJECT - Raw Milk Accountability - Federal Order Pooling. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Federal Order Pooling. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Federal Order Pooling. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Internal Pooling. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Internal Pooling.

Page 7

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Raw Milk Accountability

Milk Pick-up (Manifest)

2.4.1

On-line entry of manifest information by hauler.

Yes

Raw Milk Accountability

Milk Pick-up (Manifest)

2.4.2

On-line visibility to route information for the hauler.

Yes

Raw Milk Accountability

Milk Pick-up (Manifest)

2.4.3

Raw Milk Accountability

Milk Pick-up (Manifest)

2.4.4

Track load level (plant, load, and transport information) and Yes pick-up level (producer and raw milk information) manifest data. On-line visibility to load shrinkage (actual load weight versus Yes cumulative pick up weights).

Raw Milk Accountability

Milk Pick-up (Manifest)

2.4.5

Split a farm pick-up based upon a percentage of the load or a Yes fixed volume in pounds.

Raw Milk Accountability

Milk Pick-up (Manifest)

2.4.6

Raw Milk Accountability

Hauler Payroll

2.5.1

Electronic transfer of hauler manifest information to handler Yes system (for *** Client Name *** handlers) or to *** Client Name *** system (for other handlers). On-line maintenance of hauler information (hauler number, Yes name, assignments, dues, insurance, supplies).

Raw Milk Accountability

Hauler Payroll

2.5.2

Calculate and track hauler subsidies and premiums.

Yes

Raw Milk Accountability

Hauler Payroll

2.5.3

Yes

Raw Milk Accountability

Hauler Payroll

2.5.4

Calculate hauler payroll based upon the weight of the load, mileage, number of stops, primary plant, alternate plant, supply sales, and producer deductions. Automated price-by-load capability.

Raw Milk Accountability

Hauler Payroll

2.5.5

Calculate and track hauler assignments (assignments may be Yes calculated both before and after deductions).

Raw Milk Accountability

Hauler Payroll

2.5.6

Automatic application of mandatory assessments.

Yes

Raw Milk Accountability

Hauler Payroll

2.5.7

Forecasting capability.

Yes

Raw Milk Accountability

Hauler Payroll

2.5.8

Automated generation of hauler payroll checks.

Yes

Raw Milk Accountability

Hauler Payroll

2.5.9

Generate advance checks on demand.

Yes

Raw Milk Accountability

Hauler Payroll

2.5.10

Enter manual checks.

Yes

Raw Milk Accountability

Hauler Payroll

2.5.11

Automated 1099 generation.

Yes

Yes

MDE21SM1.xls

Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Fluid Milk Marketing. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Fluid Milk Marketing. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Fluid Milk Marketing. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Fluid Milk Marketing. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Fluid Milk Marketing. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Fluid Milk Marketing. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Hauler Payroll. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Hauler Payroll. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Hauler Payroll. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Hauler Payroll. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Hauler Payroll. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Hauler Payroll. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Hauler Payroll. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Hauler Payroll. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Hauler Payroll. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Hauler Payroll. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Hauler Payroll.

Page 8

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Raw Milk Accountability

Hauler Payroll

2.5.12

Automated general ledger entries from hauler payroll.

Yes

Raw Milk Accountability

Hauler Payroll

2.5.13

Analyze trends using the weight audit report.

Yes

Raw Milk Accountability

Producer Payroll 2.6.1

Track 3.5% butterfat price (established monthly).

Raw Milk Accountability

Producer Payroll 2.6.2

Track and maintain grade “A” health permits information (pooling will be done by this data).

Yes

Raw Milk Accountability

Producer Payroll 2.6.3

Track farm by tank.

Yes

Raw Milk Accountability

Producer Payroll 2.6.4

Track member weights and tests received from non-*** Client Name *** haulers/handlers.

Raw Milk Accountability

Producer Payroll 2.6.5

Track collection of premiums from producers.

Raw Milk Accountability

Producer Payroll 2.6.6

Track freight charges and freight movement costs.

Raw Milk Accountability

Producer Payroll 2.6.7

Ability to exempt producers from hauling charges.

Raw Milk Accountability

Producer Payroll 2.6.8

Track milk procurement fees and milk producer security fees.

Raw Milk Accountability

Producer Payroll 2.6.9

Track antibiotic and compressor failure milk payments.

Raw Milk Accountability

Producer Payroll 2.6.10

Track check deductions and assignments (assignments may be calculated both before and after deductions).

Yes

Raw Milk Accountability

Producer Payroll 2.6.11

On-line access to hauling deductions from producer checks.

Yes

Requirement needs to be handled by another application. Third party software available which meets some of these requirements. See Appendix B.

Raw Milk Accountability

Producer Payroll 2.6.12

Producer payroll adjustment capability. Retain a history of all Yes adjustments.

Requirement needs to be handled by another application. Third party software available which meets some of these requirements. See Appendix B.

Yes

MDE21SM1.xls

Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Hauler Payroll. Requirement needs to be handled by another application. CUSTOMIZATION PROJECT - Raw Milk Accountability Hauler Payroll. Datalogix - Inventory > Set up item, enter price as needed, query entries for historical Items & Costing > Cost information. Third party software available which meets Detail some of these requirements. See Appendix B. Requirement needs to be handled by another application. Third party software available which meets some of these requirements. See Appendix B. Requirement needs to be handled by another application. Third party software available which meets some of these requirements. See Appendix B. Datalogix - Purchasing > Tracked as receipts against a supplier. Test results are also Receipts & Quality > Cust / tracked. Third party software available which meets some of Vendor Results these requirements. See Appendix B. Requirement needs to be handled by another application. Third party software available which meets some of these requirements. See Appendix B. Datalogix - Purchasing > Acquisition costs can be tracked by Purchasing. Third party Purchase Order Entry software available which meets some of these requirements. See Appendix B. Datalogix - Purchasing > Acquisition costs can be tracked by Purchasing. Third party Purchase Order Entry software available which meets some of these requirements. See Appendix B. Datalogix - Purchasing > Acquisition costs can be tracked by Purchasing. Third party Purchase Order Entry software available which meets some of these requirements. See Appendix B. Datalogix - Purchasing > Acquisition costs can be tracked by Purchasing. Third party Purchase Order Entry software available which meets some of these requirements. See Appendix B. Requirement needs to be handled by another application. Third party software available which meets some of these requirements. See Appendix B.

Page 9

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Raw Milk Accountability

Producer Payroll 2.6.13

Support various producer pricing algorithms (component, 3.5 Yes butter fat, cheese yield).

Requirement needs to be handled by another application. Third party software available which meets some of these requirements. See Appendix B.

Raw Milk Accountability

Producer Payroll 2.6.14

Calculate assignments from producer and hauler payroll by fixed dollar, percentage, or per cwt.

Yes

Requirement needs to be handled by another application. Third party software available which meets some of these requirements. See Appendix B.

Raw Milk Accountability

Producer Payroll 2.6.15

Support split farms and partnerships (handle splits based upon percentages, fixed pounds and fixed dollar amounts).

Yes

Requirement needs to be handled by another application. Third party software available which meets some of these requirements. See Appendix B.

Raw Milk Accountability

Producer Payroll 2.6.16

Automated grade and premium calculations (discretionary and quality) which support multiple levels of incentives.

Yes

Requirement needs to be handled by another application. Third party software available which meets some of these requirements. See Appendix B.

Raw Milk Accountability

Producer Payroll 2.6.17

Ability to pay producers different grade prices based upon the Yes day (pick-up and delivery).

Requirement needs to be handled by another application. Third party software available which meets some of these requirements. See Appendix B.

Raw Milk Accountability

Producer Payroll 2.6.18

Forecasting capability.

Raw Milk Accountability

Producer Payroll 2.6.19

Automated generation of form letters and mailing labels from Yes customer, member, hauler and vendor master lists (including creation of USPS bar codes).

History can be queried and imported to spreadsheet such as LOTUS and linear regression analysis can be done to forecast. Third party software available which meets some of these requirements. See Appendix B. Requirement needs to be handled by another application. Third party software available which meets some of these requirements. See Appendix B.

Raw Milk Accountability

Producer Payroll 2.6.20

Automated generation and distribution of producer and fieldman quality report.

Yes

Raw Milk Accountability

Producer Payroll 2.6.21

Automated generation of milk patron statistical report.

Yes

Raw Milk Accountability

Producer Payroll 2.6.22

Automated generation of milk receipt statistical summary and Yes report on premiums by state and in summary form.

Yes

MDE21SM1.xls

Passed / failed parameters can be incorporated in the Quality Module and queried or reported against them. Third party software available which meets some of these requirements. See Appendix B. Data can be queried and exported to other applications for analysis. Third party software available which meets some of these requirements. See Appendix B. Data can be queried and exported to other applications for analysis. Third party software available which meets some of these requirements. See Appendix B.

Page 10

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Raw Milk Accountability

Producer Payroll 2.6.23

Automated generation of producer cost comparison and producer count comparison.

Yes

Requirement needs to be handled by another application. Third party software available which meets some of these requirements. See Appendix B.

Raw Milk Accountability

Producer Payroll 2.6.24

Automated 1099 generation.

Yes

Requirement needs to be handled by another application. Third party software available which meets some of these requirements. See Appendix B.

Raw Milk Accountability

Producer Payroll 2.6.25

Support multiple payrolls.

Yes

Requirement needs to be handled by another application. Third party software available which meets some of these requirements. See Appendix B.

Raw Milk Accountability

Producer Payroll 2.6.26

Automated generation of producer payroll checks.

Yes

Requirement needs to be handled by another application. Third party software available which meets some of these requirements. See Appendix B.

Raw Milk Accountability

Producer Payroll 2.6.27

Enter manual checks.

Yes

Requirement needs to be handled by another application. Third party software available which meets some of these requirements. See Appendix B.

Raw Milk Accountability

Producer Payroll 2.6.28

Automated application of mandatory assessments.

Yes

Requirement needs to be handled by another application. Third party software available which meets some of these requirements. See Appendix B.

Raw Milk Accountability

Producer Payroll 2.6.29

Ability to split payroll deductions between two or more members or producers.

Yes

Requirement needs to be handled by another application. Third party software available which meets some of these requirements. See Appendix B.

Raw Milk Accountability

Producer Payroll 2.6.30

Automated generation of checks for assignments out of payroll.

Yes

Requirement needs to be handled by another application. Third party software available which meets some of these requirements. See Appendix B.

Manufacturing

Supply Volume 3.1.1 Estimating

Datalogix - Vendor & Customer Master, Purchasing > Receipts

Proper set up of Vendors, Customers and through using Purchasing and Sales Order this requirement can be queried and / or reported.

Manufacturing

Supply Volume 3.1.2 Estimating

Track and maintain fluid milk budget (pounds of producer raw milk by producer/month, pounds of raw milk from other sources by source/month, pounds of raw milk sold to other handlers by handler/month) at region, division, and department levels. Access to production trend information.

Datalogix - Production > Batch

Manufacturing

Supply Volume 3.1.3 Estimating

Projections of total milk production based upon manifest information.

Datalogix - Vendor & Customer Master, Purchasing > Receipts

Through the implementation of the production module, production history can be queried and exported to another application for data analysis, Through the implementation of purchasing module, receipts can be queried and exported to another application for data analysis.

MDE21SM1.xls

Page 11

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Manufacturing

Plant Schedule 3.2.1

Manufacturing

Plant Schedule 3.2.2

Manufacturing

Plant Schedule 3.2.3

Manufacturing

Plant Schedule 3.2.4

Manufacturing

Production Accounting Production Accounting

3.3.1

Production Accounting Production Accounting

3.3.3

Manufacturing

Production Accounting

Manufacturing

Manufacturing Manufacturing

3.3.2

On-line bill of materials data entry, maintenance (product numbers, descriptions, formulations, theoretical yields, yield goals, etc.) and inquiry. Automated production scheduling based upon information from the order entry and inventory systems. Ability to reassign product number. Supply and demand side production and product mixture Yes planning capabilities at the region, division, and plant level. Automate input of production results from shop floor process Yes control equipment. Track key production throughput and yield by vat, product, and lot.

Datalogix - Formula

This requirement handled by Formula management.

Datalogix - MPS

This requirement handled by MPS.

Datalogix > Inventory > Items Datalogix - MRP & MPS

GEMMS allows for items to be active / inactive.

Datalogix - Production > Batch Input & Batch Output

This requirement handled by the MRP / MPS modules. Need interface in order to have automatic entry of the shop floor process control equipment data into batch reporting. Batch information tracks expected usage versus actual.

Track intake rate (milk volume or usage) in pounds (pounds to production). Track and report efficiency indicators by product (actual yields, milk to cheese) and efficiency indicators by operation.

Datalogix - Production > Batch Input Datalogix - Production > Batch Output

3.3.5

Track product cost data (fixed, variable, standard costs) based on bill of materials and cost models by product or operation with the ability to override individual cost components.

Datalogix - Costing > Cost This information is tracked through the costing module. Rollup

Production Accounting Production Accounting Production Accounting Production Accounting

3.3.6

Accommodate several cost drivers within each product.

3.3.7

This information is handled in the costing module using routing in formulae. This information is handled in the costing module.

Manufacturing

Production Accounting

3.3.10

Datalogix - Formula & Costing > Cost Rollup

Manufacturing

3.3.11

Costing Module will provide product costing to include raw material costs, fixed and variable overhead, and other associated costs, however Profit / Loss analysis need be done via another application. Data can be exported to another applications for graphical presentation. Data can be exported to another applications for graphical presentation. GEMMS allows for manual updating only.

Manufacturing

Production Accounting Production Accounting Production Accounting Production Accounting Recall

Allocate costs (production, non-production, controllable, noncontrollable) by product and operation. Estimate costs of new products based upon costs existing products. Track emissions and hazardous material information (such as spill information) to ensure compliance with federal (EPA and OSHA) and state ordinances. Allow flexible selection (period, product, locations, etc.), sorting, grouping, and summarizing (Total Costs Per Pound, Profit/Loss Per Pound, Total Profit/Loss) of production accounting data for reports. Support graphical representation or production accounting Yes data. Track and report monthly operating trends. Yes

Datalogix - Formula & Costing > Cost Rollup Datalogix - Costing > Cost Rollup Datalogix - Costing > Cost Rollup Datalogix - Inventory > Items

Manufacturing

Recall

3.4.2

Manufacturing

Manufacturing Manufacturing Manufacturing

Manufacturing Manufacturing Manufacturing

3.3.4

3.3.8 3.3.9

3.3.12 3.3.13 3.3.14 3.4.1

Automated update of deal/price lists when product number Yes changes. File transfer capability which creates a file for export to PC spreadsheet and word processing packages. Associate inventory (vendor, product, lot) with resulting finished products (product and vat or lot) to support product recall. Ability to initiate recall process via multiple process/material usage entry points.

MDE21SM1.xls

Reported in the batch information. This data is tracked in the batch information.

This information is handled in the costing module. By establishing some intelligence in the item master, reportable items can be tracked.

Data can be exported to another applications. Datalogix - Formula > Ingredient Use & Inventory > Lot / Sub Lot Datalogix - Formula > Ingredient Use & Inventory > Lot / Sub Lot

Where from and where to analysis available. Need to set up lot / sub - lot control. Where from and where to analysis available. Need to set up lot / sub - lot control.

Page 12

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Manufacturing

Recall

3.4.3

Execute recall process within one hour.

Manufacturing

Inventory

3.5.1

Single system for tracking raw milk, supplies, raw materials, supply sales, and finished goods inventory.

Manufacturing

Inventory

3.5.2

Manufacturing

Inventory

3.5.3

On-line visibility to raw milk, raw materials, finished goods, and supply sales inventory activity. Inventory classification (ABC).

Manufacturing

Inventory

3.5.4

Product reclassification for aged products.

Manufacturing

Inventory

3.5.5

Ability to receive finished goods into inventory prior to receiving grading information.

Manufacturing Manufacturing

Inventory Inventory

3.5.6 3.5.7

Bar code capabilities for receiving and tracking inventory. Yes Track and maintain operations (projected budgets down to Yes account level, summarized by division, location, and department) and manufacturing (monthly budgets by product) budgets at the region, division, and department levels.

Manufacturing

Inventory

3.5.8

Manufacturing

Inventory

3.5.9

Product ownership specification and tracking, including the ability to house multiple owners' finished goods at the same location. Track inventory stored at non-*** Client Name *** locations.

Manufacturing

Inventory

3.5.10

Track inventory location to bin within warehouse.

Manufacturing

Inventory

3.5.11

Manufacturing

Inventory

3.5.12

Manufacturing

Inventory

3.5.13

Manufacturing

Inventory

3.5.14

Track inventory within 60 warehouses (17 *** Client Name *** and 43 public). Automated receipts processing for inter-plant, inter-region, intra-region, and warehouse transfers. Automated depletion processing for inter-plant, inter-region, and intra-region transfers. Deplete inventory on a First In First Out (FIFO) basis.

Manufacturing

Inventory

3.5.15

Manufacturing

Inventory

3.5.16

Manufacturing

Inventory

3.5.17

Automated reconciliation of inventory to sales orders.

Manufacturing

Inventory

3.5.18

Automated warnings for inventory items that drop below the minimum stocking level (reorder points).

On-line inventory adjustment capability, including quantity and status. Automated inventory updates based upon production raw material usage and finished goods counts.

MDE21SM1.xls

Datalogix - Formula > Ingredient Use & Inventory > Lot / Sub Lot Datalogix - Purchasing, Inventory & Oracle Customer & Vendor Master

Limited by the amount of data that must be searched.

Datalogix - Inventory > Item Inquiry Inventory > Item Inquiry

Set up of the Inventory Module will allow for this.

Datalogix - Inventory > Item & Warehouse

Specifications / test results down to the lot / sub - lot level. Items can be controlled to the location / bin sub level.

Datalogix - Inventory > Item & Warehouse Datalogix - Inventory > Item & Warehouse & Warehouse Locations Datalogix - Inventory > Item & Warehouse Datalogix - Inventory > Warehouse Xfer Rules Datalogix - Inventory > Warehouse Xfer Rules Datalogix - Inventory > Items Datalogix - Inventory > Lot Status Datalogix - Inventory > Items

GEMMS allows for indefinite Item, Warehouse and Warehouse Locations. GEMMS allows for indefinite Item, Warehouse and Warehouse Locations.

Set up of the respective modules ( Purchasing & Inventory ) and Masters ( Vendors & Customers ) will allow for this.

The inventory can be assigned the standard ABC designation however the computations to arrive at the designation must be performed by another applications. Datalogix - Inventory > Lot Lot status allows for the reclassification of inventory. Status Datalogix - Inventory > Lot Items can be received to inventory with a lot status other than Status available for use, ( HOLD, QUARANTINED, HOLD FOR INSPECTION, ETC. ) Requires another application. See attachment II. Data can be exported to another application for reporting purposes.

Datalogix - Sales > Sales Order & Inventory > Item Inquiry Datalogix - Inventory > Warehouse Rules

GEMMS allows for indefinite Item, Warehouse and Warehouse Locations. GEMMS allows for Warehouse transfers provide Warehouse Rules are properly set up. System generates transfers if relationships are properly set up properly. Items can be allocated First In First Out ( FIFO ) as well as First Expired First Out ( FEFO ) basis. Inventory > Quantities allow for inventory adjustments. Lot status allow for inventory status changes. Inventory updates are based on timely inventory transactions. Issues to batches and / or Firmed Planned Orders and Shipping, Receipts govern these transactions. During Sales Order Entry, available inventory is visible and can be allocated. Warehouse / Item allow for setting up safety stock, minimum / maximum, re - order points and re - order rules. MRP makes suggestions.

Page 13

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Manufacturing

Inventory

3.5.19

Automated warnings for inventory items that exceed the maximum stocking level.

Manufacturing

Inventory

3.5.20

Manufacturing

Inventory

3.5.21

Manufacturing

Inventory

3.5.22

Manufacturing

Inventory

3.5.23

Automated generation of physical inventory turn-around Yes documents. Periodic (monthly) inventory valuation based on cost alone, cost plus margin, market value (date of make, or current) plus premium, sales history, or offered price and allow for valuation overrides and reevaluations. Track the relationship between lotted inventory and resulting finished product vat or lot (for federal order grade receipts, reclassifications, dispositions, and outside milk). Tie producer and tanker test results to raw milk inventories.

Manufacturing

Inventory

3.5.24

Track product weight, grade, and quality data by lot and serial number in inventory.

Manufacturing

Inventory

3.5.25

Manufacturing

Inventory

3.5.26

Track property and materials (boiler, underground tank, and hazardous materials) ,associating safety procedures and other relevant data to ensure compliance with federal and state ordinances. Provide hazardous materials reports. Yes

Manufacturing Manufacturing

Inventory Preventative Maintenance Preventative Maintenance Preventative Maintenance Fleet Management Fleet Management Fleet Management Fleet Management Fleet Management Fleet Management Fleet Management Fleet Management Fleet Management

3.5.27 3.6.1

Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing Manufacturing

3.6.2 3.6.3

Automated product inventory journal entries. On-line preventative maintenance data entry and inquiry capabilities. Automated preventative maintenance scheduling.

Datalogix - Inventory > Warehouse Rules

Yes Yes

3.7.1

On-line access to spare parts inventory (stand-alone package Yes in place at one plant). Provide on-line access to vehicle identification information. Yes

3.7.2

Track vehicle lease information.

Yes

3.7.3

Track vehicle fuel usage.

Yes

3.7.4

Track vehicle mileage by state.

Yes

3.7.5

Track vehicle maintenance.

Yes

3.7.6

Yes

3.7.7

Track vehicle license renewal information (single state & IRP). Track bulk tank license renewal information.

3.7.8

Track vehicle accident information.

Yes

3.7.9

Track authorized driver accident and license renewal information.

Yes

Yes

MDE21SM1.xls

Warehouse / Item allow for setting up safety stock, minimum / maximum, re - order points and re - order rules. MRP makes suggestions. Query and report.

Datalogix - Costing > Cost GEMMS allow for Costing based on standard cost and Roll Up & Cost release 3.2 allows for actual costing. UpDatalogixe Datalogix - Formula > Ingredient Use & Inventory > Lot / Sub Lot Datalogix - Quality > Cust / Vendor Results & Item Location Results Datalogix - Quality > Cust / Vendor Results & Item Location Results Datalogix - Inventory > Items

Items can be tracked where to / where from. Test results down to lot / sub lot level can be supported. Producers samples treated as customer / vendor samples, truck sample treated as sampling material from inventory. Item visibility by lot / sub - lot, quantity, lot status. Set up Item Classification Code and query and report against it. Item code can be established with some intelligence and data queried and reported. See Appendix B. All item transaction are sent over to Oracles are desired. Requirement need to be handled by another application. See Appendix B. Requirement need to be handled by another application. See Appendix B. Requirement need to be handled by another application. See Appendix B. Requirement need to be handled by another application. See Appendix B. Requirement need to be handled by another application. See Appendix B. Requirement need to be handled by another application. See Appendix B. Requirement need to be handled by another application. See Appendix B. Requirement need to be handled by another application. See Appendix B. Requirement need to be handled by another application. See Appendix B. Requirement need to be handled by another application. See Appendix B. Requirement need to be handled by another application. See Appendix B. Requirement need to be handled by another application. See Appendix B.

Page 14

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Manufacturing

3.7.10

Track driver information.

Yes

3.7.11

Track information on vehicle licenses.

Yes

3.7.12

Track excise and use taxes.

Yes

3.7.13

Manufacturing

Fleet Management Fleet Management Fleet Management Fleet Management Testing

Provide for International Fuel Tax Agreement (IFTA) Yes tracking and payment (quarterly). On-line maintenance of daily antibiotic test results keeping a history of all changes.

Manufacturing

Testing

3.8.2

Support multiple algorithms for calculating the antibiotic test Yes failure penalty.

Manufacturing

Testing

3.8.3

Automated generation of invoices for antibiotic loads.

Manufacturing

Testing

3.8.4

On-line access to butterfat test results at division level for all milk.

Manufacturing

Testing

3.8.5

On-line access to product nutrition and composition analysis.

Manufacturing

Testing

3.8.6

On-line access to quality test results.

Manufacturing

Testing

3.8.7

Centralized test data repository that will be available to producer payroll, plants, and quality.

Manufacturing

Testing

3.8.8

Print quality test results on the producer payroll check.

Manufacturing

Testing

3.8.9

Manufacturing

Testing

3.8.10

Automated dial-in voice system for producers to get results of Yes tests and volumes (information is currently available by fax or mail). Automated upload of test data to controlling agencies. Yes

Manufacturing

Testing

3.8.11

Manufacturing Manufacturing Manufacturing

3.8.1

Yes

Yes

Automated matching of the manifest number with the lab test data.

MDE21SM1.xls

Requirement need to be handled by another application. See Appendix B. Requirement need to be handled by another application. See Appendix B. Requirement need to be handled by another application. See Appendix B. Requirement need to be handled by another application. See Appendix B. Datalogix - Quality > Cust / Test results handled in the Quality Module by customer/ Vendor Results vendor test results, Inventory test results, Production test results. Requirement need to be handled by another application. Third party software available which meets some of these requirements. See Appendix B. Requirement need to be handled by another application. Third party software available which meets some of these requirements. See Appendix B. Datalogix - Quality > Cust / Test results handled in the Quality Module by customer/ vendor test results, Inventory test results, Production test Vendor Results results. Datalogix - Quality > Cust / Test results handled in the Quality Module by customer/ vendor test results, Inventory test results, Production test Vendor Results results. Quality > Cust / Vendor Test results handled in the Quality Module by customer/ vendor test results, Inventory test results, Production test Results results. Third party software available which meets some of these requirements. See Appendix B. Quality > Cust / Vendor Test results handled in the Quality Module by customer/ Results vendor test results, Inventory test results, Production test results. Third party software available which meets some of these requirements. See Appendix B. Requirement need to be handled by another application. Third party software available which meets some of these requirements. See Appendix B. Requirement need to be handled by another application. Third party software available which meets some of these requirements. See Appendix B. Requirement need to be handled by another application. Third party software available which meets some of these requirements. See Appendix B. Datalogix - Quality > Test results handled in the Quality Module by customer/ Samples vendor test results, Inventory test results, Production test results. Sample identity key to tracing sample to a particular producer.

Page 15

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Manufacturing

Testing

3.8.12

On-line grade tracking and valuation.

Inventory > Lot / Sub Lot

Manufacturing

Testing

3.8.13

Track downgraded loads, producers, and products, by reason for downgrade (failure to meet regulatory guidelines, out-oftolerance loads, bad smell, etc.).

Manufacturing

Testing

3.8.14

Tracking test results for samples to be included, excluded, and rechecked.

Manufacturing

Testing

3.8.15

Allow substitution of test results with visibility to original test results (override).

Manufacturing

Testing

3.8.16

Flexible report format which allows summarization of test data at various levels (producer, plant, etc.).

Manufacturing

Testing

3.8.17

Graphical representation of test results (charts, graphs, etc.). Yes

Manufacturing

Testing

3.8.18

Automated warnings for test failures and sample test results which vary significantly from previous results.

Manufacturing

Testing

3.8.19

Missing test report based upon test requirements.

Manufacturing

Testing

3.8.20

Automated missing test substitution base on rules.

Manufacturing

Testing

3.8.21

Tracking of customer complaints (ex. Taco Bell Hotline complaints).

Financials

All Areas

4.1

Provide on-line inquiry and ability to download data to PC formats.

Financials

General Ledger 4.1.1

Access controls on GL account creation and usage.

Financials

General Ledger 4.1.2

On-line visibility to GL detail.

Financials

General Ledger 4.1.3

On-line visibility to period open and close dates.

Financials

General Ledger 4.1.4

Create standard journal entries for future periods.

Financials

General Ledger 4.1.5

Entry of automatically reversing accruals.

Yes

MDE21SM1.xls

Test results handled in the Quality Module by customer/ vendor test results, Inventory test results, Production test results. Sample identity key to tracing sample to a particular producer. Inventory > Lot / Sub Lot Test results handled in the Quality Module by customer/ vendor test results, Inventory test results, Production test results. Sample identity key to tracing sample to a particular producer. Lot status changes part of the data base. Datalogix - Quality > " test Test results handled in the Quality Module by customer/ vendor test results, Inventory test results, Production test " Results results. Third party software available which meets some of these requirements. See Appendix B. Datalogix - Quality > " test Test results can be " changed " , query will provide history. " Results Third party software available which meets some of these requirements. See Appendix B. Datalogix - Quality > " test Query data and report. Third party software available which " Results & Oracle Data meets some of these requirements. See Appendix B. Browser Query and export to another application for further analysis. Third party software available which meets some of these requirements. See Appendix B. Datalogix - Quality > " test Test results are evaluated against established parameters and " Results & Assay limits and failure are flagged. Third party software available which meets some of these requirements. See Appendix B. Datalogix - Quality " test : Item / Location Specification report identifies inventory that Results > Assay Results may need Q.C. attention. Third party software available which meets some of these requirements. See Appendix B. Datalogix - Quality " test : Item / Location Specification report identifies inventory that Results > Assay Results may need Q.C. attention. Assay results report also available. Manual entry. Third party software available which meets some of these requirements. See Appendix B. Requirement need to be handled by another application. Third party software available which meets some of these requirements. See Appendix B. Oracle General Ledger All Oracle applications offer individual inquiry screens, which in most cases can be turned into query screens. All Oracle applications are DDE compliant which allows down loading to PC formats. Oracle General Ledger A special Oracle security responsibility is used to establish and maintain GL Accounts. This special responsibility is than assigned only to authorized users. Oracle General Ledger Online access to all accounting information is available, at the summary level down to the lowest level of detail. Oracle General Ledger A separate online menu option is available for the establishment, viewing, and maintenance of the financial calendars. Oracle General Ledger Unlimited recurring journal entries can be established and maintained. Oracle General Ledger You can automatically reverse and entry in any period specified.

Page 16

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Financials

General Ledger 4.1.6

Oracle General Ledger

General Ledger 4.1.8

Define recurring journal entries for posting without changes and for processing after review and edit. Allow the GL coordinator and the financial accounting manager to perform entry maintenance. Store multiple budgets in the ledger.

Financials

General Ledger 4.1.7

Financials Financials

General Ledger 4.1.9

Enter statistical data into the ledger.

Oracle General Ledger

Financials

General Ledger 4.1.10

Oracle General Ledger

Financials

General Ledger 4.1.11

Track and report non-dollar information (comments) associated with GL accounts. Dynamic cost center association.

Financials

General Ledger 4.1.12

Oracle General Ledger

Financials

General Ledger 4.1.13

Automatic allocation of region overhead expenses to divisions based on preset percentages or relative values of account balances. Track customer accruals in both weights and dollars.

Financials

General Ledger 4.1.14

Track and report customer accruals by plant.

Oracle General Ledger

Financials

General Ledger 4.1.15

Automated journal entries for customer accruals.

Oracle General Ledger

Financials

General Ledger 4.1.16

Oracle General Ledger

Financials

General Ledger 4.1.17

Financials

General Ledger 4.1.18

Financials

General Ledger 4.1.19

Print a transaction register to review entries before they are posted to the ledger. Allow the GL coordinator and the financial accounting manager to immediate-post entries. Critical account listing by month, by year, and by multiple year. Direct download of audit related data to spreadsheet.

Financials Financials Financials

General Ledger 4.1.20 Purchasing 4.2.1 Purchasing 4.2.2

Trend analysis. Track and maintain vendor information. EDI to receive updated vendor price lists.

Oracle General Ledger Oracle Accounts Payable

Financials

Purchasing

4.2.2

Financials

Purchasing

4.2.3

Financials Financials

Purchasing Purchasing

4.2.4 4.2.5

Financials

Purchasing

4.2.6

Track and maintain vendor discount terms to support multiple companies with common vendor file. Provide a common vendor file for purchasing and accounts payable. Maintain catalogue of items with specs and final contract. Yes On-line vendor contract history (price negotiations, RFP and Yes Bid responses). Maintain a vendor information and performance history.

Oracle General Ledger Oracle General Ledger

Oracle General Ledger

Oracle General Ledger

Oracle General Ledger Oracle General Ledger Oracle General Ledger

Yes

MDE21SM1.xls

Oracle Accounts Payable Oracle Accounts Payable

Oracle Accounts Payable

Recurring journal entries can be established and maintained in several ways. Individual user security is available and assigned by responsibility definition. Unlimited budget versions can be established, maintained, and reported on. Unlimited statistical units can be maintained and reported on. Up to 64,000 characters of descriptive information, per each transaction, can be entered and reported on. New cost centers are not dynamically established in Oracle General Ledger. However, they can be established quickly based on business rules defined by *** Client Name ***. Recurring journal entries or mass allocations features can be used to allocate revenues and expenses across multiple cost centers, regions, etc. If Account(s) are setup for accruals you should be able to track dollars if Customer is a segment in the Accounting Flexfield. Weights can be tracked using Statistical Accounts. If Account(s) are setup for accruals you should be able to track if Plant is a segment in the Accounting Flexfield If Account(s) are setup for accruals you should be able to track if Plant is a segment in the Accounting Flexfield Entries can be reviewed on-line or on printed reports This is accomplished through Responsibility definition and assignment. Satisfied with a report developed with FSG Oracle applications are DDE compliant, allowing transfer of data to PC based spreadsheets. Satisfied with a report developed with FSG Vendor Master meets this requirement. EDI ( STERLING )interface software must be purchased or developed to meet this requirement. See Appendix B. Oracle Accounts Payable and GEMMS share a common vendor file, where discount terms are maintained. Oracle Accounts Payable and GEMMS share a common vendor file. Requirement need to be handled by another application. Requirement need to be handled by another application. Vendor information is maintained in the Vendor Master. Performance history can be queried.

Page 17

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Financials

Purchasing

4.2.7

Track purchase orders from requisition, through all the approval processes, to order placement and receipt and invoice processing.

Yes

Datalogix - Purchasing > Purchase Order Entry & Receipts

GEMMS does not have online requisitioning and approval capabilities, however P.O. entry, receipt and invoicing is supported by GEMMS - ORACLE. Full requested functionality is being considered for future release.

Financials

Purchasing

4.2.8

Financials

Purchasing

4.2.9

Provide for both one-time and blanket processing of purchase orders. Support One-Time-Only (OTO) vendor transactions.

Datalogix - Purchasing > Purchase Order Entry Datalogix - Purchasing > Purchase Order Entry Datalogix -

GEMMS supports one time vendor and Blanket P.O. processing. GEMMS supports one time vendor transactions.

Financials Financials

Purchasing Purchasing

4.2.10 4.2.11

Process tax exemption certificates. Provide EDI to send orders to major vendors.

Financials

Purchasing

4.2.12

Financials

Purchasing

4.2.13

Financials

Purchasing

4.2.14

Raw milk purchase vouchers by grade which support class Yes and component pricing, market administrator fees, class charges, hauling charges, multiple service charges and credits, multiple zone charges and credits, and advance charges and credits. Automated verification of the purchase order dollar amount Yes against the CAR listed on the purchase order. On-line access to purchase order history.

Financials

Purchasing

4.2.15

On-line invoice approval mechanism.

Datalogix - Purchase > Purchase Order Entry Oracle Payables

Financials

Purchasing

4.2.16

Automated vendor payment with ability to suspend payments.

Oracle Payables

Financials

Purchasing

4.2.17

Automated accounts payable entries for purchases.

Oracle Payables

GEMMS Purchasing is tightly integrated with Oracle Payables. To match an invoice to a purchase order, the user enters the purchase order number in the invoice screen. The system will retrieve the line items on the purchase order.

Financials

Purchasing

4.2.18

Purchasing

4.2.19

Financials

Purchasing

4.2.20

Ability to set up an asset once it is received.

Datalogix - Purchasing > Purchase Order Entry & Oracle Data Browser Datalogix - Purchasing > Purchase Order Entry & Oracle Data Browser Oracles Payables & Oracle Assets

Query and report.

Financials

Track and report purchase orders for various categories of merchandise separately (supply sales, cream purchases, manufacturing supplies, etc.). Summary of high dollar/ high volume suppliers.

Financials

Purchasing

4.2.21

Update inventory upon receipt of inventory items.

Financials

Cash Management

4.3.1

Calculate estimated daily interest on outstanding loans.

Yes

Datalogix - Purchasing > Receipts Yes

MDE21SM1.xls

GEMMS accommodates tax exemption processing As stated in the RFP response, Oracle has established strategic alliance partnerships with a number of firms which have developed EDI ( STERLING ). interfaces. See Appendix B. Raw Milk Purchase Vouchers are created as a result of Raw Milk Sale. The only region concerned is Morning Glory. More definition of the event is required before a system solution can be applied. CAR budgetary control checking must be performed at this time against all expenditures applied to a given CAR Online visibility of purchase orders not archived. Oracle Payables allows for user-defined approval codes to be placed on an invoice. A separate menu option is used to release holds on an invoice. For invoice payment, Oracle Payables will determine the appropriate payment date based on vendor terms. Recurring payments can also be established. The system allows for the user to change the payment, if authorized to do so.

Query and report. Oracle Payables updates Oracle Assets when an invoice is received for an asset that should be capitalized. Oracle Payables can automatically flag this transaction to update Oracle Assets. Done automatically upon receipt. Availability for use based on rules set up. Requirement need to be handled by another application. See attachment .

Page 18

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Financials

Cash Management Cash Management Cash Management Cash Management Cash Management

4.3.2

Allocate interest charged on loans to the regions.

Oracle General Ledger

Mass Allocation formulas can be used

4.3.3

Track disbursements and allocate them to the regions.

Oracle General Ledger

Mass Allocation formulas can be used

4.3.4

Oracles Receivables

4.3.5

Automated recording of lock box receipts including invoice details for receivables matching. Support amounts up to $99,999,999,999.99.

Oracle Receivables automatically records payments directly from a bank, in the format the bank sends. Supported

4.3.6

Automatic bank reconciliation.

Oracles Payables

Cash Management Cash Management Cash Management

4.3.7

Means for bank account inquiry.

Oracle General Ledger

4.3.8

Forecast cash requirements by day based upon A/P information. Capability for wire transfers and other automatic payments.

Oracles Payables

Financials

Cash Management

4.3.10

Access to account maintenance system available from TCB, Micro-link.

Yes

Financials

Cash Management

4.3.11

Connect to Texcommunication, an inquiry system which provides screen-print functionality.

Yes

Financials

Accounts Payable

4.4.1

EDI capable of receiving electronic invoicing from vendors.

Oracles Payables

Financials

Accounts Payable Accounts Payable Accounts Payable

4.4.2

Automated calculation of optimum payment date according to vendor terms. View commitments by date range.

Oracles Payables

Oracles Payables

Accounts Payable Accounts Payable

4.4.5

Recurring payables maintenance and generation for fixed (rent, lease, and insurance payments) and variable (telephone bills, utility bills, etc.) expenses. Permit partial payment of an invoice.

4.4.6

Allow back posting and forward posting.

Oracles Payables

Financials

Accounts Payable

4.4.7

EDI (ACH) capable of generating payment orders.

Oracles Payables

Financials

Accounts Payable

4.4.8

Produce remittance note containing the customer invoice numbers.

Yes

Financials

Accounts Payable

4.4.9

Provide a comments section on checks.

Yes

Financials Financials Financials Financials Financials Financials Financials

Financials Financials Financials Financials

4.3.9

4.4.3 4.4.4

All Oracle Financials

Oracles Payables

Oracles Payables

Oracles Payables

MDE21SM1.xls

Oracle Payables loads bank reconciliation data into a temporary table. The system updates payment history and prints a report of reconciliation exceptions. Either online inquiry or a report will provide GL account balance activity for individual banks. Oracle Payables provides several cash requirements reports. Oracle Payables provides an EFT format that meets the EFT file format specifications of the Bankers Automated Clearing House (BACS) for half-inch magnetic media. Application Programming Interfaces (API's) are available that will allow for this type of integration. A properly formatted file is required. Application Programming Interfaces (API's) are available that will allow for this type of integration. A properly formatted file is required. Oracle Payables offers a front-end program that allows for invoice information to be transferred in via EDI ( STERLING ). The file will have to be properly formatted to transfer invoices in. Appendix B. Oracle Payables can use the vendor terms to calculate the appropriate payment due date. Oracle Payables provides a standard cash requirement reports. Oracle Payables allows for recurring payments to be established with the number of periods (payments) along with total amount of payments. Oracle Payables permits partial payment of an invoice. Back posting of an invoice is allowed if the period is open. Forward posting is allowed if the user allows future enterable activity in the selected period. Oracle Payables offers a front-end program that allows for invoice information to be transferred in via EDI ( STERLING ). The file will have to be properly formatted to transfer invoices in. See Appendix B. After the appropriate invoices have been selected for payment, Oracle Payables creates a payment output file. This file can be formatted to print the applicable information onto the remittance advice. The payment output file will be modified to print the applicable information on the remittance advice.

Page 19

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Financials

Accounts Payable Accounts Payable Accounts Payable

4.4.10

Issue manual checks that can be added to a regular check run.

Oracles Payables

4.4.11

Automated journal entries for manually raised checks.

Oracles Payables

4.4.12

Automated posting of accounts payable journal entries to the general ledger.

Oracle Payables

Accounts Payable Accounts Payable Accounts Payable Accounts Payable

4.4.13

Automated general ledger account number verification.

Oracle Payables

4.4.14

Automated 1099 creation and reporting to ensure compliance with Federal Tax Code. On-line entry of vendor credits.

Oracle Payables

Oracle Payables

Drill down capability is available from Oracle General Ledger to Accounts Payable.

Accounts Payable Capital Expenditures

4.4.17

Oracle Payables

The system offers numerous on-line inquiry functions.

Oracle General Ledger

Budgeting can be performed at any level needed.

Capital Expenditures Capital Expenditures Capital Expenditures Capital Expenditures Capital Expenditures

4.5.2

On-line inquiry to A/P detail by check number, date, clearing date (or lack thereof - outstanding checks), payee, and amount. Accounts payable sub-ledger inquiry (by date, invoice, vendor, amount outstanding, and date of pay). Track and maintain capital appropriations budget (projected appropriations by month) at the region, division, and department levels. Enter and track Capital Acquisition Requests (CARs).

Oracle General Ledger Oracle General Ledger

4.5.4

Maintain capital budgets linking them to Capital Acquisition Requests. Record the actual cost against the CAR.

Capital Appropriation Requests can be tracked and maintained by setting them up as capital project budgets. Requirement need to be handled by another application.

Oracle General Ledger

Requirement need to be handled by another application.

4.5.5

Link CARs that are part of the same project.

Oracle General Ledger

Requirement need to be handled by another application.

4.5.6

Oracle General Ledger

Requirement need to be handled by another application.

Financials

Fixed Assets

4.6.1

Oracle Assets

Depreciation projections can be performed at the appropriate level needed.

Financials

Fixed Assets

4.6.2

Automated transfer of information from the CAR to Fixed Assets when the item is received, such as budget group and life. Track and maintain asset depreciation budget (projected depreciation for existing and budgeted assets) at the region, division, and department levels. Ability to split an asset.

Oracle Assets

Financials

Fixed Assets

4.6.3

Ability to restore a previously deleted asset.

Oracle Assets

Financials

Fixed Assets

4.6.4

Track construction projects.

Oracle Assets

Financials

Fixed Assets

4.6.5

Oracle Assets

Financials Financials

Fixed Assets Fixed Assets

4.6.6 4.6.7

Track insurance coverage and insurance value with the associated asset. Track fully depreciated assets. Provide for the unique methods of calculating depreciation (Book, Tax, and State).

Financials

Fixed Assets

4.6.8

Determine depreciation as of a specific date with or without capital budget items.

Oracle Assets

Oracle Assets allows for an assets depreciation expense to be spread across multiple GL accounts. Oracle Assets allows for the capability to reload asset data online if necessary. Assets allows for tracking CIP assets. Assets is fully integrated with Payables and General Ledger to record and track the appropriate activity. Descriptive Flexfields will be established to track the appropriate level of insurance information needed. The Asset system will track fully depreciated assets. Assets allows for unlimited depreciation books to be established. The system provides numerous standard depreciation methods. Oracle Assets provides standard reporting.

Financials Financials Financials Financials Financials Financials Financials Financials Financials Financials Financials Financials Financials

4.4.15 4.4.16

4.5.1

4.5.3

MDE21SM1.xls

Oracle Payables

Oracle Assets Oracle Assets

Further clarification may be required. If a manual check has been issued, why add it to a regular check run? Oracle Payables automatically creates the appropriate GL entries for manual checks. This is a user configurable option. The user can specify when Accounts Payable information updates GL (immediately or as a background process). Account validation and security checking is performed at the time of invoice entry. 1099 information can be printed on hard copy forms or be written to magnetic media. On-line entry of credit information is allowed.

Page 20

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Financials

Fixed Assets

4.6.9

Allocate depreciation across multiple departments.

Oracle Assets

Financials

Fixed Assets

4.6.10

Oracle Assets

Financials

Fixed Assets

4.6.11

Financials

Fixed Assets

4.6.12

Ability to obtain information for Personal Property Renditions. The Purchasing or A/P system must be integrated into the Capital Authorization/Fixed Asset system. Ability to track buyer info when asset is sold or traded in.

Financials

Accounts Receivable Accounts Receivable Accounts Receivable

4.7.1

Allow receivables reports and receivable control accounts to be classified by invoice type. Separate receivables by customer type and product. Yes

Oracle Receivables

4.7.3

Track and report balances for individual and combined accounts.

Oracle Receivables

Accounts Receivable Accounts Receivable Accounts Receivable Accounts Receivable

4.7.4

Allow partial payment of invoices, tracking the remaining balance due. Identify and track discounts by type.

Oracle Receivables

Financials Financials Financials Financials Financials

4.7.2

4.7.5

Oracle Assets

Yes

Oracle Receivables

Oracle Receivables Oracle Receivables

4.7.7

Monitor AR days outstanding by type of sale and type of customer. Aging on demand by due date.

Accounts Receivable Accounts Receivable Accounts Receivable Accounts Receivable Accounts Receivable Accounts Receivable Accounts Receivable

4.7.8

On-line visibility to customers with past-due balances.

Oracle Receivables

4.7.9

Ability to charge interest on overdue accounts.

Oracle Receivables

4.7.10

Automated generation of customer past-due notices.

Oracle Receivables

4.7.11

Initiate order holding for past-due customers.

Oracle Receivables

4.7.12

On-line cash application entry and maintenance (correct application of cash payments). Visibility to payments due in connection with loans via *** Client Name *** Investment Corp. Allow system to process customer payments without an invoice. Payments on account.

Oracle Receivables

Financials

Accounts Receivable

4.7.15

Permit payment for Supply Sales to be collected by driver or deducted from Producer Payroll.

Financials

Accounts Receivable

4.7.16

Financials

Accounts Receivable Accounts Receivable

4.7.17

Generate a credit against the distributor’s balance, when the distributor sells a product to a producer. (The distributor is charged for the product at the time he receives it.) Tracking of supply sales receivable credits.

4.7.18

Permit A/R adjustments for invoices.

Financials Financials Financials Financials Financials Financials Financials Financials

Financials

4.7.6

Oracle Assets

4.7.13 4.7.14

Oracle Receivables

Yes

Oracle Human Resources Oracle Receivables

The Asset system allows you to track who an asset was sold to. Receivables allows for user defined invoice transaction types to be established. The information is available in the system. A custom report will be developed. Receivables allows for unlimited customer relationships to be established. These relationships can be used in cash application and for reporting. Receivables allows partial payments to be entered. The information is available in the system. Custom report will be developed. Information is available through on-line inquiry or reporting. System allows for user-defined aging buckets to be established. Numerous Aged Trial Balance reports can be generated as of a certain date. The system provides several customer and document inquiry screens. The system allows for interest to be charged. The user indicates whether to send a customer dunning letters when invoices have become past due. The user can automatically prevent shipping of products to customers with unacceptable outstanding credit exposure. The system allows for multiple cash application methods, including on-line processing. Note processing and receivable system requirement. When entering cash receipts, the system allows for customer payments to be entered as an on-account transaction.

Oracle Receivables & Alert Oracle Receivables and Oracle Alert can be used to notify a driver to collect payment of Supply Sales. An invoice would be established with COD terms and an ALERT would be established to monitor the transaction. Oracle Alert Oracle Alert would be used to monitor this activity and create the credit against the distributor's balance based on the event. Oracle Receivables Oracle Receivables

MDE21SM1.xls

The Asset system allows for depreciation to be spread across multiple GL accounts and/or multiple departments. Descriptive Flexfields would be defined to track and report on the appropriate Personal Property Renditions required. The Assets system is fully integrated with Accounts Payable.

The system allows for user-defined transaction types to be established. The system allows you to separately adjust different aspects of an invoice.

Page 21

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Financials

Accounts Receivable Accounts Receivable

4.7.19

On-line adjustment capabilities for maintenance within or between customers. On-line write-offs for miscellaneous cash shortages and overages with proper approval for the particular dollar amount. Permit automatic retrieval of lock box information via Cash Management.

Oracle Receivables

Financials

Accounts Receivable

4.7.21

Financials

Financials

Accounts Receivable Accounts Receivable Credit

4.7.22

Ability to print comments on customer statements.

Oracle Receivables

4.7.23

Oracle Receivables

4.8.1

Automated posting of accounts receivable journal entries to the general ledger. Provide a link with D&B for credit history.

Financials

Credit

4.8.2

Means to contact banks and other credit references.

Oracle Receivables

Financials

Credit

4.8.3

Oracle Receivables

Financials

Credit

4.8.4

Record customer's credit history as received from references and credit agencies. Track key customer contact information.

Financials

Credit

4.8.5

Automated initiation of annual credit verification.

Oracle Receivables

Financials

Credit

4.8.6

Record customer's payment terms against his account.

Oracle Receivables

Financials

Credit

4.8.7

Ability to inquire into and report viability of vendors.

Oracle Receivables

Descriptive Flexfields will be established to capture the appropriate information.

Financials

Credit

4.8.8

Oracle Alert

Create Oracle Alert to notify of this situation.

Financials

Credit

4.8.9

Automated notification of customers and/or accounts that need attention. Automated notification of delinquent producer payments.

Oracle Alert

Financials Financials

Credit Notes Receivable Notes Receivable

4.8.10 4.9.1

Oracle ALERT will be used to provide automatic notification based on user specified criteria. Requirement need to be handled by another application. Note Processing and Receivable software or subsystem required. See Appendix B. Note Processing and Receivable software or subsystem required. See Appendix B.

Notes Receivable Notes Receivable Notes Receivable Notes Receivable Notes Receivable Notes Receivable

4.9.3

Financials

Financials

Financials Financials Financials Financials Financials Financials Financials

4.7.20

4.9.2

4.9.4 4.9.5 4.9.6 4.9.7 4.9.8

Oracle Receivables Oracle Receivables

Yes

Oracle Receivables

Track litigation steps for bad debts. Create loans and lines of credit with fixed and variable rates and with fixed and variable payments. Track loans including application and note creation, loan payoff , interest payments, amortization, automatic renewals and taxes. Track open loans.

Yes Yes

On-line support for field report scheduling and document tracking (for large and exception loans). On-line support for revenue tracking by state for loans and notes receivable. Track deductions and payments against loans.

Yes

Apply payments based on a fixed dollar amount deduction/payment or CWT of milk. Keep two months open at the same time.

Yes

Yes Yes

Yes Yes

Yes

MDE21SM1.xls

The system allows for on-line customer maintenance, with complete audit trails of the activity. The system provides the ability to control approvals for receivable adjustments. The system allows you to receive payments directly from a bank in their standard format with customer identification for each payment. The system allows you to define as many statement cycles as needed. The user specifies when Oracle receivables will update the General Ledger. Application Program Interfaces (API's) are available to provide a link with D&B. Appropriate file formats need to be built. Descriptive Flexfields will be established to capture the appropriate information. Descriptive Flexfields will be established to capture the appropriate information. The system allows for unlimited customer contacts to be established. The system provides a standard report, Customer Credit Profile, that can be used to review customer profiles. Individual payment terms can be established for each customer site.

Note Processing and Receivable software or subsystem required. See Appendix B. Note Processing and Receivable software or subsystem required. See Appendix B. Note Processing and Receivable software or subsystem required. See Appendix B. Note Processing and Receivable software or subsystem required. See Appendix B. Note Processing and Receivable software or subsystem required. See Appendix B. Note Processing and Receivable software or subsystem required. See Appendix B.

Page 22

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Financials

4.9.9

Specify credit restrictions.

Yes

4.9.10

Analyze customer accounts by key indicators.

Yes

4.9.11

Track bad debt history.

Yes

4.9.12

Extend or refinance a loan without starting a note.

Yes

Payroll

Notes Receivable Notes Receivable Notes Receivable Notes Receivable Benefits

5.1.1

Date-triggered event notification.

Yes

Oracle - Human Resources

Payroll

Benefits

5.1.2

Yes

Oracle - Human Resources

Payroll

Benefits

5.1.3

Yes

Oracle - Human Resources

Payroll

Benefits

5.1.4

Yes

Oracle - Human Resources

Payroll

Benefits

5.1.5

Yes

Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE.

Payroll

Benefits

5.1.6

Yes

Payroll

Benefits

5.1.7

Payroll

Benefits

5.1.8

Payroll

Benefits

5.1.9

Payroll

Benefits

5.1.10

Payroll

Benefits

5.1.11

Payroll

Benefits

5.1.12

Automated calculation of death, disability, and deferred/late retirement benefits. Track and report benefits plan eligibility and participation in annual benefits statements. Automated generation of form letters (termination, insurance, 401K, retirement, disability, workman’s compensation) to employees, insurance carriers, and disability/workman’s compensation physicians. Automated generation of form letters and mailing labels off the vendor master list for use with Affirmative Action and Certificates of Insurance. Automatic payroll deduction for 401K and insurance with online access to the deduction information. On-line access to insurance, 401K, retirement, and disability benefit information. Automated response system that allows employee phone inquiries into personal benefit information. Automated report routing based on transaction (such as employee status updates). Track the deposit schedule and ensure that it meets federal requirements. Track employee gender and race statistics to ensure antidiscrimination law compliance. Generation of EEOC and other government reports.

Payroll

Benefits

5.1.13

Yes

Payroll

Benefits

5.1.14

Aggregate reporting capability (county being the lowest aggregate level) for EEOC reports. Maintain DOT Qualification Files.

Payroll

Benefits

5.1.15

Payroll

Benefits

5.1.16

Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE.

Payroll

Benefits

5.1.17

Payroll

Benefits

5.1.18

Financials Financials Financials

Yes Yes Yes Yes Yes Yes

Yes

Tracking and notification of regulatory updates (DOT, Yes OSHA, etc.). On-line employee history (time, attendance, position Yes eligibility, certification, training, and drug test data) tracking. Provide the capability to administer a drug-testing program and track the results. On-line driver maintenance, data acquisition, and tracking.

Yes Yes

MDE21SM1.xls

Note Processing and Receivable software or subsystem required. See Appendix B. Note Processing and Receivable software or subsystem required. See Appendix B. Note Processing and Receivable software or subsystem required. See Appendix B. Note Processing and Receivable software or subsystem required. See Appendix B. To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE.

Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE.

Page 23

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Payroll

Benefits

5.1.19

Yes

Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE.

Yes

5.1.21

On-line Special Plan Account (SPA) processing and insurance cost tracking for insured employees and spouses. Include both insured and uninsured losses. Continue insurance coverage into retirement with automatic billing capabilities. On-line visibility to upcoming COBRA activity.

Payroll

Benefits

5.1.20

Benefits

5.1.22

Track bonding.

Yes

Payroll

Benefits

5.1.23

Yes

Payroll

Benefits

5.1.24

Coordinate and track claims through a third party claims processor. Track lawsuits.

Payroll

Benefits

5.1.25

Yes

Payroll

Benefits

5.1.26

Payroll

Benefits

5.1.27

Payroll

Benefits

5.1.28

Calculation of frequency and incident rates based on loss, general ledger, mileage, and man-hours. On-line processing and tracking of checks for insurance carrier. Support employee 401K participation including employee enrollment, participant maintenance, balance reallocation, participation suspension, and employee termination. 401K company matching.

Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE.

Payroll

Benefits

Payroll

Payroll

Benefits

5.1.29

Payroll

Benefits

5.1.30

Allow 401K hardship withdrawals and loans (amortization Yes calculation, loan note creation, and payroll deduction setup). Automated monthly transfer to trust company. Yes

Payroll

Benefits

5.1.31

Track monthly withdrawal distributions.

Yes

Payroll

Benefits

5.1.32

Automated balancing of 401K numbers with regions.

Yes

Payroll

Benefits

5.1.33

Yes

Payroll

Benefits

5.1.34

Payroll

Benefits

5.1.35

Track employee retirement eligibility and contributions including disabled employees approaching retirement. Calculate retiree benefits, determining vestment category based upon length of employment. Generate retirement checks.

Payroll

Benefits

5.1.36

Yes

Payroll

Benefits

5.1.37

Payroll

Benefits

5.1.38

Track disability and workman’s compensation claims including physician verification. Monitor employee disability status for continued benefit eligibility. Generate disability checks.

Payroll

Benefits

5.1.39

EDI to insurance carriers.

Yes

Payroll

Benefits

5.1.40

Load the Bureau of Labor Statistics Census Data Tape.

Yes

Payroll

Benefits

5.1.41

Yes

Payroll

Benefits

5.1.42

Automated Wyatt Eligibility/Ineligibility file creation and EDI capabilities for claims processing and actuary services. Retain 5 years of employee history and a lifetime medical history.

Yes

Yes

Yes Yes Yes

Yes Yes

Yes Yes

Yes

MDE21SM1.xls

Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE.

Page 24

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Payroll

Employee Payroll

5.2.1

Payroll

Employee Payroll Employee Payroll Employee Payroll Employee Payroll Employee Payroll Employee Payroll

5.2.2

Employee Payroll Employee Payroll Employee Payroll Employee Payroll Employee Payroll

5.2.8

Employee Payroll Employee Payroll Employee Payroll Employee Payroll Employee Payroll Employee Payroll

5.2.13

Employee Payroll Employee Payroll Employee Payroll

5.2.19

Payroll Payroll Payroll Payroll Payroll Payroll Payroll Payroll Payroll Payroll Payroll Payroll Payroll Payroll Payroll Payroll Payroll Payroll Payroll

5.2.3 5.2.4 5.2.5 5.2.6 5.2.7

5.2.9 5.2.10 5.2.11 5.2.12

5.2.14 5.2.15 5.2.16 5.2.17 5.2.18

5.2.20 5.2.21

Provide central data repository for data entry and viewing by Yes payroll, human resources, and Corporate Office personnel, with security access as necessary and inquiry-only capabilities where appropriate. Complete, easy to use documentation and customer Yes service/user support. On-line personnel file maintenance including set up of new Yes employees. On-line employee status (active, laid-off, quit, etc.) tracking. Yes

Oracle - Payroll

The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials.

Oracle - Payroll

On-line training and development tracking, including licenses and certifications. On-line job description and review including historical tracking of job reviews. On-line compensation tracking, including salary history and multiple account capability for labor and cost center distribution. On-line staff tracking, including new hire processing, termination processing, and succession planning. Automated collection and processing of hours from divisions.

Yes

Oracle - Payroll

Yes

Oracle - Payroll

Yes

Oracle - Payroll

The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials.

Yes

Oracle - Payroll

Yes

Oracle - Payroll

Track vacation accrual and ability to customize the accrual calculation. Process and track vehicle income (personal use of company car). Track and maintain employee payroll budget (total payroll expense by location), providing summaries at the region, division, and department levels. Support salaried, hourly, sliding scale, piece work, and commission based employee wages. Ability to assign an individual more than one pay rate.

Yes

Oracle - Payroll

Yes

Oracle - Payroll

Yes

Oracle - Payroll

Yes

Oracle - Payroll

Yes

Oracle - Payroll

Automated calculation and tracking of Texas division driver Yes pay. Calculate and track employee commissions. Yes

Oracle - Payroll

Automated payroll deductions (W-2 and benefits) authorization and tracking. Process and track the cafeteria plan and section 125 information, including tracking new forms filled out by employees each year. On-line processing and tracking of pension, insurance, and union dues. On-line processing and tracking of all assignments out of paychecks. On-line processing and tracking of payroll deposits including check generation/direct deposit (FICA, Federal Withholding, Medicaid, Health Insurance, State & County Taxes (weekly), and W2 Creation).

Yes

Oracle - Payroll

Yes

Oracle - Payroll

Yes

Oracle - Payroll

Yes

Oracle - Payroll

Yes

Oracle - Payroll

MDE21SM1.xls

Oracle - Payroll Oracle - Payroll

Oracle - Payroll

The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials.

Page 25

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Payroll

Employee Payroll Employee Payroll Employee Payroll Employee Payroll Employee Payroll Employee Payroll Employee Payroll Employee Payroll Employee Payroll

5.2.22

Tracking of retirement allocations/accruals.

Yes

Oracle - Payroll

5.2.23

Calculation, payment, and tracking of unemployment tax.

Yes

Oracle - Payroll

5.2.24

Calculation, payment, and tracking of annual county tax.

Yes

Oracle - Payroll

5.2.25

Yes

Oracle - Payroll

Yes

Oracle - Payroll

Yes

Oracle - Payroll

5.2.28

Automated processing of corporate payroll twice monthly, automatic check generation. Automated check generation to pay hourly and salaried employees. On-line processing and tracking of check requests (automated generation of checks). Provide capability to run multiple payrolls on demand.

Yes

Oracle - Payroll

5.2.29

Support 1700 bi-weekly checks.

Yes

Oracle - Payroll

5.2.30

Yes

Oracle - Payroll

Payroll

Employee Payroll

5.2.31

Yes

Oracle - Payroll

The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials.

Payroll

Employee Payroll

5.2.32

Yes

Oracle - Payroll

The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials.

Payroll

Employee Payroll

5.2.33

Yes

Oracle - Payroll

The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials.

Payroll

Employee Payroll Employee Payroll Employee Payroll Employee Payroll Employee Payroll Employee Payroll

5.2.34

Yes

Oracle - Payroll

5.2.35

On-line processing and tracking of checks, including check creation, check register maintenance, and other check reports generation. Provide flexible viewing and reporting of payroll, and human resources, including ability to sort on any personnel data, current, and history. On-line generation of standardized and easily accessible reports related to employee demographic data and employment history, compensation, benefits administration, OSHA, Workers Compensation, IRS, etc. On-line report writer that allows custom reporting capabilities, form letters, merge functions and import/export capabilities to word processing or spread sheet software. Automated report of Weekly Payroll Liability - Deposit Summary Schedule. Provide the ability to execute retirement check run.

Yes

Oracle - Payroll

5.2.36

Provide a special report format for Iowa.

Yes

Oracle - Payroll

5.2.37

Yes

Oracle - Payroll

Yes

Oracle - Payroll

Yes

Oracle - Payroll

Employee Payroll Employee Payroll Employee Payroll

5.2.40

Integration of payroll and automated time clock package with on-line and reporting capabilities. Process and track 1099s. Identify exceptions which do not require a TIN and validate TIN entries for all other cases. On-line government mandated reporting, including I-9 compliance/verification, EEO/Affirmative Action, OSHA & Workers Compensation, Vets-100 reporting, COBRA, and Form 5500. On-line safety tracking, including integration with the government compliance reporting. Automated generation of State Department Of Labor Reports. (Minnesota, Wisconsin, Texas) Tracking of W2 Balance and W2 register.

The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials.

Yes

Oracle - Payroll

Yes

Oracle - Payroll

Yes

Oracle - Payroll

Payroll Payroll Payroll Payroll Payroll Payroll Payroll Payroll

Payroll Payroll Payroll Payroll Payroll

Payroll Payroll Payroll

5.2.26 5.2.27

5.2.38 5.2.39

5.2.41 5.2.42

MDE21SM1.xls

The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials.

The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials. The Oracle Payroll System can meet this functional requirement and integrate to Oracle Financials.

Page 26

FUNCTIONAL GAPS/TRADE-OFF ANALYSIS Payroll

Labor Reporting 5.3.1

On-line labor relations tracking.

Yes

Payroll

Labor Reporting 5.3.2

Automated labor data acquisition by product and operation.

Yes

Payroll

Labor Reporting 5.3.3

On-line data tracking for state labor reporting.

Yes

Payroll

Labor Reporting 5.4.1

Payroll Payroll Membership Services Membership Services Membership Services Membership Services Membership Services Membership Services Membership Services Membership Services Membership Services

Expense Claims Expense Claims Membership Services Membership Services Membership Services Membership Services Equity Accounting Equity Accounting Equity Accounting Equity Accounting Equity Accounting

On-line EPA, loss control, and worker's compensation inquiry Yes capabilities by product, operation, and classification. Process and track expense reports. Process bi-weekly expense reports. On-line maintenance of member information. Yes

5.4.2 5.4.3 6.1.1

On-line support for field service personnel scheduling and activity tracking (including member contacts). Provide ability to track producer activity for starts, quits, transfers, etc. Provide multiple pricing schemes and delivery points for a single producer. On-line member equity maintenance and inquiry capabilities.

Yes

Yes

6.2.3

Automated calculation of amounts for annual repayment of equity positions. Automated generation of equity payment checks.

6.2.4

Support open loans.

Yes

6.2.5

Interface from producer payroll to feed equity calculation.

Yes

6.1.2 6.1.3 6.1.4 6.2.1 6.2.2

Yes Yes Yes

Yes

MDE21SM1.xls

Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracle - Human Resources To be satisfied in Phase III, Installation of Oracle HR / PAYROLL SOFTWARE. Oracles Payables Oracle Financials. Oracles Payables Oracle Financials. To be satisfied in the MEMBERSHIP SERVICES CUSTOMIZATION. To be satisfied in the MEMBERSHIP SERVICES CUSTOMIZATION. To be satisfied in the MEMBERSHIP SERVICES CUSTOMIZATION. To be satisfied in the MEMBERSHIP SERVICES CUSTOMIZATION. To be satisfied in the MEMBERSHIP SERVICES CUSTOMIZATION. To be satisfied in the MEMBERSHIP SERVICES CUSTOMIZATION. To be satisfied in the MEMBERSHIP SERVICES CUSTOMIZATION. To be satisfied in the MEMBERSHIP SERVICES CUSTOMIZATION. To be satisfied in the MEMBERSHIP SERVICES CUSTOMIZATION.

Page 27