MillerCoors

3rd Party Freight Payment

Carrier

Desktop Guide

Outbound Beer Shipments FROM or Dunnage Return Shipments To:

Golden, CO

Elkton, VA

Camp Hill, PA

Portland, OR

Monee, IL

Inbound Truckload Supplies TO:

Golden, CO and Elkton, VA

February 2011

Table of Contents

TOPIC / PAGE
Overview / 3
Payment Terms / 4
Submitting Invoices for Payment / 4
D2L Payment Address / 4
Invoice Check List / 4
Fuel Surcharge / 5
Multi-stop Shipments / 5
Detention Charges / 5
Other Accessorial Charges / 6
Miscellaneous Invoices / 6
Balance Due or Corrected Invoices / 6
Commonly Asked Invoicing Questions / 7
Finding the Bill of Lading Number / 10
Finding the Equipment Type Using MillerCoors Event Manager System / 11
Checking Invoice and Payment Status—Accessing D2L’s Web Carrier Portal / 12
Submitting New Rate Information / 14
Contact Information—D2L, MillerCoors, RMBC / 15
Appendix: Fuel Surcharge Addendum (Effective April 27, 2009) / 16

Overview

•Data2Logistics (D2L) pays freight invoices on behalf of:

– MillerCoors

•beer and return dunnage shipments originating at or destined to one of the Coors supply chain facilities:

•Golden, CO

•Elkton, VA

•Camp Hill, PA

•Portland, OR

•Monee, IL

•inbound truckload supplies destined to:

•Golden, CO

•Elkton, VA

–Rocky Mountain Bottle Company

Note: Beer and return dunnage shipments originating at or destined to a Miller supply chain facility will be paid through the existing channel, not by D2L.

• MillerCoors Payment Terms:

–payment cycles through Data2Logistics areNet 30

–payments are processed weekly to increase your ability to manage your cash flow

–payment will be based on the invoice date, not the ship date

–fuel surcharge calculations are based on the Ship Start Date (carrier pickup date)

•Submitting Invoices to D2L

–invoices will be submitted to Data2Logistics, not MillerCoors

–invoices may be mailed to D2L or submitted electronically

–specific information is required for all invoices (achecklist is included along with information on where to obtain key information)

–fuel surcharge addendum is attached

–accessorial charges (except for fuel surcharges) are invoiced separately from the line haul charge via paper invoices (LTL and Parcel are exempt)

•Checking Invoice and Payment Status

–Data2Logistics web-based carrier portal provides information regarding the status of an invoice or a check

–24/7 access to information

•Submitting New Rate Information

–new rates must be submitted to MillerCoors. (Please do not submit rates to Data2Logistics as they can only accept rates from MillerCoors.)

–rates must be submitted on company letterhead, include specific information and be signed

•Contact Information for Data2Logistics, MillerCoors and RMBCis provided

Payment Terms

Carriers are paid weekly on a Net 30 basis from the date of invoice. The fuel surcharge is calculated as of the Ship Start Date (carrier pickup date) rather than the invoice date.

Submitting Invoices for Payment

Mail Invoices to Data2Logistics

Submit using electronic transfer only if set up with Data2Logistics –

[Please Contact Clare Langmacher at MillerCoors with questions]

MillerCoors Invoice Check List

Please ensure your invoice contains the following information:

Name of company being billed (c/o Data2Logistics)
Bill of Lading Number
Purchase Order Number (all shipments that are not beer or return dunnage)
Invoice Number
Invoice Date
Sender Name and Address
Receiver Name and Address
SCAC by which Coors system identifies your company
Commodity Description (describe what is being shipped e.g. beer, barley, insulated blankets, yeast) / Equipment Type (beer and return dunnage shipments only)
Trailer Number or Car Number
Line Haul Rate
Fuel Surcharge
Rate and Class (e.g. class 70) for LTL
Weight
Discount
Customer Reference/Notes
Total Amount Due

Please submit an invoice that includes only the following two line items:

1) line haul charge and

2) fuel surcharge (if applicable)

Line items for other charges must be submitted on a separate paper invoice.

Please ensure you have included the Bill of Lading Number and the Purchase Order Number (if necessary). This information is required for processing your invoice.

