-
+1 - 312-224-1615
Get in touch with us
-
support@helpwithassignment.com
Send us an e-mail
Solution Library
Prepare Cash Budget And Make Recommendations Based On It
Question
The board of directors of Gladiator Robotics is considering whether or not to donate to a national robotics convention for high school students interested in technology and engineering. The company needs you to prepare a monthly cash budget to determine the available cash reserves for January, February, and March. Relevant data appear below.
|
|
October |
November |
December |
January |
February |
March |
|
Sales |
$300,000 |
$325,000 |
$450,000 |
$310,000 |
$350,000 |
$400,000 |
All sales are on account. Collections are expected to be 60% in the month following the sale, 25% in the second month following the sale, and 10% in the third month following the sale. Five percent are deemed to be uncollectible. The company sold equipment in February for $20,000 and received a dividend on investments of $4,000 in March. Cash on hand as of January 1st is $14,000.
Material purchases are as follows:
|
October |
November |
December |
January |
February |
March |
|
$80,000 |
$85,000 |
$105,000 |
$80,000 |
$88,000 |
$92,000 |
Material purchases are paid 50% in the month purchased and the remainder in the following month.
Other disbursements are paid in the month incurred.
|
|
January |
February |
March |
|
Labor and wages |
150,000 |
185,000 |
215,000 |
|
Selling costs |
62,000 |
68,000 |
78,000 |
|
G & A costs |
30,000 |
31,000 |
38,000 |
|
Income taxes |
|
|
32,000 |
|
Capital equipment |
50,000 |
|
|
The company wants to maintain a cash balance at the end of each month of at least $10,000. It has a $250,000 line of credit at the bank and will borrow from the bank in order to maintain this balance.
Part I: Prepare a monthly cash budget for January, February, and March.
Part II: Analyze the cash budget and make recommendations to the board of directors of Gladiator Robotics regarding your findings. Be specific regarding possible causes and remedies
Part III: What if any concerns do you have about the ability to make the donation? Also, do you have any concerns about cash on hand which might impact variable HR expenses such as recruitment costs or other commitments to employees including staffing, development or rewards? Be specific.
Summary
The question belongs to Accounting and it discusses about preparing a cash budget for an organization and making recommendations based on the review of the cash budget.
Total Word Count 554
Download Full SolutionWHAT OUR STUDENTS SAY
1. I never faced any problem with marketing management or finance. But with operations management, I always suffered. I was unable to under the concepts of the decision tree analysis and the concept of location strategies. When I came across TheReliableTutor.com, I was relieved as they helped me overcome the horrors of operations management and transformed my fear into a genuine interest.
Simon Betteridge Student
As an undergraduate statistics student at one of the leading institutes in Singapore I was finding it increasingly difficult keeping up with the assignments with the rest of the class. I was lost, and not in a good way, in probability, displaying data etc. That is when I found TheReliableTutor. Here the stats homework solver helped me out with all my assignments and I have been getting great reviews and grades since then.
Jun Jie Student
Believe it or not I used to get C or D in my chemical engineering assignments. So when the chapters of distillation came I was really worried. But with the help of HwA, I started getting a B or an A. Then gradually when it came to the kinetics of solids, I passed with straight “Aâ€s"
Catherina Basch Student
I was badly stuck with my tax credit assignment solution when I came across HwA. I was happily surprised to see that this website has taxation experts from New Zealand itself and that uplifted my confidence in this. The assignments all got good feedback and now as I am pursuing my PhD also, I seek constant help from them.
Sapphire Barron Student
Great assistance!!! Thank you guys for all your support. I love the way you dealt with my every instruction and I’m very much satisfied with the work. As I had difficulties managing time for studies and job, you really saved both.
Brendon Student
Comments
this is a very good website
I have 50 questions for the same test your page is showing only 28
hi can you please help or guide me to answer my assignments. thanks
hi can anyone help or guide me to my assignments. thanks
This solution is perfect ...thanks
Hello Allison,I love the 2nd image that you did! I also, had never heard of SumoPaint, is something that I will have to exolpre a bit! I understand completely the 52 (or so) youtube videos that you probably watched. Sometimes they have what you want, sometimes they don't! However, it is always satisfying when you are able to produce something that you have taught yourself. Great job!Debra 0 likes
Perfect bank of solution.
great !
thanks for the quick response. the solution looks good. :)
thnx for the answer. it was perfect. just the way i wanted it.
works fine.