Please see the attached for the questions

Case study: Houzit Pty LtdSoon after the end of the first quarter, Jim Schneider the CEO of Houzit, asked you to follow up withCelina Patel, Houzit?s accountant, to see how the actual results compared with the budget you hadprepared three months ago. You explained that you had a meeting with Celina that afternoon to getthe results and that you would report back as soon as you had done some analysis.The key questions that the board was most interested to have answered from the budgets and thevariance reports were:

STRATHFIELD COLLEGE Strathfield College Pty Ltd CRICOS Code: 02736K National Code: 91223 ABN: 85 168 435 667 Level 2, 86 Mary St, Surry Hills, NSW, 2010, AUSTRALIA - Tel +61 2 9212 7799 Level 2, 422 Little Collins St, Melbourne, Vic, 3000 - Tel +61 3 8658 5200 info@strathfieldcollege.edu.au - www.strathfieldcollege.edu.au ASSESSMENT TASK 2 Assessment Details Qualification code Unit Code BSB61015 BSBFIM601 Assessment Type Qualification Name Unit Name Case Study Advanced Diploma of Leadership & Management Manage Finances Term 4/2016 Due Date Trainer / Assessor's Details Full Name: Date of Submission Student Details Student Name Student ID Instructions to the Candidates Pre Requirement for this task Student must review Lesson materials provided in class Examples used in lessons. Instructions to Students: Please complete assessment task within the time frame given You must attempt all the requirements that are addressed within this assessment task. Copying or any kind of cheating is absolutely not permitted, if someone is found cheating or copying, will be debarred from the assessment and a disciplinary proceeding would begin. This assessment covers the following Performance Criteria PC's Covered: 1.1, 1.2, 1.4, 3.1 3.3, 3.4, 3.5, 4.1, 4.2, 4.3 BSBFIM601_Manage Finances. AT 2.Case Study. V2 Page 1 of 7 STRATHFIELD COLLEGE Strathfield College Pty Ltd CRICOS Code: 02736K National Code: 91223 ABN: 85 168 435 667 Level 2, 86 Mary St, Surry Hills, NSW, 2010, AUSTRALIA - Tel +61 2 9212 7799 Level 2, 422 Little Collins St, Melbourne, Vic, 3000 - Tel +61 3 8658 5200 info@strathfieldcollege.edu.au - www.strathfieldcollege.edu.au Monitor and review budget Procedure 1. Read the case study. 2. Develop a variance report based on the format and template provided by Houzit. 3. Complete a cash flow analysis on the average length of time it takes Houzit to collect funds from its debtors to determine the trend based on the financial reports in Assessment Task 1. 4. Examine the sales budget, profit budget, cash flow budget and debtor ageing summary to identify the following in a report: a. Issues: i. Identify, describe and prioritise significant issues that are evidenced in the provided case study information and describe reasons or causes of these issues. Include in this issues of financial probity that you have identified or considered when monitoring these budgets. b. Variances: i. Complete an actual-to-budget variance report, using the template provided in the case study. ii. Identify variances by comparing actual results with the established budget, and provide reasons why these variances may have occurred. c. Performance: i. Compare financial performance of the organisation (according to financial information provided) to industry benchmarks for this organisation in line with the retail trade sector. ii. Respond to the performance questions provided by the CEO, as provided by the board of Houzit, iii. Determine a trend of the average debtor days and the impact to the cash flow of Houzit. d. Recommendations: i. Outline your recommendations for ongoing financial viability for the organisation, based on your assessment of the issues, reasons for variances and organisational performance you have identified (Steps 1-3). BSBFIM601_Manage Finances. AT 2.Case Study. V2 Page 2 of 7 STRATHFIELD COLLEGE Strathfield College Pty Ltd CRICOS Code: 02736K National Code: 91223 ABN: 85 168 435 667 Level 2, 86 Mary St, Surry Hills, NSW, 2010, AUSTRALIA - Tel +61 2 9212 7799 Level 2, 422 Little Collins St, Melbourne, Vic, 3000 - Tel +61 3 8658 5200 info@strathfieldcollege.edu.au - www.strathfieldcollege.edu.au ii. Include in this section your plans for a revised budget, effectively managing contingencies and issues that have been identified in feedback and monitoring of the budgets. e. Evaluation: i. Provide a summary review of the financial management processes in place for the organisation, in light of your assessment of the issues, reasons for variances and organisational performance you have identified. Include in this section any recommendations you have for modifying management processes. 5. Prepare for and undertake the role-play presentation: a. Arrange a time with Jim Schnieder, CEO of Houzit Pty Ltd (your assessor), to present an oral explanation of your variance report. Ensure that your assessor has copies of or access to documents you will be referring to. b. Deliver the presentation of your variance report i. Summarise your findings (issues, variances, financial performance) ii. Prioritise and present your recommendations. c. Ask for questions, either during or at the end of the presentation, to: i. demonstrate your oral communication skills ii. use questioning and listening techniques iii. demonstrate competent exchange of information iv. use appropriate conventions and protocols v. ensure the manager/CEO is clear about budgets d. Seek approval (or discuss as required) of your recommendations in the report. Specifications You must submit: a complete actual-to-budget variance report a completed report detailing the issues, variances, performance, recommendations and evaluations identified from the financial information for Houzit Pty Ltd. Your assessor will be looking for: Evidence that you reviewed the provided case study information to develop an evaluative report concerning the progress of the budget. BSBFIM601_Manage Finances. AT 2.Case Study. V2 Page 3 of 7 STRATHFIELD COLLEGE Strathfield College Pty Ltd CRICOS Code: 02736K National Code: 91223 ABN: 85 168 435 667 Level 2, 86 Mary St, Surry Hills, NSW, 2010, AUSTRALIA - Tel +61 2 9212 7799 Level 2, 422 Little Collins St, Melbourne, Vic, 3000 - Tel +61 3 8658 5200 info@strathfieldcollege.edu.au - www.strathfieldcollege.edu.au Adjustment for distance-based learners No changes to the task are required. Case study: Houzit Pty Ltd Soon after the end of the first quarter, Jim Schneider the CEO of Houzit, asked you to follow up with Celina Patel, Houzit's accountant, to see how the actual results compared with the budget you had prepared three months ago. You explained that you had a meeting with Celina that afternoon to get the results and that you would report back as soon as you had done some analysis. The key questions that the board was most interested to have answered from the budgets and the variance reports were: 'To what extent do the reports support the view of the board that Houzit is financially viable?' 'Will we be able to maintain our gross profit margins in the predicted downturn?' Jim and you both agreed that it had been a tough quarter with the economy still in recession and the impact this was having on the retail sector. Banks are raising interest rates in line with the increased upward international pressure and Houzit has a significant part of their loan funds on a variable interest rate which changes directly with market conditions. Jim was pleased that the sales seem to be holding up reasonably well as first quarter results are generally impacted by factors relating to public and school holidays but he was concerned about the discounts that had to be given to generate these sales. 'That's going to hurt us at some point' Jim said. 'Just a pity we could not get into some national magazines this quarter to promote the store offers. I'm sure that would have helped us exceed the budgets you set. I guess we will just have to spend that advertising money in the next quarter' Jim said. 'I still think we are running our wages and salaries a bit high. The industry benchmark for wages and salaries is close to 11% of sales' Jim went on to explain, 'One of our contingency plans in a slowing economy is to reduce our exposure to debt by applying our profits to the repayment of the long term debt. This will help reduce the interest burden on the business and take some pressure off the diminishing profits. It would also be of interest to determine the impact that our debtors has on the cash flow of the business from 2010/11.' You are a beneficiary of the company's profit bonus scheme that is based on the profitability of the company's financial reports which you are required to prepare. You also prepare the departmental reports that form the basis of the performance review of the managers. You are the manager of the finance/administration and prepare this department's report as well. BSBFIM601_Manage Finances. AT 2.Case Study. V2 Page 4 of 7 STRATHFIELD COLLEGE Strathfield College Pty Ltd CRICOS Code: 02736K National Code: 91223 ABN: 85 168 435 667 Level 2, 86 Mary St, Surry Hills, NSW, 2010, AUSTRALIA - Tel +61 2 9212 7799 Level 2, 422 Little Collins St, Melbourne, Vic, 3000 - Tel +61 3 8658 5200 info@strathfieldcollege.edu.au - www.strathfieldcollege.edu.au You met that afternoon with Celina and she provided you with the following report on the actual results for the quarter ended 30 September 2011. Houzit Pty Ltd Actual Results Qtr 1 Revenue Sales 3,371,200 - Cost Of Goods Sold 1,955,296 Gross Profit 1,415,904 Gross Profit % 42% Expenses - Accounting Fees 2,500 - Interest Expense 28,150 - Bank Charges - Depreciation - Insurance - Store Supplies - Advertising - Cleaning - Repairs & Maintenance - Rent 380 42,500 3,348 790 150,000 3,325 16,150 660,127 - Telephone 3,100 - Electricity Expense 5,245 - Luxury Car Tax - Fringe Benefits Tax - Superannuation - Wages & Salaries - Payroll Tax - Workers' Compensation Total Expenses 12,000 7,000 37,404 410,500 19,741 8,312 1,410,572 Net Profit (before tax) 5,333 Income Tax 1,600 Net Profit 3,733 BSBFIM601_Manage Finances. AT 2.Case Study. V2 Page 5 of 7 STRATHFIELD COLLEGE Strathfield College Pty Ltd CRICOS Code: 02736K National Code: 91223 ABN: 85 168 435 667 Level 2, 86 Mary St, Surry Hills, NSW, 2010, AUSTRALIA - Tel +61 2 9212 7799 Level 2, 422 Little Collins St, Melbourne, Vic, 3000 - Tel +61 3 8658 5200 info@strathfieldcollege.edu.au - www.strathfieldcollege.edu.au GST cash flow - Actual Aged debtors - Actual Cash flow analysis - GST Qtr 1 AGED DEBTORS BUDGET GST Collected 337,120 Sales Less GST Paid 279,988 % Debtors Sales GST Payable 57,132 Qtr 1 3,371,200 22% Total Debtors 741,664 Current 585,915 30 days 111,250 60 days 37,083 90 days 7,417 Total Debtors 741,664 Budget variance report template According to the organisational policy and procedures, the following format is to be used when preparing a budget variance report. Houzit Pty Ltd Variance to Budget xxx Quarter ended mmm-yyyy Actual Results Budget-Qx Actual-Qx $ Variance % Variance F or U Sales x,xxx x,xxx x,xxx x% F or U - Cost Of Goods Sold x,xxx x,xxx x,xxx x% F or U Calculation Calculation Calculation x% F or U % % % x% F or U - Accounting Fees x,xxx x,xxx x,xxx x% F or U - Interest Expense x,xxx x,xxx x,xxx x% F or U - Bank Charges x,xxx x,xxx x,xxx x% F or U - Depreciation x,xxx x,xxx x,xxx x% F or U - Insurance x,xxx x,xxx x,xxx x% F or U - Store Supplies x,xxx x,xxx x,xxx x% F or U - Advertising x,xxx x,xxx x,xxx x% F or U Gross Profit Gross Profit % Expenses BSBFIM601_Manage Finances. AT 2.Case Study. V2 Page 6 of 7 STRATHFIELD COLLEGE Strathfield College Pty Ltd CRICOS Code: 02736K National Code: 91223 ABN: 85 168 435 667 Level 2, 86 Mary St, Surry Hills, NSW, 2010, AUSTRALIA - Tel +61 2 9212 7799 Level 2, 422 Little Collins St, Melbourne, Vic, 3000 - Tel +61 3 8658 5200 info@strathfieldcollege.edu.au - www.strathfieldcollege.edu.au - Cleaning x,xxx x,xxx x,xxx x% F or U - Repairs & Maintenance x,xxx x,xxx x,xxx x% F or U - Rent x,xxx x,xxx x,xxx x% F or U - Telephone x,xxx x,xxx x,xxx x% F or U - Electricity Expense x,xxx x,xxx x,xxx x% F or U - Luxury Car Tax x,xxx x,xxx x,xxx x% F or U - Fringe Benefits Tax x,xxx x,xxx x,xxx x% F or U - Superannuation x,xxx x,xxx x,xxx x% F or U - Wages & Salaries x,xxx x,xxx x,xxx x% F or U - Payroll Tax x,xxx x,xxx x,xxx x% F or U - Workers' Compensation x,xxx x,xxx x,xxx x% F or U Total Expenses Calculation Calculation x,xxx x% F or U Net Profit (Before Tax) Calculation Calculation x,xxx x% F or U Income Tax Calculation Calculation x,xxx x% F or U Net Profit Calculation Calculation x,xxx x% F or U Note: F = Favourable, U = Unfavourable Debtor ageing ratio template 2009/10 2010/11 2011/12 Trade Debtors Sales Debtor Days Anticipate that the trade debtors for the 2011/12 financial period maintain the same growth as that which took place between 2009/10 to 2010/11. BSBFIM601_Manage Finances. AT 2.Case Study. V2 Page 7 of 7 Houzit Pty Ltd Variance to Budget First Quarter 30 september 2011 Actual Result Budget-Q1 Actual-Q1 $ Variance % Variance F or U Sales 3,394,247 3,371,200 -23,047 -0.7 U Cost of Goods Sold 1,934,721 1,955,296 20,575 1.1 U Gross Profit 1,459,526 1,415,904 -43,622 -3.0 U 43% 42% -1% -2.3 U Gross Profit % Expenses 0 Accounting fees 2,500 2,500 0 Interest Expense 21,127 28,150 7,023 33.2 U Bank Charges 400 380 -20 -5.0 F Depreciation 42,500 42,500 0 0.0 3,348 3,348 0 0.0 750 790 40 5.3 U 200,000 150,000 -50,000 -25.0 F 3,256 3,325 69 2.1 U 16,068 16,150 82 0.5 U 660,127 660,127 0 Telephone 2,999 3,100 101 3.4 U Electricity Expense 5,356 5,245 -111 -2.1 F 12,000 12,000 0 0.0 7,000 7,000 0 0.0 Superannuation 37,404 37,404 0 0.0 Wages & Salaries 415,600 410,500 -5,100 19,741 19,741 0 0.0 8,312 8,312 0 0.0 1,458,488 1,410,572 -47,916 -3.3 F 1,038 5,333 4,295 413.8 F Income Tax 311 1,600 1,289 414.5 U Net Profit 727 3,733 3,006 413.5 F Insurance Stores Supplies Advertising Cleaning Repairs & Maintenance Rent Luxury Car Tax Fringe Benefits Tax Payroll Tax Workers Compensation Total Expenses Net Profit Before Tax 0.0 0.0 -1.2 U