Fuel Surcharge

Fuel surcharge amounts are calculated using the MillerCoors Fuel Surcharge Addendum. A copy of the Fuel Surcharge Addendum effective April 27, 2009 is located in the Appendix section of this document.

The carrier pickup date, which is the “Ship Start Date” in the MillerCoors system, is the date that is used for calculating the appropriate fuel surcharge amount.

The fuel surcharge should be included as a line item on the invoice for the freight line haul charge. Other accessorial charges must be invoiced separately and submitted using paper invoice.

Multi-stop Shipments

To Invoice for Multi–stop Shipments (if applicable) include the following additional information:

Stop off name and address information

Stop Charge

Out of route miles

Mileage for MillerCoors beer/dunnage shipments is calculated based on the Rand McNally v19 HHG Practical Miles.

Detention Charges

To Invoice for Detention include:

Type of detention charge (beer and dunnage shipments)

  • Detention at Plant
  • Detention at DC
  • Detention at Distributor

Site of detention

Appointment time

Arrival time

Departure Time

Total time at stop

Amount of detention charge for each location

Invoices for detention charges must be submitted using a separate paper invoice.

Other Accessorial Charges

Accessorial charges must be invoiced on a separate paper invoice from the invoice for the line haul charge and the fuel surcharge. Each charge should be a separate line item.

Miscellaneous Invoices

An invoice for a miscellaneous charge based on a special arrangement with MillerCoors such as trailer rental, repairs, cross-docking services or other special programs should be mailed (paper invoice) to Data2Logistics with sufficient information to be processed and approved.

Balance Due or Corrected Invoices

Balance due or corrected invoices should be mailed, faxed or emailed to Data2Logistics. Please do not submit corrections or balance due invoices electronically (EDI). If you are disputing a claim, please provide all supporting documentation along with the balance due or corrected invoice. Please indicate on the invoice whether it is a balance due or a correctedinvoice, and be sure to include the original invoice number and the bill of lading number or purchase order number, if applicable.

Commonly Asked Invoicing Questions

Why do we need a Bill of Lading number on an invoice?

MillerCoors uses the Bill of Lading (BOL) Number instead of Shipment Number for Invoicing (Beer and Return Beer Dunnage Carriers). Using this number provides a unique identification number for each shipment allowing us to assure that all billing is correct.

How do I get the BOL number?

