MOD003457 Business Planning – Management Accountant’s Report
Stuck with your MOD003457 Business Planning Assessment? If yes, then AssignmentHelpAus is the place where students can easily get the Homework Help from expert writers. Contact our Live Chat team now and get the Best Assignment Writing Service in Australia.
Assessment Details:-
- Course Code: MOD003457
- Course Title: Business Planning
- Referencing Styles: Open
- Words: 9000+
- University: Anglia Ruskin University
- Country: GB
Assessment Task:-
It is the end of the financial year, and you are required to produce a management accountant’s report to be given to the company’s chief financial officer (CFO). Choose a company (real or created) and create a report using Microsoft Word, showing both the original budgeted results for the financial year and the actual results for the financial year. Insert graphs and tables taken from Microsoft Excel where appropriate. Save the final version as a PDF and upload the file to Turnitin.
Include the following:
Contents Page
Report Summary: Summarise main findings in the report, including how the company has performed over the year and how the company has performed relative to the budget. One paragraph, approximately.
A budgeted Statement of Profit & Loss, shown monthly for a period of 12 months for the financial year, including a 13th the column is showing the total for the year.
An actual Statement of Profit & Loss, shown monthly for a period of 12 months, including a 13th column showing the total for the year.
Both actual and budgeted Statements of Profit & Loss should display the following headings (you do not need to break categories down further than this):
- Sales
- Direct Materials (variable)
- Direct Labour (variable)
- Variable Overheads (variable or semi-variable)
- Fixed Overheads (fixed, stepped fix, or semi-variable)
- Gross Profit
- Administration Costs (fixed, stepped fix, or semi-variable)
- Distribution Costs (fixed, stepped fix, or semi-variable)
- Selling Costs (fixed, stepped fix, or semi-variable)
- Operating Profit
- Finance Costs (fixed, stepped fix, or semi-variable)
- Profit Before Tax
- Tax (fixed – evenly spread across the year)
- Profit After Tax
The following graph for the actual performance only. Provide a brief comment on interpreting what the data from the graphs mean and what the implication is for the business:
- A pie chart showing the relative size of each of the costs for the year.
The following graphs are comparing the budgeted against the actual performance. Provide a brief comment on interpreting what the data from the graphs mean and what the implication is for the business:
- A line graph comparing 12 months of budgeted against actual sales
- A line graph comparing 12 months of budgeted against actual gross profit
- A line graph comparing 12 months of budgeted against actual operating costs (administrative costs + selling costs + distribution costs)
- A line graph comparing 12 months of budgeted against actual operating profit
The following cost variances. In the comments include an interpretation of what the variance result means and the implication for the business:
- Sales variance calculations with a brief comment
- Direct materials variance calculations with a brief comment
- Direct labour variance calculations with a brief comment
- Variable overhead variance calculations with a brief comment
- Fixed overhead variance calculations with a brief comment
A budgeted Statement of Financial Position at year-end and an actual Statement of Financial Position at year-end with the following headings:
TOTAL ASSETS
- NON-CURRENT ASSETS
Plant & Machinery - CURRENT ASSETS
Cash - Inventory
Trade Receivables
TOTAL EQUITY AND LIABILITIES
- EQUITY
- Share Capital
- NON-CURRENT LIABILITIES
Bank Loan - CURRENT LIABILITIES
Trade Payables
Ensure that both statement balance (i.e. total assets = total equity and liabilities)
The following performance ratios calculations:
- Profitability ratio calculations for both budgeted and actual years
- Liquidity ratio calculations for both year start and year-end
- Activity ratio calculations for both budgeted and actual years
- Risk ratio calculations for both budgeted and actual years
The following bar chart graphs and a brief comment stating what the variance result means and the implication for the business:
- Profitability ratio charts showing both budgeted and actual
- Liquidity ratio calculations for both year start and year-end
- Activity ratio calculations for both budgeted and actual years
- Risk ratio calculations for both budgeted and actual years
General written style, spelling, grammar, punctuation and overall presentation of financial statements, graphs, calculations, and the report as a whole.