• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Victoria Kite Company is a small Melbourne firm that sells kites on the Web wants a master budget for the next three months, beginning January 1, 2005. When developing the master budget it was discovered that only 60% of the current sales are

Extracts from this document...

Introduction

Group Project Unit Four ACG_420 Managerial Accounting And Organizational Controls July 1, 2006 Victoria Kite Company's Master Budget Schedules Schedule A: Sales Budget January February March Total Recent & Forecasted Sales $62,000 $75,000 $38,000 $175,000 Schedule B: Cash Collections January February March Totals 60% of Current Month Sales $37,200 $45,000 $22,800 $105,000 30% of Previous Month Sales 7,500 18,600 22,500 48,600 10% of 2 Months Earlier 2,500 2,500 6,200 11,200 Totals $ 47,200 $ 66,100 $ 51,500 $ 164,800 Schedule C: Purchases January February March Totals Desired ending inventory $ 6,000 $ 6,000 $ 6,000 $ 18,000 Cost of goods sold 31,000 37,500 19,000 87,500 Total needed 37,000 43,500 25,000 105,500 Less beginning inventory 39,050 8,050 6,000 53,100 Purchases $ - $ 35,450 $ 19,000 $ 52,400 Schedule D: Disbursements January February March Total 100% of last months purchases $ 35,550 $ - $ 35,450 $ 71,000 Cash Budget Jan Feb March Beginning cash balance $ 5,000 $ 5,100 $37,692 Minimum cash balance desired $ 5,000 $ 5,000 $ 5,000 Available cash balance $ - $ 100 $32,692 Cash Receipts and Disbursements Cash Collections $ 47,200 ...read more.

Middle

An ending minimum cash balance of $5,000 is desired at the end of each month and the budget shows an ending balance of ($10,400) therefore creating the need for a loan of $15,500 giving Victoria Kite Company a closing cash balance of $5,100 at the end of January 2005. (See table 1) Victoria Kite Company needs to take out a bank loan due to the lack of funds to pay the larger rent and monthly costs. The company only has the minimum starting cash balance causing a shortage when subtracting the disbursements from the cash receipts. Table 1 Cash budget Jan-05 Feb-05 Mar-05 Cash balance at the beginning of the month $5,000.00 $5,100.00 $37,692.00 Cash collected from sales $47,200.00 $66,100.00 $51,500.00 Total cash available $52,200.00 $71,200.00 $89,192.00 Cash disbursed for operations ($61,100.00) ($17,750.00) ($53,200.00) Furniture's & Fixtures ($3,000.00) Dividends ($1,500.00) Total cash disbursement ($62,600.00) ($17,750.00) ($56,200.00) Balance at the end of month before bank loan ($10,400.00) $53,450.00 $32,992.00 Required closing balance $5,000.00 $5,000.00 $5,000.00 Bank loan received $15,500.00 Bank loan repaid ($15,500.00) ...read more.

Conclusion

One other option would be to offer a cash back discount like 5% for paying within the specified net 30 day terms. This offers an incentive to both the customer and the company. The Victoria Kite Company comes to a negative excessive cash balance in January requiring them to get a bank loan. The terms of the loan are the loan has to be paid in $500 increments with 10% interest rate. The accounts receivable, cash and credit payments are the income sources that will be used to repay the bank loan. A bank loan also helps a company grow faster than it may be able to grow without the added money. If a business is working at its full capacity and still unable to meet customer demand, it may be worth taking out a bank loan to increase the facility to be able to meet customer demand. Repayment of the bank loan will be paid back in full with interest in the month of February 2005 due to the increase cash collections from sales operation sources providing the cash flow for the repayment of the bank loan. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Accounting & Finance section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Accounting & Finance essays

  1. Unit 5 Introduction to Accounting

    When they are calculating the sale price, the owner will most of the time add an amount on top of the value of the assets. He does that to take account of the factors. That has been known as goodwill and appears as an intangible asset in the accounts firm.

  2. Management Accounting Report.

    100 �126,200 October 120 �144,000 120 �158,400 110 �138,820 November 150 �180,000 150 �198,000 160 �201,920 December 130 �156,000 130 �171,600 150 �189,300 Total 1300 �1,560,000 1190 �1,570,800 1350 �1,703,700 Cash Flow Forecast At Actual Price NAME: PERIOD: RECEIPTS JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV

  1. The Purpose of Keeping Accurate Accounts

    This is commonly known as the 'True and Fair overview'. It has been treated as an important loophole in the law and has been the cause of much argument, and dissatisfaction with the accounting profession. Depreciation in financial statements The consistency concept ensures that eth same calculation method-straight line reducing

  2. Wilson Lumber Company Case

    229167 229167 229167 229167 229167 187500 187500 187500 187500 A/R Lagged 1 month 222000 187500 187500 229167 229167 229167 229167 229167 229167 187500 187500 187500 Receipts from loan 10000 Total Cash receipts 222000 187500 197500 229167 229167 229167 229167 229167 229167 187500 187500 187500 Cash disbursements Purchases 142118 142118 173700

  1. Complete Report on Askari Commercial Bank

    Kashif Mateen Ansari Member Auditors * A.F.Ferguson & Co. Chartered Accountants Legal Advisors * Rizvi, Isa, Afridi & Angell Awards And Achievements Over the years, ACBLA has received several awards for the quality of its banking service to individuals and corporate. These include: Best Commercial Bank Consumer Choice award 2005 by The Consumers Association of Pakistan Best Retail Bank

  2. Project DR: Manufacturing Division

    Based on internal documents and other research material, LTA found that the following expenses needed to be allocated across divisions. They included charges for the purchase of computer equipment for $225,000; Manufacturing equipment worth $275,000 to produce products sold by the company; Depreciation associated with the computer and manufacturing equipment;

  1. Budget in multinational company

    CONCLUSION 9 REFERENCES 10 BIBLIOGRAPHY 10 1. Introduction Today we can sense a growing dissatisfaction among CEOs, CFOs and business managers and across the whole business community with the traditional general management approach, which is based on budgetary control - with a fixed annual performance contract, fixed action plans for an entire year and a highly political budgeting process dominated by "gaming" as the result.

  2. Mr Carter has requested that I research the financial needs of potential and current ...

    Established families (40-50) The financial needs of an established family are similar to a young family. The variation is that it is not likely for this age group to pay into an endowment fund (although they may have done so earlier in their life).

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work