Question
Given the following information prepare the Combined Cash Budget for April and May. Description January February March April May June July Cash Collected (actual cash
Given the following information prepare the Combined Cash Budget for April and May.
Description | January | February | March | April | May | June | July |
Cash Collected (actual cash collection | 30,000 | 33,000 | 26,000 | 32,000 | 27,000 | 25,000 | 30,000 |
Direct Material Purchases | 12,000 | 13,000 | 14,000 | 13,000 | 12,000 | 14,000 | 16,000 |
Salaries and Wages | 12,500 | 12,600 | 12,500 | 12,500 | 12,500 | 12,600 | 12,500 |
All Selling Costs | 300 | 200 | 200 | 400 | 200 | 300 | 100 |
Fixed Admin. & Equipment Costs (includes $300 in depreciation) | 4,800 | 6,100 | 3,000 | 3,100 | 2,800 | 2,000 | 2,700 |
Disbursement Timing:
Direct Materials are paid for in the month following the purchase
Salaries and Wages are paid half in the month earned and half in the following month
All other costs are paid in the month incurred
Bank Information:
Ending Cash Balance on March 31 is $3000. The company requires a minimum cash balance of $5,000. The bank requires the company to borrow in increments of $1,000 at 12% annual interest rate. The company may borrow from this operating line at any time and pay back the balance plus interest at any time. At the current time the company has no outstanding loans. The company also has no plans to pay back any borrowings or interest until the following quarter.
Required:
Prepare the Combined Cash Budget for April and May. (Note: Show each month seperately)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started