90.2K

Verified Solution

Link Copied!

Nunez Company expects to have a cash balance of $45,000 on January 1, 2020. Relevant monthly budget data for the first two months of 2020 are as follows:

1.		Collections from customers: January $101,000; February $160,000
2.		Payments to suppliers: January $60,000; February $78,000
3.		Direct labour: January $31,000; February $43,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 $16,000; February $19,000. These costs are exclusive of depreciation. They are paid as incurred.
6.		Sales of marketable securities in January are expected to realize $10,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 $23,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 Ending Cash BalanceDisbursementsBeginning Cash BalanceCash ReceiptsTotal ReceiptsTotal FinancingTotal DisbursementsFinancingExcess of Available Cash Over Cash DisbursementsTotal Available Cash
select between addition and deduction AddLess: select an opening name for section one Total FinancingExcess of Available Cash Over Cash DisbursementsFinancingTotal ReceiptsBeginning Cash BalanceCash ReceiptsEnding Cash BalanceTotal Available Cash
select a cash budget item Manufacturing OverheadRepaymentCollection From CustomersIncome Tax ExpenseDirect LabourCollection Of Notes ReceivableSelling And Administrative ExpensesBorrowingPurchase Of LandSale Of Marketable SecuritiesDirect Materials
select a cash budget item BorrowingDirect MaterialsManufacturing OverheadIncome Tax ExpenseRepaymentCollection Of Notes ReceivablePurchase Of LandCollection From CustomersSelling And Administrative ExpensesDirect LabourSale Of Marketable Securities
select a closing name for section one DisbursementsEnding Cash BalanceCash ReceiptsTotal FinancingTotal Available CashExcess of Available Cash Over Cash DisbursementsTotal DisbursementsFinancingBeginning Cash BalanceTotal Receipts
select a summarizing line for the first part Total FinancingTotal Available CashBeginning Cash BalanceTotal ReceiptsTotal DisbursementsExcess of Available Cash Over Cash DisbursementsFinancingDisbursementsCash ReceiptsEnding Cash Balance
select between addition and deduction AddLess: select an opening name for section two Total FinancingDisbursementsEnding Cash BalanceTotal DisbursementsBeginning Cash BalanceExcess of Available Cash Over Cash DisbursementsFinancingTotal Available Cash
select a cash budget item RepaymentCollection Of Notes ReceivableDirect MaterialsPurchase Of LandSale Of Marketable SecuritiesSelling And Administrative ExpensesIncome Tax ExpenseManufacturing OverheadBorrowingDirect LabourCollection From Customers
select a cash budget item Manufacturing OverheadIncome Tax ExpenseCollection From CustomersRepaymentCollection Of Notes ReceivablePurchase Of LandDirect LabourSale Of Marketable SecuritiesDirect MaterialsSelling And Administrative ExpensesBorrowing
select a cash budget item Manufacturing OverheadCollection Of Notes ReceivableSale Of Marketable SecuritiesBorrowingSelling And Administrative ExpensesIncome Tax ExpenseDirect LabourPurchase Of LandCollection From CustomersDirect MaterialsRepayment
select a cash budget item Sale Of Marketable SecuritiesRepaymentBorrowingSelling And Administrative ExpensesCollection From CustomersCollection Of Notes ReceivableManufacturing OverheadDirect MaterialsPurchase Of LandDirect LabourIncome Tax Expense
select a closing name for section two FinancingTotal Available CashTotal DisbursementsBeginning Cash BalanceTotal FinancingDisbursementsExcess of Available Cash Over Cash DisbursementsEnding Cash Balance
select a summarizing line for the second part Total FinancingCash ReceiptsDisbursementsBeginning Cash BalanceTotal DisbursementsTotal ReceiptsExcess of Available Cash Over Cash DisbursementsTotal Available CashFinancingEnding Cash Balance
select an opening name for section three
select a cash budget item
select a cash budget item
select a closing name for section three
select a closing cash budget item

Answer & Explanation Solved by verified expert

See Answer