Engineering Commons^™

A Database Design For Cvs Pharmacy's Patterson, California Distribution Center, Jason Kenneth Okajima

Industrial and Manufacturing Engineering

CVS Pharmacy’s Patterson, California Distribution Center did not have an efficient and cost effective method for auditing shipped out products. The purpose of this project was to create a new system and procedure for the Patterson Distribution Center to audit shipped out container totes. The distribution center’s original method was slow, inefficient, and involved paper waste, considerable travel time, and several manual procedures. This project was meant to develop a new process and database system to provide a solution to their problem. The end goal of this project was to implement the designed method and system of auditing for daily …

Chevrolet Upper Control Arm Re-Design, Christopher Mclean

Industrial and Manufacturing Engineering

The purpose of this project is to design and manufacture an improved upper control arm for a 1988-1998 Chevrolet K2500 truck. This component controls the suspension of a vehicle and will be redesigned to improve the many shortcomings of the current design. The objectives of this project were met by redesigning the stock upper control arm, designing and manufacturing a weld fixture, manufacturing a prototype component, and performing a cost analysis. This component was designed to improve performance, reliability, serviceability and strength while maximizing manufacturability. The fixture and upper control arm were manufactured using computer aided design, CNC methods and …

Preference-Driven Assignment Decision-Support System For Multiple Sets Of Pairs, Stephen J. Gilmore

Industrial and Manufacturing Engineering

This project focuses on designing a computerized decision support system (DSS) to assist the Cal Poly Alumni Association with scheduling their Mustang Mentoring day. The current scheduling process is time intensive, error prone, and does not consider student preferences. The decision support system optimally generates multiple sets of pairs of students and mentors and schedules them avoiding conflicts and duplicates. The system was developed in Microsoft Excel using its Solver add-in. Excel was selected as the system platform also because of its relative popularity compared to alternative platforms. The DSS utilizes integer linear programming to maximize the total student satisfaction …

Rfid Classroom Management System, Andrew W. Wright

Master's Theses

Professors who manage large classes are unrealistically expected to grade each student fairly and accurately. Even with all of the technological advancements that have occurred in the past thirty years, very little progress has been made in classroom management, and as a result, professors are not equipped with enough tools to successfully manage large class sizes. Because radio frequency identification (RFID) technology is making its way into student issued identification cards, there is an opportunity to use it as a tool to aid professors in the classroom. The focus of this paper is to discover the most effective system that …

An Optimization Approach To Employee Scheduling Using Fuzzy Logic, William G. Spence

Master's Theses

An Optimization Approach to Employee Scheduling Using Fuzzy Logic

William G. Spence

Selection of sales employees is critical because the sales employees represent the company’s image, competitive advantage, technology, and values. In many service systems the majority of consumer contact is with the sales department. Since there are different types of customers, scheduling quality salespersons who can adequately help consumers may affect revenue.

This thesis proposes a new methodology for the scheduling of employees in a service system. The methodology uses Fuzzy Logic to calculate possible sales and Linear Programming to create an optimal schedule. This approach enables the rating …

The Effectiveness Of Milestone Versus Duration Projects In A University Environment, Nicholas James Mehas

Master's Theses

The Critical Path and Critical Chain project management methodologies have different and unique characteristics; both methods are used by project managers to manage projects. This research develops and implements two methodologies, milestones (critical path) versus duration (modified critical chain), in a university environment. The implementation of the two methods allows for the comparison of the effectiveness of both styles. The intent is to determine if there is a significant difference in the project management methodologies in a university setting. The design of both projects allows for easy implementation and the ability to easily record determined measureable statistics.

Migration Models - Comparison Of Pvc, Pet And Pla Diffusivity, Combined With A Production Cost Model For Westridge Laboratories, Shelley Cooke, Sarina Surrette

Materials Engineering

This project has two parts: [1] a migration and diffusivity model for candidate plastics used in containers, and [2] a product cost model for Westridge Laboratories (Santa Ana, CA).

Diffusion modeling is a useful tool to predict migration of polymer constituents into exposed liquids. Polyvinyl chloride (PVC), polyethylene terephthalate (PET) and polylactic acid (PLA) were studied to estimate production costs, and component migration into water-based liquids from plastic containers. Bis (2-ethylhexyl) phthalate (DEHP), antimony trioxide, and stannous octoate, are components of concern in the three candidate polymers, respectively. Normal detection limits for these constituents are about 1 - 10 ppb, …

Effect Of Gold Content On The Reliability Of Snagcu Solder Joints, Jianbiao Pan, Julie Silk, Mike Powers, Patrick Hyland

Industrial and Manufacturing Engineering

Electroplated Ni/Au over Cu is a popular metallization for PCB finish as well as for component leads, especially wire-bondable high frequency packages, where the gold thickness requirement for wirebonding is high. The general understanding is that less than 3 wt% of Au is acceptable in SnPb solder joints. However, little is known about the effect of Au content on the reliability of SnAgCu solder joints. The purpose of this study is to determine the acceptable level of Au in SAC305 solder joints. Three different package platforms with different Au thicknesses were assembled on boards with two different Au thicknesses using …

Design And Implementation Of An Automated Pick And Place System For Johanson Technology, Inc., Alex M. Felker

Industrial and Manufacturing Engineering

Johanson Technology, a capacitor and microelectronic part manufacturer, located in Camarillo, CA has forecasted a 50% increase in demand for single layer capacitors for the year 2011. Johanson chose to hire an intern to design and implement a robotic pick and place system to meet this demand. A complete automated system composed of a Stäubli RS20 robotic arm, CS8C-M Controller, and Electrosort Bowl Feeder needed to be integrated into an environment where no system currently existed. A bill of materials and parts list indicated that the entire system would be a fixed cost of $50,104. This proved to be the …

