Data table December 31, 2023, account balances: Requirements Cash $ 28,000 Accounts Receivable 14,000 1. Prepare the schedule of cash receipts from customers for January and February 2024. Assume cash receipts are 60% in the month of the sale and 40% in the month following the sale. Merchandise Inventory 17,000 Accounts Payable 12,000 2. Prepare the schedule of cash payments for purchases for January and February 2024. Assume purchases are paid 60% in the month of purchase and 40% in the month following the purchase. Prepare the schedule of cash payments for selling and administrative expenses for January and February 2024. Assume 40% of the accrual for Salaries and Commissions Payable is for commissions and 60% is for salaries. The December 31 balance will be paid in January. Salaries and commissions are paid 30% in the month incurred and 70% in the following month. Rent and income tax expenses are paid as incurred. Insurance expense is an expiration of the prepaid amount. Salaries and Commissions Payable 2,900 Budgeted amounts for 2024: January February 3. Sales, all on account $ 80,000 $ 81,600 Purchases, all on account 41,200 42,000 Commissions Expense 4,000 4,080 Salaries Expense 5,000 5,000 4. Prepare the cash budget for January and February 2024. Assume no financing took place. Rent Expense 3,200 3,200 Depreciation Expense 600 600 Insurance Expense 200 200 Income Tax Expense 1,800 1,800
Data table December 31, 2023, account balances: Requirements Cash $ 28,000 Accounts Receivable 14,000 1. Prepare the schedule of cash receipts from customers for January and February 2024. Assume cash receipts are 60% in the month of the sale and 40% in the month following the sale. Merchandise Inventory 17,000 Accounts Payable 12,000 2. Prepare the schedule of cash payments for purchases for January and February 2024. Assume purchases are paid 60% in the month of purchase and 40% in the month following the purchase. Prepare the schedule of cash payments for selling and administrative expenses for January and February 2024. Assume 40% of the accrual for Salaries and Commissions Payable is for commissions and 60% is for salaries. The December 31 balance will be paid in January. Salaries and commissions are paid 30% in the month incurred and 70% in the following month. Rent and income tax expenses are paid as incurred. Insurance expense is an expiration of the prepaid amount. Salaries and Commissions Payable 2,900 Budgeted amounts for 2024: January February 3. Sales, all on account $ 80,000 $ 81,600 Purchases, all on account 41,200 42,000 Commissions Expense 4,000 4,080 Salaries Expense 5,000 5,000 4. Prepare the cash budget for January and February 2024. Assume no financing took place. Rent Expense 3,200 3,200 Depreciation Expense 600 600 Insurance Expense 200 200 Income Tax Expense 1,800 1,800
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
I really need help with requirement 3
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.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