Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / 1

1

Accounting

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.

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

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
(80% of Total 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

Cash Sales

(20% of December Sales)

$ 6,000

Collection for November Credit Sales

(80% of November Sales)

$ 20,800

$ 26,800

Cash Disbursement for December 2020

Purchases

$ 13,500

Selling and Administrative Expenses:

30% of December expenses           $ 2,820

70% of November expenses           $ 5,040

$ 7,860

- $ 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.