April $710,000 Manufacturing costs 425,000 Selling and administrative expenses 60,800 The company expects to sell about 25% of its merchandise for cash. Of sales on account, 60% are collected in the month of the sale, and the remainder in the month following the sale. 65% of the manufacturing costs are paid in the month in which they are incurred, and the balance in the following Sales. of the coming fiscal year March $625,000 260,000 50,800

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

Please do not give solution in image format thanku 

Golf Company has accumulated the following budget information for the two months of the coming fiscal year:
March
April
$625,000 $710,000
260,000
425,000
50,800
60,800
The company expects to sell about 25% of its merchandise for cash. Of sales on account, 60% are collected in the
month of the sale, and the remainder in the month following the sale.
Sales.
Manufacturing costs
Selling and administrative expenses
65% of the manufacturing costs are paid in the month in which they are incurred, and the balance in the following
month.
Depreciation, insurance, and property taxes represent $12,000 of the monthly selling and administrative expenses.
Insurance is paid in May, and property taxes are paid yearly in September. Of the remainder of the selling and
administrative expenses, one-half are to be paid in the month in which they are incurred and the balance in the following
month.
Capital additions of $250,000 are paid in April.
A $12,000 installment on income taxes is to be paid in March
Current assets as of March 1 are composed of cash of $75,000 and accounts receivable of $90,000.
Current liabilities as of March 1 our accounts payable of $200,000 ($180,000 for materials purchases and $20,000 for
operating expenses).
Management desires to maintain a minimum cash balance of $30,000.
REQUIRED:
Prepare a monthly cash budget for March and April. Show Cash Collections on account and Cash Payments on
account separately.
Transcribed Image Text:Golf Company has accumulated the following budget information for the two months of the coming fiscal year: March April $625,000 $710,000 260,000 425,000 50,800 60,800 The company expects to sell about 25% of its merchandise for cash. Of sales on account, 60% are collected in the month of the sale, and the remainder in the month following the sale. Sales. Manufacturing costs Selling and administrative expenses 65% of the manufacturing costs are paid in the month in which they are incurred, and the balance in the following month. Depreciation, insurance, and property taxes represent $12,000 of the monthly selling and administrative expenses. Insurance is paid in May, and property taxes are paid yearly in September. Of the remainder of the selling and administrative expenses, one-half are to be paid in the month in which they are incurred and the balance in the following month. Capital additions of $250,000 are paid in April. A $12,000 installment on income taxes is to be paid in March Current assets as of March 1 are composed of cash of $75,000 and accounts receivable of $90,000. Current liabilities as of March 1 our accounts payable of $200,000 ($180,000 for materials purchases and $20,000 for operating expenses). Management desires to maintain a minimum cash balance of $30,000. REQUIRED: Prepare a monthly cash budget for March and April. Show Cash Collections on account and Cash Payments on account separately.
Expert Solution
steps

Step by step

Solved in 3 steps

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
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