accounting

posted by .

Prepare a monthly Cash Budget in tabular form for the months of February, March and April; showing the bank balance at each month's end.

Company Information and Background

The following data is available from the various functional budgets prepared at Congo Limited.

JanuaryFebruaryMarchApril
$'000 $'000 $'000 $'000
CASH SALES 128 84 72 90
Credit Sales 1,140 760 640 800
Purchases for Resale 880 560 520 320
Salaries and Wages 266 280 238 248
Overhead Expense 160 150 160 140


Other information is available as follows:

1.5% of all sales on credit are expected to become bad debts. Receipts from credit customers are due in the month following sale.
2.All goods are bought on credit from suppliers who allow 2½% cash discount for payment in the month following purchase.
3.Salaries and wages are paid in the month in which they are earned.
4.Payments for overhead expenses are made in the month following the month in which expenses are incurred. The above overhead budget includes $28,000 per month for depreciation.
5.Two new vans costing $21,000 each are to be paid for in April.
6.Taxation amounting to $175,000 is to be paid in March.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Management Accounting

    Victoria Kite Company, a small Melbourne firm that sells kites on the Web wants a master budget for the next three months, beginning January 1, 2005. It desires an ending minimum cash balance of $5,000 each month. Sales are forecasted …
  2. Finance

    The Victoria Nursery, which provides facilities for pre-school children on a commercial basis, is preparing its cash budget for next year. A profile of the estimated revenues and expenses for the first four months of the year is as …
  3. Accounting

    If the owner of a company invests personal funds into his company, where does that fit into the balance sheet. I know the cash will increase, but I don't know how it put it in the equity section. For example, If Greg Jones invests …
  4. Accounting

    If the owner of a company invests personal funds into his company, where does that fit into the balance sheet. I know the cash will increase, but I don't know how it put it in the equity section. For example, If Greg Jones invests …
  5. Accounting

    If the owner of a company invests personal funds into his company, where does that fit into the balance sheet. I know the cash will increase, but I don't know how it put it in the equity section. For example, If Greg Jones invests …
  6. finance

    For this assignment, imagine you are the accountant for Floral Design Company and are assigned to prepare the monthly bank reconciliation. Complete this task, by using the data below: 1. Complete the bank reconciliation for the month …
  7. accounting

    Part 5 Cash Budgeting Landis Company has the following sales forecasts for the selected three-month period in the current year: Month Sales April $12,000 May 7,000 June 8,000 Seventy percent of sales are collected in the month of the …
  8. accounting

    Moreno Industries has adopted the following production budget for the first 4 months of 2013. Month Units Month Units January 10,000 March 5,000 February 8,000 April 4,000 Each unit requires 3 pounds of raw materials costing $2 per …
  9. Finance

    Assignment 1: LASA 2—Cash Management and Budgeting The new owner of Bob’s Boats, Bob, just purchased the business and discovered that the prior owner did not have a plan for managing the current assets of the company. Bob has decided …
  10. accounting

    •The Bank Account as a control device that helps to protect cash. One of the requirements is to conduct periodic bank statement reconciliations. Using the following data, complete a bank statement reconciliation or EEE Electric for …

More Similar Questions