Cash budget for Joes Bar and Grill
Not what you're looking for?
Prepare a cash budget for Joes Bar and Grill based on the following information:
Sales are projected to be 100 in Jan, 150 in Feb, 300 in Mar and 100 in Apr.
Collections are 50% in the month of sale and 50% one month after the sale.
Collections one month after the sale are reduced by the credit card fee of 2%.
COGS is 30% of sales.
Joe has terms of "2/10 net 30" and pays in 30 days for all purchases.
Fixed costs include a fee for protection from Guido and Vito Arm and Leg Preservation services of 10 per month, Taxes of 10 per year to be paid in January, Rent of 2 per month and Utilities of 1 per month.
Minimum cash balance is 20.
Joe has a credit card he uses as his line of credit. It has a maximum limit of 20.
Is Joes line of credit adequate to run his business through the end of April?
Prove your answer by preparation of a cash budget, showing all work.
Purchase this Solution
Solution Summary
The solution prepares cash budget for Joes Bar and Grill and finds out whether Joes line of credit is adequate to run his business through the end of April.
Purchase this Solution
Free BrainMass Quizzes
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Motivation
This tests some key elements of major motivation theories.
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.