Prepare a cash budget for March for Gado Company.

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter7: Budgeting
Section: Chapter Questions
Problem 6PA: Relevant data from the Poster Companys operating budgets are: Additional data: Capital assets were...
icon
Related questions
icon
Concept explainers
Question

Using the following information:

  1. Beginning cash balance on March 1, $75,000.
  2. Cash receipts from sales, $302,000.
  3. Cash payments for direct materials, $134,000.
  4. Cash payments for direct labor, $70,000.
  5. Cash payments for overhead, $36,000.
  6. Cash payments for sales commissions, $8,000
  7. Cash payments for interest, $180 (1% of beginning loan balance of $18,000)
  8. Cash repayment of loan, $18,000.

Prepare a cash budget for March for Gado Company.

Prepare a cash budget for March for Gado Company.
Beginning cash balance
Add: Cash receipts from sales
Total cash available
Less: Cash payments for
Direct materials
Direct labor
Other expenses
Repayment of bank loan
Overhead
Interest on loan
Total cash payments
Preliminary cash balance
Loan activity
Ending cash balance
Loan balance, end of month
GADO COMPANY
Cash Budget
$
19
March
75,000
302,000
134,000
70,000
18,000
36,000
180
$
19
$
377,000
258,180
118,820
204,000
(85,180)
Transcribed Image Text:Prepare a cash budget for March for Gado Company. Beginning cash balance Add: Cash receipts from sales Total cash available Less: Cash payments for Direct materials Direct labor Other expenses Repayment of bank loan Overhead Interest on loan Total cash payments Preliminary cash balance Loan activity Ending cash balance Loan balance, end of month GADO COMPANY Cash Budget $ 19 March 75,000 302,000 134,000 70,000 18,000 36,000 180 $ 19 $ 377,000 258,180 118,820 204,000 (85,180)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Budgeting
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
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781337119207
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning