Identification of reasons for previous profits and losses

Assignment Help Financial Management
Reference no: EM13776542 , Length: 1000 Words

Prepare budgets

This assessment requires you to determine the requirements to undertake budgeting, financial forecasting and reporting requirements for an organisation. You will also need to review the case study provided and prepare a budget (in electronic spreadsheet format) and budget notes for distribution and implementation in the organisation.

1. Read the case study.

2. Analyse the case study information (including business plan summary and previous financial data) and complete the following.

a. Develop a sales budget, profit budget, cash flow budget and debtor ageing summary using electronic spreadsheets (as separate worksheets) making sure each budget is divided into quarterly periods and that you use previous financial data to determine allocations for resources.

Ensure each budget you prepare complies with the organisational and policies and procedures as provided.

b. Develop budget notes which include:

i. identification of reasons for previous profits and losses

ii. your comment on the effectiveness of existing financial management approaches

iii. all assumptions and basis that have been made or used to form budgets

iv. any relevant notes regarding implementation and monitoring of budget expenditure.

Case study

You have recently been appointed as the business manager of Houzit Pty Ltd having been a store manager for the past three years. Houzit Pty Ltd is a 15 store retail chain located in Brisbane. Houzit is the leading homewares retailer, catering to the growing need for furnishing new and renovated dwellings in the greater Brisbane area.

The assortment on offer of bathroom fittings, bedroom fittings, mirrors and decorative items together with the recently added lighting fixtures has positioned Houzit as a leader in homewares retailing in Australia. Houzit has grown over the past five years from a single store to the current chain. Houzit prides itself on superior after sales service which has been a key reason for the continued growth in sales and corresponding profit increases. Today Houzit employs over 150 staff.

Houzit Pty Ltd is a proprietary limited company (ACN 34 765 234 02) registered with the Australian Securities and Investment Commission. The registered address is with Houzit's solicitors (Langs Lawyers, 535 Queen Street, Brisbane, QLD 4000) and the principle place of business is 505 Boundary Street Spring Hill Brisbane QLD 4000.

Computer software requirement

The current accounting information system has not adequately provided sufficient analysis of revenue and expenditure and has made it difficult to make informed estimates of future profits. Estimates have relied on the 'gut feel' of the experienced traders on the board and of the senior managers. The board sees the need to apply more analysis to past results that they believe could be done with the introduction of state-of-the-art computer software.

Houzit Pty Ltd wants to upgrade their existing accounting system which will manage the company accounts more efficiently in the long run. They request that the new system you recommend to them to be compliant with all legislative and statutory requirements for small to medium businesses.

None of Houzit's products are GST free however the accounting information system records the GST collected as well as the input tax credits earned on the purchases of stock and assets. These amounts are reported and paid in accordance with the business activity statement (BAS) schedule determined by the Australian Tax Office.

They have 100 fulltime and 50 part-time staff, but only 10 of the staff will have or need access to the financial system. Some staff are paid on a salary sacrifice arrangement that attracts fringe benefits tax. The staff with access to the financial system want software that is a single purchase with no ongoing license fees, and a plan to keep using if for the next 3-5 years, while the organisation continues to grow. They are anticipating that within five years they will have over 250 full-time staff, and at least 20 staff will require access to the financial system by then.

The payroll system deducts withholding tax from the employees and remits this along with the firm's pay as you go (PAYG) instalment each quarter as reported on the firm's business activity statement. Income tax return for the company and its annual statement is completed by the firm's accountant. Taxes and fees due are paid by the due dates. Financial records are kept at Houzit's principle place of business. Houzit have just upgraded their computers and have five new desktop PCs which will be used by the finance staff. They are current specification machines with i5 CPUs and 4Gb RAM each, and all have Windows 7 Professional and Norton's 360 installed with the professional version of Microsoft Office Small Business as well. Other staff will use their machines at various times, so it is important that the software requires a login to access data and that data stored by the software cannot be accessed in any other way.

Reference no: EM13776542

Questions Cloud

