Capacity Planning System – Food Product Provider
PPP is a food processing company that supplies proteins such as pork, sausage, or beef as well as other food items to foodservice and retails brands. They work with their clients to produce custom products and design solutions for manufacturing and the supply chain to meet needs and challenges. Originally founded in 1909 and based out of Aurora, IL, PPP has since grown to have offices and over 40 manufacturing facilities worldwide.
When a customer places an order from PPP, our client must determine its ability to meet that demand. Their process previously involved manually entering order information into one capacity planning spreadsheet. One individual in the organization was in charge of the spreadsheet and manually planned which line in which manufacturing plant would fulfill the order. The PPP employee also made necessary adjustments and received approval from a coordinator before confirming that the order could be placed.
This process limited the company’s growth and provided opportunities for errors to occur. The complexity of the spreadsheet restricted the number of users who were able to correctly input information. When two or more people made requests for orders simultaneously, copies of the spreadsheet were made and worked on separately. The information would then be manually merged after approval and confirmation. This process became too time consuming, and PPP was in search of a new system. They wanted to provide their customers with quick and reliable answers regarding their capacity to produce orders without going through tedious, manual processes that were limited to one person.
We created a capacity planning system for our client to address current problematic processes. With the browser based system, we solved the problem of only one person having access to the Excel spreadsheet to complete capacity planning. Now, anyone who needs to can log in and enter “what if ” scenarios based on requested and current orders to determine the ability to meet demand. The capacity planning software will also provide deeper insights regarding operations.
The system will generate reports for analyzing data over multiple years, so PPP will have a year-over-year comparison of actual versus planned production. Users have the flexibility to change many variables regarding production to examine alternative project options and outcomes generated automatically by the application. Then, requests can be submitted through the new system for coordinator approval.
With this application, we were able to fill in the gaps of the large software systems used by the company, optimizing other areas of production.
5 Reasons to Work with a Local Software Development Firm Over a Large Tech Giant
Navigating through the software development industry can be difficult. When taking on a development project, choosing a provider can take longer than the actual project if you have no idea where to begin! Let’s lay out your options: Forget development, continue business as usual or select an off-the-shelf package (Here are 3 ways forward thinking […]
7 Reasons to Consider a Cloud Migration [Webinar]
November 29, 2017 – 1:00 PM CT Oops! This webinar already took place! To watch a recording of this webinar, please fill out the form below. An email will be delivered immediately to your inbox with a link to the recorded session. Meet the Speakers: Tony Cichella is a Senior Solution Architect at alligatortek, a leading […]
10 Benefits of Outsourcing You May Not Have Considered
Outsourcing is the business practice of shifting tasks, operations, jobs or processes to an external contracted third party for an extended period. To reduce costs or improve efficiency, companies pay an outside organization to work on a project they could not otherwise do themselves. Whether employees don’t have the skills or the scope of the […]