Danner Company expects to have a cash balance of 53774 on Ja

Danner Company expects to have a cash balance of $53,774 on January 1, 2014. Relevant monthly budget data for the first 2 months of 2014 are as follows. Collections from customers: January $99,365, February $175,350. Payments for direct materials: January $58,450, February $81,830. Direct labor: January $35,070, February $52,605. Wages are paid in the month they are incurred. Manufacturing overhead: January $24,549, February $29,225. These costs include depreciation of $1,169 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $17,535, February $23,380. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $11,690 in cash. Danner Company has a line of credit at a local bank that enables it to borrow up to $29,225. The company wants to maintain a minimum monthly cash balance of $23,380. Prepare a cash budget for January and February

DANNER COMPANY
Cash Budget
For the Two Months Ending February 28, 2014

January

February

DANNER COMPANY Cash Budget For the Two Months Ending February 28, 2014
			January		February
$\"\"$ Beginning Cash BalanceBorrowingsCollections from CustomersDirect LaborDirect MaterialsDisbursementsEnding Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingManufacturing OverheadReceiptsRepaymentsSale of Marketable SecuritiesSelling and Administrative ExpensesTotal Available CashTotal DisbursementsTotal Receipts		$ $\"\"$		$ $\"\"$
$\"\"$ AddLess :	$\"\"$ Beginning Cash BalanceBorrowingsCollections from CustomersDirect LaborDirect MaterialsDisbursementsEnding Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingManufacturing OverheadReceiptsRepaymentsSale of Marketable SecuritiesSelling and Administrative ExpensesTotal Available CashTotal DisbursementsTotal Receipts
	$\"\"$ Beginning Cash BalanceBorrowingsCollections from CustomersDirect LaborDirect MaterialsDisbursementsEnding Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingManufacturing OverheadReceiptsRepaymentsSale of Marketable SecuritiesSelling and Administrative ExpensesTotal Available CashTotal DisbursementsTotal Receipts		$\"\"$		$\"\"$
	$\"\"$ Beginning Cash BalanceBorrowingsCollections from CustomersDirect LaborDirect MaterialsDisbursementsEnding Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingManufacturing OverheadReceiptsRepaymentsSale of Marketable SecuritiesSelling and Administrative ExpensesTotal Available CashTotal DisbursementsTotal Receipts		$\"\"$		$\"\"$
	$\"\"$ Beginning Cash BalanceBorrowingsCollections from CustomersDirect LaborDirect MaterialsDisbursementsEnding Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingManufacturing OverheadReceiptsRepaymentsSale of Marketable SecuritiesSelling and Administrative ExpensesTotal Available CashTotal DisbursementsTotal Receipts		$\"\"$		$\"\"$
$\"\"$ Beginning Cash BalanceBorrowingsCollections from CustomersDirect LaborDirect MaterialsDisbursementsEnding Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingManufacturing OverheadReceiptsRepaymentsSale of Marketable SecuritiesSelling and Administrative ExpensesTotal Available CashTotal DisbursementsTotal Receipts		$\"\"$		$\"\"$
$\"\"$ AddLess :	$\"\"$ Beginning Cash BalanceBorrowingsCollections from CustomersDirect LaborDirect MaterialsDisbursementsEnding Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingManufacturing OverheadReceiptsRepaymentsSale of Marketable SecuritiesSelling and Administrative ExpensesTotal Available CashTotal DisbursementsTotal Receipts
	$\"\"$ Beginning Cash BalanceBorrowingsCollections from CustomersDirect LaborDirect MaterialsDisbursementsEnding Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingManufacturing OverheadReceiptsRepaymentsSale of Marketable SecuritiesSelling and Administrative ExpensesTotal Available CashTotal DisbursementsTotal Receipts		$\"\"$		$\"\"$
	$\"\"$ Beginning Cash BalanceBorrowingsCollections from CustomersDirect LaborDirect MaterialsDisbursementsEnding Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingManufacturing OverheadReceiptsRepaymentsSale of Marketable SecuritiesSelling and Administrative ExpensesTotal Available CashTotal DisbursementsTotal Receipts		$\"\"$		$\"\"$
	$\"\"$ Beginning Cash BalanceBorrowingsCollections from CustomersDirect LaborDirect MaterialsDisbursementsEnding Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingManufacturing OverheadReceiptsRepaymentsSale of Marketable SecuritiesSelling and Administrative ExpensesTotal Available CashTotal DisbursementsTotal Receipts		$\"\"$		$\"\"$
	$\"\"$ Beginning Cash BalanceBorrowingsCollections from CustomersDirect LaborDirect MaterialsDisbursementsEnding Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingManufacturing OverheadReceiptsRepaymentsSale of Marketable SecuritiesSelling and Administrative ExpensesTotal Available CashTotal DisbursementsTotal Receipts		$\"\"$		$\"\"$
	$\"\"$ Beginning Cash BalanceBorrowingsCollections from CustomersDirect LaborDirect MaterialsDisbursementsEnding Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingManufacturing OverheadReceiptsRepaymentsSale of Marketable SecuritiesSelling and Administrative ExpensesTotal Available CashTotal DisbursementsTotal Receipts		$\"\"$		$\"\"$
$\"\"$ Beginning Cash BalanceBorrowingsCollections from CustomersDirect LaborDirect MaterialsDisbursementsEnding Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingManufacturing OverheadReceiptsRepaymentsSale of Marketable SecuritiesSelling and Administrative ExpensesTotal Available CashTotal DisbursementsTotal Receipts		$\"\"$		$\"\"$
$\"\"$ Beginning Cash BalanceBorrowingsCollections from CustomersDirect LaborDirect MaterialsDisbursementsEnding Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingManufacturing OverheadReceiptsRepaymentsSale of Marketable SecuritiesSelling and Administrative ExpensesTotal Available CashTotal DisbursementsTotal Receipts
$\"\"$ AddLess :	$\"\"$ Beginning Cash BalanceBorrowingsCollections from CustomersDirect LaborDirect MaterialsDisbursementsEnding Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingManufacturing OverheadReceiptsRepaymentsSale of Marketable SecuritiesSelling and Administrative ExpensesTotal Available CashTotal DisbursementsTotal Receipts		$\"\"$		$\"\"$
$\"\"$ AddLess :	$\"\"$ Beginning Cash BalanceBorrowingsCollections from CustomersDirect LaborDirect MaterialsDisbursementsEnding Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingManufacturing OverheadReceiptsRepaymentsSale of Marketable SecuritiesSelling and Administrative ExpensesTotal Available CashTotal DisbursementsTotal Receipts		$\"\"$		$\"\"$
$\"\"$ Beginning Cash BalanceBorrowingsCollections from CustomersDirect LaborDirect MaterialsDisbursementsEnding Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsFinancingManufacturing OverheadReceiptsRepaymentsSale of Marketable SecuritiesSelling and Administrative ExpensesTotal Available CashTotal DisbursementsTotal Receipts		$ $\"\"$		$ $\"\"$

Dear Student,

Best effort has been made to give quality and correct answer. But if you find any issues please comment your concern. I will definitely resolve your query.

Cash Budget
	January	February
Beginning Cash Balance	$ 53,774.00	$ 30,394.00
Collections from customers	$ 99,365.00	$ 175,350.00
Sales of marketable securities	$ 11,690.00
Total Available Cash	$ 164,829.00	$ 205,744.00
Disbursements:
Direct materials	$ 58,450.00	$ 81,830.00
Direct labor	$ 35,070.00	$ 52,605.00
Manufacturing overhead*	$ 23,380.00	$ 28,056.00
Selling and administrative expenses	$ 17,535.00	$ 23,380.00
Total Disbursements	$ 134,435.00	$ 185,871.00
Excess (Deficiency) of Available Cash Over Cash Disbursements	$ 30,394.00	$ 19,873.00
Financing:
Borrowing		$ 3,507.00
Repayment
Interest
Ending Cash Balance	$ 30,394.00	$ 23,380.00

Danner Company expects to have a cash balance of $53,774 on January 1, 2014. Relevant monthly budget data for the first 2 months of 2014 are as follows. Collect

Danner Company expects to have a cash balance of 53774 on Ja

Solution

Get Help Now

Submit a Take Down Notice