1. Read through the scenario provided and tasks A and B. 2. Design and develop a spreadsheet to capture budgeted and actual figures to produce a variance report. 3. Access actual budget figures from relevant managers and accounting systems (assessor). 4. Monitor and record actual figures. 5. Produce a variance report as per organisational requirements. 6. Consider the scenario information and contingency plan provided and analyse the variance report. 7. Modify the contingency and implementation plans provided in the scenario to improve effectiveness. 8. Submit all documents required in the specifications below to your assessor. Ensure you keep a copy of all work submitted for your records