Question
James, Inc. makes a product that has peak sales in September of each year. The company has prepared a sales budget for the third quarter
James, Inc. makes a product that has peak sales in September of each year. The company has prepared a sales budget for the third quarter as shown below:
Month | Budgeted Sales | ||
July | $ | 200,000 | |
August | 400,000 | ||
September | 600,000 | ||
The company is in the process of preparing a cash budget for the third quarter and must determine the expected cash collections by month. To this end, the following information has been assembled:
Collections on Sales | |||
In month of sale | 60 | % | |
In month following sale | 25 | % | |
In second month following sale | 15 | % | |
The company gives a 3% cash discount to customers paying in the month of their sale. The company charges 2% interest to customers who pay in the second month following their sales. The accounts receivable balance to start the quarter is $150,000: $35,000 from May's sales and $115,000 from June's sales. Required: Prepare a schedule of cash receipts for the third quarter.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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