Question

In: Accounting

Use the following information provided by Ashleigh Enterprises to prepare the:

Use the following information provided by Ashleigh Enterprises to prepare the:


4.1 Debtors Collection Schedule for March and April 2021.

4.2 Cash Budget for March and April 2021.

Note: * Where applicable, round off amounts to the nearest Rand. * Use separate monetary columns for each month.

INFORMATION 1. The following are estimates for the first four months of 2021: January (R) February (R) March (R) April (R) Sales 140 000 120 000 190 000 230 000 Purchases 70 000 60 000 85 000 115 000 Wages 9 000 9 000 ? ? 2. Forty percent (40%) of the sales are for cash and the balance is on credit. Collections for credit sales are as follows: 30% during the month of the sale; 65% in the month following the sale. The remaining 5% is written off as bad debts. 3. All purchases are on credit. Creditors are paid two months after the month of purchase. 4. Ashleigh Enterprises will make an investment of R60 000 in fixed deposit on 01 March 2021. Interest of R400 per month is expected to be received from March 2021. 5. Rent expense amounts to R156 000 per year and is payable monthly. 6. Wages will be increased by 9% on 01 March 2021. 7. A new computer is expected to be purchased for R15 000 cash during April 2021. 8. Commission payable to sales personnel is calculated at 10% of sales and it is paid one month later. 9. The bank balance on 28 February 2021 is expected to be R30 000 (favourable).

Solutions

Expert Solution

Receipts from Sales on account: 30% of current month's Sales 65% of previous month,s Sales Debtors Collections Schedule March April 34,200 (190,000 *60% * 30%] [230,000 * 60% * 30%] 46,800 [120,000 * 60% * 65%] (190,000 * 60% * 65%] 81,000 41,400 Total Sales in March = R190,000 Cash Sales = 40% and the balance 60% is credit sales 74,100 Total Salesin April = R230,000 Cash Sales = 40% and the balance 60% is credit sales 115,500 February Sales = R120,000 Total Cash Collections


Related Solutions

Use the following information provided by Ashleigh Enterprises to prepare the:
REQUIRED Use the following information provided by Ashleigh Enterprises to prepare the: 4.1 Debtors Collection Schedule for March and April 2021. 4.2 Cash Budget for March and April 2021. Note: * Where applicable, round off amounts to the nearest Rand. * Use separate monetary columns for each month. INFORMATION 1. The following are estimates for the first four months of 2021: January (R) February (R) March (R) April (R) Sales 140 000 120 000 190 000 230 000 Purchases 70...
Use the following information provided by Ashleigh Enterprises to prepare the:
QUESTION 4 Use the following information provided by Ashleigh Enterprises to prepare the:4.1 Debtors Collection Schedule for March and April 2021. 4.2 Cash Budget for March and April 2021. Note: * Where applicable, round off amounts to the nearest Rand. * Use separate monetary columns for each month.INFORMATION 1. The following are estimates for the first four months of 2021: January (R) February (R) March (R) April (R) Sales 140 000 120 000 190 000 230 000 Purchases 70 000...
REQUIRED Use the information provided below to prepare the following for March 2020: 2.1. Flexible budget...
REQUIRED Use the information provided below to prepare the following for March 2020: 2.1. Flexible budget for two different activity levels i.e. 18 000 and 25 000 units (9) 2.2. Performance report (11) 2.3. Comment on the following variances: 2.3.1. Sales (1) 2.3.2. Direct Material (2) 2.3.3. Fixed overheads (2) INFORMATION Widget Ltd manufactures a single product. It originally planned to produce and sell 12 000 units during the year but the actual activity level was 14 000 units. The...
QUESTION 3 (20 Marks) REQUIRED Use the information provided below to prepare the following for Electroman...
QUESTION 3 REQUIRED Use the information provided below to prepare the following for Electroman Limited for August and September 2020 (using separate monetary columns for each month): 3.1 Debtors Collection Schedule 3.2 Cash Budget. Note: Where applicable, round off amounts to the nearest Rand. INFORMATION Electroman Limited sells appliances. The following forecasts were made: 1. The bank balance on 31 July 2020 is expected to be R50 000 (favourable). 2. Sixty percent (60%) of all sales are for cash; the...
Use the information provided below to prepare the liabilities and stockholders’ equity part of the December...
Use the information provided below to prepare the liabilities and stockholders’ equity part of the December 31, 2013 balance sheet for Lark Corporation. If a beginning of the year balance is not mentioned, you may assume that it was zero. Information for Lark Corporation for 2013: - Lark Corporation was authorized to issue 3,000,000 shares of $1 par value common stock and 100,000 shares of $100 par value 5% convertible preferred stock. Each share of preferred stock was convertible into...
3.1 REQUIRED Use the information provided below to prepare the Bank account in the ledger of...
3.1 REQUIRED Use the information provided below to prepare the Bank account in the ledger of Prince Stores showing all the entries that would have been made in the cash journals. Clearly show the contra account for each entry. Balance the account. The cash journals are not required. Use the following format: General ledger DR BANK CR 2020 Jan 31 2020 Jan 31 INFORMATION When comparing the bank statement with the cash journals of Prince Stores for January 2020 the...
Use the income statement and additional information provided below and the appropriate software to prepare the...
Use the income statement and additional information provided below and the appropriate software to prepare the annual budgeting income statement for the next three year. You need to save and upload your budget to Moodle with the final submission for this assessment. Additional information ?? Annual sales are expected to increase by 10% each year ?? Expected average gross profit margin is 30% ?? Advertising costs are expected to increase by $800 each year ?? Depreciation charges are the same...
Question 1 : Use provided information to prepare [A] General Journal. [B] T-Account, [C] Prepare Adjusted...
Question 1 : Use provided information to prepare [A] General Journal. [B] T-Account, [C] Prepare Adjusted Trial Balance --------------------------------------------------------------------------------------------------------------------- [A] Prepare General Journal Company provided services $3,000 in cash Owner invested $1,000 in cash Company purchased office supplies $650 on account Company paid rent expense $5,000, Salary salaries expenses $1,500, Insurance Expenses $450 Company sold inventory $600 on account B] Prepare T-Account and Normal balance from the Table above c)                                                 UNADJUSTED TRIAL BALANCE            Debit        Credit Cash Account...
Using the following information, prepare the Statement of Cash Flows for Corbett Enterprises for the year...
Using the following information, prepare the Statement of Cash Flows for Corbett Enterprises for the year ended December 31, 2017 in the Answer sheet in this Excel spreadsheet. Place parentheses around those figures in the statement representing cash outlays. Then answer the 4 multiple choice questions in the Answer sheet in this Excel spreadsheet. Notice that the ? is beside Cash received from customers. You will need to prepare the Statement of Cash Flows with the other amounts and solve...
Abc trading provided following information :- 1. Prepare a Cash Flow Statement from the following information...
Abc trading provided following information :- 1. Prepare a Cash Flow Statement from the following information for the year ended 30 June 2021. 2. Prepare a Statement in accordance with AASB 107 reconciling net cash flows from operating activities to operating profit after income tax. Borrowed from NAB Bank $22,500 Cash at the beginning of the year $100,050 Cash received from Accounts Receivable $136,000 Cash received from sale of equipment $10,000 Cash paid for operating expenses $36,300 Cash sales $80,500...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT