Spitfire’s Budget/Forecast/Analysis
(BFA) spreadsheet combines the ease-of-use, reliability
and versatility of Excel with Spitfire’s unique security, document
control, and
workflow. This combination brings you a true state-of-the art
package including:
User-level security
Site and User preferences stored by view
(Hide/show columns, Rename columns, filters and sorts, set defaults)
Predefined Filters and multiple sort options to focus on user-selected
Cost Codes/Tasks and/or Account Categories/Cost Types
Up to three level of detail – for example,
Division, Cost Codes, Account Categories
Drill-down to source documents for Actual-to-date and Committed-to-date
amounts
User notes stored by row, with drill-down to history with
prior revisions
Project Totals summary, as well as Column
and filter totals
Forecast changes identified as interim or posted
Copy/export data to another workbook for further analysis etc.
By offering three views of your data, Project Managers, Executives and Accountants
can quickly and easily zero in on the precise data they need for their cost
analysis.
Project Analysis
Snapshot of the project’s
current status including:
Current Budget with revision amounts
Real-time Actual and Commitment amounts
Current Forecast projections
Budgeting
Create and maintain the project budget
with a built-in review and approval process;
including:
Create New – Builds the project’s Work
Breakdown Structures from scratch by Adding Cost Codes/Tasks and Cost Types/Account
Categories and Amounts and/or Units for each
Create from Existing - copies an existing project’s budget
Base new budget on Original Budget, EAC, Actuals or FAC
Option to copy all or some rows from the existing budget
Apply multipliers to Amounts or Units
Import Wizard
Capable of working with mixed source documents
that store the Account Categories amounts in either row or column format.
Source documents could be packaged estimating applications with Excel export,
or homegrown Excel spreadsheets
Create multiple import maps and save for repetitive
use
All import methods check for existing Cost
Codes and Account Categories to prevent duplication and offers user keep
or replace option
All import rows displayed in a selection form
where the user can choose which rows to import
Budget Revision
Maintains Original Budget and tracks Revisions in separate columns
Add Cost Codes/Tasks and Account Categories/Cost Types just like being in
creation mode
Multiple saves and closing/opening available between approvals
Forecasting
Create and maintain the project forecast
with built-in algorithms,
including:
Review and approval process
Industry-recommended forecasting algorithms to project Forecast-At-Completion
and Forecast-To-Complete for Cost Codes/Tasks and Cost Types/Account Categories
Forecast data generated based on Units of Production or Amounts
Consolidation Form brings all forecast related fields into one convenient
popup form: Costing Method, Revised EAC, Actual + Committed, Current Position,
Change Amount, Working FAC, Working Gain/Loss
Tracks and identifies changes, by who, what, and when – for each Cost
Code and Account Category
Declare Values for Percentage Complete and
Units Complete allow PMs to position the base from which to forecast to reflect
reality when actual
values may lag behind
What if – change any of the following: % Spent or % Complete, Production
Units, Amounts, Production Unit
