Peak sales for Midwest Products
Not what you're looking for?
See attached.
Exercise 9-1 Schedule of Expected Cash Collections [LO2]
Peak sales for Midwest Products, a wholesale distributor of leaf rakes, occur in August. The company's sales budget for the third quarter showing these peak sales is given below:
July August September Total
Budgeted sales (all on account) $ 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, another 70% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. May sales totaled $430,000, and June sales totaled $540,000.
Requirement 1:
Prepare a schedule of expected cash collections from sales, by month and in total, for the third quarter. (Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.)
Requirement 2:
Assume that the company will prepare a budgeted balance sheet as of September 30. Compute the accounts receivable as of that date. (Omit the "$" sign in your response.)
Purchase this Solution
Solution Summary
This solution is comprised of a detailed explanation to prepare a schedule of expected cash collections from sales, by month and in total, for the third quarter.
Solution Preview
Exercise 9-1 Schedule of Expected Cash Collections [LO2]
Peak sales for Midwest Products, a wholesale distributor of leaf rakes, occur in August. The company's sales budget for the third quarter showing these peak sales is given below:
July August September Total
Budgeted sales ...
Purchase this Solution
Free BrainMass Quizzes
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
Introduction to Finance
This quiz test introductory finance topics.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.