Question

Danner Company expects to have a cash balance of $55,800 on January 1, 2020. Relevant monthly...

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

Collections from customers: January $105,400, February $186,000.
Payments for direct materials: January $62,000, February $93,000.
Direct labor: January $37,200, February $55,800. Wages are paid in the month they are incurred.
Manufacturing overhead: January $26,040, February $31,000. These costs include depreciation of $1,860 per month. All other overhead costs are paid as incurred.
Selling and administrative expenses: January $18,600, February $24,800. These costs are exclusive of depreciation. They are paid as incurred.


Sales of marketable securities in January are expected to realize $14,880 in cash. Danner Company has a line of credit at a local bank that enables it to borrow up to $31,000. The company wants to maintain a minimum monthly cash balance of $24,800.

Prepare a cash budget for January and February.

DANNER COMPANY
Cash Budget

January

February

$enter a dollar

enter a dollar amount

enter a dollar amount

enter a dollar amount enter a dollar amount
enter a total
enter a total amount for the first part enter a total amount for the first part

enter a dollar amount

enter a dollar amount

select a cash budget itemRepaymentsDirect MaterialsTotal DisbursementsManufacturing OverheadSale of Marketable SecuritiesDirect LaborReceiptsTotal ReceiptsBorrowingsTotal Available CashFinancingBeginning Cash BalanceSelling and Administrative ExpensesExcess (Deficiency) of Available Cash Over Cash DisbursementsCollections from CustomersDisbursementsEnding Cash Balance 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

enter a dollar amount

enter a dollar amount

enter a dollar

enter a dollar amount enter a dollar amount

select a closing name for section twoBeginning Cash BalanceTotal ReceiptsCollections from CustomersDirect MaterialsTotal Available CashEnding Cash BalanceManufacturing OverheadDirect LaborDisbursementsTotal DisbursementsBorrowingsReceiptsSelling and Administrative ExpensesFinancingSale of Marketable SecuritiesRepaymentsExcess (Deficiency) of Available Cash Over Cash Disbursements 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

enter a total amount for section two enter a total amount for section two

select a summarizing line for the second partTotal ReceiptsSale of Marketable SecuritiesSelling and Administrative ExpensesDirect LaborDisbursementsExcess (Deficiency) of Available Cash Over Cash DisbursementsCollections from CustomersTotal

enter a total amount for the second part enter a total amount for the second part

select an opening name for section threeDirect LaborReceiptsExcess (Deficiency) of Available Cash Over Cash DisbursementsSelling and Administrative ExpensesCollections from CustomersEnding Cash BalanceFinancingTotal ReceiptsTotal DisbursementsRepaymentsTotal Available CashDirect MaterialsBeginning Cash BalanceManufacturing OverheadBorrowingsDisbursementsSale of Marketable Securities 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

select between addition and deductionAddLess AddLess: select a cash budget item Beginning Cash BalanceBorrowingsTotal Available CashEnding Cash BalanceManufacturing OverheadTotal ReceiptsRepaymentsSale of Marketable SecuritiesCollections from CustomersTotal DisbursementsExcess (Deficiency) of Available Cash Over Cash DisbursementsSelling and Administrative ExpensesDisbursementsReceiptsFinancingDirect LaborDirect Materials 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

enter a dollar amount

enter a dollar amount

select between addition and deductionAddLess AddLess: select a cash budget item BorrowingsRepaymentsTotal ReceiptsCollections from CustomersExcess (Deficiency) of Available Cash Over Cash DisbursementsEnding Cash BalanceDisbursementsBeginning Cash BalanceTotal DisbursementsSelling and Administrative ExpensesDirect LaborDirect MaterialsReceiptsTotal Available CashSale of Marketable SecuritiesManufacturing OverheadFinancing 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

enter a dollar amount enter a dollar amount

select a closing cash budget itemSelling and Administrative ExpensesFinancingTotal Available CashEnding Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsTotal DisbursementsTotal ReceiptsReceiptsDirect LaborDirect MaterialsDisbursementsBorrowingsManufacturing OverheadRepaymentsSale of Marketable SecuritiesBeginning Cash BalanceCollections from Customers 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

$enter a total amount for the cash budget $enter a total amount for the cash budget

Homework Answers

Answer #1

Cash budget

