title: A computer model for predicting the demand for end-stage renal failure (ESRF) treatment, contract setting and monitoring.
abstract: BACKGROUND
  The high cost of end-stage renal failure (ESRF) treatment, and the anticipated need for expansion of the service at a time of limited resources for health care expenditure, means that careful planning of such an expansion is necessary. This needs to inform the setting and monitoring of contracts between commissioning organizations and providers of treatment. A spreadsheet based computer model is described which fulfils both of these needs.
  
  
  METHODS
  A computer programme was written to run on a commonly available spreadsheet in order to predict the demand for ESRF treatment, set contracts, and monitor in year performance.
  
  
  RESULTS
  The model described has facilitated contracting for ESRF services. Purchasers have used it to examine various planning scenarios, while the provider unit has used it to support a business case for further development. Using this model, the predictions for the Sheffield resident population are that the total number of patients on the ESRF treatment programme will increase from a mid-year average of 204 patients in the year 1994-95 to 266 patients in the year 1999-2000, while costs increased over the same time period from 2.37 million pounds to 2.78 million pounds.
  
  
  CONCLUSIONS
  A computer spreadsheet based model described is a useful tool for predicting demand, and setting and monitoring contracts, for treatment for ESRF. Problems with the model and potential further developments are discussed.
authors.affiliation: Department of Public Health, and Sheffield Kidney Institue, Sheffield, UK.
authors.forename: J
authors.initials: J
authors.lastname: Wight
authors.forename: A
authors.initials: A
authors.lastname: Olliver
authors.forename: N
authors.initials: N
authors.lastname: Payne
mesh_terms: D003164:Competitive Bidding / Q000706:statistics & numerical data; D003198:Computer Simulation; D003284:Contract Services / Q000706:statistics & numerical data; D006285:Health Planning / Q000191:economics / Q000706:statistics & numerical data; D006301:Health Services Needs and Demand / Q000191:economics / Q000706:statistics & numerical data; D006801:Humans; D007676:Kidney Failure, Chronic / Q000191:economics* / Q000628:therapy*; D017582:Renal Replacement Therapy / Q000191:economics* / Q000706:statistics & numerical data*; D012984:Software