Web based budgeting and forecasting system for an international Pharmaceutical Company

Budgeting Approach
1) Six year planning segment
     (Estimate, Budget, Plus 4 years)
2) Project based with Baseline
3) 'Bottom Up' approach (detail)
4) Automated assistance
5) Annual and monthly data and planning

 

Planning Wizard Modules & Segments
1) Private Cost Center Manager working level
2) General Published reporting level
3) Special segment for Research & Development
4) Special segment for Personnel budgeting and reporting
5) Special segment for Capital Budgeting
6) Financial analysis tools
7) Application administrative modules

Design Features
1) Oracle database
2) DynaSight/inSight
3) Microsoft IIS web server
4) Data input, import, processing, reporting, and transfer
5) Multiple Security levels
6) Intranet

 

Initially this was a three phase project.  The initial phase was to provide consultation to the ‘Business Planning Redesign Core Team’ in determining an appropriate budgeting and forecasting concept.  The second phase was to design, development, and implement an online web based budgeting and forecasting system that met the conceptual requirements of the Pharmaceutical Company in the USA. The third phase was to update, modify, and maintain the system.  Over the five years of its continuing operations, the system has grown significantly in size and functionality.  It has been recently SAP enabled to collect, calculate, display and export end-user cost center budgeting data. 

The System is a large budgeting and forecasting application for cost center, capital, and personnel planning.  It contains extensive automated features for online analysis and for data import and export.  Included are detail budget, forecast and actual financial comparisons that are updated daily.  The end-users access this Oracle system through their browser. 

Highlights of the system:

·  Provides continuity and connections between SAP and the Planning System.

·  Currently used throughout the USA as the planning tool for cost center budgeting within the Division, in preference over the SAP planning module despite a company-wide move to SAP.

·  Provides an automated six year planning range for each planning period.

·  Contains extensive budget, actual, and forecast reporting for all hierarchy levels of the Division from top to bottom.

·  Over a thousand installed users and supports about fifty to hundred concurrent users.

 

---

This page last modified on
Email your comments to info@wpmc.com
Copyright: Williams & Partner, 2004