Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. SONOMA HOUSEWARES INC. Cash Budget For the Three Months Ending July 31, 2014 May June July Estimated cash receipts from: Cash sales Collections from
1. | |||||||||||||
SONOMA HOUSEWARES INC. | |||||||||||||
Cash Budget | |||||||||||||
For the Three Months Ending July 31, 2014 | |||||||||||||
May | June | July | |||||||||||
Estimated cash receipts from: | |||||||||||||
Cash sales | |||||||||||||
Collections from accounts receivable | |||||||||||||
Total cash receipts | |||||||||||||
Estimated cash payments for: | |||||||||||||
Manufacturing costs | |||||||||||||
Selling and administrative expenses | |||||||||||||
Capital expenditures | |||||||||||||
Other purposes: | |||||||||||||
Income tax | |||||||||||||
Dividends | |||||||||||||
Total cash payments | |||||||||||||
Cash increase (decrease) | |||||||||||||
Cash balance at beginning of month | |||||||||||||
Cash balance at end of month | |||||||||||||
Minimum cash balance | |||||||||||||
Excess (deficiency) | |||||||||||||
Supporting calculations: | |||||||||||||
Collections of accounts receivable: | |||||||||||||
Sales on | |||||||||||||
Account | Percentage | May | June | July | |||||||||
March sales | |||||||||||||
April sales: | |||||||||||||
Collected in May | |||||||||||||
Collected in June | |||||||||||||
May sales: | |||||||||||||
Collected in June | |||||||||||||
Collected in July | |||||||||||||
June sales | |||||||||||||
Totals | |||||||||||||
Payments for manufacturing costs: | |||||||||||||
Costs on | |||||||||||||
Account | Percentage | Payments | |||||||||||
Paid in May: | |||||||||||||
Incurred in April | |||||||||||||
Incurred in May | |||||||||||||
Total | |||||||||||||
Paid in June: | |||||||||||||
Incurred in May | |||||||||||||
Incurred in June | |||||||||||||
Total | |||||||||||||
Paid in July | |||||||||||||
Incurred in June | |||||||||||||
Incurred in July | |||||||||||||
Total | |||||||||||||
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