Cash budget preparation for Elmwood Manufacturing Company
Not what you're looking for?
Prepare a cash budget for Elmwood Manufacturing Company for the first three months of 2007 based on the following information.
(See information attached as a file)
The company has found that approximately 40% of sales are collected during the month the sale is made and the remaining 60% are collected during the month following the sale. Material purchases are 30% of next month's estimated sales, and payments lag these purchases by one month. Labor costs are 35% of next month's sales and are paid during the month uncurred. Factory overhead and selling and administrative expenses are paid during the month incurred. In addition, a payment for new equipment of $1.5 million is due in February. Also, a tax payment of $1.6 million and a dividend payment of $650,000 are due in March.
The company's projected cash balance at the beginning of January is $1.5 million. Furthermore, Elmwood desires to maintain a $750,000 cash balance at the end of each month.
Purchase this Solution
Solution Summary
This solution provides a brief written explanation of how to prepare a cash budget for Elmwood Manufacturing Company for the first three months of 2007 based on provided information. The expert also provides an Excel spread sheet detailing the produced budget for the company.
Solution Preview
Helo!
The cash budget is in the attached file. The formulas in it should be self-explanatory.
Notice that material ...
Purchase this Solution
Free BrainMass Quizzes
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.