Waterway Company prepares monthly cash budgets. Relevant data from operating budgets for 2027 are as follows. January February Sales $460,800 $512,000 Direct materials purchases 153,600 160,000 Direct labor 115,200 128,000 Manufacturing overhead 89,600 96,000 Selling and administrative expenses 101,120 108,800 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases are paid in cash in the month of purchase, and the balance due is paid in the month following the purchase. All other items above are paid in the month incurred except for selling and administrative expenses, which include $1,280 of depreciation per month. Other data: 1. Credit sales: November 2026, $320,000; December 2026, $409,600. 2. Purchases of direct materials: December 2026, $128,000. 3. Other receipts: January-Collection of December 31, 2026, notes receivable $19,200; February-Proceeds from sale of securities $7,680. 4. Other disbursements: February-Payment of $7,680 cash dividend. The company's cash balance on January 1, 2027, is expected to be $76,800. The company wants to maintain a minimum cash balance of $64,000. Prepare a cash budget for January and February in columnar form. く ✓ WATERWAY COMPANY Cash Budget January $ $
Waterway Company prepares monthly cash budgets. Relevant data from operating budgets for 2027 are as follows. January February Sales $460,800 $512,000 Direct materials purchases 153,600 160,000 Direct labor 115,200 128,000 Manufacturing overhead 89,600 96,000 Selling and administrative expenses 101,120 108,800 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases are paid in cash in the month of purchase, and the balance due is paid in the month following the purchase. All other items above are paid in the month incurred except for selling and administrative expenses, which include $1,280 of depreciation per month. Other data: 1. Credit sales: November 2026, $320,000; December 2026, $409,600. 2. Purchases of direct materials: December 2026, $128,000. 3. Other receipts: January-Collection of December 31, 2026, notes receivable $19,200; February-Proceeds from sale of securities $7,680. 4. Other disbursements: February-Payment of $7,680 cash dividend. The company's cash balance on January 1, 2027, is expected to be $76,800. The company wants to maintain a minimum cash balance of $64,000. Prepare a cash budget for January and February in columnar form. く ✓ WATERWAY COMPANY Cash Budget January $ $
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Transcribed Image Text:Waterway Company prepares monthly cash budgets. Relevant data from operating budgets for 2027 are as follows.
January
February
Sales
$460,800 $512,000
Direct materials purchases
153,600 160,000
Direct labor
115,200
128,000
Manufacturing overhead
89,600
96,000
Selling and administrative expenses 101,120
108,800
All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in
the second month following the sale. Sixty percent (60%) of direct materials purchases are paid in cash in the month of purchase, and
the balance due is paid in the month following the purchase. All other items above are paid in the month incurred except for selling and
administrative expenses, which include $1,280 of depreciation per month.
Other data:
1.
Credit sales: November 2026, $320,000; December 2026, $409,600.
2.
Purchases of direct materials: December 2026, $128,000.
3.
Other receipts: January-Collection of December 31, 2026, notes receivable $19,200;
February-Proceeds from sale of securities $7,680.
4.
Other disbursements: February-Payment of $7,680 cash dividend.
The company's cash balance on January 1, 2027, is expected to be $76,800. The company wants to maintain a minimum cash balance
of $64,000.
Prepare a cash budget for January and February in columnar form.
く
✓
WATERWAY COMPANY
Cash Budget
January
$
$
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education