Matching Items (2)
Filtering by
- All Subjects: Procurement
Description
Services procured by government agencies are often ridden with delay and costly change orders. Government agencies may react to these failures by implementing restrictive terms and conditions intended to ensure that the service is delivered on time and within budget. While potentially helpful (and nearly always counterproductive), this approach often fails to recognize the cause of the procurement failure \u2014 inadequate request for proposal (RFP) draftsmanship. The RFP must provide the vendor, or service provider, with a comprehensive understanding of the client's motivations for soliciting the bid, the environment in which the materials and services will be utilized, and accurate specifications for those materials and services. In summary, the RFP must be a clean and concise roadmap of client expectations. This thesis describes, for the novice RFP drafter, a value-based approach to preparing a request for proposal.
ContributorsWheeler, Brynn Marie (Author) / Sullivan, Kenneth (Thesis director) / Savicky, John (Committee member) / Hurtado, Kristen (Committee member) / Department of Supply Chain Management (Contributor) / Department of Marketing (Contributor) / Barrett, The Honors College (Contributor)
Created2018-05
Description
A public North American university needed a tool to automate their Vendor of Record rotation program. The goal was to give each vendor in the program fair opportunities and to be open and honest with how vendors were selected. This tool was created in Microsoft Excel with VBA to code macros. The three major Excel sheets are the Masters, the FM Interface, and the Executive Interface. The Masters act as a database and house data for each project. It is a plain Excel worksheet populated with tables. The FM Interface is a macro-enabled Excel workbook. It is distributed to every Facilities Manager in the program. The FM Interface communicates with the Masters in the background. The FMs use the various inputs and buttons to go through every step of procuring a project. They start by initializing a project, and are given a generated list of vendors who are qualified. This list is automatically rotated for every project. Then they fill in an RFQ and it is automatically emailed to the required vendors. When the Facilities Manager receives every quote, they input them into the program and they are saved to the database. When the project is complete, the manager must fill out a satisfaction survey to measure safety, cost, schedule, and quality of work. This is the main method of tracking vendor performance. The last sheet, the Executive Interface, is given only to the administrator of the program. It generates various reports, such as vendor performance, FM performance, and insurance status. It also has many administrative functions including insurance updating, vendor input, and delete project/vendor. The automated tool has been used without error on over 50 projects by 11 different Facilities Managers. The university's Facilities Management team is pleased with the automated process.
ContributorsSchneider, Steven Andrew (Author) / Sullivan, Kenneth (Thesis director) / Savicky, John (Committee member) / Mechanical and Aerospace Engineering Program (Contributor) / Barrett, The Honors College (Contributor)
Created2016-12