Flexible budget and sales volume variances and the Report

Preparation and Submission Details: This is an individual assignment Students must use excel to perform the calculation in PART A – flexible budget and sales volume variances and the Report i.e. PART B should be prepared using a Word document. An Excel file containing PART A should be prepared using the format prescribed by the management. A Word file containing PART B – the Report should include (at least) executive summary, causes for variances and recommendations. Students are required to use cell references/sheet references/formulas/functions as required. Marks will be deducted if numbers are entered manually. There is no further requirement to provide/show separate calculations (calculations/formula links/cell references/worksheet references in the excel file will be checked by the markers) The students need to submit both word and excel files. Additional information: PDFs will not be accepted. Students must submit their assignments using the submission link on the course website. The language used should be concise and appropriate for a professional environment. Marks will be deducted for poor presentation. Please make sure that PART B - Report does not exceed 1200 (± 10%) words limit. The assignment should be submitted via the online submission link.