System configuration chart
Sales forecast planning system.
The server is installed in a Japan's data center, and is available from Japan and overseas.
Background and scale of system development
Our company has been extensively using Excel for information sharing. So we have selected work processes one after another where we can expect a great performance boost by using dbSheetClient and so developed and operated. We present here the details of the sales forecast planning system that covers both domestic and overseas activities.
(1) The first step
Domestic factories using dbSheetClient for inventory
We have been using Excel partially for taking month end raw material inventory. Now we have deployed a system to create the book inventory list automatically for physical inventory input, by using dbSheetClient. We have implemented primary and secondary closing feature in the system so we can grasp the progress of inventory as well as standardize the activity. As a result, inventory activity performance has boosted and time and number of staff for inventory has reduced by half.
- No. of screens: 17
- Forms: 3
- Development start: December 2009
- Deployment in production: February 2010
Then, based on the success of the first step, we are promoting systems by utilizing dbSheetClient to address challenges of the sales forecast management for each overseas subsidiary.
(2) The second step
Sales forecast planning system / Japan, Hong Kong, and Guangzhou (production factories) Products: Lamps
We have developed a system to enter the domestic and overseas sales forecast and to relay the data to each domestic and overseas production factory.
- No. of screens: 15
- Forms: 11
- Development start: April 2010
- Deployment in production: October 2010
(3) The third step
Sales forecast planning system / China (Shanghai, Beijing, and Shenzhen, Chengdu) Products: Lamps, equipment
By using dbSheetClient, we have developed a sales forecast planning system that integrates such information from the multiple remote sales offices in China.
- No. of screens: 22
- Forms: 7
- Development start: October 2011
- Deployment in production: April 2012
(4) The fourth step
Sales forecast planning system / Taiwan Products: Lamps, equipment
By applying the sales forecast planning system, our third step deployment done in China, to Taiwan, we have developed a sales forecast planning system with a minimum of customization.
- No. of screens: 22
- Forms: 8
- Development start: April 2013
- Deployment in production: October 2013
System overview
Sales forecast planning system
Location of use: Japan, Hong Kong, and Guangzhou (production factories)
• Switches information sharing method for domestic and overseas sales offices and production factories, from the sending-Excel-files to database sharing.
• Develops a system that can relate weekly production plan, produced by factories, to sales forecast plans of domestic and overseas sales companies.
Sales forecast planning system
Location of use: China (Beijing, Shanghai, Shenzhen, Chengdu) / Taiwan
• Sales representative for each site can input sales forecast for each product / each customer for several years (with an emphasis on the current fiscal year).
• The various analysis tables (budget and performance, difference with the previous month, etc.) that are modified to incorporate the request for features from overseas subsidiaries can be referred to in real time.
• Error messages can be displayed both in English and in Japanese.
- • Inventory activity system sample screen
- • Sales forecast planning system sample screen 1
- • Sales forecast planning system sample screen 2
- • Sales forecast planning system sample screen 3
Reason for adopting the dbSheetClient
The trigger was first hearing about it during an exhibition called “Software Development Environment Exhibition”. dbSheetClient was focusing on the idea of a central management of business data in a database with Excel I/F.
While our company widely used Excel in our sharing of business information, the sending-Excel-files presented many challenges in the operational and management aspects, such as version control, so we required a framework that would allow valid and authentic data inputs for the sales forecast planning and management of it. In particular, in the deployment of the system toward our overseas subsidiaries, we were looking for a system where we can utilize our familiar and efficiency-proven Excel worksheet instead of introducing a finished package, and thought dbSheetClient to be optimal.
Once the inventory management system was established in our domestic factories, there came demands of deployment of the sales forecast planning system from our overseas subsidiaries.
Since dbSheetClient is a front end for Excel, it is easy to use and we were able to achieve a centralized management through a database with Excel I/F. We have also achieved a response improvement by combining terminal services.
For the actual development based on dbSheetClient, we received technical support from NEWCOM, and realized an optimal system development while taking advantage of their development know-how.
Results following the introduction
Inventory management system
• When we first introduced dbSheetClient, we had wondered about how much effect it would have. However, since we could directly take advantage of Excel, and link it natively to Oracle, which is used in the whole company, we were able to recognize that it is an effective tool, and that it can significantly improve our operations.
Sales forecast planning system
• We were able to integrate and manage sales forecast information from each subsidiary in remote locations.
• Thanks to application of the sales forecast planning system to other overseas subsidiaries, we were able to introduce a unified system within the group.
• From the administrator’s viewpoint, the fact that administrative work for the system’s operation can be achieved domestically, and that the system was developed without increasing the local personnel man-power (and without increasing the costs) are considered as factors for successful application of overseas deployment.
• The accuracy of the sales forecast input has vastly improved and analysis operations have become feasible. Since reality we could not see so far has become visible, we were able to achieve an early detection of issues and accelerate our decision-making.
Overseas expansion
• When the system was introduced first, we conducted on-site guidance for data maintenance and operating instructions, but afterwards, everything could run effectively with support from Japan.
Future initiatives
We plan to keep implementing the expansion of the sales forecast planning system to our overseas subsidiaries and further strengthen the cooperation with headquarters.