Unisyms Company - Monthly cash budget
Not what you're looking for?
The treasurer of Unisyms Company has accumulated the following budget information for the first two months of the coming year:
March April
Sales. $450,000 $520,000
Manufacturing costs 290,000 350,000
Selling and administrative expenses 41,400 46,400
Capital additions 250,000 ---
The company expects to sell about 35% of its merchandise for cash. Of sales on account, 80% are expected to be collected in full in the month of the sale and the remainder in the month following the sale. One-fourth of the manufacturing costs are expected to be paid in the month in which they are incurred and the other three-fourths in the following month. Depreciation, insurance, and property taxes represent $6,400 of the probable monthly selling and administrative expenses. Insurance is paid in February and a $40,000 installment on income taxes is expected to be paid in April. Of the remainder of the selling and administrative expenses, one-half are expected to be paid in the month in which they are incurred and the balance in the following month. Capital additions of $250,000 are expected to be paid in March.
Current assets as of March 1 are composed of cash of $45,000 and accounts receivable of $51,000. Current liabilities as of March 1 are composed of accounts payable of $121,500 ($102,000 for materials purchases and $19,500 for operating expenses). Management desires to maintain a minimum cash balance of $20,000.
Prepare a monthly cash budget for March and April.
Purchase this Solution
Solution Summary
Step by step calculation is shown.
Education
- Chartered Accountant (Equivalent to CPA in US), Institute of Charted Accountants of India
- Bachelor of Commerce, West Bengal University
Recent Feedback
- "I got this feedback and I wanted to know if you can explain it to me. I noticed something within your workings which I believe is incorrect. It looks like you've mistaken the Debt ratio for the Equity Multiplier. You've done a calculation to determine Return on Equity (ROE) but if you take a look at the ratios provided for us you'll see ROE listed on the bottom line already. You can use ROE, Profit Margin and Total Asset Turnover to figure out the Equity Multiplier amount. Equity multiplier is not provided for us and we need to calculate it. I really hope this is helpful to you. "
- "Very attentive to detail. Answers are designed in easy to understand format."
- "Fast response and thorough answer"
- "thank you very much! "
- "thank you so much !!!!!!!"
Purchase this Solution
Free BrainMass Quizzes
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.
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
Lean your Process
This quiz will help you understand the basic concepts of Lean.
Motivation
This tests some key elements of major motivation theories.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.