Question

The following balances have been extracted from the accounting system of Buloon (Pty) Ltd at 31...

The following balances have been extracted from the accounting system of Buloon (Pty) Ltd at 31 March 2016, their most recent financial
year end. Mr Duffy, the owner, has approached you to assist him in planning for the next quarter ending on 30 June 2016.
R
Share Capital         220 000
Loan BAO Bank         160 000
Furniture and Equipment at Cost price         240 000
Vehicles at Cost price         200 000
Inventory           10 000
Debtors           80 000
Creditors           20 600
Bank             3 000
Mr Duffy has also provided the following additional information pertaining to the next quarter :
1. The loan from BAO bank bears interest at 2% per month, payable monthly.
2. Sales are estimated at R125 000 per month and purchases of inventory amount to an estimated R28 000 per month.
3. Inventory on hand at the end of the next quarter is estimated at R8 500.
4. Depreciation on furniture and equipment is at 25% per annum and on vehicles at 20% per annum, based on the cost price.
6. Provision for taxation of R9 800 must be made.
7. Monthly expenses are as follows:
R
Rental          12 000
Salaries and Wages          36 000
Telephone            1 140
Water and electricity               900
8. The following other expenses will be incurred during the next quarter:
R
Administration expenses          26 000    8 666.67
Traveling expenses          16 000    5 333.33
9. Share capital consists of 50 000 shares.
Required
a) Prepare the budgeted income statement for Buloon Pty (Ltd) for the next quarter ending on 30 June 2016. [12]
b) Mr Duffy is concerned about the low bank balance and is uncertain as to whether he will have enough cash available in his business during
      the next month. He has also asked you to calculate the estimated cash available at the end of the next month (30 April 2016). The following
       information pertains to the collections and payment patterns of the business:
Sales:         If a customer pays cash, they receive a 7,5% discount, otherwise, they receive 30 days to pay. 5% of
                     customers buying on credit end up defaulting in payments. 80% of sales are on credit.
Payments: all payments are done in cash, except for purchases of inventory, which are paid 30 days after purchase.  
                       Cash discounts received on other payments total R3 000 per month. Taxation is only payable in August. [11]
