Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Nunez Company expects to have a cash balance of $44,000 on January 1, 2020. Relevant monthly budget data for the first two months of 2020
Nunez Company expects to have a cash balance of $44,000 on January 1, 2020. Relevant monthly budget data for the first two months of 2020 are as follows:
1. | Collections from customers: January $98,000; February $161,000 | ||
2. | Payments to suppliers: January $61,000; February $78,000 | ||
3. | Direct labour: January $32,000; February $46,000. Wages are paid in the month they are incurred. | ||
4. | Manufacturing overhead: January $27,000; February $30,000. These costs include depreciation of $1,000 per month. All other overhead costs are paid as incurred. | ||
5. | Selling and administrative expenses: January $15,000; February $20,000. These costs are exclusive of depreciation. They are paid as incurred. | ||
6. | Sales of marketable securities in January are expected to realize $9,000 in cash. |
Nunez Company has a line of credit at a local bank. It can borrow up to $24,000. The company wants to keep a minimum monthly cash balance of $17,000. Prepare a cash budget for January and February.
NUNEZ COMPANY Cash Budget For the Two Months Ending February 29, 2020 | |||||||
---|---|---|---|---|---|---|---|
Month | |||||||
Jan | Feb | Total | |||||
select an opening cash budget item FinancingEnding Cash BalanceTotal FinancingTotal DisbursementsDisbursementsTotal ReceiptsExcess of Available Cash Over Cash DisbursementsTotal Available CashCash ReceiptsBeginning Cash Balance | $enter a dollar amount | $enter a dollar amount | $enter a total for the row | ||||
select between addition and deduction AddLess: select an opening name for section one Total Available CashTotal ReceiptsEnding Cash BalanceBeginning Cash BalanceCash ReceiptsTotal FinancingExcess of Available Cash Over Cash DisbursementsFinancing | |||||||
select a cash budget item RepaymentSelling And Administrative ExpensesCollection From CustomersDirect MaterialsBorrowingDirect LabourIncome Tax ExpenseCollection Of Notes ReceivableManufacturing OverheadPurchase Of LandSale Of Marketable Securities | enter a dollar amount | enter a dollar amount | enter a total for the row | ||||
select a cash budget item Direct MaterialsIncome Tax ExpenseManufacturing OverheadBorrowingSale Of Marketable SecuritiesCollection From CustomersRepaymentSelling And Administrative ExpensesCollection Of Notes ReceivableDirect LabourPurchase Of Land | enter a dollar amount | enter a dollar amount | enter a total for the row | ||||
select a closing name for section one Total ReceiptsTotal Available CashEnding Cash BalanceTotal DisbursementsFinancingTotal FinancingDisbursementsExcess of Available Cash Over Cash DisbursementsBeginning Cash BalanceCash Receipts | enter a total amount for section one | enter a total amount for section one | enter a total amount for section one |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started