There are four parts to this assignment.
The first part requires you to prepare a basic master budget. The general description is provided in Part A, in this document. However the
data for the assignment is to be obtained from the associated assignment data file. This file is in MS Excel format and requires you to enter
your student number to generate the assignment data. The data generated is unique to each student. The basic format and requirements of the
assignment are the same for each student, however the different data sets will result in a substantially different solution for each student.
The data file for this assignment is available on the PRBA007 Learnline site in the same section from where you obtained this document.
The second part requires you to write a brief report on the Cost Structures identified in the budget prepared for Part A and in the data
provided in the data file for this assignment. The answer for this part will not be affected by the accuracy or otherwise of your answer to Part
A. The appropriateness (or otherwise) of this report will be based on the analysis you undertake using the data you produce in Part A and the
additional calculations you provide for this part.
The third part also requires you to write a brief report on the Budgeted versus Actual Outcomes using the budget prepared for part A and the
additional data provided in the data file for this assignment. The answer for this part will not be affected by the accuracy or otherwise of your
answer to Part A. The appropriateness (or otherwise) of this report will be based on the analysis you undertake using the data you produce in
Part A and the additional calculations you provide for this part.
The fourth part requires you to research a behavioural and communication issue related to budgeting and performance evaluation. You are
required to refer to the outcomes of Part C to illustrate your essay/report. Details of the issue are provided in Part D. You are to write a short
essay or report, appropriately referenced. A short concise answer is all that is required.