WIXLIB

Blueview ApplicationTraining Guide & HandbookTailored for US Plant Operations TeamLast Updated June 13th, 2019

Strategic Operations - Automating Insights, Decisions, and Work FlowsTraining Summary & Content Index2 How to Access Blueview’s Main Page & Instructions for 1st Time Users, Slide 3 Production Application, Slides 4-13 Ops Finance Scorecard, Slides 14-19 Quality Audits App, Slides 20-24 Volumes, Slides 25-28 Component Per Repair App, Slides 23-25 Inventory History App, Slides 26-30 Damage Rate App, Slides 31-34 Reclaim Per Teardown App, Slides Blueview Directory, Slide 3835-37

Accessing Blueview’s Main PageAccessing Blueview’s Main PageDirections to Access the Site and Set up 1st Time Users Go to http://blueview.chep.com/qlikview/index-us.html If you are a new employee, or receive a brand newcomputer you will need to install the Internet ExplorerPlugin found on the main page (right hand side – seeimage). Download the Plugin and Restart Internet Explorer If you receive an error message saying “Admin AccessDenied”, then Contact thechepuslogisticsbusinessinteligence@chep.com Team emailand they will help you work with IT to get the download It is recommended to always use Internet Explorer forBlueview – Improved Functionality & End User Experience3

ProductionApplication

Blueview - Production ApplicationWhat is the Production Application?#2 Application Overall and heavily utilized by Logistics, Planning, Operations, S&OP, and Finance to review Production Activity Metrics- Includes all C-Gen Metrics & Compliance Tracking, Repairs, Sort, Damage Rate, Current Inventory Levels & Trends, Days of Coverage, PlantCapacity, Pallet Issues & Collection Flows. By using a snapshot of current inventory levels, pre-loads, C-Gen metrics it shows projected Surplusand Deficit Levels for any Site at the Current Moment. Go to the Logistics Dropdown, ThenPlanning, then Production Application Selecting the Production ApplicationIcon will direct you to the Application C-Gen, Sort, Repair Activity, andDamage Rate Calc. all come from PlantPIMS in Sarah Daily Inventory comes directly fromSarah Reporting by the Plants (lastreport time) Inbounds and Outbound Flows comedirectly from the Volumes Database5

Blueview – Production ApplicationCurrent Week – Plant Performance Summary TabThis Display’s Your Sites Current Inventory, Plant Capacity, Days of Coverage, and Weekly C-Gen Progress vs. Planned TargetsRegional & Plant Level ViewLatest Inventory CountsP-Stock vs. Other Pallet MixPre-Loaded Trailers on SitePlant Capacity %This Week’s C-Gen, Repair, and Cfrom Sort Targets vs. Actuals Damage Rate this week A, B, C Days of Coverage 6

Blueview – Production ApplicationCurrent Week – Plant Performance Summary TabHow to Easily See your sites not on track to meet weekly C-Gen Targets, or those at High Capacity, or Low Days of Coverage Type in your name, region, or plantcode Select “plant View” icon on the farright to see at plant level Double Click the column header tosort ascending / descending view.For instance, the image to the rightI double clicked the WTD C-GenActuals vs. Target column to seewhich sites are falling behind theirweekly C-Gen Target Do the same to see those sites athigh capacity, or Days of coverage,etc.7

Blueview – Production ApplicationService Center Production TabTrend Analysis and Year over Year Views for Sort, Repair, C-Gen, Issues, Returns, Damage Rate, Relos, Teardowns, YOY Performance by Fiscal Week orMonth for Issues, Sort, C-Gen,Damage Rate, Issues, Collections 4 Fiscal Year to Date Charts (ByFiscal Week) to show RepairConformance, C-Gen Conformance,Damage Rate, and C-Gen vs. Issues/ C Days of Coverage Summarized Table showing PlantLevel Views within a Region orMgmt. Group on Production toTargets (C-Gen, Sort, Repair) –Which sites are performing good /top opportunity sites8

