Project Description: This project was my primary task for my Summer 2022 internship at Wabash. I created an Excel tool for forecasting machine utilization and manufacturing capacity. My final presentation for the project is included below.
Software Used: Excel
Big Wins: I learned a lot about Excel macros and VBA, and delivered a product that my manager was happy with.
Challenges: This project was more “Big M”-Manufacturing (industrial engineering-y) than my background and interests were and are, so the project wasn’t the best fit for me. I was still able to get some new shop experience from the project though.
Key Takeaways: Moving forward, I definitely want to focus on the single-machine/part scope of manufacturing, rather than broad tasks such as resource planning, thought I can appreciate the importance of such tasks much more now.