c) What could mr Duffy do should he experience a cash deficit during the next quarter?
[2]

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The following balances have been extracted from the accounting records of Tancan Ltd at 31 December...
The following balances have been extracted from the accounting records of Tancan Ltd at 31 December 2018: € Cash sales 1,230,000 Credit sales 2,600,000 Opening inventory 360,000 Purchases 2,124,000 Carriage inwards 119,000 Carriage outwards 227,000 Office equipment at 1 January 2018: Cost 460,000 Accumulated depreciation 92,000 Administrative expenses 416,000 The following further information is available: (1) Closing inventory is €450,000 (2) Some office equipment, which had cost €20,000, with accumulated depreciation at 1 January of 2018 of €14,000, was sold...
The information below was taken from the general ledger accounts of, Dance Life Pty Ltd who...
The information below was taken from the general ledger accounts of, Dance Life Pty Ltd who uses the accrual basis of accounting. Dance Life Pty Ltd 30 June    2019    2018 Accounts receivable Inventory Prepaid advertising Accounts payable Wages payable Sales Cost of sales Wages Expenses $231 600 96 720 4 400 71 000 6 400 540 000 296 000 88 000 $157 200 104 400 5 400 74 400 9 400 REQUIRED: A.         Calculate the amount of cash collected from customers...
The following details have been extracted from the budget of a merchandising company. Rent Expense ?$8,400...
The following details have been extracted from the budget of a merchandising company. Rent Expense ?$8,400 per month Depreciation Expense ?$3,500 per month Insurance Expense ?$2,000 per month Miscellaneous Expense ?2% of? sales, paid as incurred Commissions Expense ?8% of sales Salaries Expense ?$6,000 per month Dec Jan Feb March Sales? $55,000 ?$60,000 ?$75,000 ?$90,000 Commissions and salaries expenses are paid? 50% in the month to which they are incurred and the balance in the next month. Rent and miscellaneous...
The following details have been extracted from ten budget of a merchandising company. Rent expense :...
The following details have been extracted from ten budget of a merchandising company. Rent expense : $8,700 per month Depreciation expense: $ 4,000 per month Insurance expense: $1,250 per month Miscellaneous expense: 4% of sales, paid as incurred Commission expense: 10% of sales Salaries expense: $6000 per month Sales: dec $70,000 Jan $75,000 feb $90,000 mar $105000 Commissions and salaries expenses are paid 50% in month to which they are incurred and the balance next month. Rent and miscellaneous expenses...
Selected comparative statement data for SuperAmart Pty Ltd is presented as below: 2016 2017 ($) 2018...
Selected comparative statement data for SuperAmart Pty Ltd is presented as below: 2016 2017 ($) 2018 ($) Net sales $500 000 $620 000 Cost of goods sold 280 000 360 000 Gross profit Selling and administration expense 5 000 6 000 Finance cost 6000 6000 Profit Cash at Bank 60 000 80 000 Inventory (30 June) 55 000 65 000 Total assets (30 June) 600 000 640 000 700 000 Total liabilities (30 June) 200 000 180 000 Required: Calculate...
The statement of financial position (extract) of Kent Pty Ltd as at 30 June 2019 is...
The statement of financial position (extract) of Kent Pty Ltd as at 30 June 2019 is given below: Kent Pty Ltd Statement of Financial Position As at 30 June 2019 Current Assets Current Liabilities Cash Receivables Inventories Prepaid expenses 360 000 251 200 540 800   49 600 $1 201 600 Payables Other liabilities 360 000 416 000              $776 000 The company signed a loan agreement in early 2019 that requires the company to maintain a minimum current ratio of...
You have been provided with the Balance Sheet and Income Statement for OSR Pty Ltd as...
You have been provided with the Balance Sheet and Income Statement for OSR Pty Ltd as at 30 June 2020 with 2019 comparatives to prepare an analysis for the performance of OSR Pty Ltd: OSR Pty Ltd    Account Balance   As at 30 June 2020 2019 Assets $ $ Cash $30,000 $19,200 Accounts receivable $49,200 $44,100 Inventory $84,000 $82,800 Property, plant and equipment $312,000 $312,000 Total Assets $475,200 $458,100 Liabilities Accounts Payable $57,000 $67,200 Mortgage payable $120,000 $120,000 Total Liabilites $177,000...
An extract from the balance sheets of Mum & Dra Pty Ltd showed the following for...
An extract from the balance sheets of Mum & Dra Pty Ltd showed the following for the years ended 30 June 2013 and 30 June 2014: Current Assets 30 June 2013 30 June 2014 Bank Accounts receivable Allowance (provision) for doubtful debts Inventory Bills Receivable 17,000 67,000 - 3,000 52,000 10,000 19,300 61,000 - 2,000 55,000 14,000 Current Liabilities Accounts payable Taxation payable Provision for annual leave Provision for dividend 44,000 12,000 14,000 16,000 48,000 14,000 22,000 22,000 Additional Information:...
Question 2 Smith Ltd manufactures and sells one product. You are presented with the following information...
Question 2 Smith Ltd manufactures and sells one product. You are presented with the following information for the preparation of the annual operating budget for the period ending 31 December 2021: Estimated sales in units are 50,000 units for Quarter 1, 53,000 units for Quarter 2, 62,000 units for Quarter 3, and 65,000 units for Quarter 4. The estimated per unit selling price is $9 for Quarters 1-3, and $10 for Quarter 4. Smith Ltd has set the desired ending...
Halloween Pty Ltd is preparing a cash budget for the first three months of 2016. Relevant...
Halloween Pty Ltd is preparing a cash budget for the first three months of 2016. Relevant estimates for the budget are as follow: January February March Sales 260,000 300,000 350,000 Materials Purchases 150,000 185,000 220,000 Salaries and Wages 30,000 30,000 35,000 Selling Expenses 14,500 19,000 22,000 Administration Expenses 20,500 24,800 27,600 Additional information: ? All sales are on credit. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20%...