Cash Collections | ||
July | $ 2,72,990 | |
August | $ 3,11,820 | |
Workings: | ||
July | August | |
May | $ 48,300 | |
June | $ 1,30,190 | $ 58,170 |
July | $ 94,500 | $ 1,48,050 |
August | $ 1,05,600 | |
Total Cash Collections | $ 2,72,990 | $ 3,11,820 |
July | August | |
May | 230000*0.21 | |
June | 277000*0.47 | 277000*0.21 |
July | 315000*0.3 | 315000*0.47 |
August | 352000*0.3 |
Fox Trail Center's sales are all made on account. The firm's collection experience has been that...
a month's sales are collected in the month the sale is made, 47 % are collected in the month following Fox Trail Center's sales are all made on account The firm's collection experience has been that 30 % sale. The sales forecast for the months of May through August is as follows: a sale, and 21% are collected in the second month following the May S245.000 288,000 Jund 366 000 August Req the cash collections that would be included in...
Ed’s Waterbeds has made the following sales projections for the next six months. All sales are credit sales. March $ 32,000 June $ 36,000 April 38,000 July 44,000 May 27,000 August 46,000 Sales in January and February were $35,000 and $34,000 respectively. Experience has shown that 10 percent of total sales are uncollectible, 30 percent are collected in the month of sale, 40 percent are collected in the following month, and 20 percent are collected two months after sale. a....
Scottsdale Co. has actual sales for July and August and forecast sales for September October, November, and December as follows: $ 98,900 105,200 Actual: July August Forecast September October November December 114,200 94,300 121, 3ee 107,400 Based on past experience, it is estimated that 28% of a month's sales are collected in the month of sale, 49% are collected in the month following the sale, and 6% are collected in the second month following the sale. Required: Calculate the estimated...
Arbor Co. has forecast sales to be $400,000 in May, $475,000 in June, $575,000 in July and $700,000 in August. Forty percent of sales are made in cash, the remainder is on credit. Credit sales are collected 60% in the month of sale, the remaining the following month. What are budgeted cash collections for July? $230,000 $334,000 $459,000 $551,000
Scottsdale Co. has actual sales for July and August and forecast sales for September, October, November, and December as follows: Actual: July $ 97,300 August 105,300 Forecast: September 114,800 October 94,300 November 122,900 December 106,300 Based on past experience, it is estimated that 29% of a month’s sales are collected in the month of sale, 48% are collected in the month following the sale, and 9% are collected in the second month following the sale. Required: Calculate the estimated cash...
Simpson Glove Company has made the following sales projections for the next six months. All sales are credit sales. March April May $41,000 June 50,000 July 32,000 August $47,000 58,000 62,000 Sales in January and February were $41,000 and $39,000, respectively. Experience has shown that of total sales receipts 10 percent are uncollectible, 40 percent are collected in the month of sale, 30 percent are collected in the following month, and 20 percent are collected two months after sale. Prepare...
Laura's Decor Stores made the following sales projection for the next six months. All sales are credit sales. march 38,000 April 44,000 may 33,000 june 42,000 july 50,000 august 52,000 sales in january and february were $41,000 and $40,000 respectively experience has shown that total sales, 10% are uncollectible, 35% are collected in the month of sale, 45 percent are collected in the following month and 10 percent are collected two months after sale. a) prepare a monthly cash receipts...
Gallonte Inc. began operations in April of this year. It makes all sales on account, subject to the following collection pattern: 30% are collected in the month of sale; 60% are collected in the first month after sale; and 10% are collected in the second month after sale. If sales for April, May, and June were $63,000, $83,000, and $73,000, respectively, what were the firm's budgeted collections for June?
Watt's Lighting Stores made the following sales projection for the next six months. All sales are credit sales March $46,000 June $50,000 April 52,000 July 58,000 May 41,000 August 60,000 Sales in January and February were $49,000 and $48,000, respectively. Experience has shown that of total sales, 10 percent are uncollectible, 25 percent are collected in the month of sale, 35 percent are collected in the following month, and 30 percent are collected two months after sale. a. Prepare a...
Tiara Company has the following historical collection pattern for its credit sales: 70% collected in month of sale 15% collected in the first month after sale 10% collected in the second month after sale 4% collected in the third month after sale 1% uncollectible Budgeted credit sales for the last six months of the year follow. $ June July August September October November December 32,000 30,000 35,000 40,000 45,000 50,000 42,500 I Required: A. What would be the estimated total...