We can develop custom Desktop Software to solve any of your data needs. We have developed simple applications that were used to digitalize data and store it in a database, instead of having to print it and store it in binders. We have developed complex applications that calculated the cost to make bakery items in stores across the United States, which eliminated the use of Excel spreadsheets that had to be udpated every month with new costing information. Please call us at 513-757-9449 if you would like to discuss having a custom application built for your company.
All Desktop Software development is billed at $75/hour.
Advertising Review Center (ARC)
12 departments in 20 divisions needed to update their weekly sales ad comments in 20 spreadsheets by noon every Thursday.
Only 1 person could be in the main spreadsheet at a time.
A department would create a copy of the file to enter their data.
A set range of rows in the spreadsheet were assigned to each department.
Each department would then email their copy back to advertising.
Advertising would open/copy/paste all the data from each department into the main spreadsheet.
Advertising would review the comments and return any that were incorrect or unclear back to the department.
An SQL database was created to store the ad comments.
A VB.Net application was created to allow the department to enter their ad comments without having to wait for a file to be unlocked or create a copy of the file.
As soon as the department finished their ad comments, Advertising would receive a notification.
Advertisng could accept or recject the comment.
If the comment was rejected, the department would receive a notication.
If the comment was accepted, the ad comment was locked and ready to be sent to the printing company.
An average of 500 people worked on weekly sales ad comments every week.
With the old Excelprocess, each person spent about 60 minutes every week working on ad comments.
With ARC, each person spent about 10 minutes every week working on ad comments.
500 x 50 minutes = 25,000 minutes or about 416.67 hours.
The average wage was $25 per person.
Estimated savings in labor per week (416.67 * 25): $10,416.