DataTree Spreadsheets
datatreespreadsheets.co.uk

Standard Costing and Resource Management Model

Using DataTree Spreadsheets we have fully developed what we believe is a balance between simplicity and the need to have a future proof costing and resource management planning model that can handle conceivable changes. This model includes built-in validation and error checking and can be as simple or as detailed as mangers require.

The same standard costing and resource management model may be used for both the public and private sector.

The model is used to support:-

• Issues regarding product/service cost;

• Managing resources, including optimization;

• Monitoring of performance and service delivery;

• Efficiency targets;

• Benchmarking of services across all sectors;

• Consideration of investment decisions;

• Negotiation of revised levels of funding.

 

Our costing is undertaken on a full absorption basis. Full absorption means that costs of products/services should be matched to the resources that were used to generate them reflecting the full and true cost with the minimum of cross-subsidisation, taking into consideration the data and time available.

 

With our historical background in costing hospital departments such as pathology and radiology, then moving into costing surgical procedures like hip and knee replacements and the problems that highlighted, we set about developing DataTree Spreadsheets and believed one day someone would be interested in looking at cost, against quality against outcome with resource optimization, capacity planning, benchmarking and contract monitoring, all in a single model. A tall order, but one, that helped us to develop the first real numerical processor.

This standard model also follows the NHS Costing guidelines to the letter and is capable of going well beyond with the added optimization facilities for any resource. The model uses advanced reverse calculation techniques; ideal for playing advanced “What ifs”. e.g. What is the maximum workload we can do within this budget, with these limits on these resources?

You can have thousands of product forms in a single model and the real clever bit is, there is only one set of equations, one for each rule (only 180 equations) which you will never see or need to edit.

 

A developer can assist with automatic data import using standard file formats, like a monthly transaction list. Any new items will be highlighted if not already assigned to a cost recovery centre. Once the model is set up, by pressing one button a full Word document can be automatically produced which contains all the tables and graphs to help make decisions.

 

 

 

A full description of this model is available on request together with a range of optional bureau services.