[Case Study] Transitioning from Excel project management to reducing monthly processing time to approximately 10 minutes.

Revamp individual Excel project management and centralize everything from sales to projects. Reduce the beginning-of-month processing time from several hours to about a few minutes to 10 minutes!

This is a case study from a company that provides technical consulting focused on automotive noise and vibration issues. The company managed projects using one Excel file per project. With 100 to 200 projects running annually, the search, update, and aggregation of files became burdensome, making the beginning-of-month processing an essential task even during New Year and holiday periods. Additionally, information related to sales activities and estimates was managed separately, making it difficult to track the progress of projects across the board. After the system implementation, customer, sales, and project information was managed on a single platform. The screens were adjusted to fit the company's unique calculation methods and business processes, reducing the beginning-of-month processing time from several hours to about 5 to 10 minutes, and the amount of Excel-related work was cut to less than half of what it was before implementation. You can read the full article through the related link. Please take a look. [Challenges Before Implementation] ■ Searching, updating, and aggregating Excel files for each project was time-consuming. ■ Years of modifications had complicated Excel formulas and macros. ■ Information on sales activities, estimates, and projects was dispersed.

DatabaseSFA/Sales Support System