Ask Experts Questions for FREE Help!
  Advanced
Register  |  Log in  
   Ask    
 Answer  
  Help  

Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
Free Answers in 3 Easy Steps

Register Now
3 Steps

At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.

Home > Business & Careers > Accounting   »   Cash Collections Budget Problem

 
Question Tools Search this Question Display Modes
Question
 
 
#1  
Old Feb 21, 2006, 03:42 PM
wzwest
New Member
wzwest is offline
 
Join Date: Feb 2006
Posts: 1
wzwest See this member's comment history on his/her Profile page.
Cash Collections Budget Problem

I would REALLY appreciate any help you could give me with this problem:

Sales
May 60,000
June 70,000
July 80,000
August 100,000
All sales are on credit. Records show that 60 percent of the customers pay during the month of the sale, 20 percent pay the month after the sale, and the remaining 15 percent pay the second month after the sale. 5% are uncollectable.

Prepare a cash collections budget for July and August.

Thanks so much!

Reply With Quote
 
     

Answers
 
 
Old Feb 21, 2006, 06:47 PM   #2  
CaptainForest
Finance & Accounting Expert
CaptainForest is offline
 
CaptainForest's Avatar
 
Join Date: Nov 2005
Location: Canada
Posts: 3,658
CaptainForest See this member's comment history on his/her Profile page.CaptainForest See this member's comment history on his/her Profile page.CaptainForest See this member's comment history on his/her Profile page.CaptainForest See this member's comment history on his/her Profile page.
July Cash Collections
July sales = 80,000 * .6 = 48,000
June sales = 70,000 * .2 = 14,000
May sales = 60,000 * .15 = 9,000
TOTAL CASH COLLECTIONS IN JULY = 71,000

August Cash Collections
August sales = 100,000 * .6 = 60,000
July sales = 80,000 * .2 = 16,000
June sales = 70,000 * .15 = 10,500
TOTAL CASH COLLECTIONS IN AUGUST = 86,500
  Reply With Quote
 
     


Question Tools Search this Question
Search this Question:

Advanced Search
Display Modes

 
Similar Sponsors

Similar Questions
Question Asker Topic Answers Last Post
BC collections pennybot Bankruptcy & Debt 2 Jun 30, 2006 10:37 PM
collections sathya_svv Internet & the Web 1 Jan 11, 2006 08:57 PM
Cash Budget cutemiissy Accounting 0 Sep 3, 2005 03:24 PM
Collections yarddog Bankruptcy & Debt 4 May 11, 2005 10:06 AM
collections CMBOUT Bankruptcy & Debt 0 Aug 24, 2004 04:40 PM




Copyright ©2003 - 2007, Ask Me Help Desk.
All times are GMT -8. The time now is 12:48 AM.

Content Relevant URLs by vBSEO 3.0.0 RC6 © 2006, Crawlability, Inc.