onth following the sale. The Ju $4,400 in accounts payable; a ans are obtained at the end o g-of-the-month loan balance end of the month. Operating e

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
July
$58,500 $74, 500
September
$ 53,500
August
Budgeted sales
Budgeted cash payments for
Direct materials
16,060
3,940
20,100
13,340
3,260
16,700
13,660
3,340
17,100
Direct labor
Factory overhead
Sales are 25% cash and 75% on credit. All credit sales are collected in the month following the sale. The June 30 balance
sheet includes balances of $15,000 in cash; $44,900 in accounts receivable; $4,400 in accounts payable; and a $4,900
balance in loans payable. A minimum cash balance of $15,000 is required. Loans are obtained at the end of any month
when a cash shortage occurs. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at
each month-end. If an excess balance of cash exists, loans are repaid at the end of the month. Operating expenses are
paid in the month incurred and consist of sales commissions (10% of sales), office salaries ($3,900 per month), and rent
($6,400 per month).
1. Prepare a cash receipts budget for July, August, and September.
BUILT-TIGHT
Cash Receipts Budget
For July, August, and September
July
August
September
Less: ending accounts receivable
Cash receipts from:
Total cash receipts
$
$
Transcribed Image Text:July $58,500 $74, 500 September $ 53,500 August Budgeted sales Budgeted cash payments for Direct materials 16,060 3,940 20,100 13,340 3,260 16,700 13,660 3,340 17,100 Direct labor Factory overhead Sales are 25% cash and 75% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $15,000 in cash; $44,900 in accounts receivable; $4,400 in accounts payable; and a $4,900 balance in loans payable. A minimum cash balance of $15,000 is required. Loans are obtained at the end of any month when a cash shortage occurs. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at each month-end. If an excess balance of cash exists, loans are repaid at the end of the month. Operating expenses are paid in the month incurred and consist of sales commissions (10% of sales), office salaries ($3,900 per month), and rent ($6,400 per month). 1. Prepare a cash receipts budget for July, August, and September. BUILT-TIGHT Cash Receipts Budget For July, August, and September July August September Less: ending accounts receivable Cash receipts from: Total cash receipts $ $
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Ratio Analysis
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education