Danner Company expects to have a cash balance of $54,000 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows.

Collections from customers: January $102,000, February $180,000.

Payments for direct materials: January $60,000, February $90,000.

Direct labor: January $36,000, February $54,000. Wages are paid in the month they are incurred.

Manufacturing overhead: January $25,200, February $30,000. These costs include depreciation of $1,800 per month. All other overhead costs are paid as incurred.

Selling and administrative expenses: January $18,000, February $24,000. These costs are exclusive of depreciation. They are paid as incurred.

Sales of marketable securities in January are expected to realize $14,400 in cash. Danner Company has a line of credit at a local bank that enables it to borrow up to $30,000. The company wants to maintain a minimum monthly cash balance of $24,000. Prepare a cash budget for January and February.

DANNER COMPANY Cash Budget choose the accounting period For the Quarter Ending February 28, 2020February 28, 2020For the Two Months Ending February 28, 2020
		January		February
select an opening cash budget item Total ReceiptsBorrowingsManufacturing OverheadFinancingExcess (Deficiency) of Available Cash Over Cash DisbursementsTotal Available CashReceiptsCollections from CustomersDirect MaterialsRepaymentsSelling and Administrative ExpensesEnding Cash BalanceDirect LaborBeginning Cash BalanceDisbursementsTotal DisbursementsSale of Marketable Securities		$enter a dollar amount		$enter a dollar amount
select between addition and deduction AddLess: select an opening name for section one Total DisbursementsTotal Available CashDisbursementsBeginning Cash BalanceRepaymentsBorrowingsEnding Cash BalanceDirect LaborExcess (Deficiency) of Available Cash Over Cash DisbursementsCollections from CustomersTotal ReceiptsSale of Marketable SecuritiesDirect MaterialsReceiptsSelling and Administrative ExpensesManufacturing OverheadFinancing
select a cash budget item Total ReceiptsSelling and Administrative ExpensesBeginning Cash BalanceTotal Available CashFinancingExcess (Deficiency) of Available Cash Over Cash DisbursementsSale of Marketable SecuritiesDirect MaterialsTotal DisbursementsManufacturing OverheadBorrowingsDirect LaborCollections from CustomersEnding Cash BalanceRepaymentsReceiptsDisbursements		enter a dollar amount		enter a dollar amount
select a cash budget item BorrowingsTotal DisbursementsManufacturing OverheadTotal Available CashDirect LaborExcess (Deficiency) of Available Cash Over Cash DisbursementsCollections from CustomersRepaymentsEnding Cash BalanceFinancingDirect MaterialsSale of Marketable SecuritiesSelling and Administrative ExpensesBeginning Cash BalanceReceiptsTotal ReceiptsDisbursements		enter a dollar amount		enter a dollar amount
select a closing name for section one Direct MaterialsDirect LaborTotal DisbursementsBeginning Cash BalanceDisbursementsTotal ReceiptsSelling and Administrative ExpensesBorrowingsExcess (Deficiency) of Available Cash Over Cash DisbursementsReceiptsTotal Available CashSale of Marketable SecuritiesRepaymentsManufacturing OverheadCollections from CustomersFinancingEnding Cash Balance		enter a total amount for section one		enter a total amount for section one
select a summarizing line for the first part Total DisbursementsBeginning Cash BalanceTotal ReceiptsDisbursementsCollections from CustomersSelling and Administrative ExpensesDirect LaborFinancingDirect MaterialsEnding Cash BalanceRepaymentsSale of Marketable SecuritiesManufacturing OverheadExcess (Deficiency) of Available Cash Over Cash DisbursementsReceiptsBorrowingsTotal Available Cash		enter a total amount for the first part		enter a total amount for the first part
select between addition and deduction AddLess: select an opening name for section two Direct LaborTotal DisbursementsFinancingSale of Marketable SecuritiesBeginning Cash BalanceEnding Cash BalanceRepaymentsTotal ReceiptsBorrowingsCollections from CustomersDirect MaterialsManufacturing OverheadTotal Available CashDisbursementsSelling and Administrative ExpensesExcess (Deficiency) of Available Cash Over Cash DisbursementsReceipts