Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 been forecasted as follows:

October November December
Beginning inventory 13,000 13,000 13,000
Merchandise purchases 51,000 61,000 26,000
Sales 51,000 61,000 31,000
Ending inventory 13,000 13,000 8,000

Units are sold for $12 each. One fourth of all sales are paid for in the month of sale and the balance are paid for in the following month. Accounts receivable at September 30 totaled $446,000.

Merchandise is purchased for $6 per unit. Half of the purchases are paid for in the month of the purchase and the remainder are paid for in the month following purchase. Selling and administrative expenses are expected to total $116,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 $286,000.

Cash at September 30 totaled $76,000. A payment of $296,000 for purchase of equipment is scheduled for November, and a dividend of $196,000 is to be paid in December.

Required:
a.

Prepare a schedule of expected cash collections for each of the months of October, November, and December. (Omit the "$" sign in your response.)

Schedule of Expected Cash Collections
October November December
Sales $ $ $
September accounts receivable $
October sales $
November sales $
December sales
Total cash collections $ $ $

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. (Omit the "$" sign in your response.)

Schedule of Expected Cash Disbursements
October November December
Merchandise purchases $ $ $
Selling and administrative expenses
Total incurred $ $ $
Disbursements, previous month $ $ $
Disbursements, current month
Total $ $ $

c.

Prepare a cash budget for each of the months October, November, and December. There is no minimum required ending cash balance. (Input all amounts as positive values. Omit the "$" sign in your response.)

Randall Company Cash Budget
October November December
Beginning cash balance $ $ $
Add cash receipts
Total cash available $ $ $
Disbursements
Accounts payable
Payment for equipment
Payment for dividend
Total disbursements
Ending cash balance $ $ $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

What are the Griggs v. Duke Power implications for HRM? P-968

Answered: 1 week ago