This fall, our Capstone project team is working with Procter & Gamble (P&G), a global consumer product goods company. P&G is a Fortune 50 company that serves approximately 4.8 billion people around the world with its brands. P&G’s brand portfolio includes many household names like Gillette, Bounty, and Tide, and 25 of those brands generate more than $1 billion in annual sales.
This semester, our team will be working on digitizing the paperwork and processes behind P&G’s sales initiatives. Currently, all of the paperwork associated with these new sales initiatives is sent from employee to employee using Word documents in email attachments. The Word document is highly editable and employees are taking advantage of that by creating documents that don’t follow a standard format and exceed recommended lengths by dozens of pages. To compound the issue, there is no real enforceable structure behind the document creation process, which can lead to several conflicting versions existing at the same time and employees not knowing whose responsibility it is to continue the process. Overall, these issues lead to one of the biggest problems a company like P&G can face: decreased sales.
Our Capstone team is working on a two-part solution for P&G’s sales initiatives. The first is the creation of a web form that will replace the Word document. This form will allow for restrictions to be placed on the document and will end the problem of multiple conflicting versions existing at the same time. The second part is an automated workflow solution. This solution will take care of notifying employees of when it is their responsibility to work on the form or authorize further work to be done, decreasing the amount of downtime that currently exists in the sales document creation process.
The team just got out of the administrative and planning phase of the project. We are now doing preliminary work on the web form part of the project, with plans to finish the form by October 9, 2014.