Question
Janus Inc. needs to prepare a cash budget. The following are actual and forecasted sales figures: Actual Forecast November December January February March April $200,000
Janus Inc. needs to prepare a cash budget. The following are actual and forecasted sales figures:
Actual | Forecast | ||||
November | December | January | February | March | April |
$200,000 | $220,000 | $280,000 | $320,000 | $340,000 | $330,000 |
Thirty percent of each months sales are in cash, 50% are paid the month after sale and 20% are paid two months after sale. Materials cost 30% of sales and are purchased one month prior to sale and paid for 30 days later. Labor expense is 40% of sales, selling and administrative expenses are 5% of sales and both are paid in the month of sale. Overhead is $28,000 per month, depreciation expense is $10,000 per month. Taxes of $8,000 will be paid in January and dividends of $2,000 will be paid on March. Cash on hand at the beginning of January is $80,000 and the desired cash balance is $75,000. Prepare the cash budget for January March.
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