Build a production management system that utilizes Excel assets to visualize all processes in the manufacturing department.
【System Consideration Issues】 In the manufacturing department of SOLIZE Products Co., Ltd.'s "Prototyping Business," there was a need for significant system improvements in production management and business support systems to respond more quickly than ever to changes in the increasingly diverse prototyping market and to the unique requirement changes after order receipt in the prototyping business. 【New System Requirements】 The selection of the system to be implemented required the following criteria: - The system must allow the manufacturing department to take the lead in its operation and improvement. - It should enable the re-utilization of many Excel assets created using Microsoft Excel VBA for business efficiency. 【Adoption of dbSheetClient】 Considering the above points, the decision was made to adopt Newcom's dbSheetClient. In our development environment, which assumes in-house development and maintenance after system construction, the functionality to respond immediately to on-site needs (improvement requests) and the maintainability essential for continuous operational management were two very important requirements.
Inquire About This Product
basic information
【Development Form】 We aimed to systematize using existing Excel assets with dbSheetClient, and we tried to develop while making the most of the features of this product as much as possible. This product has a component called task type, and by combining these, we were able to create quite complex logic. However, we were not able to express all the functions we required solely with task types, so we also utilized Excel VBA for the parts that were lacking. During the development process, we received technical support from Newcom, which allowed us to build the planned system. 【Implementation Effects】 The effects of the new system implementation can be summarized in two main points. The first is the reduction of man-hours in schedule management and the ability to respond to specification changes from customers in a shorter time. The second is the ability to respond to changes in system requirements in a shorter time.
Price range
P5
Delivery Time
Applications/Examples of results
【dbSheetClient Purpose】 ○ Model System Examples → Petty Cash Management System → Support Business Assistance System ○ Usage Examples → Production Management System → PSI Management System → PL Monitor System → Sales Forecast Management System → Attendance Management System → KPI Management System → Employee Capability Management System → Customer Management System → Sales Performance Management System → Order Product Inquiry System → Bento Reservation and Ordering System → Construction Project Management System → IT Equipment Management System For more details, please contact us.
catalog（11）
Download All Catalogs![[Case Study] Production Management System Utilizing Excel - SOLIZE Products](https://image.mono.ipros.com/public/catalog/image_generated/01/166/265784/265784_IPROS860331483589596907_1.jpg?w=120&h=170)
Company information
Our headquarters is located in Saitama Prefecture, but our customers are located throughout Japan. Our CORE THEMA is "Bridge," and our logo is inspired by the concept of a "Bridge." We were established with the aim of becoming a "Bridge" to a hopeful future for everyone through the platform of IT, and we strive to be a globally recognized one-of-a-kind company.