Would you approach the elder dr cole : Would you approach the elder Dr. Cole? Why or why not? Is this a problem that can be "fixed"? If so, how can it be fixed? Are you willing to give the younger Dr. Cole the time to "fix" the issues as the CEO
How is the claim tied to the audiences values : How is the claim tied to the audience's values, assumptions, and beliefs? How is the claim qualified, if it is? Does the audience need to be convinced that it shares the author's values?
Summary of the background or history of the artist : Choose a musical artist (from any music era) and provide a 1-2 page summary of the background or history of the artist. Next, pick one of his or her main works (songs or compositions) and explain:
Accounting convergence efforts addressing liabilities : Briefly discuss how accounting convergence efforts addressing liabilities is related to the IASB/FASB conceptual framework project.
Identification of reasons for previous profits and losses : Develop a sales budget, profit budget, cash flow budget and debtor ageing summary using electronic spreadsheets -  Identification of reasons for previous profits and losses.
Purchased a high-speed industrial centrifuge : Holiday Laboratories purchased a high-speed industrial centrifuge at a cost of $440,000. Shipping costs totaled $30,000. Foundation work to house the centrifuge cost $8,600. An additional water line had to be run to the equipment at a cost of $3,000.
Contribute to enlightenment philosophy : Name the various preclassical thinkers identified in this lesson. What ideas did each contribute to Enlightenment philosophy? What form did those ideas take in classical criminological thought?
Discuss the budgetary and managerial impact : Discuss the budgetary and managerial impact that future trends will likely have not only on the component you select, but also on the other components of the criminal justice system. Be sure to include current research data (qualitative and quanti..
Questions regarding social change : How do you think life in the United States will change in the next 10 years? How might technology be involved or effect social change in American culture?

Reviews

Write a Review

 

Financial Management Questions & Answers

  How much is the firms net working capital

Universal Financial, Inc. has total current assets of $1,200,000; long-term debt of $600,000; total current liabilities of $500,000; and long-term assets of $800,000. How much is the firm's net working capital?

  A price to book ratio considers

A price to book ratio considers

  What amount of safety stock would provide a stock out risk

The injection molding department of a company uses an average of 30 gallons of special lubricant a day. The supply of the lubricant is replenished when the amount on hand is 170 gallons. It takes four days for an order to be delivered. Safety stock i..

  What is the stock price at the start of year

Logitech stock is currently selling for $30 per share. The next expected annual dividend is $3 at the end of this year and the dividend growth rate is 6% per year. What is the stock price at the start of year 4 (end of yr 3)?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  What is the expected capital gains yield over the next year

Bond X is a premium bond with a coupon rate of 9%. Bond Y is a discount bond with a coupon rate of 5%. Both bonds make annual payments, have a YTM of 7%, and have five years to maturity. What is the current yield for Bond X? What is the current yield..

  Interest rate remains constant over entire period of time

Determine the current amount of money that must be invested at 14% nominal interest, compounded monthly, to provide an annuity of $11,500 (per year) for 6 years, starting 11 years from now. The interest rate remains constant over this entire period o..

  What is the baht to franc spot exchange rate

An analyst for Credit Suisse in Zurich (Switzerland) receives the following quotes for Swiss franc and Thai baht (both against the dollar), for spot and six-month forward. Spot exchange rate: What is the baht to franc spot exchange rate ?

  Calculate your total profit from triangular arbitrage

You observe the following three exchange rates at which you can buy or sell (borrow or lend). Calculate your total profit from triangular arbitrage, reporting your total profit in $ (by first calculating the profit in British pounds and then converti..

  Navigation systems inc now has total worldwide revenues of

navigation systems inc. now has total worldwide revenues of over 500 million forecast for this coming year. you have

  Interest received at end of the period is reinvested

You placed $5,139 in a saving account today that earns an annual interest rate of 19.95 percent, compounded semi-annually. How much will you have in this account at the end of 8 years? Assume that all interest received at the end of the period is rei..

  What should be the increase in earnings per share

Last year, Cayman Corporation had sales of $7,000,000, total variable costs of $3,000,000, and total fixed costs of $1,500,000. In addition, they paid $480,000 in interest to bondholders. Cayman has a 35% marginal tax rate. If Cayman's sales increase..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd