SOLUTION: | |||||
SCHEDULE OF THE CASH RECEIPT FOR THE MONTH OF JAN , FEB & MAR | |||||
PARTICULARS | MARCH | APRIL | MAY | JUNE | |
Cash Sales (A) | $ 21,000 | $ 30,000 | $ 42,000 | $ 55,000 | |
Credit Sales | $ 11,000 | $ 12,000 | $ 37,000 | $ 53,000 | |
25 % Expected to collect in the same month (B) | $ 2,750 | $ 3,000 | $ 9,250 | $ 13,250 | |
60% in the month following the sale ('C) | $ 6,600 | $ 7,200 | $ 22,200 | ||
10 % in second month following the sales(D) | $ 1,100 | $ 1,200 | |||
Total Cash Collected (A+B+C+D) | $ 23,750 | $ 39,600 | $ 59,550 | $ 91,650 | |
ANSWER = Option A = $ 59,550 | |||||
Two Brothers Moving prepared the following sales budget: Month Cash Sales Credit Sales March $21,000 $11,000...
Three Brothers Moving prepared the following sales budget: Month Cash Sales Credit Sales March $20,000 $10,000 April $36.000 $16,000 May $52,000 $30,000 Jung $60.000 $46.0od Credit collections are 40% in the month of sale, 50% in the month following the sale, and 5% two months following the sale. The remaining 5% is expected to be uncollectible. What are the total cash collections in May at Three Brothers Moving? 572,500 557.800 562.400 555.750
Magna Corporation has prepared the following sales budget: Month Cash Sales Credit Sales Jan $16,000 $68,000 Feb 20,000 80,000 March 18,000 74,000 April 24,000 92,000 May 22,000 76,000 Collections are 40% in the month of sale, 45% in the month following the sale, and 10% two months following the sale. The remaining 5% is expected to be uncollectible. Required: Prepare a schedule of cash collections for March through May,
Feeney Furniture prepared the following sales budget: Month Cash Sales Credit Sales March $23,000 $12,000 April $37,000 $12,000 May $40,000 $39,000 June $54,000 $46,000 Credit collections are 10% two months following the sale, 55% in the month following the sale, and 30% in the month of sale. The remaining 5% is expected to be uncollectible What are the total cash collections in June at Feeney Furniture? O A $36,450 OB. $100,000 OC. $90,450 OD. $29,650
January February March April May June Cash Credit Sales Sales $ 80,000 $180,000 $ 85,000 $200,000 $ 48,000 $160,000 $ 43,000 $128,000 $ 53,000 $230,000 $110,000 $220,000 The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: Collections on sales: 50% in month of sale 40% in month following sale 10% in second month following sale The accounts receivable balance on...
Norman Corp. has prepared the sales budget. The expected sales are as follows: $84,000 for March, $100,000 for April, $92,000 for May, $116,000 for June, and $98,000 for July. Credit sales are 80% of total sales, and cash sales are remaining 20%. Collections of account receivables are 80% in the month of sale (and subject to 1% discount), 15% in the month following the sale. The remaining 5% is expected to be uncollectible. (a) Prepare a schedule of cash collections...
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 $ 185,000 Actual credit sales for April $ 237,000 Estimated credit sales for May $ 342,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...
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 Actual credit sales for April Estimated credit sales for May Estimated collections in the month of sale Estimated collections in the first month after the month of sale stimated collections in the second month after the month of sale Estimated provision for bad debts (made...
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 Actual credit sales for April Estimated credit sales for May Estimated collections in the month of sale Estimated collections in the first month after the month of sale Estimated collections in the second month after the month of sale Estimated provision for bad debts (made...
On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget for March, April, and May. All of the company’s sales are made on account. The following information has been provided by Spicer’s management. Month Credit Sales January $ 300,000 (actual) February 400,000 (actual) March 526,000 (estimated) April 646,000 (estimated) May 800,000 (estimated) The company’s collection activity on credit sales historically has been as follows. Collections in the month of the sale...
Sales are 65% cash and 35% credit. Credit sales are collected 10% in the month of sale and the remainder in the month after sale. Actual sales in December were а. $57,000. Schedules of budgeted sales for the two months of the upcoming year are as follows: Budgeted Sales Revenue $58,000 January February $72,000 Actual purchases of direct materials in December were $25,000. The company's purchases of direct materials in January are budgeted to be $22,500 and $27,000 in February....