The BOL number (MillerCoors “Delivery #” is available in these locations:

  • Bill Of Lading the driver receives when he picks up the load. (see example on Page10)
  • “24 Hour Ship Start Report” – a daily report sent to each carrier via email in .pdf format for loads that have “ship started” the prior day
  • MillerCoors Event ManagerSystem – delivery number is shown in the “Detailed Information” once the shipment has been picked up by the carrier

How do I get the BOL into my billing system?

We suggest that you either have the driver call it in or punch it into your satellite system when he picks up the load.

Will I get paid without the BOL?

No - You will not get paid unless the D2L system can match your invoice to an actual shipment sent from MillerCoors. You must supply the BOL number to allow the system to make this match.

Why does Coors need the Equipment Type?

One of the components of the invoice matching process is that the MillerCoors Equipment Type matches the equipment that was requested. We use it to ensure that we are paying the correct rate.

How will I get the equipment type?

The equipment type is available in the following documents or sites:

  • Bill of Lading (see example on Page 10)
  • Tenders
  • MillerCoors Event Manager system in the shipment details (see example on Page 11)
  • EDI 204 (carriers receiving electronic tenders)
  • “24 Hour Ship Start Report”

What are the terms of payment for MillerCoors shipments paid by D2L?

We pay you weekly on a Net 30 basis from invoice date.

How can I check on the status of invoices that I have submitted?

Data2Logistics provides an easy way to check the status of your invoices or your payment by accessing their website. The system is available 24 hours a day, 7 days a week. Should you need additional information, you can contact the account representative assigned to the MillerCoors account.Information on accessing the D2L website can be found onPage12 and D2L contact information is located on Page15.

Can I bill my detention electronically?

No. All detention, accessorial and miscellaneous invoices must be submitted separately from the invoice for the line haul charge and the fuel surcharge using paper invoices. Detention invoices require specific information. (see Page 5)

Should I include accessorial charges with my line haul and fuel surcharge bills?

No - All accessorial charges (other than fuel) need to be submitted as separate invoiceline items. They cannot be included with line haul rate. This is to ensure that the carrier payment for the line haul is not held up due to accessorial approval. This ensures that you get paid on time.

What are the contractual requirements around time to clear up balance dues?

Our request is that all balance dues are cleared up within 180 days of the pickup date of that load. This helps both of us ensure that our books are kept up to date.

Please do not wait until year end to reconcile your account. All claim disputes should be addressed in a timely manner.

Should I change my “Bill to” Names now that I am doing business with D2L?

DO NOT change your bill to names for invoices going to Data2Logistics. The bill to name is a key field for processing invoices and they need to remain as they have always been.

The correct “Bill to” names for are:

“MillerCoors” for Outbound Beer, Return kegs/dunnage and Inbound Packaging Supplies

“Rocky Mountain Bottle Company” or “RMBC” for bottle shipments

How do I bill Multi-stop shipments?

Multi stop shipments should be billed electronically (if you are communicating electronically with D2L) to Data2Logistics. Be sure to include line items for extra stops and out of route miles according to your current contract with MillerCoors or the Rocky Mountain Bottle Company. If you are not communicating electronically, send paper invoices for multi-stops.

How do I bill miscellaneous charges that don’t fit a standard category?

Any miscellaneous charges such as trailer rental, repairs or special programs that you have arranged with MillerCoors should be sent to Data2Logistics on a paper invoice with sufficient description to be processed and approved.

What is the most common reason an invoice is rejected by D2L?

The most common reason that an invoice gets rejected is that it is missing critical information—especially

  • Bill of Lading Number and/or
  • Purchase Order Number for shipments other than beer or return dunnage

Finding the Bill of Lading Number

Below is a standard Bill of Lading for a beer shipment with the BOL number identified.

Finding the Equipment Type Using MillerCoorsEvent Manager System

1. Go to transportation visibility, and enter the shipment number you are searching for.

2. Click the search button on the bottom of the page.

3. You will find the equipment type listed in the shipment details.

Checking Invoice or Check Status: Accessing theData2Logistics Web Carrier Portal

The Data2Logistics website can be utilized to check the status of an invoice or the status of a check for MillerCoors and RMBC.

  1. Go to

2. Select Payment and Shipment Tracking

3. Select either Pro/Airbill# or Check# depending upon the nature of your query

4. Either enter the data or copy and paste from another data source (see instructions link on page for formatting)

  • For Truckload or Rail shipments, enter the invoice number that was submitted to D2L

5. The range of possible results for each type of query is listed below.

Pro/Airbill# (Invoice) Inquiry:

  • In Process – D2L has received the invoice and currently running it through their system.
  • Not in System – D2L processes new invoices nightly. If you believe that it has been submitted, please wait one day and check again before calling the helpdesk, the invoice may be loaded during batch processing that night.
  • Run#, Check#, Check Date, Check Amount – This invoice is already part of a payment run and you should receive the check at the expected time.

Check #

  • Carrier Paid, Amount, Check Date and Invoices/Airbills included on the check

Submitting New Rate Information

Domestic Rate Changes

When submitting new domestic rate information to MillerCoors please include the following information, signed, on your company letterhead:

SCAC
Origin
Destination
Effective Date
Expiration Date / Mode
Equipment Type
Rate
Rate Type

All rates must be submitted on company letterhead and must be signed.

Please do not submit rates to Data2Logistics. Data2Logistics can only accept rates from MillerCoors.
Contact Information

Data2Logistics

For payment or billing issues, please contact Data2Logistics:

1.Bethany Peters, Account Coordinator

(801) 287-8540

2. Mike Stack, Client Relationship Manager

801-287-8422

MillerCoors

Diana Barnett, Manager, Compliance & Rates

Diana Barnett

414-931-6878

Logistics Analyst

Emily Gebhardt

303-277-5047

Logistics Analyst

Amy Parker

414-931-2372

Rocky Mountain Bottling Company (RMBC)

Barb Goberis, Manager, Materials

303-425-7937 (office)

Appendix: Fuel Surcharge Addendum

1