The projected sales for the Leeds Company is given below. The company has determined that ll sales are on credit and they do not have any cash sales. For the credit sales, experience tells Leeds they will collect 60% of sales in the quarter of the sale and the remaining 40% is collected

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
The projected sales for the Leeds Company is given below. The company has determined that all
sales are on credit and they do not have any cash sales. For the credit sales, experience tells
Leeds they will collect 60% of sales in the quarter of the sale and the remaining 40% is collected
the quarter after the sale. The sales in the last quarter of the previous year is $200,000.
Qtr 1
Qtr 2
Qtr 3
Qtr 4
Budgeted Sales
$600,000
$1,600,000
$800,000
$1,000,000
Leeds need cash to pay for purchases, wages, rent, interest, income taxes, cash dividends, and
most other expenses. Leeds Company is a manufacturing company, the material purchases
requirement for the next four quarters is given in the following table. Leed Company makes all
material purchases on credit. Leed Company will pay for material purchases 80% in the quarter
of purchase and 20% in the quarter after the purchase. The materials purchased in the last
quarter of previous years is $400,000.
Budgeted Material Purchases
$250,000
$295,000
$217,500
$217,500
Leed Company also needs cash payments for direct labor (all direct labor paid in the quarter it
was incurred), cash payments for manufacturing overhead and cash payments for selling and
administrative expenses which are listed in the following table. Further, the company assumes
that $40,000 of dividends will be paid in the second quarter and $80,000 in the third quarter.
Also, Leed plans to expand operations into a new building that will cost $650,000 in Quarter 4.
Leed plans to pay cash for the new building. On January 1, Leed Company’s cash balance was
$130,000. Leeds Company like to keep at a minimum of $10,000 as their ending cash balance
each quarter. Prepare a cash budget for the next four quarters for the company.
Leeds Company
Schedule of Cash Payments
Qtr 1
Qtr 2
Qtr 3
Qtr 4
Total Cash Pmts for Material Purchases
280,000
286,000
233,000
217,500
Budgeted direct labor dollars
126,000
192,000
132,000
156,000
Cash payments for mfg overhead
80,750
89,000
81,500
80,750
Cash payments for selling and admin
110,000
160,000
120,000
130,000
Cash payments for Income Taxes
100,000*
57,500
270,000
100,000
Transcribed Image Text:The projected sales for the Leeds Company is given below. The company has determined that all sales are on credit and they do not have any cash sales. For the credit sales, experience tells Leeds they will collect 60% of sales in the quarter of the sale and the remaining 40% is collected the quarter after the sale. The sales in the last quarter of the previous year is $200,000. Qtr 1 Qtr 2 Qtr 3 Qtr 4 Budgeted Sales $600,000 $1,600,000 $800,000 $1,000,000 Leeds need cash to pay for purchases, wages, rent, interest, income taxes, cash dividends, and most other expenses. Leeds Company is a manufacturing company, the material purchases requirement for the next four quarters is given in the following table. Leed Company makes all material purchases on credit. Leed Company will pay for material purchases 80% in the quarter of purchase and 20% in the quarter after the purchase. The materials purchased in the last quarter of previous years is $400,000. Budgeted Material Purchases $250,000 $295,000 $217,500 $217,500 Leed Company also needs cash payments for direct labor (all direct labor paid in the quarter it was incurred), cash payments for manufacturing overhead and cash payments for selling and administrative expenses which are listed in the following table. Further, the company assumes that $40,000 of dividends will be paid in the second quarter and $80,000 in the third quarter. Also, Leed plans to expand operations into a new building that will cost $650,000 in Quarter 4. Leed plans to pay cash for the new building. On January 1, Leed Company’s cash balance was $130,000. Leeds Company like to keep at a minimum of $10,000 as their ending cash balance each quarter. Prepare a cash budget for the next four quarters for the company. Leeds Company Schedule of Cash Payments Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total Cash Pmts for Material Purchases 280,000 286,000 233,000 217,500 Budgeted direct labor dollars 126,000 192,000 132,000 156,000 Cash payments for mfg overhead 80,750 89,000 81,500 80,750 Cash payments for selling and admin 110,000 160,000 120,000 130,000 Cash payments for Income Taxes 100,000* 57,500 270,000 100,000
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Accounting for Merchandise Inventory
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
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