Expected Cash Collections and Disbursements Schedules
Not what you're looking for?
I really am not sure how to go about doing any of this problem. I guess figuring out the percentages would be the most help. So I can figure out the total amount for the collections. The "actual sales" part in the question is also throwing me off. Like I said any help would be great.
All sales at Bell Company are made on credit. Experience has shown that 50% of the accounts receivable are collected in the month of the sale, 48% are collected in the month following the sale, and the remaining 2% are uncollectible. Actual sales for May and budgeted sales for the following four months are given below:
May (actual sales)........... $100,000
June.................................. $200,000
July................................... $400,000
August................................. $500,000
September.................................... $300,000
The company's cost of goods sold is equal to 60% of sales. All purchases of inventory are made on credit. Bell Company pays for one half of a month's purchases in the month of purchase, and the other half in the month following purchase. The company requires that end-of-month inventories be equal to 35% of the cost of goods sold for the next month.
1. Compute the amount of cash, in total, which the company can expect to collect in July.
2. Compute the budgeted dollar amount of inventory which the company should have on hand at the end of June.
3. Compute the amount of inventory that the company should purchase during the months of July and August.
4. Compute the amount of cash payments that will be made to suppliers during August for purchases of inventory.
Purchase this Solution
Solution Summary
In this Solution, the author prepare the Schedule of Cash Collections, Schedule of Required Purchases, and Schedule of Cash Disbursements with the answer to all 4 questions. This Solution is presented in a 1 page Microsoft Excel document.
Education
- BA, Ain Shams University, Cairo Egypt
- MBA, California State University, Sacramento
Recent Feedback
- "ty i have more need help with"
- "ty i have jmore i need help with"
- "great help"
- "excellent help"
- "Very helpful and easy to understand."
Purchase this Solution
Free BrainMass Quizzes
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.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Marketing Management Philosophies Quiz
A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.