Cash Budgets for Randall Company
Not what you're looking for?
Randall Company is a merchandising company that sells a single product. The company's inventories, production, and sales in units for the next three months have forecasted as follows:
October November December
Beginning Inventory 10,000 10,000 10,000
Merchandise Purchases 60,000 70,000 35,000
Sales 60,000 70,000 40,000
Ending Inventory 10,000 10,000 5,000
Units are sold for $12 each. One fourth of all sales are paid for in the month of sale and the balance is paid in the following month. Accounts receivable at September 30 totaled $450,000.
Merchandise is purchased for $7 per unit. Half of the purchases are paid for in the month of the purchase and the remainder is paid in the month following the purchase. Selling and administrative expenses are expected to total $120,000 each month. One half of these expenses will be paid in the month in which they are incurred and the balance will be paid in the following month. There is no depreciation. Accounts payable at September 30 totaled $290,000.
Cash at September 30 totaled $80,000. A payment of $300,000 for purchase of equipment is scheduled for November, and a dividend of $200,000 is to be paid in December.
Required:
a. Prepare a schedule of expected cash collection in good form for each of the months of October, November, and December.
b. Prepare a schedule showing expected cash disbursements for merchandise purchases and selling and administrative expenses for each of the months October, November, and December.
c. Prepare a cash budget in good form for each of the months October, November, and December. There is no minimum required ending cash budget.
Purchase this Solution
Solution Summary
This solution is comprised of a schedule of expected cash collection in good form for each of the months of October, November, and December, a schedule showing expected cash disbursements for merchandise purchases and selling and administrative expenses for each of the months October, November, and December, and a cash budget in good form for each of the months October, November, and December.
Purchase this Solution
Free BrainMass Quizzes
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
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.
Learning Lean
This quiz will help you understand the basic concepts of Lean.
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.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.