Mobile Inventory: This Is Not Your Father’s Oldsmobile An Opportunity to Improve Inventory Accuracy and Staff Efficiency using Mobile Expense Issue Return Speaker Information Theresa Kaser Lead Business Analyst, SCM/FIN 10 years at Cincinnati Children’s 17 years working with PeopleSoft Technical and Functional Experience Agenda About CCHMC Oracle Mobile Implementation Modules Device Expense Issue Return by Item Module Collaboration & Development Testing and Training Review/Questions Cincinnati Children’s Hospital Medical Center Established in 1883 Full-service Nonprofit Pediatric Hospital with over 14 thousand employees In 2013, We served over 1.1 million patients from 53 countries and all 50 states Ranked 3rd in the nation among all Honor Roll Hospitals in the 2013 U.S. News & World Report survey of best children’s hospitals PeopleSoft 9.1/PeopleTools 8.53.11 Cincinnati Children’s Hospital Medical Center OR Surgery Area Two Campuses – Main and Liberty 37 Surgery Suites 700 SKU’s Inv Main 1900 SKU’s Inv Liberty Combined Nursing & OR 120 PAR locations 31,500 Surgery Cases FY14 Overview Manage Supply Returns from Surgery and Nursing using Mobile Solution Opportunity to meet Strategic Initiative Goals Add Value to Surgery Warehouse workflow Improve Inventory Accuracy and management of supplies SmartERP partnership Mobile Solution Implementation Review Identify Modules Device Selection Mobile Solutions Module Rollout Expense Issue Return by Item Mobile Solution Implementation Replace Existing 3rd Party mobile applications PAR Count and Delivery Implement Oracle Mobile solutions Receiving: PO and Non PO Delivery with signature/badge scan capture Count: Cycle and Physical Express Issue Item Inquiry Identify gap for Expense Issue Returns Mobile Solution Implementation Replace Existing 3rd Party mobile applications PAR Count Provide Bar Code labels Additional areas outside of Inventory to use Mobile PAR Count – Clinical Labs and Research labs Use PAR Count or AdHoc Count Mobile Solution Implementation Delivery PO and Non-PO: created Non PO BU Bar code on Receipt Delivery document Non PO creates a Receipt Delivery doc Ability to capture delivery confirmation using employee badge scan Information stored on Receipt Delivery Inquiry Mobile Solution Implementation Add Oracle Mobile Solutions Bar Code Scanning Signature/Badge EmplID capture Express Issue Item Stock Inquiry Count: Guided Count, Count by Location, Count by Item Mobile Solution Implementation Mobile Solution Implementation Device Selection and Requirements Rugged – Has to handle rough treatment, drops, bumps Must be HTML 5 compliant without additional cost Easy to Manage and compatible with Mobile Device Management software Include 2D Barcode Scanner attachment Mobile Solution Implementation-Device iOS – iPad/iPod/iPad Mini Pros Cons Familiar platform Durability -- screens get cracked often Significant App support What size do we choose Usability Scanner attachments require coding on device via Apple iOS SDK Scanning from camera is slower and also requires coding on device Mobile Solution Implementation-Device Android Pros Familiar platform Significant App support Usability Android OS is more simple to adapt to Enterprise based on Motorola's success Cons Android devices have saturated the market -- which device would we choose? Durability? -- with so many devices which one is the most durable With so many apps there is concern over quality of the apps Mobile Solution Implementation-Device Mobile Solution Implementation-Device Drop specifications - Multiple 4 ft./1.2 m drop per MIL STD 810G O/S Android 4.1.1, Enhanced with Enterprise 2D Barcode Scanner attachment Rubber Bezel to increase Shock-Protection AirWatch Device management Provides AW Browser and AW Launcher-securing access Expense Issue Return by Item Solution Challenges and Objectives Opportunity to meet specific business goals Pre Mobile Solution Workflow Define Requirements Post Mobile Workflow Expense Issue Return by Item Solution Strategic Goals – Process Improvement Initiative Increase Efficiency and Timeliness in the Procurement and Inventory Process by Implementing a Mobile solution for Issues/Returns and related process changes in the Operating Room. Expense Issue Return by Item Solution Pre Mobile state Manual picks not updated in system Manual returns not entered in system Additional effort completing Cycle Counts to correct item on hand balance System order lines canceled when stock qty physically available Return Workflow inconsistent Expense Issue Return by Item Solution Requirements Provide a Mobile transaction that will allow items from the OR and other departments to be returned to Inventory. Use with existing component and PeopleCode logic Expense Issue Return function for Department returns Use with Motorola ET1 device Ability to use Bar Code Scan Search by Item ID or MFG Item ID Expense Issue Return by Item Solution Main menu Expense Issue Return by Item Solution Header section Inventory BU defaults from User Preferences or is entered manually. Distrib Type entered manually or by scan CCHMC has custom logic defaulting the GL BU based on Distrib Expense Issue Return by Item Solution Middle Section PeopleSoft Item ID scanned from bar code or manually entered. Display Item’s Descr254 Display MFG Item ID as Default and as Searchable field Tab from field will trigger Fetch Display Item default Putaway location. Allow user to change. Display Item default STD UOM. Allow user to change. Expense Issue Return by Item Solution Third Section -List of items to return Cursor moves to Return Qty after Item fetch Add “Item” Push Button, to add additional row Expense Issue Return by Item Solution Item Added to list Option to cancel item, change qty, or UOM Cursor returns to Item field for next item Expense Issue Return by Item Solution Error Handling Warning message-Qty exceeds 99 Expense Issue Return by Item Solution Receipt Created Expense Issue Return by Item Solution Display returns to a new Receipt Entry transaction Expense Issue Return by Item Solution Development Collaboration with SmartERP Developed Demo for Proof of Concept User Approval of Defined Requirements Created Test scenarios Included Usability of Device Expense Issue Return by Item Solution Testing Iterations Core Users involved Focus on Module Device Expense Issue Return by Item Solution Testing Device usability Feedback and Collaboration with End Users and DeskSide Mobile support Resulted in improvements to device usability and end user workflow. Defined Best Practice Play! Expense Issue Return by Item Solution Additional Evaluation and Analysis of OR Return Workflow Provide accessible location Label area Aggregate supplies Educate staff on process-Surgery & Inventory Develop workflow using scan & drop Expense Issue Return by Item Solution Expense Issue Return by Item Solution Expense Issue Return by Item Solution Using bar code scanner, items are Returned and Issued Expense Issue Return by Item Solution Lessons learned and Outcomes Take advantage of Existing Weekly OR In-service training meetings for communication Positive Collaboration between OR Management and SCM Team Collaboration improved Adoption of Solution Expense Issue Return by Item Solution Lessons learned and Outcomes Improve physical organization of Supply OR Returns Cart Aggregate supplies by type-reduced number of steps and transactions Don’t be afraid to pull the trigger Spend time up front working through device mechanics-with the End user teams-More play and then GO! Expense Issue Return by Item Solution Goals Met Improved Inventory Accuracy Improved Workflow Reduced product Return time and eliminated duplication of effort Expense Issue Return by Item Solution Lessons Learned – Project Review Include all Stakeholders in Business Analysis and Requirements gathering Builds Ownership, Adoption and Success Enhance and Support Compliance Develop usability matrix Track Issues and improvements with devices – to include environment and hardware Include “testing” in device workflow Mobile Solution Implementation Questions? Contacts Theresa Kaser Lead Business Analyst, PeopleSoft SCM/FIN Cincinnati Children’s Hospital Medical Center [email protected] Matthew Tewksbury Director Sterile Processing & Periop Supply Chain Cincinnati Children’s Hospital Medical Center [email protected] Duke Otoshi Supply Chain Mobile Consultant SmartERP [email protected] Jason Addison Supervisor Periop Supply Chain Cincinnati Children’s Hospital Medical Center [email protected]
© Copyright 2024