Blueview – Production ApplicationService Center Production TabTrend Analysis and Year over Year Views for Sort, Repair, C-Gen, Issues, Returns, Damage Rate, Relos, Teardowns, Wash Right side of the Page will provide4 Trend Charts to Show Year toDate Trends on RepairConformance / Repairs per Bday, CGen Conformance, Damage Rate,and C-Gen vs. Issues / C Days ofCoverage9

Blueview – Production ApplicationService Center Production TabTrend Analysis and Year over Year Views for Sort, Repair, C-Gen, Issues, Returns, Damage Rate, Relos, Teardowns, Wash Can View YOY Trends by Week10 Or Select Icon to view by Month

Blueview – Production ApplicationService Center Production TabTrend Analysis and Year over Year Views for Sort, Repair, C-Gen, Issues, Returns, Damage Rate, Relos, Teardowns, Wash Summary Table on the Bottom of the Page is an easy way to view which Plants within a Region, Cluster or ManagementGroup are performing to set Targets for C-Gen, Repair, Sort In this Case below, You can easily see that Alburtis & Tunkhannock are the Top sites to Focus on for C-Gen conformancewithin all of Millwood’s sites. For Alburtis, it is easy to see that Repairs are the main driver of the Gap11

Blueview – Production ApplicationService Center Production TabTrend Analysis and Year over Year Views for Sort, Repair, C-Gen, Issues, Returns, Damage Rate, Relos, Teardowns, Wash Plant Level, Mgmt. Group View Monthly or Weekly Views with YOYGrowth / Decline on: Collections, Issues, Sort, C-Gen,Repairs, Teardowns, Damage Rate,STO’s In / Out12

Blueview – Production ApplicationService Center Scorecard TabIf you want Trends on the Latest 6 Weeks for any of your sites with details on all Activity13

Ops Finance Scorecard

Blueview - Production ApplicationWhat is the Ops Finance Scorecard Application?With 100% Accuracy Compared to Ops Finance Reports, this Application displays Insights & Full Details into Plant Level Cost. How mucheach site is spending per Month in Issue, Return, Repair, Production Activity, Rent, Lumber, Accessorials, Etc. Also find Plant Cost per C-GenMetrics & YOY Cost Comparative Analysis Go to the Operations Dropdown, ThenOperations Finance Scorecard15

Blueview – OPS Finance ScorecardFiscal Year Trend AnalysisView Monthly Cost Trends at a Plant or Management Group Level Compares Cost to Issue, Return,Repair, Wash, Heat Treat, andTeardowns Production Volume16

Blueview – OPS Finance ScorecardYear over Year Comparison TabFor a Time Selected Timeframe, View this Year’s Cost vs. Last Year In this Case, we can see that US8Xhas higher cost in the 1st Quarter ofFY19 compared to the same time inFY1817

Blueview – OPS Finance ScorecardRaw Data & Details TabExport all Plant Level Cost by Line Item and Dollar to Excel for Ad-Hoc Analysis In this Case, for US8X you havevisibility to every line item ofcost for October can export toexcel for analysis18

Blueview – OPS Finance ScorecardYear over Year Comparison TabHave the Ability to open charts that show Cost Per C-Gen (Total plant cost vs. C-Gen) Double click these icons to open the tables and view Cost per C-Gen In this Example we can easily see all the Millwood Plants and their Monthly Cost per c-Gen19

Quality Audits

Blueview - Production ApplicationWhat is the Quality Audits Application?All Plant Level Audit Scores entered within the Ops Portal are visible for tracking analytics within this app. Audits done by Reps / Mgrs /Directors, Management Groups, and External Auditor Team are included. Measures Repair C-AQL, Sort C-AQL, Avg AQL, B AQL, ComponentsReplaced Go to the Operations Dropdown, thenQuality Audits Application Three tab app Main, Charts and By Plant Data comes directly from auditsuploaded into the portal Detail view by audit as well as paretocharts and rolling 12 table Ability to view AQL by auditor type21