Process Improvement Of Kaiser Permanente Medical Group, Connie Chou, Brett Witherall

Industrial and Manufacturing Engineering

This report seeks to improve the operations of the Kaiser Permanente’s Central Refill Pharmacy. In particular, the need for better workstations became evident when witnessing the cluttered appearance of the packing workbenches in the facility. Furthermore, one of Kaiser’s largest problem areas is the physical strain caused by the repetitive motion required of the packing job function. A redesign of the packing workstations has been developed on Microsoft Visio in order to reduce clutter, be more space efficient, and decrease eye and arm movement associated with employee strain. The most significant additions are an automated slide that transfers packages from …

Design Of Online Student Fee Committee Proposal Information System, Kenneth Cairns, Gregory (Greg) Jacobson

Industrial and Manufacturing Engineering

The purpose of this project is to overhaul the IME department’s Student Fee Committee (SFC) proposal system. A web enabled database was designed in order to improve this system. A significant amount of time was spent researching different programming languages, paradigms, and frameworks in order to determine the most logical approach to the system redesign. After a few false leads, it was determined that the most appropriate solution to the problem was to design a C# based web form application using asp.NET technology, developed in Microsoft Visual Studio. A mockup was created in Access in an attempt to determine if …

Discrete Event Simulation Manual: Manufacturing Applications, Brian T. Hughes

Industrial and Manufacturing Engineering

Simulation, specifically discrete event simulation, is a useful tool for industrial and manufacturing engineers when dealing with system analysis. Currently, manufacturing engineers are only exposed to simulation for only a few weeks of their curriculum at Cal Poly. A series of labs are directed by a teacher’s assistant on how to complete a successful simulation experiment. However, there is no text available for student use during this demanding learning period. The simulation learning process involves learning a software program called ProModel, which students with little experience are expected to code, run, and interpret data from complex systems. By creating a …

Standardization For Retail Facility Layout For Patagonia, Inc., Derek King

Industrial and Manufacturing Engineering

The purpose of this project is to create a standard layout for Patagonia retail stores. Currently, Patagonia has no standard layouts to follow when they update or open a new store; this has resulted in improper layouts and not fulfilling customers’ needs. This project will develop a way for Patagonia to solve both of these problems based on statistical engineering. The outcome of this project will result in a standard way for determining the optimal layout for new or updated Patagonia retail stores while meeting the business needs of the location.

Optimization Of Screw Cap Process For E & J Gallo Winery, Robert Trent Latimer

Industrial and Manufacturing Engineering

This project takes a microscopic look at all raw material, machinery, and practices that effect the screw cap process of wine products in order to highlight and eliminate the causes of defects. The approach for this project involves the analysis of process capability for raw material to achieve its required dimensions. This project also displays methods of attaining appropriate machinery settings, and provides a basis for operating standards. Many quality engineering applications are used throughout this study, revealing the decision process for analyzing said applications.

The studies in this project found uncontrolled dimensions in the suppliers’ caps and bottles and …

Hardy Diagnostics Facility Redesign, Jamie W. Lam

Industrial and Manufacturing Engineering

This senior project is a facilities design for the plate production room at Hardy Diagnostics. This project was completed using a systematic layout planning approach. The main reason for this redesign was to consolidate all plate line production into one room. This would ensure better visability for the managers. After the project was defined, the different departments were established and the relationships between those departments were found. The space requirements needed for those departments were then measured out to also include the aisle widths and any machinery or carts needed to complete each function. Having determined all requirements for this …

High-Resolution, Non-Contact Angular Measurement System For Psa/Rsa, Ronald D. Sloat

Master's Theses

A non-contact angular measurement system for Pitch Static Attitude (PSA) and Roll Static Attitude (RSA) of hard disk drive sliders is designed and built. Real-time sampling at over 15 KHz is achieved with accuracy of +/- 0.05 degrees over a range of approximately 2-3 degrees. Measuring the PSA and RSA is critical for hard drive manufacturers to control and improve the quality and reliability of hard drives. Although the hard drive industry is able to measure the PSA and RSA at the subassembly level at this time, there is no system available that is able to measure PSA/RSA at the …

A Microsimulation Of Traffic, Parking, And Emissions At California Polytechnic State University – San Luis Obispo, Steven Michael Kilbert

Master's Theses

Traffic and parking congestion are significant issues at many universities nationwide. The delays experienced result in wasted time, money, and fuel for students, faculty and staff, not to mention the negative contributions to the environment. This paper quantifies the amount of vehicle emissions generated during an average morning peak hour in the university environment. Using VISSIM and CMEM microsimulation packages, a model is created for California Polytechnic State University- San Luis Obispo to aggregate the collective transportation behaviors and practices of the campus and recognize the implications these behaviors pose on the transportation network as a whole. Reasonable estimates are …

The Effects Of Anti-Price Gouging Legislation On Supply Chain Dynamics, Jason Edward Maynard

Master's Theses

The purpose of this thesis is to model the effects of anti-price gouging (APG) legislation on the costs to businesses during the recovery period of a disaster. A system dynamics model of a business’s replenishment procedures is used to simulate the effects of APG legislation on business performance. Economists have published expansive research on the effects of price ceilings on supply and demand, but there is little research evidence on the operational consequences of price ceiling legislation on business costs. APG legislation increases consumer’s forward buying and shortage gaming after a disaster by removing price incentives to be frugal. Forward …