Cash Collections
Not what you're looking for?
Need to compare solution. Please show all calculations used to arrive at your answer.
---
Peak sales for Midwest Products, Inc., occur in August. The company's sales budget for the third quarter showing these peak sales is given below:
Budgeted sales............... July August September Total
$600,000 $900,000 $500,000 $2,000,000
From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, that another 70% is collected in the month following sale, and that the remaining 10% is collected in the second month following sale. Bad debts are negligible and can be ignored. May sales totaled $530,000, and June sales totaled $540,000.
1. Prepare a schedule of expected cash collections from sales, by month and in total, for the third quarter.
May June July August September Total
430,000 540,000 600,000 900,000 500,000 2,000,000
86,000 378,000 60,000 180,000 499,930 1,203,930
2. Assume that the company will prepare a budgeted balance sheet as of September 30. Compute the accounts receivable as of that date.
796,070
Purchase this Solution
Solution Summary
The solution explains the preparation of a schedule of expected cash collections and the ending accounts receivable
Purchase this Solution
Free BrainMass Quizzes
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Motivation
This tests some key elements of major motivation theories.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.