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   »   Determine the amount of cash overage or shortage

 
Question Tools Search this Question Display Modes
Question
 
 
#1  
Old Dec 11, 2007, 12:06 PM
craw2488
New Member
craw2488 is offline
 
Join Date: Dec 2007
Posts: 4
craw2488 See this member's comment history on his/her Profile page.
Determine the amount of cash overage or shortage

Have a Managerial Accounting problem:
ABC Company budgeted the following transactions from May 2003

Sales (60% collected in month of sale) $180,000
Cash Operating Expenses $ 105,000
Cash Purchases of Capital Investments $ 50,000
Cash repayment on Note payable $ 40,000
Depreciation on equipment $ 25,000

There was $35,000 beginning cash balance. Sales for April were $75,000 and 40% expected to be collected in the month following the sales. The company desires to have a $20,000 and the cash balance. Determine the amount of cash overage or shortage.

4 possible answers
$42,000 shaortage
$23,000 overage
$22,000 shortage
$43,000 overage

I need help with which process to use to find the answers. A little lost.

Reply With Quote
 
     

Answers
 
 
Old Dec 11, 2007, 01:06 PM   #2  
Hermansherman
Junior Member
Hermansherman is offline
 
Join Date: Jul 2007
Posts: 36
Hermansherman See this member's comment history on his/her Profile page.
Cash in

Sales from April 75000*.4 = 30000
Sales from May 180000*.6 = 108000

Total in 138000

Cash out
Operating expenses -105000
Capital spend -50000
Repay notes payable -40000

Total out -195000

Beginning balance 35000
Cash in 138000
Cash out -195000

Projected ending balance -22000

Desired cash balance 20000

Projected shortage -42000
  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
Circuit Breakers Hissing Sound, Stove Shortage, and Automatic Fusebox Turnoff Measuray Electrical & Lighting 14 Yesterday 01:24 PM
overage paid to chapter 13 bankruptcy mscatwork Bankruptcy & Debt 0 Nov 3, 2007 09:54 AM
determine if I'm preggers. preggermaniac Women's Health 3 Oct 24, 2007 11:37 AM
electric shortage cynthiah Electrical & Lighting 1 Jan 12, 2007 06:03 PM
Decrease in Cash & Cash Equivalents 19lana911 Accounting 0 Nov 23, 2006 06:16 AM




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

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