Build a production management system that utilizes Excel assets to visualize all processes in the manufacturing department.
【System Considerations】 In the manufacturing department of SOLIZE Products Co., Ltd.'s "Prototyping Business," there was a growing 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 specific changes in order specifications after receiving orders 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, two crucial requirements were the functionality to enable immediate responses to on-site needs (improvement requests) and maintainability, which is essential for continuous operational management.
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. 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 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 quickly to changes in the system's required specifications.
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.www.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 clients 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 aspire to be a globally recognized one-of-a-kind company.