| 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...
14. Jackson Company has developed the following sales projections for the calendar year: May $ 100,000 June 120,000 July 140,000 August 160,000 September 150,000 October 130,000 Normal cash collection experience has been that 50% of sales is collected during the month of sale and 45% in the month following the sale. The remaining 5% of sales are never collected. Jackson's budgeted cash collections for the third calendar quarter are: (CMA adapted)
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...