Download Final - Electrical Engineering & Computer Science at CSM

Abstract
Omnitech International, Inc designs, engineers, develops, and installs can manufacturing
systems. Omnitech needs an improved budget management and cash flow forecasting
system for each of their projects. Their accounting system, QuickBooks, handles
accounting, but not cash flow or budgeting. Therefore, Omnitech handles cash flow and
budgeting by a process requiring several users, several spreadsheets, and duplication of
data entry. This system is confusing, time consuming, and duplicates efforts for parties
in charge of keeping the system updated and accurate.
Omnitech wants to have cash flow and budget status reports automatically available each
week (and on demand). Both reports must have drill-down capability so that
management can view high-level data and other users may view more in-depth data. The
reports must be user-friendly and the data entry process must be efficient and easy.
Our team analyzed possible solutions for the project, presented our solutions and
recommendations to the client, and finally designed and began implementation of the
client chosen solution.
1