Using the following information: a. Beginning cash balance on March 1, $81,000. b. Cash receipts from sales, $309,000. c. Cash payments for direct materials, $134,000. d. Cash payments for direct labor, $73,000. e. Cash payments for overhead, $43,000. f. Cash payments for sales commissions, $8,000 g. Cash payments for interest, $130 (1% of beginning loan balance of $13,000) h. Cash repayment of loan, $13,000.

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter7: Budgeting
Section: Chapter Questions
Problem 12EB: Drainee purchases direct materials each month. Its payment history shows that 65% is paid in the...
icon
Related questions
icon
Concept explainers
Question
Using the following information:
a. Beginning cash balance on March 1, $81,000.
b. Cash receipts from sales, $309,000.
c. Cash payments for direct materials, $134,000.
d. Cash payments for direct labor, $73,000.
e. Cash payments for overhead, $43,000.
f. Cash payments for sales commissions, $8,000
g. Cash payments for interest, $130 (1% of beginning loan balance of $13,000)
h. Cash repayment of loan, $13,000.
Prepare a cash budget for March for Gado Company.
GADO COMPANY
Cash Budget
March
Beginning cash balance
Add: Cash receipts from sales
Total cash available
Less: Cash payments for
81,000
309,000
390,000
Direct materials
134,000
Direct labor
73,000
Overhead
43,000
Sales commissions
8,000
Interest on loan
130
Total cash payments
258,130
Ending cash balance
$ 131,870
Loan activity
Beginning cash balance
13,000
Repayment of Bank loan
118,870
Loan balance, end of month
%24
Transcribed Image Text:Using the following information: a. Beginning cash balance on March 1, $81,000. b. Cash receipts from sales, $309,000. c. Cash payments for direct materials, $134,000. d. Cash payments for direct labor, $73,000. e. Cash payments for overhead, $43,000. f. Cash payments for sales commissions, $8,000 g. Cash payments for interest, $130 (1% of beginning loan balance of $13,000) h. Cash repayment of loan, $13,000. Prepare a cash budget for March for Gado Company. GADO COMPANY Cash Budget March Beginning cash balance Add: Cash receipts from sales Total cash available Less: Cash payments for 81,000 309,000 390,000 Direct materials 134,000 Direct labor 73,000 Overhead 43,000 Sales commissions 8,000 Interest on loan 130 Total cash payments 258,130 Ending cash balance $ 131,870 Loan activity Beginning cash balance 13,000 Repayment of Bank loan 118,870 Loan balance, end of month %24
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
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
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College