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

Collections from customers: January $85,000, February $150,000.

Payments for direct materials: January $50,000, February $75,000.

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

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

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

Sales of marketable securities in January are expected to realize $12,000in cash. Danner Company has a line of credit at a local bank that enables it to borrow up to $25,000. The company wants to maintain a minimum monthly cash balance of $20,000. Prepare a cash budget for January and February.(Do not leave any answer field blank. Enter "0" for the amounts.)

DANNER COMPANY Cash Budget For the Two Months Ending February 28, 2017For the Quarter Ending February 28, 2017February 28, 2017
January	February
Excess (Deficiency) of Available Cash Over Cash DisbursementsFinancingSale of Marketable SecuritiesSelling and Administrative ExpensesTotal Available CashDirect LaborTotal DisbursementsCollections from CustomersDirect MaterialsEnding Cash BalanceDisbursementsTotal ReceiptsBeginning Cash BalanceBorrowingsManufacturing OverheadReceiptsRepayments	$	$
AddLess: RepaymentsTotal ReceiptsBeginning Cash BalanceEnding Cash BalanceBorrowingsSale of Marketable SecuritiesCollections from CustomersDirect LaborSelling and Administrative ExpensesTotal Available CashTotal DisbursementsExcess (Deficiency) of Available Cash Over Cash DisbursementsDirect MaterialsDisbursementsManufacturing OverheadFinancingReceipts
Total Available CashManufacturing OverheadRepaymentsCollections from CustomersTotal DisbursementsTotal ReceiptsBeginning Cash BalanceDisbursementsBorrowingsSelling and Administrative ExpensesDirect LaborDirect MaterialsEnding Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingReceiptsSale of Marketable Securities
Total DisbursementsEnding Cash BalanceDisbursementsReceiptsDirect MaterialsCollections from CustomersRepaymentsSale of Marketable SecuritiesFinancingExcess (Deficiency) of Available Cash Over Cash DisbursementsBorrowingsTotal ReceiptsDirect LaborSelling and Administrative ExpensesManufacturing OverheadTotal Available CashBeginning Cash Balance
Excess (Deficiency) of Available Cash Over Cash DisbursementsCollections from CustomersTotal Available CashDirect LaborReceiptsEnding Cash BalanceFinancingRepaymentsDirect MaterialsTotal DisbursementsManufacturing OverheadDisbursementsSale of Marketable SecuritiesSelling and Administrative ExpensesTotal ReceiptsBeginning Cash BalanceBorrowings
Sale of Marketable SecuritiesTotal ReceiptsManufacturing OverheadRepaymentsBeginning Cash BalanceDisbursementsEnding Cash BalanceDirect MaterialsReceiptsCollections from CustomersBorrowingsExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingSelling and Administrative ExpensesTotal Available CashTotal DisbursementsDirect Labor
AddLess: BorrowingsDirect LaborEnding Cash BalanceCollections from CustomersDirect MaterialsDisbursementsExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingManufacturing OverheadSelling and Administrative ExpensesTotal Available CashRepaymentsReceiptsTotal ReceiptsTotal DisbursementsSale of Marketable SecuritiesBeginning Cash Balance
Beginning Cash BalanceTotal Available CashDirect MaterialsDirect LaborDisbursementsBorrowingsCollections from CustomersEnding Cash BalanceRepaymentsSale of Marketable SecuritiesExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingManufacturing OverheadTotal DisbursementsSelling and Administrative ExpensesReceiptsTotal Receipts
Total ReceiptsSale of Marketable SecuritiesEnding Cash BalanceDirect LaborBorrowingsFinancingSelling and Administrative ExpensesReceiptsExcess (Deficiency) of Available Cash Over Cash DisbursementsDirect MaterialsDisbursementsRepaymentsTotal Available CashManufacturing OverheadTotal DisbursementsBeginning Cash BalanceCollections from Customers
Direct MaterialsReceiptsSelling and Administrative ExpensesTotal Available CashDisbursementsRepaymentsTotal DisbursementsTotal ReceiptsExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingBeginning Cash BalanceSale of Marketable SecuritiesBorrowingsEnding Cash BalanceManufacturing OverheadCollections from CustomersDirect Labor
Selling and Administrative ExpensesSale of Marketable SecuritiesDirect LaborExcess (Deficiency) of Available Cash Over Cash DisbursementsReceiptsTotal Available CashFinancingRepaymentsTotal DisbursementsCollections from CustomersBeginning Cash BalanceDirect MaterialsTotal ReceiptsBorrowingsEnding Cash BalanceDisbursementsManufacturing Overhead
DisbursementsTotal DisbursementsBorrowingsEnding Cash BalanceTotal ReceiptsDirect LaborExcess (Deficiency) of Available Cash Over Cash DisbursementsTotal Available CashSelling and Administrative ExpensesFinancingCollections from CustomersDirect MaterialsSale of Marketable SecuritiesBeginning Cash BalanceManufacturing OverheadReceiptsRepayments
Beginning Cash BalanceEnding Cash BalanceDirect MaterialsFinancingDirect LaborRepaymentsBorrowingsCollections from CustomersTotal DisbursementsManufacturing OverheadDisbursementsExcess (Deficiency) of Available Cash Over Cash DisbursementsReceiptsSale of Marketable SecuritiesTotal ReceiptsSelling and Administrative ExpensesTotal Available Cash
FinancingEnding Cash BalanceManufacturing OverheadReceiptsBorrowingsDisbursementsRepaymentsExcess (Deficiency) of Available Cash Over Cash DisbursementsSale of Marketable SecuritiesSelling and Administrative ExpensesDirect MaterialsTotal Available CashTotal DisbursementsTotal ReceiptsBeginning Cash BalanceCollections from CustomersDirect Labor
LessAdd: Excess (Deficiency) of Available Cash Over Cash DisbursementsEnding Cash BalanceTotal ReceiptsDirect LaborReceiptsFinancingManufacturing OverheadDisbursementsRepaymentsSelling and Administrative ExpensesSale of Marketable SecuritiesTotal Available CashTotal DisbursementsBeginning Cash BalanceBorrowingsCollections from CustomersDirect Materials
LessAdd: Excess (Deficiency) of Available Cash Over Cash DisbursementsRepaymentsDirect LaborReceiptsManufacturing OverheadCollections from CustomersFinancingSale of Marketable SecuritiesDirect MaterialsSelling and Administrative ExpensesDisbursementsTotal Available CashEnding Cash BalanceTotal DisbursementsTotal ReceiptsBeginning Cash BalanceBorrowings
Total ReceiptsCollections from CustomersTotal Available CashTotal DisbursementsFinancingBeginning Cash BalanceEnding Cash BalanceBorrowingsSale of Marketable SecuritiesManufacturing OverheadDirect LaborReceiptsRepaymentsDirect MaterialsDisbursementsSelling and Administrative ExpensesExcess (Deficiency) of Available Cash Over Cash Disbursements	$	$