Question
4. AJ Co. is projecting a cash balance of $30,000 in its beginning balance for the year. AJs schedule of expected collections from customers for
4. AJ Co. is projecting a cash balance of $30,000 in its beginning balance for the year. AJs schedule of expected collections from customers for the first quarter of 2014 shows total collections of $180,000. The schedule of expected payments for direct materials for the first quarter of 2014 shows total payments of $41,000. Other information gathered for the first quarter of 2014 is sale of equipment $3,000; direct labor $70,000, manufacturing overhead $35,000, selling and administrative expenses $45,000; and purchase of securities $14,000. AJ wants to maintain a balance of at least $25,000 cash at the end of each quarter. Prepare a cash budget for the first quarter.
AJ Co, Cash Budget For the Quarter Ended March 31, 2014 | |
Beginning cash balance | 30,000 |
Add: Receipts |
|
Total Collections from customers | 180,000 |
Sales of equipment | 3000 |
Total receipts | 183,000 |
Total available cash |
|
Less: Disbursements |
|
Direct materials | 41,000 |
Direct labor | 70,000 |
MOH | 35,000 |
Selling and administrative expenses | 45,000 |
Purchase of securities | 14,000 |
Total disbursements | 205,000 |
Excess of available cash over disbursements |
|
Financing |
|
Add: Borrowings |
|
Less: Repayments |
|
Ending cash balance |
|
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