msd total supplier performance and inventory …edge.rit.edu/edge/p16701/public/detailed design...

MSD Total Supplier Performance and Inventory ControlDetailed Design Review

Keleigh Bicknell, William Darlington, Alex Resnick, Brian Woodard

Overview● Overall Project Status● Current State vs. Project Plan● Updated Risk Assessment● Updates to Prototypes since last review● MSD II Plans - Week 1-5● Appendix

Overall Project StatusTIMELINE Continually completing tasks on schedule or ahead of schedule

BUDGETCurrently have spent ~14% of our budget. We will be purchasing a label maker prior to MSDII.

SCOPEPrimarily MSD 4th floor. Hope to do more with the ME machine shop, EE lab, and basement surplus in MSDII.

Project Plan vs. Current StateOriginal Plan

● Paperless Purchase Form● Tool Database● Surplus Database● Streamlined Loan Out Procedure

Current State

★ Paperless Purchase Form○ Integrated Order Tracking○ Team and Guide email notifications

★ Tool Database○ SKUs○ Categorized Tools

★ Streamlined Loan Out Procedure○ Paperless○ Usage reports○ Automated return reminders

★ Budget Management Tool★ Testing Prototypes

Updated Risk Assessment● Adjusted Likelihood Score

○ Card Swipe doesn’t work■ Reduced from 1 to 0: Can use

RIT Student ID #○ MSD Employees do not like new

system■ Reduced from 2 to 1: Continual

communication through design process

● Added two Risks○ Students block emails from website

■ Reduced from 2 to 0: Provide email preference setting

○ Guide is out of office■ Likelihood of 1: Assign a backup

guide to approve after 48 hours

Prototype Changes & RevisionsChanges Since Last Review

● Purchasing○ Email functionality for each milestone○ Email preferences○ Reporting functionality○ List of Vendors

● Tool Loan Out○ Added search for tool by keyword○ Added email functionality to Tools Out Report○ Developed the Tool History Report

Plans for Next Semester

● Purchasing○ Surplus/Tool inventory list○ User testing & Revisions

● Tool Loan Out○ Import the actual tool list○ Import the active student list○ User testing & Revisions

Overall Plans for MSD II● Usability Testing

○ Students○ Employees

● Tool Database● Barcode and 5S MSD Tools● Surplus Database● 5S Surplus● Training and Maintenance Documentation● Beta Testing● Full Implementation

MSD II Weeks 1-5 Preliminary Outline

MSD II Prototype Testing Plan

MSD II Prototype Training Plan

Questions?

Appendix

A summary of the work completed for the Preliminary Design Review, Systems Design Review, Sub System Design Review, and Preliminary Design Review. Spanning Weeks 1 - 15 of MSDI.

Team Roles

From Left: Alex Resnick, Brian Woodard, William Darlington, Keleigh Bicknell

Project Background - Current State● Over 300 students participate in Senior Design every year● Students design, build & test their solution to a design problem● Each team has a budget that can be used to purchase materials

○ Paper process - requires guide’s signature and MSD office sign off

● The MSD office has tools available for students to borrow○ Paper process - challenging to keep students accountable and track tool wear

● The machine shop offers tools and machines for students to use○ No schedule for the machines so students often have to wait○ Over the last 5 years - have ordered over 200 tape measures (no accountability)○ Lots of resources available that student’s don’t know exist so they purchase duplicates

Problem Statement Break Down

Customer Requirements

Engineering Requirements

Engineering & Customer Requirements Matrix

PurchasingFunctional Decomposition

Top Level Functions

Inventory Functional Decomposition

Purchasing Functional Decomposition

System Architecture

Benchmarking

Morphological Chart

Concept Development

Five design concepts were generated through use of the morphological chart. The concept development matrix highlights the primary functions of the system and the design option for each concept displayed on the left.

Concept Selection

Purchasing Process Map

Tool Loan Out Process Map

Prototype Testing Plan

Stakeholder TestingDiscussed prototypes with 5 RIT MSDI students and received feedback:

● Requested all team members receive purchasing update emails● State that tools are available but loaned out and quantity usually available● Could we implement a tool dropbox for returning tools when office is

busy?● Implement a “Search” feature so it’s easy to find exactly which tool you are

looking for● Send Budget sheet after orders are placed/received

Survey ResultsComments and Concerns

● Communicate discounts and shipping cost.● Tracking and order confirmation● Cost summary sheets

Time to Approve (days)

<1 1-2 2-5 >5

Email 0 5 1 1

Signature 6 3 1 2

Current State Analysis Tool Loan Out

Process Expert FeedbackIndustrial EngineersAlec JarvieSuggested additional functionality to update the class list in the prototypes directly from Oracle. In addition, suggested performing spot audits weekly to eliminate one large audit at the end of each semester.

Tim GallmanRequested the tool loan out prototype includes a visual confirmation that the tool was loaned out / returned successfully. Also suggested creating non-admin type queries so students can search what tools they have out as an individual as well as a team as a whole. Robin BorkholderPushed the team to consider how the program could be backed up. What will happen if we lose a day of data. Also suggested a cage area for damaged tools. Potentially could benchmark a R&D company for surplus storage.

Industry SpecialistsMSCOpportunity to utilize a tool vending machine or carousel if RIT commits to an annual sales amount with the company. Received information from MSC pertaining to RIT sales history to determine whether the contract would be in the department's best interest.

GraingerMet with two representatives from Grainger to discuss their vending machine opportunities. Similar to MSC, however the annual sales commitment is less.Emailed the Rochester representative to see if it would be possible to benchmark their facility from an inventory management perspective. Have not received an email back.

Supply PointRequested a slightly damaged machine to test to avoid signing a contract with MSC. Supply Point will not work with us, and instead directed us back to MSC.