Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Anderson Corporation has found that 70% of its sales in any given month are credit sales, while the remainder are cash sales. Of the credit
Anderson Corporation has found that 70% of its sales in any given month are credit sales, while the remainder are cash sales. Of the credit sales, Anderson Corporation has experienced the following collection pattern:
20% received in the month of the sale |
40% received in the month after the sale |
22% received two months after the sale |
November sales for last year were $95,000, while December sales were $115,000. Projected sales for the next three months are as follows:
January sales. | $175,000 |
---|---|
February sales | $130,000 |
March sales. . . | $200,000 |
Requirement
Prepare a cash collections budget for the first quarter, with a column for each month and for the quarter.
Anderson Corporation | ||
Cash Collections Budget | ||
For the Months of January through March |
January | |
Cash sales | |
Collections on credit sales: | |
20% Month of sale | |
40% Month after | |
22% Two months after | |
Total cash collections |
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