1 Mandatory requirement: Students are required to complete Budget on the provided Excel 2 3 4...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1 Mandatory requirement: Students are required to complete Budget on the provided Excel 2 3 4 5 5 B spreadsheet template. (For the purpose of Budget calculation in the assessment, ignore all GST calculations) Task 1 Below you are provided with details of two companies and their budgets. Prepare the budgets and complete the following tasks: From the following information relating to Marmax Consulting Services, prepare a budgeted Income Statement (Budget 1) for the period from January to December 2022, showing the profit level required by management. 0 9 (Note: Please refer to the Extract of Policies & Procedures in Appendix A on page 8): The budgeted fees estimate is expected at 100 per cent Only 80 per cent of the fees budget estimate is achieved 1 2 3 Nominate at least 1 Key Performance Indicator (KPI) in this budget 4 5 The fees budget shows a budgeted level of 1000 consultancy hours per month at $100 per hour, of 6 which the hourly rate has been set at a budgeted level at least 10% lower than the average market rate in the industry. 7 8 Expenses are as follows: Advertising is a fixed amount of $4,500 per annum plus 1.25 per cent of fees 9 10 Office wages $2,000 per month 1 2 Office supplies is fixed amount of $2,100 per annum plus 10 cents per consultancy hour Staff salaries $8,500 per month 3 Staff commission 4 per cent of fees 4 Vehicle expenses $15,300 per annum plus 0.25 per cent of fees 5 Interest expense 15.5 per cent per annum of a loan of $20,000 6 Legal fees $1,000 per month plus 0.7 per cent of fees. 7 Rates $12,900 per annum. 8 Income tax 33 cents in the dollar Prepare a performance report for the above income statement (in Question A) for the year ended December 2022, showing Income, total expenses, profit before tax, and all variances from the budget in dollars and percentages. 9 Fixed costs include: Office wages; Staff salaries; Rates. 0 -1 2 3 4 5 6 You are acting as an accountant for the General Manager of Marmax Consulting Services and are required to write a formal short report on the performance of the actual budget. The report must be provided to the General Manager within one month of the close of End of Year. 1 234 A (Task 1A) 5 INCOME 6 B C D E F G MARMAX CONSULTANCY SERVICES Budgeted Income Statement for period January to December 2022 7 Consultancy hours (HRS) 8 Consultancy fees received ($) 9 EXPENSES 10 11 Advertising 12 Office wages 13 Office supplies 14 Staff salaries 15 Staff commission 16 Vehicle expenses 17 Interest expense 18 Legal fees 19 Rates 20 TOTAL EXPENSES 21 Profit before tax 22 Tax Payable 23 Net Profit after Tax H (Task 1D) Estimated Budget for new calendar year 2023 100% Budgeted before start of year 2022 80% Actual Achieved in year 2022 Variance F/U Variance Percentage % Change in the new year 2023 (from year 2022) 1 Mandatory requirement: Students are required to complete Budget on the provided Excel 2 3 4 5 5 B spreadsheet template. (For the purpose of Budget calculation in the assessment, ignore all GST calculations) Task 1 Below you are provided with details of two companies and their budgets. Prepare the budgets and complete the following tasks: From the following information relating to Marmax Consulting Services, prepare a budgeted Income Statement (Budget 1) for the period from January to December 2022, showing the profit level required by management. 0 9 (Note: Please refer to the Extract of Policies & Procedures in Appendix A on page 8): The budgeted fees estimate is expected at 100 per cent Only 80 per cent of the fees budget estimate is achieved 1 2 3 Nominate at least 1 Key Performance Indicator (KPI) in this budget 4 5 The fees budget shows a budgeted level of 1000 consultancy hours per month at $100 per hour, of 6 which the hourly rate has been set at a budgeted level at least 10% lower than the average market rate in the industry. 7 8 Expenses are as follows: Advertising is a fixed amount of $4,500 per annum plus 1.25 per cent of fees 9 10 Office wages $2,000 per month 1 2 Office supplies is fixed amount of $2,100 per annum plus 10 cents per consultancy hour Staff salaries $8,500 per month 3 Staff commission 4 per cent of fees 4 Vehicle expenses $15,300 per annum plus 0.25 per cent of fees 5 Interest expense 15.5 per cent per annum of a loan of $20,000 6 Legal fees $1,000 per month plus 0.7 per cent of fees. 7 Rates $12,900 per annum. 8 Income tax 33 cents in the dollar Prepare a performance report for the above income statement (in Question A) for the year ended December 2022, showing Income, total expenses, profit before tax, and all variances from the budget in dollars and percentages. 9 Fixed costs include: Office wages; Staff salaries; Rates. 0 -1 2 3 4 5 6 You are acting as an accountant for the General Manager of Marmax Consulting Services and are required to write a formal short report on the performance of the actual budget. The report must be provided to the General Manager within one month of the close of End of Year. 1 234 A (Task 1A) 5 INCOME 6 B C D E F G MARMAX CONSULTANCY SERVICES Budgeted Income Statement for period January to December 2022 7 Consultancy hours (HRS) 8 Consultancy fees received ($) 9 EXPENSES 10 11 Advertising 12 Office wages 13 Office supplies 14 Staff salaries 15 Staff commission 16 Vehicle expenses 17 Interest expense 18 Legal fees 19 Rates 20 TOTAL EXPENSES 21 Profit before tax 22 Tax Payable 23 Net Profit after Tax H (Task 1D) Estimated Budget for new calendar year 2023 100% Budgeted before start of year 2022 80% Actual Achieved in year 2022 Variance F/U Variance Percentage % Change in the new year 2023 (from year 2022)
Expert Answer:
Related Book For
Fundamentals of Financial Accounting
ISBN: 978-0078025914
5th edition
Authors: Fred Phillips, Robert Libby, Patricia Libby
Posted Date:
Students also viewed these accounting questions
-
Give the approximate temperature at which creep deformation becomes an important consideration for each of the following metals: nickel, copper, iron, tungsten, lead, and aluminum.
-
Sketch the ac equivalent model for a JFET if IDSS = 10 mA, VP = -4 V, VGSQ = -2 V, and yos = 25 S.
-
Switzerland is 48 percent Protestant. Heidi Gilsing is a Swiss. Therefore, Heidi Gilsing is 48 percent Protestant. Identify the fallacies of presumption, ambiguity, and illicit transference committed...
-
From the point of view of each observer in Figure \(6.5,\) (a) is the energy of each cart constant? (b) Is the isolated system containing cart 1 closed? (c) Is the isolated system containing cart 2...
-
What did Brown and BWNS do well in this situation? What could have been done better? MINI CASE Reggie Brown, B&W Nuclear Service Companys (BWNS) project manager for Nita Light and Powers Green Meadow...
-
A multinational corporation is accused of environmental pollution and human rights violations in a foreign country where it operates. What legal challenges arise in holding the corporation...
-
Haiti was hit by a magnitude 7.2 earthquake on August 15, 2021. The earthquake occurred at the Tiburon Peninsula, leaving at least 1,297 people dead and more than 5,700 injured, according to the...
-
Write project about the capital structure of Amazon or any publicly traded company and the M&M theory of capital structure. project should consist of The I-Abstract II - Table of Contents III -...
-
What is your analysis of Aviva Investors' campaign against Vedanta? What are the benefits to Aviva?
-
Assume the interest rate is 10% and quarterly compounding. 1. You are going to receive $10,000 in five years. What is the present value? 2. You are going to receive $2,500 at the end of each quarter...
-
Discuss the maSince the late 1980's many national financial markets got aboard the liberalization process to enhance global integration of all the financial markets. Required: i) Discuss the...
-
How do terrorist organizations typically convert cryptocurrencies into fiat currency, considering the challenges associated with direct conversion on traditional exchanges?
-
1) Define what is meant by the division of labor and its importance in business? 2) What is the essence of technology in the field of economics?
-
A bar of a steel alloy that exhibits the stress-strain behavior shown in Figure 6.22 is subjected to a tensile load; the specimen is 375 mm (14.8 in.) long and has a square cross section 5.5 mm (0.22...
-
The position of a particle is defined by the position vector where numerically \(a=0.33, b=0.71, c=1.0\). Determine: 1. the dimensions of \(a, b, c\); 2. the function describing the velocity and...
-
A projectile is launched from the Earth's surface with velocity \(v_{0}=50.0 \mathrm{~m} / \mathrm{s}\), at an angle \(\theta=60^{\circ}\) to the vertical. Determine the radius of curvature of the...
-
The equation of motion of a particle is given in Cartesian coordinates by the relation \(\mathbf{r}(t)=\alpha t^{2} \hat{\mathbf{i}}+\beta t^{2} \hat{\mathbf{j}}\). Determine (i) the trajectory of...
Study smarter with the SolutionInn App