(a) Prepare Swifty's cash budget for the fourth quarter, considering only required expenditures. Present amounts for each month and for the quarter overall. October November De Swifty Corp's accounting team is putting together the cash budget for the fourth quarter of the current year. Budgeted cash receipts and cash disbursements for DM are listed below, along with other budgeted costs and additional information. October November December Budgeted cash receipts $313,000 $303,000 $328,000 Budgeted cash disbursements for DM purchases 45,300 67,400 50,600 Budgeted DL and MOH cost 138,300 145,400 151,400 Budgeted SG&A cost 124,400 127,900 123,900 . Beginning cash balance on October 1 is $22,400, minimum required balance is $20,000. Budgeted MOH cost includes $11,800 of depreciation each month. Budgeted SG&A cost includes $13,100 of depreciation each month. A line of credit is available from the bank, subject to a 4% annual interest rate; withdrawals must be made on the first of the month, and repayments must be made on the last day of the month. The withdrawals and repayments must be in $500 increments. If excess cash is available, the following spending priorities have been identified (in order of priority). 1. Equipment purchase of $30,000 (must be made at some point during this quarter with available cash or loan from the bank). 2 Research and development of $10,000 per month (could be made for any number of months or none at all). 3. Advertising of $5,000 per month (could be made for any number of months or none at all).
(a) Prepare Swifty's cash budget for the fourth quarter, considering only required expenditures. Present amounts for each month and for the quarter overall. October November De Swifty Corp's accounting team is putting together the cash budget for the fourth quarter of the current year. Budgeted cash receipts and cash disbursements for DM are listed below, along with other budgeted costs and additional information. October November December Budgeted cash receipts $313,000 $303,000 $328,000 Budgeted cash disbursements for DM purchases 45,300 67,400 50,600 Budgeted DL and MOH cost 138,300 145,400 151,400 Budgeted SG&A cost 124,400 127,900 123,900 . Beginning cash balance on October 1 is $22,400, minimum required balance is $20,000. Budgeted MOH cost includes $11,800 of depreciation each month. Budgeted SG&A cost includes $13,100 of depreciation each month. A line of credit is available from the bank, subject to a 4% annual interest rate; withdrawals must be made on the first of the month, and repayments must be made on the last day of the month. The withdrawals and repayments must be in $500 increments. If excess cash is available, the following spending priorities have been identified (in order of priority). 1. Equipment purchase of $30,000 (must be made at some point during this quarter with available cash or loan from the bank). 2 Research and development of $10,000 per month (could be made for any number of months or none at all). 3. Advertising of $5,000 per month (could be made for any number of months or none at all).
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Transcribed Image Text:(a) Prepare Swifty's cash budget for the fourth quarter, considering only required expenditures. Present amounts for each month
and for the quarter overall.
October
November
De
Transcribed Image Text:Swifty Corp's accounting team is putting together the cash budget for the fourth quarter of the current year. Budgeted cash
receipts and cash disbursements for DM are listed below, along with other budgeted costs and additional information.
October
November December
Budgeted cash receipts
$313,000 $303,000 $328,000
Budgeted cash disbursements for DM purchases
45,300
67,400
50,600
Budgeted DL and MOH cost
138,300
145,400
151,400
Budgeted SG&A cost
124,400
127,900
123,900
.
Beginning cash balance on October 1 is $22,400, minimum required balance is $20,000.
Budgeted MOH cost includes $11,800 of depreciation each month.
Budgeted SG&A cost includes $13,100 of depreciation each month.
A line of credit is available from the bank, subject to a 4% annual interest rate; withdrawals must be made on the first of
the month, and repayments must be made on the last day of the month. The withdrawals and repayments must be in $500
increments.
If excess cash is available, the following spending priorities have been identified (in order of priority).
1.
Equipment purchase of $30,000 (must be made at some point during this quarter with available cash or loan from
the bank).
2
Research and development of $10,000 per month (could be made for any number of months or none at all).
3.
Advertising of $5,000 per month (could be made for any number of months or none at all).
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education