150 likes | 162 Vues
Learn about the evolution of financial models from manual calculations to high-tech tools, with case studies from Zambia and East Asia. Discover how these models aided in policy decisions and improved government efficiency.
E N D
From ‘back of the envelope’ - to high-tech policy tool The model in use malcolm.green@c3consult.co.uk
Zambia: the first model 1997 - 1998 malcolm.green@c3consult.co.uk
Zambia: classic bureaucratic issues • Expenditure on pay crowded-out other necessary budget items • Low pay • Ad hoc (and inequitable) allowances • High cost of separating staff • External funds available to help fund a ‘solution’ – but what solution? malcolm.green@c3consult.co.uk
The strategy was clear • Reduce employee numbers to release funds for other budget lines • Improve pay after separations have been made • Consolidate allowances into basic pay • But – no robust financial analysis to determine precise solution malcolm.green@c3consult.co.uk
Zambia: the first model • Custom-built in Excel • User un-friendly (nobody in GoZ could use it) • Not transparent to even an experienced Excel user • But it worked • Ministry of Finance worked through a solution, and presented it to a CG malcolm.green@c3consult.co.uk
Zambia: model output – financial summary malcolm.green@c3consult.co.uk
East Asia financial models 2000 - 2003 malcolm.green@c3consult.co.uk
Background • Asian financial crisis had exposed institutional weaknesses • Governments needed new policy tools to conduct rigorous analysis • Objective: promote government efficiency with the focus on pay & employment • Two major models developed for Philippines and Thailand; plus a ‘generic’ model malcolm.green@c3consult.co.uk
Design criteria • Comprehensive – address all aspects of pay & employment policy • Transparent design • Easy to use – whilst maintaining rigorous analysis • Counterparts to work on model development • Transfer to clients malcolm.green@c3consult.co.uk
Design elements Three parts to model: • Data entry: grade/ministry matrix (very easy to enter/re-enter) • Calculations (inaccessible to user) • Scenario development (very easy to use) with step-by-step guide malcolm.green@c3consult.co.uk
Philippines model • No longer looks much like an Excel worksheet • Easy to prepare – if you have the data • Easy to construct scenarios • Model workings are inaccessible malcolm.green@c3consult.co.uk
The model in use • Typically we put a laptop on the Minister of Finance’s desk • The Minister then plays with the scenarios he wants to see • Live and interactive • Policy decisions can be made on the spot malcolm.green@c3consult.co.uk
Generic model – available on web Developed a ‘Wizard’ to: • Control data entry • Assist scenario-building Used advanced modelling techniques to: • Reduce model size • Speed up processing malcolm.green@c3consult.co.uk
Individual country models • Still required for detailed planning • Needed to design in precise separation/pension rules • Possibly integrate with pensions malcolm.green@c3consult.co.uk