Accounting: Schedule of Expected Cash Collections
Watch this threadPage 1 of 1
Saver2
Badges:
0
Rep:
?
You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#1
Smith Inc. desires a minimum ending cash balance each month of $11,000. The ties ae sold to retailers for $9 each. Recent and forecasted sales in units are as follows:
January (actual) . . . . . . . . . 20,000
February (actual) . . . . . . . . 24,000
March (actual) . . . . . . . . . . 28,000
April . . . . . . . . . . . . . . . . . . 35,000
May . . . . . . . . . . . . . . . . . . 45,000
June . . . . . . . . . . . . . . . . . . 60,000
July . . . . . . . . . . . . . . . . . . 40,000
August . . . . . . . . . . . . . . . 36,000
September . . . . . . . . . . . . . 32,000
The large build-up in sales before and during June is due to Father's Day. Ending inventories are supposed to equal 90% of the next month's sales in units. The ties cost the company $5 each.
Purchases are paid for as follows: 50% in the month of purchases and the remaining 50% in the following month. All sales are on credit, with no discount, and payable within 15 days. The company has found, however, that only 25% of a month's sales are collected by month-end. An additional 75% is collected in the following month. Bad debts have been negligible. I'm trying to figure where I went wrong for the Schedule of Expected Cash Collection. Can someone help me get on the right track?
Smith Inc. desires a minimum ending cash balance each month of $11,000. The ties are sold to retailers for $9 each. Recent and forecasted sales in units are as follows:
January (actual) . . . . . . . . . 20,000
February (actual) . . . . . . . . 24,000
March (actual) . . . . . . . . . . 28,000
April . . . . . . . . . . . . . . . . . . 35,000
May . . . . . . . . . . . . . . . . . . 45,000
June . . . . . . . . . . . . . . . . . . 60,000
July . . . . . . . . . . . . . . . . . . 40,000
August . . . . . . . . . . . . . . . 36,000
September . . . . . . . . . . . . . 32,000
The large build-up in sales before and during June is due to Father's Day. Ending inventories are supposed to equal 90% of the next month's sales in units. The ties cost the company $5 each.
Purchases are paid for as follows: 50% in the month of purchases and the remaining 50% in the following month. All sales are on credit, with no discount, and payable within 15 days. The company has found, however, that only 25% of a month's sales are collected by month-end. An additional 75% is collected in the following month. Bad debts have been negligible. I'm trying to figure where I went wrong for the schedule of expected Cash collection.
January (actual) . . . . . . . . . 20,000
February (actual) . . . . . . . . 24,000
March (actual) . . . . . . . . . . 28,000
April . . . . . . . . . . . . . . . . . . 35,000
May . . . . . . . . . . . . . . . . . . 45,000
June . . . . . . . . . . . . . . . . . . 60,000
July . . . . . . . . . . . . . . . . . . 40,000
August . . . . . . . . . . . . . . . 36,000
September . . . . . . . . . . . . . 32,000
The large build-up in sales before and during June is due to Father's Day. Ending inventories are supposed to equal 90% of the next month's sales in units. The ties cost the company $5 each.
Purchases are paid for as follows: 50% in the month of purchases and the remaining 50% in the following month. All sales are on credit, with no discount, and payable within 15 days. The company has found, however, that only 25% of a month's sales are collected by month-end. An additional 75% is collected in the following month. Bad debts have been negligible. I'm trying to figure where I went wrong for the Schedule of Expected Cash Collection. Can someone help me get on the right track?
Smith Inc. desires a minimum ending cash balance each month of $11,000. The ties are sold to retailers for $9 each. Recent and forecasted sales in units are as follows:
January (actual) . . . . . . . . . 20,000
February (actual) . . . . . . . . 24,000
March (actual) . . . . . . . . . . 28,000
April . . . . . . . . . . . . . . . . . . 35,000
May . . . . . . . . . . . . . . . . . . 45,000
June . . . . . . . . . . . . . . . . . . 60,000
July . . . . . . . . . . . . . . . . . . 40,000
August . . . . . . . . . . . . . . . 36,000
September . . . . . . . . . . . . . 32,000
The large build-up in sales before and during June is due to Father's Day. Ending inventories are supposed to equal 90% of the next month's sales in units. The ties cost the company $5 each.
Purchases are paid for as follows: 50% in the month of purchases and the remaining 50% in the following month. All sales are on credit, with no discount, and payable within 15 days. The company has found, however, that only 25% of a month's sales are collected by month-end. An additional 75% is collected in the following month. Bad debts have been negligible. I'm trying to figure where I went wrong for the schedule of expected Cash collection.
| April | May | June | Quarter |
February Sales | 54,000 | 0 | 0 | 54,000 |
March Sales | 189,000 | 63,000 | 0 | 252,000 |
April Sales | 78,750 | 236,250 | 78,750 | 393,750 |
May Sales | 0 | 101,250 | 202,500 | 303,750 |
June Sales | 0 | 0 | 135,000 | 135,000 |
Total Cash Collections | 321,750 | 400,500 | 416,250 | 1,138,500 |
0
reply
X
Page 1 of 1
Quick Reply
Back
to top
to top