Ilona Ltd is preparing its cash budget for May. The following information is available regarding the...

Ilona Ltd is preparing its cash budget for May. The following information is available regarding the monthly collection history of the company:

Current month’s sales collections	30%
Prior month’s sales collections	58%
2 months’ prior sales collections	6%
3 months’ prior sales collections	4%

The remaining 2% is not collected and the company writes it off as bad debt. Credit sales to date are as follows:

February	R410 000
March	R295 000
April	R385 000
May	R400 000

The total cash disbursements for the month of May amounts to R420 000 and the cash balance on 1 May was R10 000.

REQUIRED

Calculate the cash balance on 31 May.Show all calculations clearly.

Comment on the cash flow positions on 31 May.

Solutions

Expert Solution

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Papst Company is preparing its cash budget for the month of May. The following information is...

Papst Company is preparing its cash budget for the month of May. The following information is available concerning its accounts receivable (based on sales made to customers on open account): Actual credit sales for March $ 130,000 Actual credit sales for April $ 160,000 Estimated credit sales for May $ 210,000 Estimated collections in the month of sale 25 % Estimated collections in the first month after the month of sale 60 % Estimated collections in the second month after...

TO Industries prepares monthly cash budgets. The following budget information is available for April and May...

TO Industries prepares monthly cash budgets. The following budget information is available for April and May 2020: April May Sales $650,000 $700,000 Direct material purchases 220,000 240,000 Direct labor 175,000 180,000 Manufacturing overhead 120,000 130,000 Selling and administrative expenses 150,000 150,000 All sales are credit sales. The company expects to collect 65% from customers in the month of the sale and the remaining 35% in first month following the sale. The company purchases direct materials on account. The company pays...

TO Industries prepares monthly cash budgets. The following budget information is available for April and May...

TO Industries prepares monthly cash budgets. The following budget information is available for April and May 2019: April May Sales $650,000 $700,000 Direct material purchases 220,000 240,000 Direct labor 175,000 180,000 Manufacturing overhead 120,000 130,000 Selling and administrative expenses 150,000 150,000 All sales are credit sales. The company expects to collect 60% from customers in the month of the sale and the remaining 40% in first month following the sale. The company purchases direct materials on account. The company pays...

Q.1 The budget department of ABC Ltd., gathered the following information for preparing its budgets for...

Q.1 The budget department of ABC Ltd., gathered the following information for preparing its budgets for forthcoming period. 1. Sales forecast. Product Sales Quantity Selling price Inventories 01-01-2019 31-12-2019 Product-A 30,000 units Rs. 30 per unit. 5,000 units 10,000 units Product-B 40,000 units Rs. 40 per unit. 10,000 units 15,000 units Materials Purchase budget. 2. Material Product Inventories A B 01-01-2019 31-12-2019 Price per kg Materials-X 2kg 1kg 25,000kg 30,000kg Rs.2.0 Materials-Y 1kg 3kg 10,000 kg 15,000 kg Rs.1.0 3....

Use the following information for #22 and #23: Bries Corporation is preparing its cash budget for...

Use the following information for #22 and #23: Bries Corporation is preparing its cash budget for January. The budgeted beginning cash balance is $18,000. Budgeted cash receipts total $183,000 and budgeted cash disbursements total $188,000. The desired ending cash balance is $30,000. 22. The excess (deficiency) of cash available over disbursements for January is: A. $23,000 B. $13,000 C. ($5,000) D. $201,000 23. To attain its desired ending cash balance for January, the company should borrow: A. $17,000 B. $0...

Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...

Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October: Sales are budgeted to be $167,000. About 85% of sales is cash; the remainder is on account. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. Food and supplies purchases, all on account, are expected to be $102,000. La Famiglia pays 25% in the month of...

Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...

Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October: Sales are budgeted to be $161,000. About 85% of sales is cash; the remainder is on account. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. Food and supplies purchases, all on account, are expected to be $113,000. La Famiglia pays 25% in the month of...

Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...

Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October: Sales are budgeted to be $153,000. About 85% of sales is cash; the remainder is on account. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. Food and supplies purchases, all on account, are expected to be $101,000. La Famiglia pays 25% in the month of...

Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...

Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October: Sales are budgeted to be $162,000. About 85% of sales is cash; the remainder is on account. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. Food and supplies purchases, all on account, are expected to be $103,000. La Famiglia pays 25% in the month of...

Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October:...

Preparing a Cash Budget La Famiglia Pizzeria provided the following information for the month of October: Sales are budgeted to be $166,000. About 85% of sales are cash; the remainder are on account. La Famiglia expects that, on average, 70% of credit sales will be paid in the month of sale, and 28% will be paid in the following month. Food and supplies purchases, all on account, are expected to be $113,000. La Famiglia pays 25% in the month of...

Subjects