Question
PART 1 Wilson Inc. manufactures basketballs for $20/unit. Wilson Inc. budgets on a quarterly basis and the sales department has budgeted for the following sales:
PART 1
Wilson Inc. manufactures basketballs for $20/unit. Wilson Inc. budgets on a quarterly basis and the sales department has budgeted for the following sales:
Budgeted Sales Units: | JUNE | JULY | AUGUST |
10,000 | 11,000 | 12,000 |
The Basketballs selling price is $35 each.
- Please prepare the Sales Budget.
SALES BUDGET | |||
June | July | August | |
Expected Sales (units) |
|
|
|
Selling Price (/unit) | $35 | $35 | $35 |
Total Budgeted Sales |
|
|
|
PART 2
Wilson Inc. does not collect all of the sales revenue in the period of sale. The accounts receivable department has budgeted for 85% of sales revenue to be collected in the period of sale and 15% to be collected in the next period. The accounts receivable beginning balance is $80,000.
- Please prepare the Schedule of Expected Cash Collections.
SCHEDULE OF EXPECTED CASH COLLECTIONS | |||
June | July | August | |
Accounts Receivable, beginning balance | 80,000 | ||
June Sales
|
|
|
|
July Sales
|
|
|
|
August Sales
|
|
|
|
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