The south African government had election during the last thirteen months. New administration came with new...
Fantastic news! We've Found the answer you've been seeking!
Transcribed Image Text:
The south African government had election during the last thirteen months. New administration came with new national department, Department of Air Travel. The purpose of the new department is to regulate airlines. It was separated from the National Department of Transport which has just been given a new responsibility to regulate the taxi industry. You were appointed as a Director within Financial Management Directorate of the established department. One of your responsibilities is preparation of financial statements. The following information is available to you to prepare the below required statement and notes as part of annual financial statements. 3.1. Design a template using Microsoft Excel to prepare the annual financial statements. Your Template should include: 3.1.1. Name of each sheet from your workbook 3.1.2. formulas and links. 3.1.3. Fill colour to indicate areas which are editable 3.2. Compile a statement of financial performance of Department of Air Travel for financial year ended 31 March 2022. Notes to the statement of financial performance 3.3.1. Annual appropriation 3.3.2. Departmental revenue 3.3. 3.3.2.1. Sales of goods and services other than capital assets 3.3.2.2. Fines, penalties, and forfeits 3.3.2.3. Interest and dividends 3.3.3. Compensation of employees 3.3.3.1. Salaries and wages 3.3.3.2. Social contribution 3.3.4. Goods and services 3.3.5. Transfers and subsidies A. Trial Balance of Department of Air Travel for the year ended 31 March 2022 Debit General Account of Vote Interest Fines Penalties Dividends Administrative fees Sales by market establishment Sales of broken laptops (current) Purchases of New Equipment Bought Buildings Aid Assistance Aid assistance (current) Basic Salary Service based wages Medical aid Bargaining council Pension Fund Transfers to Households Transfers and subsidies (Public corporations) Water and electricity Cleaning Interest paid Stationery Rent on land Bought new laptops (current) Consultation and advisory Administrative fees Computer Software Advertising Bursaries to employees Audit cost Fleet services Travel and subsistence Inventory Unauthorized expenditure approved without funding Venues B. Additional Information 10 000 000 15 000 000 650 000 8 000 000 960 000 210 000 35 000 200 000 550 500 7 000 000 180 000 65 000 15 000 13 250 350 000 30 000 450 000 680 000 100 000 170 020 200 000 32 000 75 000 630 000 20 000 600 000 100 000 Credit 154 820 440 80 000 60 000 90 000 930 000 3 000 000 1 500 000 92 000 750 000 1. All the appropriated funds to the department were received. 2. The remaining balance of voted funds/Annual appropriation to be surrendered was R109 154 670. 3. The remaining aid assistance was R100 000. 4. There was no own revenue included in Annual appropriation. 5. The Department currently has four Programmes i.e. Administration, Operational, Aviation and Corporate services. The department's vote/ appropriation is allocated in the following ratio: • Administration 50% • Operational 20% • Aviation 20% • Corporate services 10% The south African government had election during the last thirteen months. New administration came with new national department, Department of Air Travel. The purpose of the new department is to regulate airlines. It was separated from the National Department of Transport which has just been given a new responsibility to regulate the taxi industry. You were appointed as a Director within Financial Management Directorate of the established department. One of your responsibilities is preparation of financial statements. The following information is available to you to prepare the below required statement and notes as part of annual financial statements. 3.1. Design a template using Microsoft Excel to prepare the annual financial statements. Your Template should include: 3.1.1. Name of each sheet from your workbook 3.1.2. formulas and links. 3.1.3. Fill colour to indicate areas which are editable 3.2. Compile a statement of financial performance of Department of Air Travel for financial year ended 31 March 2022. Notes to the statement of financial performance 3.3.1. Annual appropriation 3.3.2. Departmental revenue 3.3. 3.3.2.1. Sales of goods and services other than capital assets 3.3.2.2. Fines, penalties, and forfeits 3.3.2.3. Interest and dividends 3.3.3. Compensation of employees 3.3.3.1. Salaries and wages 3.3.3.2. Social contribution 3.3.4. Goods and services 3.3.5. Transfers and subsidies A. Trial Balance of Department of Air Travel for the year ended 31 March 2022 Debit General Account of Vote Interest Fines Penalties Dividends Administrative fees Sales by market establishment Sales of broken laptops (current) Purchases of New Equipment Bought Buildings Aid Assistance Aid assistance (current) Basic Salary Service based wages Medical aid Bargaining council Pension Fund Transfers to Households Transfers and subsidies (Public corporations) Water and electricity Cleaning Interest paid Stationery Rent on land Bought new laptops (current) Consultation and advisory Administrative fees Computer Software Advertising Bursaries to employees Audit cost Fleet services Travel and subsistence Inventory Unauthorized expenditure approved without funding Venues B. Additional Information 10 000 000 15 000 000 650 000 8 000 000 960 000 210 000 35 000 200 000 550 500 7 000 000 180 000 65 000 15 000 13 250 350 000 30 000 450 000 680 000 100 000 170 020 200 000 32 000 75 000 630 000 20 000 600 000 100 000 Credit 154 820 440 80 000 60 000 90 000 930 000 3 000 000 1 500 000 92 000 750 000 1. All the appropriated funds to the department were received. 2. The remaining balance of voted funds/Annual appropriation to be surrendered was R109 154 670. 3. The remaining aid assistance was R100 000. 4. There was no own revenue included in Annual appropriation. 5. The Department currently has four Programmes i.e. Administration, Operational, Aviation and Corporate services. The department's vote/ appropriation is allocated in the following ratio: • Administration 50% • Operational 20% • Aviation 20% • Corporate services 10%
Expert Answer:
Related Book For
Managing in a Global Economy Demystifying International Macroeconomics
ISBN: 978-1285055428
2nd edition
Authors: John E. Marthinsen
Posted Date:
Students also viewed these accounting questions
-
The following particulars relating to the year ended 31 March 20X3 have been extracted from the books of Heel and Toe, footwear wholesalers. All sales have been recorded in personal accounts in the...
-
The following particulars relating to the year ended 31 March 20X3 have been extracted from the books of a trader:...
-
The following figures relating to the year ended 31 March 20X3 have been extracted from the books of a manufacturer: ............................................................... Total of sales...
-
Two ball bearings from different manufacturers are being considered for a certain application. Bearing A has a catalog rating of 2.0 kN based on a catalog rating system of 3 000 hours at 500 rev/min....
-
A company has a bond issue outstanding that pays $150 annual interest plus $1000 at maturity. The bond has a maturity of 10 years. Compute the value of the bond when the interest rate is 5%, 9%, and...
-
At the beginning of the current tennis season, on April 1, 2017, Kicked-Back Tennis Shop's inventory consisted of 50 tennis racquets at a cost of $40 each. Kicked-Back uses a perpetual inventory...
-
Following is a sample of five matched pairs. Let 1 and 2 represent the population means and let d = 1 2. A test will be made of the hypotheses H0: d = 0 versus H1: d > 0. a. Compute the differences....
-
Peak Entertainment acquires 60 percent of its subsidiary Saddlestone Inc. on January 1,2013. In preparing to consolidate Peak and Saddlestone at December 31,2013, we assemble the following...
-
Ch 18 HWA Question 4 of 7 View Policies < > mugsh... M Gmail 0/5 E Show Attempt History Current Attempt in Progress Cullumber Corp. has collected the following data concerning its maintenance costs...
-
Schmidt Company began operations on January 1, 2006 and used the LIFO inventory method for both financial reporting and income taxes. However, at the beginning of 2008 the company decided to switch...
-
1.Create an amortization table that allows for an input each period of the amount that the borrower actually pays. Using the facts of the case, use the amortization table structure to find the...
-
What basic contents are found on an agenda for the presentation What are the basic contents of a presentation? How to write an agenda
-
3. Kakashi went shopping and bought the following items: Quantity 2 Cart 2 1 He had one coupon for Smart Watch Band Silicone Watch Case Portable Wireless Charger Price per item $4.98 each $1.48 each...
-
The AUD depreciated relative to the US$ in the 2nd and 3rd quarters of 2022, despite positive net exports. Identify and briefly explain 2 factors that may have caused this depreciation. Australia:...
-
Having earned a bonus at his work, Rick placed the money in an investment earning 5.61% compounded monthly. He withdrew $256 at the end of every month for the next 8 years. (a) What was the amount of...
-
What is the discounted value of $909.00 paid at the end of every year for 5 years if interest is 9% per annum compounded quarterly.
-
Given the following declaration statement: double high ; Which of the following is correct: printf("%d", &mile); printf("%f", &mile); printf("%d", mile); printf("%lf", mile);
-
Information graphics, also called infographics, are wildly popular, especially in online environments. Why do you think infographics continue to receive so much attention? How could infographics be...
-
Choose among the alternative answers in italics and fill in the blank lines.
-
Use the natural-rate hypothesis to explain the economic adjustments that would occur if a nation's inflation rate fell from its expected level of 6% to an unexpected 2% rate.
-
Why do many nations have more than one money supply measure (e.g., M1 and M2)?
-
Assume you are working on a project to improve customer service. Create a Pareto chart based on the information in the following table. Use the Pareto chart template from the companion website or...
-
Brainstorm two different quality related problems that you are aware of at your college or organization. Then review the charts found in the section of this chapter on the seven basic tools of...
-
Updating processes, policies, procedures, and knowledge bases is part of __________. A. updating organizational process assets B. archival C. updating project documents D. lessons learned
Study smarter with the SolutionInn App