January February
Beginning Cash Balance 55,800 34,100
Receipts
Collections from Customers 105,400 186,000
Sale of Marketable Securities 14,880 0
Total Receipts 120,280 186,000
Total Available Cash 176,080 220,100
Disbursements
Direct Materials 62,000 93,000
Direct Labor 37,200 55,800
Manufacturing Overhead 24,180 29,140
Selling and Administrative Expenses 18,600 24,800
Total Disbursements 141,980 202,740
Excess of Available Cash Over Cash Disbursements 34,100 17,360
Financing
Borrowings 0 13,640
Ending Cash Balance 34,100 31,000
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Danner Company expects to have a cash balance of $ 45,450 on January 1, 2020. Relevant...
Danner Company expects to have a cash balance of $ 45,450 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $ 85,850, February $ 151,500. Payments for direct materials: January $ 50,500, February $ 75,750. Direct labor: January $ 30,300, February $ 45,450. Wages are paid in the month they are incurred. Manufacturing overhead: January $ 21,210, February $ 25,250. These costs include depreciation of $ 1,515...
Danner Company expects to have a cash balance of $45,000 on January 1, 2020. Relevant monthly...
Danner Company expects to have a cash balance of $45,000 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Prepare a cash budget for 2 months. 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,500 per month. All other...
Danner Company expects to have a cash balance of $46,800 on January 1, 2020. Relevant monthly...
Danner Company expects to have a cash balance of $46,800 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $88,400, February $156,000. Payments for direct materials: January $52,000, February $78,000. Direct labor: January $31,200, February $46,800. Wages are paid in the month they are incurred. Manufacturing overhead: January $21,840, February $26,000. These costs include depreciation of $1,560 per month. All other overhead costs are paid as incurred....
Nadia Company expects to have a cash balance of $44,800 on January 1, 2020. Nadia has...
Nadia Company expects to have a cash balance of $44,800 on January 1, 2020. Nadia has budgeted the following for the first two months of the year 2020: 1. Collections from customers: January $90,700; February $109,500. 2. Payments to suppliers: January $39,900; February $49,700. 3. Direct labour: January $30,300; February $35,100. Wages are paid in the month they are incurred. 4. Manufacturing overhead: January $25,200; February $30,200. Overhead costs are paid as incurred. 5. Selling and administrative expenses: January $16,100;...
Danner Company expects to have a cash balance of $59,040 on January 1, 2017. Relevant monthly...
Danner Company expects to have a cash balance of $59,040 on January 1, 2017. Relevant monthly budget data for the first 2 months of 2017 are as follows. Collections from customers: January $111,520, February $196,800. Payments for direct materials: January $65,600, February $98,400. Direct labor: January $39,360, February $59,040. Wages are paid in the month they are incurred. Manufacturing overhead: January $27,552, February $32,800. These costs include depreciation of $1,968 per month. All other overhead costs are paid as incurred....
Nadia Company expects to have a cash balance of $44,800 on January 1, 2020. Nadia has...
Nadia Company expects to have a cash balance of $44,800 on January 1, 2020. Nadia has budgeted the following for the first two months of the year 2020: 1. Collections from customers: January $90,900; February $109,300. 2. Payments to suppliers: January $39,900; February $49,500. 3. Direct labour: January $29,700; February $35,300. Wages are paid in the month they are incurred. 4. Manufacturing overhead: January $25,000; February $30,200. Overhead costs are paid as incurred. 5. Selling and administrative expenses: January $15,900;...
Deitz Corporation is projecting a cash balance of $33,900 in its December 31, 2019, balance sheet....
Deitz Corporation is projecting a cash balance of $33,900 in its December 31, 2019, balance sheet. Deitz’s schedule of expected collections from customers for the first quarter of 2020 shows total collections of $209,050. The schedule of expected payments for direct materials for the first quarter of 2020 shows total payments of $48,590. Other information gathered for the first quarter of 2020 is sale of equipment $3,390; direct labor $79,100, manufacturing overhead $39,550, selling and administrative expenses $50,850; and purchase...
Gundy Company expects to produce 1,275,600 units of Product XX in 2020. Monthly production is expected...
Gundy Company expects to produce 1,275,600 units of Product XX in 2020. Monthly production is expected to range from 84,000 to 122,000 units. Budgeted variable manufacturing costs per unit are: direct materials $5, direct labor $8, and overhead $10. Budgeted fixed manufacturing costs per unit for depreciation are $5 and for supervision are $1. In March 2020, the company incurs the following costs in producing 103,000 units: direct materials $544,000, direct labor $815,000, and variable overhead $1,038,000. Actual fixed costs...
Gundy Company expects to produce 1,220,400 units of Product XX in 2020. Monthly production is expected...
Gundy Company expects to produce 1,220,400 units of Product XX in 2020. Monthly production is expected to range from 73,000 to 115,000 units. Budgeted variable manufacturing costs per unit are: direct materials $4, direct labor $7, and overhead $9. Budgeted fixed manufacturing costs per unit for depreciation are $5 and for supervision are $3. In March 2020, the company incurs the following costs in producing 94,000 units: direct materials $400,000, direct labor $652,000, and variable overhead $850,000. Actual fixed costs...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows....
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows. January February Sales $360,000 $400,000 Direct materials purchases 120,000 125,000 Direct labor 90,000 100,000 Manufacturing overhead 70,000 75,000 Selling and administrative expenses 79,000 85,000 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases...