BSBFIM601 Manage Finances-Accounting Software
Answer:
Houzit Pty Ltd is located in Brisbane and they are running retail chain of 15 stores. They are the leader in the retail sector of home ware and provide the new and renovated furnishing all over the Greater Brisbane area. over the past five years they have grown from a single store to the 15 chain store. They are well known for their superior after sales service and this is the crucial reason behind their growth in sales and increase in profit.
Financial statements
- Sales and profit budget
Particulars |
2015/16 |
Quarter 1 |
Quarter 2 |
Quarter 3 |
Quarter 4 |
Sales |
$ 16,814,136.02 |
$ 3,362,827.63 |
$ 4,035,392.73 |
$ 4,371,675.28 |
$ 5,044,240.38 |
(-) Cost of Goods Sold |
$ 9,151,896.00 |
$ 1,830,379.43 |
$ 2,196,455.09 |
$ 2,379,492.91 |
$ 2,745,568.57 |
Gross Profit |
$ 7,662,240.02 |
$ 1,532,448.20 |
$ 1,838,937.64 |
$ 1,992,182.37 |
$ 2,298,671.81 |
Gross Profit % |
46% |
46% |
46% |
46% |
46% |
Accounting Fees |
$ 10,000.00 |
$ 2,500.00 |
$ 2,500.00 |
$ 2,500.00 |
$ 2,500.00 |
Interest Expenses |
$ 84,508.00 |
$ 21,127.00 |
$ 21,127.00 |
$ 21,127.00 |
$ 21,127.00 |
Bank Charges |
$ 1,200.00 |
$ 300.00 |
$ 300.00 |
$ 300.00 |
$ 300.00 |
Depreciation |
$ 170,000.00 |
$ 42,500.00 |
$ 42,500.00 |
$ 42,500.00 |
$ 42,500.00 |
Insurance |
$ 13,390.00 |
$ 3,347.50 |
$ 3,347.50 |
$ 3,347.50 |
$ 3,347.50 |
Store Supplies |
$ 3,749.20 |
$ 749.84 |
$ 899.81 |
$ 974.79 |
$ 1,124.76 |
Advertising |
$ 350,000.00 |
$ 200,000.00 |
$ 50,000.00 |
$ 50,000.00 |
$ 50,000.00 |
Cleaning |
$ 16,282.24 |
$ 3,256.45 |
$ 3,907.74 |
$ 4,233.38 |
$ 4,884.67 |
Repairs & Maintenance |
$ 64,272.00 |
$ 16,068.00 |
$ 16,068.00 |
$ 16,068.00 |
$ 16,068.00 |
Rent |
$ 2,640,508.00 |
$ 660,127.00 |
$ 660,127.00 |
$ 660,127.00 |
$ 660,127.00 |
Telephone |
$ 14,996.80 |
$ 2,999.36 |
$ 3,599.23 |
$ 3,899.17 |
$ 4,499.04 |
Electricity Expenses |
$ 26,780.00 |
$ 5,356.00 |
$ 6,427.20 |
$ 6,962.80 |
$ 8,034.00 |
Fringe Benefits Tax |
$ 28,000.00 |
$ 7,000.00 |
$ 7,000.00 |
$ 7,000.00 |
$ 7,000.00 |
Superannuation |
$ 187,020.00 |
$ 37,404.00 |
$ 44,884.80 |
$ 48,625.20 |
$ 56,106.00 |
Wages & Salaries |
$ 2,078,000.00 |
$ 415,600.05 |
$ 498,720.01 |
$ 540,279.99 |
$ 623,399.95 |
Payroll Tax |
$ 93,510.00 |
$ 18,702.00 |
$ 22,442.40 |
$ 24,312.60 |
$ 28,053.00 |
Workers Compensation |
$ 41,560.00 |
$ 8,312.00 |
$ 9,974.40 |
$ 10,805.60 |
$ 12,468.00 |
Total Expenses |
$ 5,830,358.24 |
$ 1,451,931.21 |
$ 1,393,825.09 |
$ 1,443,063.03 |
$ 1,541,538.91 |
Net Profit (Before Tax) |
$ 1,831,881.78 |
$ 80,516.99 |
$ 445,112.55 |
$ 549,119.34 |
$ 757,132.90 |
Income Tax |
$ 549,564.53 |
$ 24,155.10 |
$ 133,533.77 |
$ 164,735.80 |
$ 227,139.87 |
Net Profit |
$ 1,282,317.25 |
$ 56,361.89 |
$ 311,578.79 |
$ 384,383.54 |
$ 529,993.03 |
Cash flow analysis – GST
Cash Flow Analysis - GST |
2015/16 |
Quarter 1 |
Quarter 2 |
Quarter 3 |
Quarter 4 |
GST Collected |
$ 1,681,413.60 |
$ 336,282.76 |
$ 403,539.27 |
$ 437,167.53 |
$ 504,424.04 |
Accounting Fees |
$ 1,000.00 |
$ 250.00 |
$ 250.00 |
$ 250.00 |
$ 250.00 |
Insurance |
$ 1,339.00 |
$ 334.75 |
$ 334.75 |
$ 334.75 |
$ 334.75 |
Store supplies |
$ 374.92 |
$ 74.98 |
$ 89.98 |
$ 97.48 |
$ 112.48 |
Advertise |
$ 35,000.00 |
$ 20,000.00 |
$ 5,000.00 |
$ 5,000.00 |
$ 5,000.00 |
Cleaning |
$ 1,628.22 |
$ 325.64 |
$ 390.77 |
$ 423.34 |
$ 488.47 |
Repair & Maintenance |
$ 6,427.20 |
$ 1,606.80 |
$ 1,606.80 |
$ 1,606.80 |
$ 1,606.80 |
Rent |
$ 264,050.80 |
$ 66,012.70 |
$ 66,012.70 |
$ 66,012.70 |
$ 66,012.70 |
Telephone |
$ 1,499.68 |
$ 299.94 |
$ 359.92 |
$ 389.92 |
$ 449.90 |
Electricity Expense |
$ 2,678.00 |
$ 535.60 |
$ 642.72 |
$ 696.28 |
$ 803.40 |
(-) Total GST Paid |
$ 314,656.02 |
$ 90,098.61 |
$ 74,687.65 |
$ 74,811.26 |
$ 75,058.50 |
GST Payable |
$ 1,366,757.58 |
$ 246,184.15 |
$ 328,851.63 |
$ 362,356.26 |
$ 429,365.54 |
Debtors ageing analysis
Particulars |
Quarter 1 |
Quarter 2 |
Quarter 3 |
Quarter 4 |
Sales |
$3,362,827.63 |
$ 4,035,392.73 |
$ 4,371,675.28 |
$ 5,044,240.38 |
% Debtors Sales |
20% |
20% |
20% |
20% |
Total Debtors |
$ 672,565.53 |
$ 807,078.55 |
$ 874,335.06 |
$ 1,008,848.08 |
Current |
$ 564,955.04 |
$ 677,945.98 |
$ 734,441.45 |
$ 847,432.38 |
30 Days |
$ 67,256.55 |
$ 80,707.85 |
$ 87,433.51 |
$ 100,884.81 |
60 Days |
$ 33,628.28 |
$ 40,353.93 |
$ 43,716.75 |
$ 50,442.40 |
90 Days |
$ 6,725.66 |
$ 8,070.79 |
$ 8,743.35 |
$ 10,088.48 |
Budget notes:
The main issue related to the budget is that the performance of Houzit greatly depended on their gross margin viability and maintenance of finance. The impact on the retail segment is biggest as the company is going through the recession period. however, the revenue from sales are in a growing trend and that is visible from the budget. To achieve the level of sales the company is spending a big amount towards discounts. The fluctuating interest rate is also affecting the company adversely. Moreover, the payment term of debtors also working as a barrier for the cash flow.
Statutory requirements for tax compliance:
Houzit is liable to pay 4.75% on the the total wages as the payroll tax if the amount exceeds $850,000. Moreover, the organization is liable to pay a fringe benefit tax and luxury car tax that are charged by the Australian government to minimize the dishonest activities taken up by the firm. The tax rate applicable on the luxury car is 33% as prescribed by the Australian government.
Calculation of tax
Particulars |
2015/16 |
Quarter 1 |
Quarter 2 |
Quarter 3 |
Quarter 4 |
Wages & Salaries |
$ 342,500.00 |
$ 415,600.05 |
$ 498,720.01 |
$ 540,289.99 |
$ 623,399.95 |
Superannuation tax |
$ 30,825.00 |
$ 37,404.00 |
$ 44,884.80 |
$ 48,626.10 |
$ 56,106.00 |
Payroll tax |
$ 16,268.75 |
$ 19,741.00 |
$ 23,689.20 |
$ 25,663.77 |
$ 29,611.50 |
company tax |
$ 1,055,116.73 |
$ 16,908.57 |
$ 93,473.64 |
$ 115,315.06 |
$ 158,997.91 |
Total tax |
$ 1,102,210.48 |
$ 74,053.57 |
$ 162,047.64 |
$ 189,604.94 |
$ 244,715.40 |
Compliance under Corporation Act 2001:
Under the Corporation Act 2001, the Australian firms are required to comply with the following regulations:
- The financial statement of the company must be prepared with respect to the accounting standards.
- The firm is liable to state the actual financial records of the firm to the debtors, which will enable the debtors to understand their financial viability
- The capital of the firm must be utilized in an efficient manner to pay off their liabilities
Appropriate software for Houzit Pty Ltd
The current software that are used by the firm are not able to provide the sufficient analysis of expenses and revenues and made the estimation of profits tough for the company. Therefore they want to use any other software or upgrade the existing software for better management of the accounts over the long run. One option is to use the MYOB software as Houzit is a small business firm. This is a cheap and easy to install in simple situations. Moreover, it has low risk of failure and back-up is easy.
Critical dates for generating resources in the next financial year
The most appropriate time for preparing the budget for next financial year is just after the publication of previous year’s financial year. It will give an idea about the income and expenses from the last year’s record. The proposal could be as follows:
- The budget may be prepared with the newly installed software that will be useful for preparing more accurate budget.
- The accounts are suggested to take the assumptions more appropriately to minimize the gap between the actual and budget and turn the unfavourable variances into favourable.
Recommendation for new budget
- Increasing the privacy and safety level to minimize the exploitation in preparation of budget.
- Implementation of proper authorization to access the budget will improve the conrol level.
- The budget must be prepared taking into consideration the previous year’s result, so that, the budget can be prepare more realistically.
- The budget must be prepared through the implementation of an system of accounting that will enable to prepare the budget accurately and easily.
List of modified internal control to maintain the audit trail
Audit trail is the system through which the transactions related to the items of accounting records are traced. To maintain the internal control, the following things are recommended:
- Audits must be carried out physically on the available stocks of the company to prevent the theft of stocks
- Duties of maintenance of records and preparation of financial statements must be segregated among two or most employees to minimize the manipulation of data.
- All the transaction must be documented properly to have access at the time of requirement.
- The financial record must be reconciled regularly to detect the loopholes in theinitial stages
- The access over the financial records must be allowed after proper authorization from the approval authority.
References
Akinboade, Oludele Akinloye, and Mandisa Putuma Mokwena. "Understanding the tax compliance culture of private sector tax practitioners in South Africa." Journal of Economics and Behavioral Studies 6.3 (2014): 202.
Andre, Sean M., Marco Lam, and Mark O'Donnell. "budgetary slack: exploring the effect of different types, directions, and repeated attempts of influence tactics on padding a budget." Academy of Accounting and Financial Studies Journal 20.3 (2016): 147.
Berman, Larry. The Office of Management and Budget and the presidency, 1921-1979. Princeton University Press, 2015.
Chen, Cellina. "For personal use only." Change (2015).
Curtis, Veechi. MYOB Software for Dummies-Australia. John Wiley & Sons, 2015.
De Simone, Lisa, Matthew S. Ege, and Bridget Stomberg. "Internal control quality: The role of auditor-provided tax services." The Accounting Review 90.4 (2014): 1469-1496.
Hassan, Nadiah, Mohd Mohid Rahmat, and Zakiah Muhammaddun Mohamed. "Internal Control Systems, Management Support and Public Sector Internal Audit Effectiveness In Malaysia." ASIAN JOURNAL OF ACCOUNTING AND GOVERNANCE 6 (2015): 1-12.
Salim, Emil, et al. "The Influence of Myob Accounting Softwareonthe Performance of Company Financial Report." UPI YPTK Journal of Business and Economics 1.1 (2016): 75-84.
Buy BSBFIM601 Manage Finances-Accounting Software Answers Online
Talk to our expert to get the help with BSBFIM601 Manage Finances-Accounting Software Answers to complete your assessment on time and boost your grades now
The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.