BSBFIM501 Manage budgets and financial plans - Assessment 3 Task A

Task A

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 variance report.
The report should conform to organizational requirements in policies and procedures and contain:
. columns to show actual account values
• absolute variance
• percentage variance.