ABBERMIST LIMITED
Programme Office Specialists
Established 08/11/1985
COST CONTROL PACKAGE
Additional Details
Due to the inherent complexities of Finance and Procurement packages currently in the marketplace and each organisations unique approach to financial control and reporting it is extremely difficult if not impossible to be prescriptive in any way other than for the project level where a manager needs control of his project in detail.
The Cost Control Spreadhseet
Intended for use by Project Managers to estimate, monitor, control, and report their project costs.
The cost control Sheet ABBTCOSREG001 is an Excel Workbook made up of four Worksheets namely Summary, Control, Cumulative & Monthly Sheets.
It has been formatted to present a standard printed report with preset headers and footers containing name of document, name of electronic file, worksheet name, page number and date & time of printing.
The Summary Sheet
Results from the Control, Cumulative & Monthly sheets are displayed automatically with room provided for expansion to accommodate user preferences. The bottom half of the sheet provides an area for comments, observations etc.
Data summarised includes: • Overall staff costs split by Internal and External staff, showing estimated full project against actual cost to date. • Hardware Costs showing estimated full project against actual cost to date. • Software Costs showing estimated full project against actual cost to date. • Travel & Subsistence Costs showing estimated full project against actual cost to date. • Total Costs showing estimated full project against actual cost to date.
The Control Sheet
This sheet allows the Project Manager to enter monthly estimates of project costs over a twelve month period with the ability to extend to cover any project duration.
Cumulative Report Sheet
This sheet contains ‘S’ curve graphs describing ‘Estimated’ versus ‘Actual’ cumulative costs for; Staff, Hardware, Software, Travel & Subsistence and ‘Total’. It is automatically updated from the “Control Sheet” and printer prepared.
Monthly Report Sheet
This sheet contains ‘histograms describing ‘Estimated’ versus ‘Actual’ costs by Month for; Staff, Hardware, Software, Travel & Subsistence and ‘Total’. It is automatically updated from the “Control Sheet” and printer prepared.
Back to products page
