The Managing Director, Tom Copeland has asked you to implement a process to monitor expenditure and income. He has asked you to prepare a spreadsheet to capture and compare actual income and expenditure to budgeted figures. Your spreadsheet must contain columns for each of the four quarters of the financial year. You are required to gather data from the relevant managers (your assessor) to complete a budget variation report.
The report should conform to organizational requirements in policies and procedures
and contain:
_________________ columns to show actual account values
_________________ absolute variation
_________________ percentage variation.