V2.1 Product Ordering & Inventory Net Tool User Manual
Contents
1. 014150 AL HUNTSVILLE Supreme Beverag 2100 a Jackson Order Status Reports Niew submitted and frozen orders Demand Fulfillment by Product Number View actual shipments against order sorted by product number Orders by Order Number View requested scheduled or shipped orders sorted by order number Orders by Product Number View requested scheduled or shipped orders sorted by product number All rights reserved Copyright 2002 Coors Brewing Company Golden Colorado 80401 Molson POINT Report Options There are three different reports that may be generated with Molson POINT e Order Status Reports A snapshot view of submitted and frozen orders e Demand Fulfillment by Product Number Displays quantity ordered versus actual shipments by product number e Orders by Order Number Requested scheduled and shipped orders sorted by Order Number e Orders by Product Number Requested scheduled and shipped orders sorted by Product Number Note If a distributor has assigned their own product number to a Molson product using Product Preferences the system will sort products by the distributor product number ACTION FIELD NAME 1 Click On the report name to generate the link is blue and underlined 2 View Report online or print by clicking the print icon on the browser s toolbar Page 36 of 42 2 MOLSON Molson POINT Reports USER MANUAL Order St2. 24 0 o o 49 11 29 0 12 o 0 7 Last Week ae Ra CLR EE 2 50 12 06 o 122 12 122 2 5 Forecast Weeks 51 12 13 33 0 2 919 7 5 52 12 20 o 8491 59 876 69 6 1 12 27 0 40 000 19 876 62 6 2 01 03 0 19 821 55 6 d 3 01 10 0 17 640 37 461 73 2 4 01 17 0 38 469 67 6 5 01 24 0 E 38 469 60 6 6 01 31 0 38 469 53 6 Actual Weeks last52 tast8 100 096 100 096 SID GD ENS All rights reserved Copyright 2002 Coors Brewing Company Golden Colorado 80401 ae ae The Forecasting and Inventory Worksheet brings all the information together on one page It is the best place to plan volatile products This is because the distributor can view sales arrivals inventory forecasts and orders all on the same page Note Actual sales ending inventory and all forecasts must be entered before Projected Inventory and DOI will be calculated correctly Note Orders must be saved on the Order page for distributors to receive an order An order indicates that an order has been created and saved Page 26 of 42 MOLSON Molson POINT Forecasting and Inventory Worksheet USER MANUAL Forecasting and Inventory Worksheet continued Terms Descriptions CBC Week Week number on the Molson USA calendar Monday Date Monday date corresponding to the week Prior Year Sales Reported sales remo
3. All rights reserved Copyright 2002 Coors Brewing Company Golden Colorado 80401 The Demand Fulfillment by Product Report displays quantity ordered versus actual shipments by product number Column Description Distributor The distributor assigned product number from the Distributor Product Product Preferences page Molson Product Unique Molson product number Prod Descr Description of the product Order Non intelligent number generated when the order is created Distributor PO Distributor assigned Purchase Order number during order submission Order Due Date Date the order is frozen Quantity Ordered Quantity of the product on the order Actual Shipment Quantity of the product on the actual shipment Order vs Actual Variance Variance between the quantity ordered and the planned shipment quantity Page 38 of 42 MOLSON Molson POINT Reports USER MANUAL Orders by Order Number Report HELP LOG OUT PREFERENCES Arrivals Gales 8 Inv Forecasts orksheet Orders Reports M 062250 DENVER Coors Distribut 5400 Test Pecos Orders by Order Number 062250 Coors Distributing Companys Run Date 11 26 2002 04 56 Requested Orders By Order amp 0020001174 os died Molson Gldn 24 120z 6PK Jackson DC 12 05 2002 DIST10052 LNNR DIST18161 Canadian 24 120z 6PK LNNR Scheduled or Shippe
4. e Internet Orders e Manual Orders e Manual Third Party Order Status Displays current order status Page 37 of 42 MOLSON Molson POINT USER MANUAL Reports Demand Fulfillment by Product Report HOME HEIP LOG OUT PREFERENCES ff Arrivals Sales amp Inv Forecasts Toc HX Reports Distributor D10140 AL MONTGOMERY Allstate Bevera Rd SI I 010141 AL DEMOPOLIS Allstate Bevera 2760 Highway 43 v Demand Fulfillment By Product 010141 Allstate Beverage Company Inc Run Date 12 13 2004 10 03 11 11313 Molkom Mie 2221298 TLSE 4025059311 12 13 2004 851 849 2 22 12230 Molson Exel 24 1202 6pk Dep 0020059181 kll 12 13 2004 7 056 7 056 0 66 12923 Molson Golden 1 4 Keg M 0020059287 12 13 2004 500 499 s1 12965 Molson Golden 24 12oz 12pk Can 0020059287 12 13 2004 4 080 4 080 0 12976 Molson Golden 24 1202 24pk Can 0020059287 12 13 2004 5 400 5 400 0 16215 Molson Ice 24 120z 12pk Can 0020059166 test30novi 12 13 2004 6 000 6 000 0 16251 Molson Ice 18 120z 18pk Can 0020059287 12 13 2004 8 400 8 400 0 16269 Molson Ice 12 400z LNNR 0020059287 12 13 2004 3 375 3 374 EH 16278 Molson Ice 12 21 4 12pk Btl 0020059287 12 13 2004 2 380 2 880 0 0020059301 Order 12 13 2004 640 640 43 18157 Canadian 24 120z 12pk LNNR 0020059146 test29nov3 12 13 2004 8 400 8 400 0 0020059165 test30nov 12 13 2004 16 800 16 799
5. 2 Enter Previous weeks Sales 3 Enter Previous weeks Inventory 4 Click Save button at the bottom of the page Note Distributors should only report their sales to retail and other customers Do NOT include sales to other wholesalers or damaged or out of date product removed from inventory Page 24 of 42 MOLSON Molson POINT Forecasting USER MANUAL Forecasting HOME HELP LOG OUT PREFERENCES f Arivals Gales amp inv ff Worksheet Orders Reports 014151 AL BIRMINGHAM Supreme Beverag 014150 AL HUNTSVILLE Supreme Beverag 2100 a Jackson Reporting for Week Number 50 Mm 00 eee C UM wi mu mr ok mos ms 11357 Canadian Light 24 1202 6pk LNNR 52225 18157 Canadian 24 1202 12pk LNNR 52215 18161 Canadian 24 1202 6pk LNNR sss 5 5 J E EL All rights reserved Copyright 2002 Coors Brewing Company Golden Colorado 80401 Forecasting Step by Step ACTION FIELD NAME 1 Enter Forecasted Sales quantities for each product code for each of the 8 weeks into the future Note This data feeds the corresponding Distributor Sales Act Forecast field in the Forecast and Inventory Worksheet If data is changed in either of these Pages the change will flow through to both Pages 2 Click Save button to record forecasts Forecasting Tips The most important aspect of becoming a better forecaster i
6. e Within any page click on Help located in the upper portion of the page to receive on line help documentation e Within any page click on Preferences located in the upper portion of the page to change default or previously set preferences e When moving within fields use the TAB key e All standard input fields are outlined in RED e The Message area of the home page will indicate any system messages such as downtime that you need to be aware of Please refer to the Message area often e Click on the large tabs to reach a specific page e SAVE Buttons are located on the bottom of the pages You may have to scroll down to display them Page 13 of 42 Ln MOLSON Home Page Molson POINT USER MANUAL Data Input Process The order that data is entered into the Molson POINT tool is extremely important As Molson POINT calculates expected inventories and DOIs the current inventories removals and arrivals must be entered prior to visiting the worksheet or order pages Note Any orders that have NOT arrived will be considered In Transit Data Input Process Step by Step Step 1 What has already happened e What shipments have been received Arrivals page e What you sold last week Sales amp Inventory page e What your inventory is at the end of the week Sales amp Inventory page Step 2 What do you plan for future weeks e Forecasted to sell Forecasts page Step 3 What products do you want to or
7. If the user does not enter a file name upload ERROR Please select at least one field to upload Sales and or Inventory If the user fails to select any of the fields available for upload Validation of uploaded file ERROR MESSAGE DESCRIPTION Line is too long If the file contains lines rows that are shorter than the specified file format Line is too short If the file contains lines rows that are longer than the specified file format Material Number does not exist for this location If the line row contains a Product code that the distributor is not segmented to receive Record type is invalid If the line row contains a record type code that is not a valid record type Sales Qty is not in proper format If the line row contains a sales quantity value that does not contain valid characters Inventory Qty is not in proper format If the line row contains an inventory quantity value that does not contain valid characters The file you uploaded is not in proper format If the file uploaded was not in a format that the system could not recognize The uploaded file was empty If the file uploaded did not contain any values Page 21 of 42 MOLSON Arrivals Page Molson POINT USER MANUAL Arrivals Page HOME HELP LOG OUT ee a C ee PREFERENCES f Gales amp inv Forecasts Worksheet Orders f Reports tor 0107
8. Product Preference View Preferences Paging Preference CYes No All rights reserved Copyright 2002 Coors Brewing Company Golden Colorado 80401 The Preferences page allows the distributor to customize Molson POINT Preference Description of Historical Weeks Preference setting to control the number of historical weeks displayed in Worksheet displayed in the Worksheet Screen Screen of Historical Days displayed Preference setting to control the number of days after a in Arrivals Screen shipment has been received it will be displayed on the arrivals page of Historical Days displayed Preference setting to control the number of historical days in Reports displayed on the reports page Distributor Product Preference Update the sequence and distributor assigned product codes Paging Preference Only 10 products per page will be displayed to increase download speed Note Remember to click the Save button after editing the preferences and before exiting the Preferences page Changes to the preferences will not be recorded unless the Save button has been clicked Page 16 of 42 MOLSON Molson POINT Preferences USER MANUAL Distributor Product Preference Page HOME HELP PREFERENCES Molson Golden 24 1202 12pk Can Molson Golden 24 1202 12pk LNNR Molson Golden 24 1202 6pk LNNR Molson Golden 1 2 Keg T Molson Ice 24 120
9. Req Ship Date from the drop down list Continue button Distributor Ship To and Ship from location Product number to be ordered Number of Pallets in the red outlined field Load Weight and Total Pallets do not exceed one truckload Save button Order Number Page 32 of 42 2 MOLSON Molson POINT Orders USER MANUAL Change Existing Order HELP LOG OUT Arrivals Gales amp Inv Forecasts orksheet Orders Reports EE MOLSON 062250 CO DENVER Coors Distribut hd 062250 CO DENVER Coors Distribut 5400 Test Pecos Order Action 218 Distributor PO 062250 49 Previous Orders 40020001174 12 05 2002 PO amp 062250 49 1 x Ship From Location jackson DC z Req Ship Date 12 09 2002 All rights reserved Copyright 2002 Coors Brewing Company Golden Colorado 80401 Selecting Change Existing Order from the Order Action drop down list will display the following fields Fields Description Distributor PO Distributor assigned Purchase Order number Optional Previous Orders Displays previous orders entered by the distributor that are not frozen and can be changed Ship From Location Displays Direct for orders sourced from a Molson Canadian manufacturing facility Otherwise the Ship From Location field will display the name of the warehouse from which the order will ship Requested Ship Date Date the order is
10. aua aaa au aaa 35 RODOFTS RRRRNERRERFARARARRKEREKRSE FE FRE SERE AVEEERKREEFRSENEKEREKEEFEFERI FERKEMRRNE 36 SUIBDON nasi salad dao ERR REESE RR RRRREEREREERREIEKEXRRRRR 41 Appendix A Upload File Format 1 ree ies aan aaa nau aan aan aua aaa aa p aua 42 Page 3 of 42 MOLSON Overview Molson POINT USER MANUAL This page left intentionally blank Page 4 of 42 MOLSON Molson POINT Overview USER MANUAL Objectives Overall Objectives e This document provides the process and information to utilize the Molson POINT tool effectively Detailed Objectives e Describe the MUSA beer ordering process e Describe the background and purpose of Molson POINT e Logon to CoorsNet e Access and navigate Molson POINT e Perform an Upload optional e Report Arrivals e Report Sales and Inventory e Forecast for up to 8 weeks in advance e Enter new orders e Change an existing orders e Change the requested arrival date e Generate standard system reports e Understand the support mechanisms Who to call e Review the information in the Appendices Page 5 of 42 MOLSON Overview Molson POINT USER MANUAL Overview What is Molson POINT POINT stands for Product Ordering amp Inventory Net Tool Molson POINT is an interacti
11. contact ensuring product availability close to your market Page 7 of 42 MOLSON CoorsNet Molson POINT USER MANUAL CoorsNet Background What is CoorsNet CoorsNet is your one stop shopping web site for electronic communications within Coors and Molson USA It provides connectivity to all applications by acting as the central application through which all other applications are accessed CoorsNet is the home for all new Coors related and Molson USA related computer contact with our distributor network CoorsNet supports multiple users for distributorships Coors encourages you to request IDs for every key individual within your organization In this manner you can ensure that information can be sent directly to the person who needs it Why CoorsNet To corral all Internet applications that serve distributors and field sales users to provide e Faster access to Information flow e Single point of entry e Reduced training effort e Consistent technology Benefits of using CoorsNet e Dramatically enhance Coors Brewing Company s and Molson USA s communications potential with distributors and Field Business Areas e Centralized communication to and from CBC and Molson USA e No duplicates of email postal mail phone requests or reports from CBC and Molson USA Page 8 of 42 MOLSON Molson POINT CoorsNet USER MANUAL Logging on to CoorsNet Access to CoorsNet and Molson POINT requires a connection t
12. home page simply click the HOME hyperlink located in the upper right hand corner of the blue field e Within any page click on Help located in the upper portion of the page to receive on line help documentation e Within any page click on Preferences located in the upper portion of the page to change default or previously set preferences see next page e When moving within fields use the TAB key e The Message area will indicate any system messages for which you need to be aware Please refer to the Message area often e Click on the large buttons and tabs to reach a specific page directly e Distributor Identifies who the product is sold to Usually only one distributor will appear for a distributor user e Ship All authorized warehouse locations for which product can be shipped Note Please enter Forecasts and Sales amp Inventory by Ship To location product sold from that specific location and ending inventory at that same location Page 15 of 42 MOLSON Preferences Molson POINT USER MANUAL Preferences Page HOME HELP LOG OUT E Arrivals A les amp Inv f Forecasts Worksheet A Orders Y Reports APR tor 400100 RI CRANSTON Wayne Distribut Historical Weeks Displayed in 4 zl Worksheet Screen Weeks 4 of Historical Days Displayed in 4 s Arrivals Screen LE 4E of Historical Days Displayed in Days 14m Reports Distributor
13. ix ES Address 1 u P Address 2 AAZYT Cty Od State 9 Zip Code Country Phone Number mai Phone Extension FAX Number ay Exchange Folder Address ee DR E mail Address G1 National ID or SSN E Mother s Maiden Name Peg Status Active Inactive Last Login Date 07 10 02 02 39 12 PM Modify Login Date Last Modification Date 07 10 02 02 39 15 PM New Password Re confirm New Password Your Profile Sign Ou User s System Configuration Microsoft Internet Explorer version 4 0 compatible MSIE 5 0 Windows 5 0 By clicking the Your Profile link in the top section of your page you can modify your personal settings The following important information is maintained in your personal settings Email address Your email address is an important means to send important information Make sure that your address is always correct Password This is the only location to change your password for CoorsNet and all other applications accessed via CoorsNet including Molson POINT ie MOLSON Page 11 of 42 CoorsNet Molson POINT USER MANUAL How to Create a CoorsNet Logon ID ACTION FIELD NAME 1 Go to www coorsnet com on your Internet browser The Welcome to CoorsNet page appears locate the Login box in the upper left portion of the page 2 Enter Newcnid in the Name field Note For security reason
14. requested to ship Select the previous order from the drop down list and click Continue to display the order details Page 33 of 42 MOLSON Orders Molson POINT USER MANUAL Change Existing Order continued HEP LOG OUT M Arrivals ales amp Inv Forecasts Worksheet Orders Reports ee MOLSON Distr PO Req Ship Date Ship From Location Order Number 03 31 2003 Jackson DC Jackson Distributio 0020001105 tna tt rr EE 12965 Molson Golden 24 120z 12pk Can 10050 Molson Golden 24 120z 12pk LNNR 84 168 10052 Molson Golden 24 1202 6pk LNNR 252 12901 Molson Golden 1 2 T 16 16215 Molson Ice 24 120z 12pk Can 0 16270 Molson Ice 24 120z 12pk LNNR 16272 Molson Ice 24 120z 6pk LNNR 18161 Canadian 24 1202 6pk LNNR 18157 Canadian 24 120z 12pk LNNR 18135 Canadian 1 2 KEG T 10931 Canadian 24 1202 12pk Can i0998 Canadian 12 2402 12pk Can 18198 Canadian 28 120z 28pk LN 12223 Molson Exel 24 120z 6pk LNNR Update the Pallets field to the new order qty and click Save Change Existing Order Step by Step ACTION FIELD NAME 1 Select Change Existing Order from the Order Action drop down list 2 Select Previous Order from the drop down list 3 Click Continue button 4 Enter Number of pallets into the RED Pallet input field 5 Validate Load Weight and Total Pallets do not exceed on
15. week Monday by 8 PM Mountain Time Report arrivals sales inventory and forecasts Tuesday by 5 PM Mountain Time Page 41 of 42 2 MOLSON Appendix Molson POINT USER MANUAL Appendix A Upload File Format The Upload function is designed to allow you to upload your Sales and Ending Inventory information from another software package into Molson POINT To perform the upload the software package must be able to create an upload file in the exact format specified below The file must contain valid sustaining SKU product numbers The system will perform a check of the information you are attempting to upload to verify the product numbers are correct If the system does not recognize the product number it may need to be input manually The Upload Function will only recognize products at the sustaining product code level and will not recognize or allow an upload on promotional product codes If you try to upload Inventory Sales information for promotional product codes the import system will display those as errors File Specification Sales and Ending Inventory Records by Product 1 record per product 69 bytes fixed length including one 1 character for the CR LF FIELD FIELD NAME TYPE WIDTH POSITION VALUE 1 Record Type Char 1 1 T 2 Product Code Num 8 2 9 3 Sales Num 6 10 15 4 Inventory Num 6 16 21 5 Filler Num 48 22 69 Totals Record 1 record 61 bytes fixed leng
16. 2 12pk Can Molson Ice 24 1202 12pk LNNR we O O Golden 28 1202 28pk RT MU All rights reserved Copyright 2002 Coors Brewing Company Golden Colorado 80401 dep Internet The Distributor Product Preference page allows the distributor to control the product display on all other pages Sequence number functionality is still available but with improvements such as the ability to create and maintain Distributor Product numbers and the ability to hide selected products Terms Descriptions New Sequence A distributor assigned sequence number e Displays products in ascending order e The sequence number must be numeric and less than 9999 e No duplicates are allowed but they do not need to be sequential e Leave gaps between sequence numbers to allow for new products e Any product without a sequence number will be placed at the bottom of the list and sequenced by product number Product Unique MUSA product number Distributor Product Allows the distributor to assign a product code to MUSA products authorized for that distributor The distributor can manage Molson POINT using the distributor s product numbers Product Description Brand units size retail wrap and container e g Molson Golden 24 120z 12pk LNNR Hide Checkbox allowing distributor to hide product on Molson POINT pages Page 17 of 42 0 MOLSON Preferences Mols
17. 60 AL BIRMINGHAM Birmingham Beve v 010760 AL BIRMINGHAM Birmingham Beve 211 Citation Co Shipment Origin Mode Camer Vehide Current Week Number 51 1054 Montreal DC T ABC Trucking Booking 12 20 2004 12 20 2004 Arrived On I 1053 Mentrea DC T ABC Trucking Booking 12 20 2004 0 12 20 2004 FArrived n 1052 Montrealoc T ABC Trucking Booking 12 20 2004 0 12 20 2004 FArrived On M2933942 Montreal DC T MARK VII TRANSPORTATION CO INC 07 04 2003 0 A dO All rights reserved Copyright 2002 Coors Brewing Company Golden Colorado 80401 The Arrivals page is used to report the arrival date of the shipments This page displays all shipments that have been loaded and are in transit e Use Preferences to control the number of days displayed after a shipment has been received Range is from 0 to 31 days e Link to Order Details When the shipment is clicked it will open a separate window where the shipment details will be displayed This window will provide the following information on the selected shipment o Shipment Number Distributor Product Code Molson Product Code Molson Product Description Shipment Quantity e Arrived On Button This button will input the Arrival Date at the top of the table into the Actual Arrival Date field Q Note Molson USA may have the Auto Arrivals function enabled This fu
18. Description Distributor Product The distributor assigned product number from the Distributor Product Preferences page Unique MUSA product number Brand units size retail wrap and container e g Molson Gldn 24 120z 12pk LNNR Number generated and assigned by Molson POINT once the order has been created and saved Distributor assigned Purchase Order number Number assigned by the system to each US DC sourced shipment For Canadian sourced shipments Plant and Canadian DC shipment represents the Bill of Lading BOL Number Once the order has shipped the shipment number may be used for trace ability purposes Prod Product Description Order Distributor PO Shipment Ship Location Origin Displays Direct for orders sourced from a Molson Canadian manufacturing facility Otherwise the origin field will display the name of the warehouse from which the order will ship Requested Ship Date Date the order is requested to ship Page 40 of 42 0 MOLSON Molson POINT Support USER MANUAL Support Always Refer to Training Material First Contact the appropriate resource depending upon your type of questions Business Process or Order Questions e Deadlines New Product Order variances Product Supply Please contact your Customer Service Analyst Important Reminder Order Timing for ALL Distributors on Molson POINT What When Order beer for shipment next
19. Oe POINT MOLSON POINT v2 1 Product Ordering amp Inventory Net Tool User Manual MOLSON Molson POINT USER MANUAL Revision 3 4 January 21 2005 Page 2 of 42 MOLSON Molson POINT Table of Contents USER MANUAL Table of Contents Ri CS P 5 OWVOFVIOW siisssxsa span aas su ReERERRREERREERERESERRRRERREERERE RR ENRRENERERRRRRRRFRERERERKRER ER REREREERERRREKRERRERRRE 6 CoorsNet Background 8 Logging On IO raaraa arau NENEVARNE FERRE RR EE REREERER seal 9 CoorsNet The First Paga ssssssuns nass suks nE puse nEReEESERREREEEEKRRRRRE EFREEEEFEEERRREREEREREAE 10 Your Personal Settiligs iiss asa aaa aaa yl x RR ER ERRRRR REN RRR ER KR AR RR AR EE XRRRRAR ARR ARR ERN EERRR 11 How to Create a CoorsNet Logon 12 Logging on to Molson POINT aao passu suu pans ua pa E RERESRERRRAEEREERR RENE ER REKREREEFSERSERSEEREER 13 Data Input PI OCeSS siis isses sepas nu yas uEx EE EREFEERENEEEREEEEREREEREENEENENEREREREEE EEFNEEREESRENEENENEEER 14 Molson POINT FER REERFRSERE REF REESE REERE SERERE S AER 15 Preferences Pag sisssassuasa
20. age HELP LOG OUT PREFERENCES A Arrivals Gales 8 Inv Forecasts orksheet Orders Reports Distrit r 062250 CO DENVER Coors Distribut Ship 062250 CO DENVER Coors Distribut 5400 Test Pecos x Reporting for Week Number 47 Distr Prod Products Product Descriptior DISTi10050 10050 Molson Gldn 24 1202 12PK LNNR DIST10052 10052 Molson Gldn 24 1202 6PK LNNR DIST10054 10054 Gldn 24 1202 24PK LNNR DIST10931 10931 Canadian 24 1202 12PK Can DIST10932 10932 Canadian 24 120z 24PK Can DIST10941 10941 Canadian 1 2 Keg DIST10993 10998 Canadian 12 2402 Can DIST18179 18179 Canadian 24 120z 12PK LNNR TT Totals The Sales amp Inventory page is used to report the previous week s sales and ending inventory Terms Descriptions Distributor Product The distributor assigned product number from the Distributor Product Preferences page Prod Unique MUSA product number Product Description Brand units size retail wrap and container e g Molson Gldn 24 120z 12pk LNNR Sales Identifies sales to retailers and other customers excluding Molson wholesalers between Monday through Sunday of the prior week The unit of measure is in cases or kegs Ending Inventory Ending inventory figures by product at the end of the prior week Sales amp Inventory Page Step by Step ACTION FIELD NAME 1 Locate Product to report
21. age to the next product or Click the Save button Note Actual sales ending inventory and all forecasts must be entered before Projected Inventory and DOI will be calculated correctly Page 28 of 42 MOLSON Molson POINT Orders USER MANUAL Beer Order Process What When How Order Order beer for next By 8 PM MT Monday Molson POINT arrival window Future weeks are allowed Report arrivals sales inventory By 5 PM MT Tuesday Molson POINT and forecasts Change Emergency situations or Through the Shipment week Customer Service exceptions after order deadline until the requested ship date Change Requested Orders Until they become frozen Molson POINT Key Changes for Beer Order Process e Reduction in DC warehouse sourced loads from five weeks to order this week for shipment next week e Reduction in direct orders cycle times from the Molson Canada breweries from five weeks to four e Elimination of multiple sales order numbers With the new Molson POINT tool the Web request ID sales order number Page 29 of 42 MOLSON Orders Molson POINT USER MANUAL Orders Homepage HELP LOG OUT Order Action REN Distributor Ship From Location jackson bc e Req Ship Date 12 09 2002 x Riu ganr November 26 2002 All rights reserved Copyright 2002 Coors Brewing Company Golden Colorado 80401 The Orders Home page a
22. atus Report HELP Orders Reports PREFERENCES 062250 CO DENVER Coors Distribut 5400 Pecos S v Order Status Report 062250 Coors Distributing Company Date 04 08 2004 03 01 itted Orders 0020032160 MB41901 Internet Order 0020028428 MB42203 05 02 2004 Internet Order 0020028425 MB42202 05 02 2004 Internet Order 0020028424 MB42201 05 02 2004 Internet Order 0020031141 MB41802 04 26 2004 Internet Order 0020031135 MB41801 04 23 2004 Internet Order 0020030444 MB41701 04 19 2004 Internet Order Frozen Orders 0020029680 MB41601 04 16 2004 Internet Order In Execution 0020030615 MB41502 04 05 2004 Internet Order In Execution 0020028422 MB41501 04 05 2004 Internet Order In Execution 0020027410 MB41302 03 22 2004 Internet Order In Execution 0020026519 MB41301 03 22 2004 Internet Order In Execution The Order Status Report contains information regarding which orders have been submitted and can be changed and which orders have been frozen and cannot be changed deleted on line Column Description Order Number generated and assigned by Molson POINT once the order has been created and saved Distributor PO Distributor assigned Purchase Order number Order Due Date Date the order is requested to arrive Ship Week Week the order is requested to arrive Order Type Displays type of order
23. d Orders By Order amp Origin O D Sh d Origin Est Prod Prod Product n 0010000095 123 Portland DC DISTi0052 10052 Molson Gldn 24 1202 6PK LNNR 0010000096 Portland DC 10052 Molson Gldn 24 1202 6 LNNR 0020000444 062250 1 Portland DC 10052 Molson Gldn 24 1202 6PK LNNR 0020000447 062250 2 0000001071 Jackson DC 11 13 2002 10052 Melson Gldn 24 1202 6PK LNNR 18161 Canadian 24 120z 6PK LNNR 0020001123 062250 3 Jackson DC DISTi0052 10052 Molson Gldn 24 1202 6PK LNNR DISTi8161 18161 Canadian 24 1202 6PK LNNR 0020001124 062250 4 Molson Canada Direct DIST10052 10052 Molson Gldn 24 1202 6PK LNNR 0020001143 062250 47D Molson Canada Direct 015710052 10052 Molson Gldn 24 1202 6PK LNNR 0020001175 062250 490 1 Molson Canada Direct 015710052 10052 Molson Gldn 24 1202 6 LNNR 0020001186 062250 51D 1 Molson Canada Direct DIST10052 10052 Molson Gldn 24 1202 6PK LNNR rights reserved amp Copyright 2002 Coors Brewing Company Golden Colorado 80401 The Orders by Order Number report displays the products requested scheduled Planned shipments and shipped Actual shipments Once the shipment leaves the Plant DC the load date reflects an actual date instead of an estimated date Note Jackson amp Portland Update at the time of shipment Direct shipments from plant and warehouse shipments from Canada are updated every n
24. der e In order to fulfill your sales forecast Inventory Worksheet Inorder to maintain the appropriate level of inventory Inventory Worksheet Step 4 Adjust order quantities to max out vehicles and submit order Order page Note When an order has been submitted an order number will be displayed Changes to the Worksheet will not update an order Page 14 of 42 MOLSON Molson POINT Logging On USER MANUAL Molson POINT Home Page HELP LOG OUT PREFERENCES f Arrivals inv Forecasts Worksheet Orders Reports utc 010140 AL MONTGOMERY Allstate Bevera hd 010141 AL DEMOPOLIS Allstate Bevera 2760 Highway 43 v MOLSON Welcome to the Molson Ordering System Uptosd Upload File optional Upload your weekly Sales and Inventory records from a local file Report loads that have been received unloaded and included in your Ending Inventory GST i D Sales amp Inventory Reconciliation Enter weekly Sales and Inventory for each product adus Forecast Entry Data entry screen for entering forecast by distributor V6 i Forecasting 8 Inventory Worksheet Adjust forecasts and review affect on projected inventory levels and sales trends is de s Order Creation Create or edit orders for Molson Products Pepor D Order Status Reports View up to date order status information The Home Page above will appear after logging on to the network To return to the
25. e truckload 6 Click Save button Page 34 of 42 MOLSON Molson POINT Orders USER MANUAL Change Requested Ship Date HELP LOG OUT M f Arrivals Sales amp Inv Forecasts Worksheet Orders Reports MO UN 062250 CO DENVER Coors Distribut 062250 CO DENVER Coors Distribut 5400 Test Pecos All rights reserved Copyright 2002 Coors Brewing Company Golden Colorado 80401 c itty PREFERENCES MOLSON Selecting Change Req Ship Date from the Order Action drop down list will hide the other fields on the Orders home page Click Continue to generate a list of orders that may be modified The requested ship date may be updated within the list of acceptable values Use the drop down to select a date and click Save Change Requested Ship Date Step by Step ACTION FIELD NAME Select Change Req Ship Date from the Order Action drop down list Click Continue button Verify Distributor and Ship To locations are correct Verify Order Number and Distributor PO Select Update Requested Ship Date from the drop down list Repeat Steps 1 through 3 for all orders to be changed Click Save button S E ae Duc cepe pt Page 35 of 42 2 MOLSON Reports Molson POINT USER MANUAL HOME HELP LOG OUT E PREFERENCES Arrivals Gales amp Inv ff Forecasts rksheet Orders F ributor D14151 AL BIRMINGHAM Supreme
26. ent year versus the same 52 weeks of the previous year Actual Weeks Displays the change in sales figures for the past 8 weeks starting from Last 8 the current week number of the current year versus the same 8 weeks of the previous year Forecast Weeks Displays the change in sales figures forecasted for the next 4 weeks Next 4 starting form the current week number of the current year versus the actual sales figures for the same 4 weeks of the previous year Forecast Weeks Displays the change in sales figures forecasted for the next 8 weeks Next 8 starting from the current week number of the current year versus the actual sales figures for the same 8 weeks of the previous year What do the colors in the Sales Trend Comparison charts mean The Sales Trend Comparison Actual Weeks Last 52 and Last 8 become the benchmarks for coloring coding the forecast trends RED GREEN REGULAR When the Sales Trend Comparison Forecast Weeks is equal to the Actual Weeks When the Sales Trend Comparison Forecast Weeks is less than the Actual Weeks When the Sales Trend Comparison Forecast Weeks is greater than the Actual Weeks Forecasting and Inventory Worksheet Step by Step ACTION FIELD NAME 1 Select Product to forecast 2 Enter Distr Act Forecasts if not already done so on the Forecasting page 3 Enter Distr Requested Orders 4 Click Save amp Next to advance the p
27. eq Ship Date Ship From Location 12 09 2002 Jackson DC DIST10050 Molson Gldn 24 1202 12PK LNNR 015710052 Molson Gldn 24 1202 6PK LNNR 015710054 Molson Gldn 24 1202 24PK LNNR DISTi10931 Canadian 24 1202 12PK Can DIST10932 Canadian 24 120z 24PK Can DIST10941 Canadian 1 2 Keg DIST10998 Canadian 12 240z Can 015718179 Canadian 24 1202 12PK LNNR 9 o fal o fol o fo o fo E Totals Fields Distributor Product All rights reserved amp Copyright 2002 Coors Brewing Company Golden Colorado 80401 Lo Save Description The distributor assigned product number from the Distributor Product Preferences page Prod Unique MUSA product number Product Description Brand units size retail wrap and container e g Molson Gldn 24 120z 12pk LNNR Pallets Number of pallets for each product Note If the Ship from Location is Direct then Molson POINT will limit the number of products allowed for the order If the Ship from Location is Warehouse then there is no limit to the number of different products included in the order Units Pallet Number of units cases kegs that make up a full pallet Extended Units Number of total units ordered pallets x units pallets Total Pallets Number of pallets in the order Note This cannot exceed one truck load Load Weight Calculated weight of
28. ight Column Description Order Number generated and assigned by Molson POINT once the order has been created and saved Distributor PO Distributor assigned Purchase Order number Shipment Number assigned by the system to each US DC sourced shipment For Canadian sourced shipments Plant and Canadian DC shipment represents the Bill of Lading BOL Number Once the order has shipped the shipment number may be used for trace ability purposes Ship Location Displays Direct for orders sourced from a Molson Canadian Origin manufacturing facility Otherwise the origin field will display the name of the warehouse from which the order will ship Requested Ship Date Date the order is requested to ship Est Act Load Estimated date the shipment will be loaded or the Actual date the order has already shipped Distributor Product The distributor assigned product number from the Distributor Product Preferences page Prod Unique MUSA product number Product Description Brand units size retail wrap and container e g Molson Gldn 24 120z 12pk LNNR Page 39 of 42 0 MOLSON Reports Molson POINT USER MANUAL Orders by Product Number Report HELP PREFERENCES LOG OUT Arrivals Gales amp Inv Forecasts orksheet Orders ir 062250 CO DENVER Coors Distribut 062250 CO DENVER Coors Distribut 5400 Test Pecos Orders by Product Number 062250 Coors Distributing C
29. llows the distributor to select one of three options e New Create new order e Change Existing Order Modify order quantities on an existing order e Change Ship Date Modify the requested ship date for an existing order Note The order page will always default to the New Order selection After the Order Action drop down list is activated the displayed fields will change to reflect the action selected Fields Description Order Action This is a drop down list of the three possible order actions New Change Existing Order Change Req Ship Date Distributor PO Distributor assigned Purchase Order number Optional Previous Orders Displays previous orders entered by the distributor that are not frozen and can be changed Ship From Location Displays Direct for orders sourced from a Molson Canadian manufacturing facility Otherwise the Ship From Location field will display the name of the warehouse from which the order will ship Req Ship Date Date the order is requested to ship Page 30 of 42 ey MOLSON Molson POINT Orders USER MANUAL Create a New Order To create a new order enter the Distributor PO select the Ship From Location from the drop down list select a Req Ship Date from the drop down list and click Continue Arrivals Aales amp Inv f Forecasts The new order page will be displayed HELP LOG OUT PREFERENCES orksheet Orders Reports R
30. lson USA product code not the distributor assigned product code This is the required format of the file to be uploaded to Molson POINT Please note that each field has a required character type width and position Errors will occur if the data does not meet the required format standards File Specifications Sales and Ending Inventory Records by Product This record includes sales and ending inventory at the sustaining SKU level 1 record per product 69 bytes fixed length including one 1 character for the CR LF FIELD FIELD NAME TYPE WIDTH POSITION VALUE 1 Record Type Char 1 1 A 2 Product Code Num 8 2 9 3 Sales Num 6 10 15 4 Inventory Num 6 16 21 5 Filler Num 48 22 69 Totals Record This record includes totals for sales and ending inventory 1 record 61 bytes fixed length including one 1 character for the CR LF FIELD FIELD NAME TYPE WIDTH POSITION VALUE 1 Record Type Char 1 1 2 2 Sales Num 6 2 7 3 Inventory Num 6 8 13 4 Filler Num 48 14 61 Please contact your software vendor if you have any questions about whether or not your local system can provide the information in the required format Page 20 of 42 MOLSON Molson POINT Upload File USER MANUAL Upload File Error Messages The confirmation message may display error messages like the following File Upload ERROR MESSAGE DESCRIPTION ERROR Please enter a file name to
31. nction will automatically populate the Actual Arrivals Date with the Actual Ship Date once Molson POINT receives information that an order has shipped You may choose to override this date with the procedure outlined on the next page Page 22 of 42 2 MOLSON Molson POINT Arrivals Page USER MANUAL Arrivals Page continued Terms Descriptions Shipment Unique non intelligent number assigned to the shipment by the system Origin The point of origin for each shipment e g Montreal DC Portland or Jackson Mode Mode of transportation e g rail truck or intermodal Carrier Name of the carrier Vehicle Carrier assigned Vehicle Identification Code Actual Ship Date Date the shipment was loaded Tran Days Number of days it will take the shipment to arrive at the distributor Estimated Arrival A calculated arrival date equal to the Actual Ship date plus the Transit Date days Actual Arrival Date Date the shipment arrives at the distributor location Arrivals Page Step by Step ACTION FIELD NAME 1 Locate Arrived order number s 2 Click Arrived On button to insert Arrival Date or 3 Edit Arrival Date mm dd yyyy then click Arrived On button or 4 Enter Actual Arrival Date manually 5 Click Save button at the bottom of the page Page 23 of 42 MOLSON Sales amp Inventory Molson POINT USER MANUAL Sales amp Inventory P
32. o the Internet and Internet Explorer After logging into your Internet Service Provider ISP ACTION FIELD NAME 1 Enter www coorsnet com in address field The following page will appear 3 Welcome to CoorsNet Coors Brewing Company s complete answer to distributor needs As a registered user you ll have access to a variety of services including Name word 4 E 5 Product Ordering Point of Sale Displays and Communications an Consumers and Investors please go to www Coors com Log in Other Coors Sites CoorsJobs com CoorsandCompany Site Requirements 21 MEANS 21 Legal Disclaimer About Coors Copyrights Alcohol Issues Privacy ACTION FIELD NAME 1 Enter User name in Name field 2 Enter Password Note For security reasons we recommend you do NOT select the option to save this password in your password list if prompted to do so by your browser 3 Click The Log in button Page 9 of 42 sey MOLSON CoorsNet Molson POINT USER MANUAL CoorsNet The First Page 48 T Coors Original Now amp Coors Rodeo IN LPM Your Profile Sign Out Welcome oE My Tools e n TET News Product Sup pl Sales 8 Qualit Distributor Tools Center Inter Point Molson SI Coors Light Hispanic Mana Outdoor Board 51 1 Sales Tran
33. ompanys Requested Orders By Product amp 062250 49 1 f Reports Run Date 11 26 2002 04 58 Molson Gldn 24 120z 6PK Jackson DC LNNR Canadian 24 12oz 6PK LNNR 10020001174 DIST10052 12 05 2002 015718161 0020001174 062250 49 1 Jackson DC 12 05 2002 062250 1 062250 2 062250 3 Scheduled or Shipped Orders By Product amp Portland DC Portland DC Portland DC Jackson DC Jackson DC Molson Canada Direct Molson Canada Direct Molson Canada Direct Molson Canada Direct Jackson DC Jackson DC 015710052 10052 Molson Gldn 24 120z 6PK 0010000095 0010000096 0020000444 0020000447 0020001123 0020001124 062250 4 0020001143 062250 47D 00200011751062250 490 1 0020001186 062250 510 1 0020000447 062250 2 0020001123 062250 3 0000001071 11 13 2002 0000001071 11 13 2002 18161 Canadian 24 1202 6PK LNNR All rights reserved Copyright 2002 Coors Brewing Company Golden Colorado 80401 The Orders by Product Number report displays the products requested scheduled Planned shipments and shipped Actual shipments Once the shipment leaves the Plant DC the load date reflects an actual date instead of an estimated date Note Jackson amp Portland Update at the time of shipment Direct shipments from plant and warehouse shipments from Canada are updated every night Column
34. on POINT USER MANUAL Distributor Product Preference Page continued HOME HELP SCR umm Molson Golden 24 1202 12pk Can fi 11 Molson Golden 24 1202 12pk LNNR 1113 Molson Golden 24 1202 6pk LNNR Molson Golden 1 2 Keg 151 Molson Ice 24 1202 12pk Can i161 Molson Ice 24 1202 12pk LNNR Golden 28 1202 28pk RT MU OO 4 All rights reserved Copyright 2002 Coors Brewing Company Golden Colorado 80401 Distributor Product Preference Page Step by Step ACTION FIELD NAME 1 Enter New Sequence 2 Enter Distributor Product 3 Check On the hide checkbox if you want to hide the product on other pages 4 Click Save button at the bottom of the page Note Remember to click Save at the bottom of the page or the changes will not be reflected Page 18 of 42 2 MOLSON Molson POINT Upload File USER MANUAL Upload File HELP LOG OUT Arrivals Sales amp Inv Forecasts jorksheet f Orders Reports Distributor 062250 CO DENVER CoorsDistribut sj 062250 CO DENVER Coors Distribut 5400 Test Pecos Reporting for Week Number 47 File to Upload Browse Process File Now The purpose of the file upload page is to provide you with the capability to import data into Molson POINT from an export file created from your route accoun
35. s COMMUNICATION e Conduct weekly or bi weekly meetings to discuss market activity o Involve Sales Draft Chain Category Promotions and Beer Order Forecasting and Special Events personnel e Review historical data o For example the promotion schedule this year vs last 52 week trends 8 week trends and 8 week removal history e Remember special events holidays and seasonal products that may result in volume spikes e Account for upcoming retail activity o Has a grocery chain just approved an ad feature How many stores are involved e Adjust forecasts daily weekly as needed to ensure proper inventory levels and package availability Page 25 of 42 2 MOLSON Forecasting and Inventory Worksheet Molson POINT USER MANUAL Forecasting and Inventory Worksheet HOME HEIP LOG OUT ff Arrivals Gales amp Inv Forecasts Workshe ff Orders Reports Mr MO o IN 010140 AL MONTGOMERY Allstate Bevera hd 010141 AL DEMOPOLIS Allstate Bevera 2760 Highway 43 v Product 11 11313 Molson Mix 2 12 1202 11 502 Bottles Reporting for Week Number 50 Ship To 010141 AL DEMOPOLIS Product 11 11313 Molson Mix 2x12 1202 11 50z Bottles o Monday Date Sales Price Promo DINE Price Promo Actual Scheduled Frozen Open kaa Variance AC l Prior Weeks 46 11 08 0 0 o o 47 11 15 0 0 o o 48
36. s Do not select the option to save this password in your password list 3 Enter Newcnid in the Password field 4 Click Red Log in button A new box will appear Again type in newcnid for the User Name and newcnid for the Password 5 Click OK button 6 When the form Request a New CoorsNet User ID appears on the page fill in all required information e Last 4 digits of your Social Security or National ID Number this is used for the security check if you should forget your password e First Name e Last Name e Phone Number e Distributor Number e Country e E Mail Address e Click the button marked Submit e Coors will e mail you a personalized response that includes your secure CoorsNet user name and CoorsNet password You will then be able to access CoorsNet Page 12 of 42 MOLSON Molson POINT Logging On USER MANUAL Logging on to Molson POINT After Logging on to CoorsNet Click on the Molson POINT link located on the left side of the page ag TN Ta Coors Original Now amp Coors Rodeo IN Your Profile Sign Out Welcome oE My Tools x News Product Supply Sales 8 Qualit Distributor Tools Genter Inter Point DI lt a SIM Coors Light Hispanic Mana Outdoor Board ACTION FIELD NAME 1 Click Molson link located on left side of page Molson POINT Helpful Hints
37. smittals View All Current gt gt View Archived Commitments Rebates gt gt More IRISH RED 2002 Q 3 PTO POS Coors Light Top 10 Challenge Bottle Mackhangers for 2002 Killian s and Halloween Mega Promotional Golf Packagin Online Ordering JE Resources Customize This Page gt Discussion Groups gt Brand Information gt Conventions Events gt Distributor Website Builder gt UPC Data gt 2002 Calendar Logos 6 Coors Graphics Contacts University Industry Links select Any One Departments CBC Links CoorsNet Department Sites FBA Sites Select Any One z Select Any One x Select Any One Site Requirements 21 MEANS 21 Legal Disclaimer About Coors Copyrights Alcohol Issues Privacy My Tools These are links to the different product ordering management tools Communications These links take you to current Molson USA promotions and LPMs Resources This folder contains links to Distributor Message Boards Product Information MUSA Calendars Department links and Selected Industry pages Your Profile The user preferences and data page is where you can update distributor contact information as well as change passwords Page 10 of 42 ie MOLSON Molson POINT CoorsNet USER MANUAL Your Personal Settings F Coors Original NOW LP amp Coors Rodeo First Name Last Name Job Title
38. ssunsnussuxAanE PuRERRERRRERREKNEREERERREREEESFRNEREEEERR ARRRERRERESEREERRERERERRRAR 16 Distributor Product Preference Page 1 ooo oras rapa au aa uu au aaa auus aaa ap aan aaa 17 Upload FHC P 19 File Guidelines and Specifications 1s s sies ire erra a eap aaa aaa au aaa a aua au aaa uuu 20 Upload File Error Messages oorr rois eara a naar aan a aun au aaa aan aa aa ap ERE Ro 0 3E 21 POUB as tu dE XE FAVEREEFFREERIMR 22 Sales amp Inventory E eEeREREEERRER nanain aariaa RRRR RR ERE ERA REA IRA RR 24 Forecasting si x ar a ERE REY EEREE RR EFRRRRRE VR ERE EX RERE ERR RAE RE EEFRRENRNR RARE RNRNERRR RARE KEE EXE 25 Forecasting and Inventory Worksheet 1 1 ooi oe rera a raa a aaa aun aa naar aan aaa u au aaa uas 26 Beer Order PlOCCSS isis oia saaksEssERuE FRRRER SERERE EE EREERE RES REA RR RENERRRRARRREKREEREERRKRRREREESERER 29 Orders Homepagoe usnssessasea sux uu RERRERRREEER FERRE ERR ERRARE REFERRE EERRRERY RV XERER AR ERR RER EXE EEREE 30 Create a New vara AR FERREERYES EE EE RE ideas aati 31 Change Existing Orde uiii is sssskans pa au nux uk au ERERRER ER EERRRRRERERRRRAREEERRERRERRFRRERERR ERN R 33 Change Requested Ship Date 1 oos assis prop aaa
39. th including one 1 character for the CR LF FIELD FIELD NAME TYPE WIDTH POSITION VALUE 1 Record Type Char 1 1 72 2 Sales Num 6 2 7 3 Inventory Num 6 8 13 4 Filler Num 48 14 61 Please contact your software vendor if you have any questions about whether or not your local system can provide the information in the required format Page 42 of 42 MOLSON
40. the order in pounds this weight includes the weight of the pallet Note This cannot exceed the truck weight limit Page 31 of 42 0 MOLSON Orders Molson POINT USER MANUAL Create a New Order continued HEP LOGOUT M BN Arrivals Gales amp Inv A Forecasts orksheet L Orders M Reports ee MOLSON Distr PO DIST10050 Req Ship Date Ship From Location Order Number 12 09 2002 Jackson DC Molson Gldn 24 1202 12PK LNNR 015710052 Molson Gldn 24 1202 6PK LNNR DISTi10054 Molson Gldn 24 120z 24PK LNNR DIST10931 canadian 24 120z 12PK Can DIST10932 Canadian 24 120z 24PK Can 015710941 Canadian 1 2 Keg DISTi10998 canadian 12 240z Can DIST18179 Canadian 24 120z 12PK LNNR CO COM CO OM CO OM Oo G o PSS o Pon o ponj o BS Totals All rights reserved Copyright 2002 Coors Brewing Company Golden Colorado 80401 When ordering is complete click the Save button an Order Number will be generated by Molson POINT and is the sales order in the system The order number can be used for order tracking purposes New Order Creation Step by Step ACTION Select Enter Select Select Click Verify Locate Enter Validate Click Record E Ce DX cUm Due odo ge eS oH e O FIELD NAME New from the Order Action drop down list Distributor PO Ship From Location from the drop down list
41. ting system If you do not have this capability you will not be able to use this functionality of Molson POINT Other software may be used to create the import files that software must be able to create text files with the proper file specifications as detailed on the next page Please contact your Route Accounting vendor or your Information Technology IT support staff for more information Upload File Step by Step ACTION FIELD NAME 1 Select Fields to load into database 2 Type File path and name of the file to Upload or locate the file via the Browse button 3 Click Process File Now button Note A confirmation will be displayed that summarizes the number of records that have processed successfully the number of records that have failed and the reason for the failure Page 19 of 42 2 MOLSON Upload File Molson POINT USER MANUAL File Guidelines and Specifications e Only MUSA product numbers will be accepted System will display errors if Distributor product numbers are submitted e Only sustaining product numbers will be accepted All products should be reported using the sustaining product code When there are special promotional graphics these products will often have different codes however distributors will still order and report sales and inventory under the normal product code Note for the distributors Ensure that the file exported from your route accounting system includes the sustaining Mo
42. vals history by week and product Price Promo Indicator that Molson USA has offered a price promotion for the weeks indicated Distr Act Forecast Forecasted removals this field may already be populated from the Forecasting page Actual Arrivals Quantity that has been marked as received on the Arrivals page Scheduled Arrivals Products scheduled to arrive that week but not yet marked as received on the Arrivals page Distr Order Frozen In units Order quantity that was frozen but not yet scheduled Distr Order Open In units Anticipated Orders Data entry fields which are outlined in green If quantity exists then it can be changed through the Change Existing Order function on the Order page Actual Projected A view of the weekly reported ending inventory with the projected Inventory ending inventory based on the forecasted removals and scheduled arrivals Variance Calculated inventory variance for the week Actual DOI The number of days of inventory based upon the forecasted removals The Actual DOI is restated with actual removals when they are available Page 27 of 42 MOLSON Forecasting and Inventory Worksheet Molson POINT USER MANUAL Forecasting and Inventory Worksheet continued Sales Trend Comparison vs YAG Actual Weeks Last 52 Displays the change in sales figures for the past 52 weeks starting from the current week number of the curr
43. ve web based tool to enable communication between Molson USA and distributors This system provides functionality for distributors to Record Arrivals Sales and Inventory Enter Forecasts Plan Inventory Flow Create New Orders Change Existing Orders Change Requested Ship Date Generate Reports Monitor Days Of Inventory DOI Key Terms Term Definition Molson POINT Molson Product Ordering amp Inventory Net Tool Order Distributor s request for product in a specific week Sales Removals Identifies sales to retailers and other customers excluding other Molson wholesalers Order Number generated and assigned by Molson POINT after the order has been saved Product Unique MUSA product number 5 digit number Shipment Number assigned by the system to each US DC sourced shipment For Canadian sourced shipments Plant and Canadian DC shipment represents the Bill of Lading BOL Number Page 6 of 42 MOLSON Molson POINT Overview USER MANUAL Molson USA Supply Chain Molson USA Supply Chain Process Direct Canadian Shipments from Breweries a o 5 o z 3 o 3 o booo opoo anon Warehouse 222 7 conn s onpold Molson POINT User Training 04 02 2004 Key elements of the Molson USA Supply Chain e service team focused on meeting your product supply needs including a Customer Service Analyst CSA as your single point of
Download Pdf Manuals
Related Search