Microsoft Dynamics 365 Purchasing Supply Process at Alta

Microsoft Dynamics 365 – Purchasing & Supply Process at Alta. Steel Presented by: Cheryl Laird, Strategic Procurement Manager Leanne Waye, Supply Chain Specialist, Inventory & Planning Yi He, Strategic Supply Chain Lead Date: February, 2018

Who We Are Alta. Steel is an Edmonton based, Canadian manufacturer of prime quality steel products from recycled scrap steel generated within the Alberta community. Alta. Steel is a producer of rolled steel long products for the mining, construction, automotive and engineering industries. The company operates steelmaking, hot rolling and heat treatment facilities and has an installed production capacity in excess of 330, 000 tons/year. We supply western Canadian businesses and export to the USA and Mexico. As raw material, we use in excess of 300, 000 net tons/year of scrap steel arising from Edmonton and greater Alberta, thereby contributing to the recycling of waste in our community We have been operating since 1955, and currently have 360 employees. Part of a global network of companies under Moly-Cop, headquartered in Sydney Australia with sites in Australia, Indonesia, Chile, Peru, Mexico, USA, and Canada.

Dynamics 365 Profile Alta. Steel is implementing Dynamics 365 in two phases. Phase 1: finance, purchasing, supply chain and maintenance Phase 2: customer, sales order processing and inventory Alta. Steel went live with Phase 1 in October, 2017 Phase 2 is tentatively schedule for a November/December 2018 implementation.

Supply Chain-Inventory Services Stocked items range from high value plant components to fast moving consumables Active Item Codes 16, 800 Active Inventory SKUs 10, 000 Inventory Value $17, 500, 00 0 Stocked Items Inventory Managed 60% IHM 5% Repairable Spares 35%

Supply Chain-Procurement Purchase Order per Year Purchase Order lines per year Inventory Purchases: 15, 000 Non Stock Purchases: Services Purchases 4500 2500 8000 Old system D 365 WOs Direct Requisitions Replenishment Requisition Queue Replenishment WO & Direct Requisitions Planned Orders Purchase Requisitions Queue 1 Queue 2

Ongoing Challenges • • More transactional steps needed to complete operations. Reduction of Consolidation capabilities. Pricing intelligence updates are manual (trade agreements). Gaps in process such as Landed Cost demand increased number of customizations in the system. • Designed for use within a barcoded warehouse which Alta. Steel does not have

Lessons Learned • Communication is key to all elements of project streams • Continuity of service with Consultants is critical to project • Subject Matter Experts are required from project concept • End to End Business testing is a requirement • Silo testing causes longer term problems • Well documented processes and training documents are critical to success • • User interaction increased exponentially in terms of people to support

Summary We are only 4 months into the new system. Our focus is on bringing efficiency to system and processes. Many workarounds in place across the solution. Business requires additional resourcing to support changes to work processes. Visibility of transactions limited due to lack of reporting capabilities. Microsoft Support and continued consultancy is a must have.