Spitfire Software Logo

 

Home button Company Software Support button Contact button

 

Project Management

Document Imaging

Workflow/Routing

Watchdog Alerts

Microsoft Project Integration

Project Accounting

Budget/Forecast/Analysis

Contract Management

On-line Pay Requests

Accounts Payable

Accounts Receivable

General Ledger

Cash Manager

FRx Financial Reporting

System Utilities

Customization Manager

Multi-Company

 

 

 

Budget/Forecast/Analysis

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.

BFA screen 3

 

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
    BFA screen 2
  • 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
    BFA screen 1

 

  back to top
  yellow line

Optimizing Microsoft
Solutions for
Owner/Developers

yellow line

Read About It

Project Budget/Forecast PDF

 

yellow line

Technology

  • CodeBehind build in Microsoft .Net
  • Data stored in same SQL database as Dynamics SL
  • Data transfer using XML
  • User interface Microsoft Excel 2003

 

Filters

blue dot Above or Below $ Gain/Loss
blue dot Above or Below % Spent
blue dot Above or Below % Complete
blue dot Past Days of Activity
blue dot Cost to Date
blue dot Specific Cost Code(s)
blue dot Mask of Cost Code
blue dot Best Chances and Lost Causes
blue dot Cost Code with Changes

Sorts

blue dot Gain/Loss
blue dot % Spent
blue dot % Complete
blue dot Date of Last Posting
blue dot Cost Code

 

 

 
   

 

Home | Privacy | Legal | Site Map | Contact  


Copyright (c) 2010 Spitfire Management, LLC. All rights reserved.