S&P Enterprises has provided data from the first three months of the year. The Controller has asked you to prepare the Cash Budget and the related Schedules for Expected cash collections and Payments to suppliers. Data Actual January and February and expected March sales: Cash sales Sales on account Total Sales Accounts Receivable Collections: Month of sale. Month following sale Second month following sale Uncollectible Accounts payable for inventory purchases, March 1 balance Budgeted inventory purchases in March Inventory payments: Month of purchase Month following purchase Total budgeted selling & administrative expenses in March (including depreciation) Budgeted depreciation in March (included in total selling and admin exp); Other budgeted cash disbursements in March. Equipment purchases, Dividends to be paid Minimum cash balance to be maintained March 1 cash balance. March 1 outstanding borrowings March 1 interest due. $ 14,000 $ 2,000 $10,000 $ 11,500. $0 $0 January $ 1,600. 25,000 $ 26,600 $ 12,500 $ 3,200 158 60% 22% 38 $ 10,500 $ 23,500 February. $ 3,750 30,000 $ 33,750 60% 40% March $ 5,100 40,000 $ 45,100 The company has a line of credit available to bolster the cash balance as needed. When preparing budgets, the company maintains their data on a separate sheet from the actual budget and schedules.
S&P Enterprises has provided data from the first three months of the year. The Controller has asked you to prepare the Cash Budget and the related Schedules for Expected cash collections and Payments to suppliers. Data Actual January and February and expected March sales: Cash sales Sales on account Total Sales Accounts Receivable Collections: Month of sale. Month following sale Second month following sale Uncollectible Accounts payable for inventory purchases, March 1 balance Budgeted inventory purchases in March Inventory payments: Month of purchase Month following purchase Total budgeted selling & administrative expenses in March (including depreciation) Budgeted depreciation in March (included in total selling and admin exp); Other budgeted cash disbursements in March. Equipment purchases, Dividends to be paid Minimum cash balance to be maintained March 1 cash balance. March 1 outstanding borrowings March 1 interest due. $ 14,000 $ 2,000 $10,000 $ 11,500. $0 $0 January $ 1,600. 25,000 $ 26,600 $ 12,500 $ 3,200 158 60% 22% 38 $ 10,500 $ 23,500 February. $ 3,750 30,000 $ 33,750 60% 40% March $ 5,100 40,000 $ 45,100 The company has a line of credit available to bolster the cash balance as needed. When preparing budgets, the company maintains their data on a separate sheet from the actual budget and schedules.
Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter8: Budgeting
Section: Chapter Questions
Problem 17E
Related questions
Question
Please don't give image format
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
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.Recommended textbooks for you
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College