The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 401 Weeks Ago, 4 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
28. LO.4 (Cash collections) Ridenour Ltd. is preparing its first-quarter monthly cash budget for 2011. The following information is available about actual 2010 sales and expected 2011 sales:
Excel
|
November |
December |
January |
February |
March |
|
$83,000 |
$76,000 |
$79,000 |
$88,000 |
$59,000 |
Tracing collections from prior year monthly sales and discussions with the credit man- ager helped develop a profile of collection behavior patterns.
Of a given month’s sales, 40 percent is typically collected in the month of sale. Because the company terms are 1 percent (end of month) net 30, all collections within the month of sale are net of the 1 percent discount. Of a given month’s sales, 30 percent is collected in the month following the sale. The remaining 30 percent is collected in the second month following the month of the sale. Bad debts are negligible and should be ignored.
a. Prepare a schedule of cash collections for Ridenour Ltd. for January, February, and March 2011.
b. Calculate the Accounts Receivable balance at March 31, 2011.
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------sol-----------uti-----------on.-----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- ca-----------tch-----------