Blueview – Quality AuditsMain TabDisplay’s AQL trends by stock type as well as audit type with the ability to filter as needed Regional & Plant Level View Pareto Chart shows componentdamage and cumulativepercentage Detail view shows specific audits Trend analysis chart highlights AQLover time Pie Chart provides visual breakdown of total audits completed22

Blueview – Quality AuditsCharts TabEasily manipulated AQL and component charts for quick updates AQL charts C-Repair C-Sort B-Stock B-Stock Components ReplacedChart Regional and plant views Change timeframe as needed23

Blueview – Quality AuditsPlant TabTable view of AQL data Select specific plant or region Ability to filter for ‘conducted by’ See audit scores by month24

Volumes Database

Blueview – Volumes DatabaseWhat is the Volumes Database Application?#1 Application Overall - The Data Foundation for all Applications as it relates to Issues, Collections, and Relocations & Financial Cost Tracking Go to the Logistics Dropdown, thenSupply Chain Finance, then VolumesDatabase Selecting the Volumes Database Iconwill direct you to the Application Volumes comes directly from SAP Key data in the app includes: Length ofHaul, Average Cost per Unit (Issues,Collections, Relos) Volumes come from GI/GR from SARAH Financials coming from TMS (BluJay)26

Blueview – Volumes DatabaseMain TabDisplays Volumes for the entire network, or Region, Management, or Plant Historical volumesCustomizable detailYOY MetricsFinancial SummaryLoad level informationBookmark filtersSelect a Plant to See All Inbound,Outbound, and Relocation Volumethat is GI / GR’d into the Site27

Blueview – Volumes DatabaseMain TabDetailed Load Level View of Volume In / Out of a Plant Hit Detail Tab to see a - DetailedGoods Issue / Good Return Datafor all Movements within Sarah /SAP by Plant28

Blueview – Volumes DatabaseMain TabDisplays Volumes for the entire network Historical volumesCustomizable detailYOY MetricsFinancial SummaryLoad level informationBookmark filters29

Component PerRepair

Blueview – Component Per RepairWhat is the Component Per Repair Application?Analysis of CPR & Reclaim Lumber Data at a Plant Level Go to the Operations Dropdown, thenBusiness Intelligence, then ComponentPer Repair Selecting the Component Per Repair willdirect you to the Application CPR comes directly from BLANK Key data in the app: Component perrepair %31

Blueview – Component Per RepairSummary TabDisplays volumes for the entire network Network and Plant level detailConsumptionComponent breakoutOverall, Reclaim, NewRU Plus, Premium, Cust, MO32

Inventory History

Blueview – Inventory HistoryWhat is the Inventory History Application?Shows Current & 3 Year Historical Visuals on Inventory Levels by Stock Type. Allowing for Trend Analysis & Historical checks Go to the Logistics Dropdown, thenPlanning, then Inventory History Selecting the Inventory History willdirect you to the Application Inventory comes directly from Sarah34

Blueview – Inventory HistoryMain TabDisplays inventory summary, current detail and historical detail Inventory trendsRegional breakdownsStock type detailNon-productive stockHistorical detail by week and day35

Blueview – Inventory HistoryMain TabDisplays inventory summary, current detail and historical detail Historical detail Detail by day and week36

Blueview – Inventory HistoryPlant Capacity Report TabDisplays current and historical plant capacity Regional and plant level viewsCapacity trendsRegional breakdownsStock type detail“Top 5” tables37

Damage Rate

Blueview – Damage RateWhat is the Damage Rate Application?Insights on Network Damage Rate & Historical Trend Analysis. Feeds all other Apps that display Damage Rate Metrics (Such as ProductionApp) Go to the Operations Dropdown, thenBusiness Intelligence, then DamageRate Report Selecting the Damage Rate Report Iconwill direct you to the Application Damage Rate comes directly fromBLANK39

Blueview – Damage RateDR Dashboard TabDisplays network damage rate, budget and YOY comparison SC and TPM breakdown Network DR YOY DR graph40

Blueview – Damage RateDamage Rate Flows & Volumes TabDisplays damage rate flows and volumes for network and plant level Damage, Sort and Damage Rate Conditioned data PIMS41

Reclaim Per Teardown