Fill This Form To Receive Instant Help
Homework answers / question archive / 1
1. Cabanas Waterway Sands Pte Ltd (CWS) sells beach motorbikes. The following information pertains to the operation of CWS: • The company sells its only model of beach motorbike, CWS Gold, for $300 per unit. Budgeted sales for quarters 1 and 2 for the year 2021 are as follows: Quarter 1 60 Quarter 2 80 Budgeted no of units sold • 30% of the sales are collected in the same quarter, with the rest to be collected in the following quarter. Calculate the total cash collected in Quarter 2 of 2021. Cash Collection Budget Quarter 2 Cash Sales (% of Quarter 2 sales) Cash collection for Quarter 1's credit sales % of Quarter 1 sales) Total cash collection b) If CWS' budgeted cash balance at the end of Quarter 1 is $8,000, what will be the budgeted ending cash balance for Quarter 2 of the year 2021. if cash disbursement for Quarter 2 is $17.500?
2 Paraine Pte Ltd (Paralne") sells watches. Paraing forecasts that the sales and expenses for November and December 2020 will be as follows: Sales Purchases Selling and Administrative expenses November 2020 $26,000 $11,000 $7 200 December 2020 $30,000 $13,500 $9.400 Additional information: • 80% of all sales are made on credit basis, with the remainder of the sales on cash basis. All credit sales are collected in one month's time. • Purchases are to be paid in cash within the same month in which they were incurred. • 30% of selling and administrative expenses are to be paid in cash within the same month in which they were incurred and the remainder to be paid in one month's time. • Beginning cash balance for December 2020 is $7.000 (a) Using only the information above, calculate Paraine's total cash available before financing for the month of December 2020. Show all your workings clearly (b) Calculate Paraine's Accounts Receivable as at 31 December 2020 Show all your workings clearly.
Solution
REQUIREMENT 1
Cabanas Waterway Sands Pte Ltd (CWS) has provided the sale details as follows,
Particulars |
Quarter 1 |
Quarter 2 |
Budgeted No. of Units Sold |
60 |
80 |
Budgeted Sales (Sale Price per unit = $300) |
$ 18,000 |
$ 24,000 |
30% of Revenue to be collected during same quarter |
$ 5,400 |
$ 7,200 |
70% of Revenue |
$ 12,600 |
$ 16,800 |
To be collected during |
Quarter 2 |
Quarter 3 |
(a) Assuming that there was no revenue uncollected during Quarter 4 of prior year, the cash collection budget for Quarter 2 will be prepared as follows,
Particulars |
Amount (Quarter 2) |
Cash Sales (30% of Quarter 2 Sales) |
$ 7,200 |
Cash Collection for Quarter 1’s Credit Sales (70% of Quarter 1 Sales) |
$ 12,600 |
Total Cash Collection |
$ 19,800 |
(b) Now if Budgeted Cash Balance at the end of Quarter 1 (i.e. Beginning of Quarter 2) is $ 8,000, the Budgeted Ending Cash Balance for Quarter 2 shall be calculated as follows,
Particulars |
Amount (Quarter 2) |
Budgeted Cash Balance at the beginning of Quarter 2 |
$ 8,000 |
Total Cash Collection for Quarter 2 |
$ 19,800 |
Cash Disbursement for Quarter 2 |
- $ 17,500 |
Budgeted Cash Balance at the end of Quarter 2 |
$ 10,300 |
REQUIREMENT 2
Paraine Pte Ltd has provided a basic overview of their financial affairs as follows,
Particulars |
November 2020 |
December 2020 |
Sales |
$ 26,000 |
$ 30,000 |
Credit Sales |
$ 20,800 |
$ 24,000 |
To be recovered on |
December 2020 |
January 2020 |
Cash Sales (20% of Total Sales) |
$ 5,200 |
$ 6,000 |
Purchases (Payable in Cash during same month) |
$ 11,000 |
$ 13,500 |
Selling and Administrative Expenses |
$ 7,200 |
$ 9,400 |
30% Cash |
$ 2,160 |
$ 2,820 |
70% Credit |
$ 5,040 |
$ 6,580 |
Payable on |
December 2020 |
January 2020 |
(a) Now if Budgeted Cash Balance at the Beginning of December 2020 is $ 7,000, the Budgeted Cash Balance shall be calculated as follows,
Particulars |
Amount |
||||
Budgeted Cash Balance at the beginning of December 2020 |
$ 7,000 |
||||
Total Cash Collection for December 2020
|
$ 26,800 |
||||
Cash Disbursement for December 2020
|
- $ 21,360 |
||||
Total Cash available before financing as on December 2020 |
$ 12,440 |
(b) Assuming that there was no revenue uncollected during October 2020, Credit Sales of November 2020 amounting to $ 20,800 to be collected during December 2020, and Credit Sales of December 2020 amounting to $ 24,000 to be collected during January 2020.
Therefore, Accounts Receivable as at 31st December 2020 will be $ 24,000.