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   »   Preparing monthly cash statements

 
Thread Tools Display Modes
Question
 
 
#1  
Old Mar 26, 2008, 01:36 PM
challenge mather
New Member
challenge mather is offline
 
Join Date: Mar 2008
Posts: 19
challenge mather See this member's comment history on his/her Profile page.
Preparing monthly cash statements

How do you computer prior month purchases (dec) to get total material payments for Jan?

The Denver Corporation has forecast the following sales for the first seven months of the year:
January $10,000 May $10,000
February 12,000 June 16,000
March 14,000 July 18,000
April 20,000

Monthly material purchases are set equla to 30 percent of forecasted sales for the enxt month. Of the total material cost, 40 percent are paid in themonth of purcahse and 60 percent in the following month. Labor costs will run $4,000 per month, an fixed overhed is $2,000 per month. INterest payments on the debt will be $3,000 for both March and June. Finally, the Denever sales force will receive a 1.5 percent commission on total sales for the first six months the year, to be paid on June 30.

Prepare monthly summary of cash payments for the six month period from Jan - June.

Reply With Quote
 
     

Answers
 
 
Old Mar 27, 2008, 07:01 PM   #2  
Accounting Expert
morgaine300 is offline
 
Join Date: Feb 2008
Posts: 1,397
morgaine300 See this member's comment history on his/her Profile page.
You calculate December's purchases the same way you would the rest of the months. You don't need the sales for December, since purchases are based on the next month's sales. i.e. it's 30% of January's sales.
  Reply With Quote
 
     


Thread Tools
Display Modes

 
Similar Sponsors

Similar Threads
Question Asker Forum Answers Last Post
Preparing a cash budget example for accounting Chitowndym Accounting 1 Feb 2, 2008 09:17 AM
Preparing common size income statements doriam Accounting 1 Oct 25, 2007 06:49 AM
Adjusting accounts and preparing financial statements pisces71 Finance & Accounting 1 Sep 12, 2007 01:38 PM
There does not seem to enough cash to cover the monthly expenses Tommyjo206 Bankruptcy & Debt 3 Aug 7, 2007 05:03 PM
Preparing statements davelong13 Accounting 2 Apr 5, 2007 02:42 PM




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