Question

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 per month. All other overhead costs are paid as incurred.
Selling and administrative expenses: January $ 15,150, February $ 20,200. These costs are exclusive of depreciation. They are paid as incurred.


Sales of marketable securities in January are expected to realize $ 12,120 in cash. Danner Company has a line of credit at a local bank that enables it to borrow up to $ 25,250. The company wants to maintain a minimum monthly cash balance of $ 20,200.

Prepare a cash budget for January and February.

DANNER COMPANY
Cash Budget

choose the accounting periodchoose the accounting period  For the Two Months Ending February 28, 2020February 28, 2020For the Quarter Ending February 28, 2020

January

February

select an opening cash budget itemselect an opening cash budget item  Sale of Marketable SecuritiesDirect LaborManufacturing OverheadTotal ReceiptsFinancingRepaymentsCollections from CustomersSelling and Administrative ExpensesBorrowingsBeginning Cash BalanceTotal DisbursementsDisbursementsExcess (Deficiency) of Available Cash Over Cash DisbursementsEnding Cash BalanceReceiptsDirect MaterialsTotal Available Cash

$ enter a dollar amount

$ enter a dollar amount

select between addition and deductionselect between addition and deduction  AddLess:  select an opening name for section oneselect an opening name for section one  Collections from CustomersRepaymentsBeginning Cash BalanceBorrowingsEnding Cash BalanceSale of Marketable SecuritiesDirect LaborTotal DisbursementsManufacturing OverheadTotal Available CashFinancingExcess (Deficiency) of Available Cash Over Cash DisbursementsDisbursementsReceiptsTotal ReceiptsSelling and Administrative ExpensesDirect Materials

select a cash budget itemselect a cash budget item  FinancingEnding Cash BalanceDirect MaterialsTotal ReceiptsReceiptsDirect LaborTotal Available CashExcess (Deficiency) of Available Cash Over Cash DisbursementsBeginning Cash BalanceBorrowingsSale of Marketable SecuritiesTotal DisbursementsCollections from CustomersSelling and Administrative ExpensesRepaymentsDisbursementsManufacturing Overhead

enter a dollar amount

enter a dollar amount

select a cash budget itemselect a cash budget item  FinancingCollections from CustomersTotal Available CashBorrowingsTotal ReceiptsManufacturing OverheadSale of Marketable SecuritiesBeginning Cash BalanceReceiptsTotal DisbursementsEnding Cash BalanceRepaymentsDirect LaborDirect MaterialsExcess (Deficiency) of Available Cash Over Cash DisbursementsSelling and Administrative ExpensesDisbursements

enter a dollar amount enter a dollar amount

select a closing name for section oneselect a closing name for section one  FinancingBorrowingsTotal DisbursementsDirect MaterialsCollections from CustomersDisbursementsEnding Cash BalanceBeginning Cash BalanceTotal ReceiptsSelling and Administrative ExpensesReceiptsSale of Marketable SecuritiesManufacturing OverheadTotal Available CashRepaymentsExcess (Deficiency) of Available Cash Over Cash DisbursementsDirect Labor

enter a total amount for section one enter a total amount for section one

select a summarizing line for the first partselect a summarizing line for the first part  ReceiptsSale of Marketable SecuritiesSelling and Administrative ExpensesTotal Available CashFinancingTotal ReceiptsTotal DisbursementsCollections from CustomersExcess (Deficiency) of Available Cash Over Cash DisbursementsBorrowingsDirect LaborManufacturing OverheadRepaymentsBeginning Cash BalanceDisbursementsDirect MaterialsEnding Cash Balance

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

select between addition and deductionselect between addition and deduction  AddLess:  select an opening name for section twoselect an opening name for section two  RepaymentsTotal ReceiptsExcess (Deficiency) of Available Cash Over Cash DisbursementsCollections from CustomersSale of Marketable SecuritiesEnding Cash BalanceFinancingDirect MaterialsManufacturing OverheadBeginning Cash BalanceBorrowingsReceiptsSelling and Administrative ExpensesTotal Available CashDisbursementsDirect LaborTotal Disbursements

select a cash budget itemselect a cash budget item  Excess (Deficiency) of Available Cash Over Cash DisbursementsTotal Available CashDirect MaterialsBorrowingsSelling and Administrative ExpensesReceiptsCollections from CustomersRepaymentsSale of Marketable SecuritiesDisbursementsFinancingEnding Cash BalanceTotal ReceiptsDirect LaborManufacturing OverheadBeginning Cash BalanceTotal Disbursements

enter a dollar amount

enter a dollar amount

select a cash budget itemselect a cash budget item  ReceiptsDirect LaborCollections from CustomersBeginning Cash BalanceManufacturing OverheadDirect MaterialsExcess (Deficiency) of Available Cash Over Cash DisbursementsTotal DisbursementsTotal ReceiptsRepaymentsFinancingSelling and Administrative ExpensesEnding Cash BalanceDisbursementsBorrowingsTotal Available CashSale of Marketable Securities

enter a dollar amount

enter a dollar amount

select a cash budget itemselect a cash budget item  Sale of Marketable SecuritiesDisbursementsTotal Available CashTotal DisbursementsRepaymentsCollections from CustomersBeginning Cash BalanceBorrowingsManufacturing OverheadTotal ReceiptsExcess (Deficiency) of Available Cash Over Cash DisbursementsEnding Cash BalanceFinancingDirect LaborDirect MaterialsSelling and Administrative ExpensesReceipts

enter a dollar amount

enter a dollar amount

select a cash budget itemselect a cash budget item  Total ReceiptsSelling and Administrative ExpensesDisbursementsReceiptsFinancingDirect MaterialsDirect LaborEnding Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsManufacturing OverheadTotal DisbursementsSale of Marketable SecuritiesTotal Available CashCollections from CustomersBeginning Cash BalanceBorrowingsRepayments

enter a dollar amount enter a dollar amount

select a closing name for section twoselect a closing name for section two  Total ReceiptsEnding Cash BalanceTotal Available CashBeginning Cash BalanceDirect MaterialsDirect LaborBorrowingsCollections from CustomersFinancingDisbursementsRepaymentsManufacturing OverheadTotal DisbursementsReceiptsSelling and Administrative ExpensesSale of Marketable SecuritiesExcess (Deficiency) of Available Cash Over Cash Disbursements

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

select a summarizing line for the second partselect a summarizing line for the second part  Selling and Administrative ExpensesManufacturing OverheadReceiptsTotal Available CashRepaymentsEnding Cash BalanceDisbursementsDirect LaborTotal ReceiptsBeginning Cash BalanceTotal DisbursementsExcess (Deficiency) of Available Cash Over Cash DisbursementsSale of Marketable SecuritiesBorrowingsFinancingDirect MaterialsCollections from Customers

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

select an opening name for section threeselect an opening name for section three  Excess (Deficiency) of Available Cash Over Cash DisbursementsBeginning Cash BalanceDirect MaterialsRepaymentsDisbursementsSale of Marketable SecuritiesEnding Cash BalanceTotal ReceiptsCollections from CustomersSelling and Administrative ExpensesFinancingDirect LaborTotal Available CashManufacturing OverheadReceiptsTotal DisbursementsBorrowings

select between addition and deductionselect between addition and deduction  LessAdd:  select a cash budget itemselect a cash budget item  RepaymentsReceiptsTotal Available CashTotal DisbursementsFinancingEnding Cash BalanceSale of Marketable SecuritiesCollections from CustomersDisbursementsDirect MaterialsTotal ReceiptsBeginning Cash BalanceExcess (Deficiency) of Available Cash Over Cash DisbursementsManufacturing OverheadSelling and Administrative ExpensesBorrowingsDirect Labor

enter a dollar amount

enter a dollar amount

select between addition and deductionselect between addition and deduction  AddLess:  select a cash budget itemselect a cash budget item  Manufacturing OverheadCollections from CustomersReceiptsTotal ReceiptsBorrowingsBeginning Cash BalanceDisbursementsExcess (Deficiency) of Available Cash Over Cash DisbursementsEnding Cash BalanceDirect LaborFinancingSale of Marketable SecuritiesSelling and Administrative ExpensesRepaymentsDirect MaterialsTotal DisbursementsTotal Available Cash

enter a dollar amount enter a dollar amount

select a closing cash budget itemselect a closing cash budget item  Total DisbursementsReceiptsFinancingExcess (Deficiency) of Available Cash Over Cash DisbursementsDirect MaterialsTotal Available CashTotal ReceiptsBeginning Cash BalanceSale of Marketable SecuritiesBorrowingsSelling and Administrative ExpensesDirect LaborEnding Cash BalanceRepaymentsManufacturing OverheadDisbursementsCollections from Customers

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

Homework Answers

Answer #1

Solution:

Danner Company
Cash Budget
For January and February
Particulars January February
Beginning cash balance $45,450.00 $27,775.00
Cash Receipts:
Collection from customers $85,850.00 $151,500.00
Sales of marketable securities $12,120.00 $0.00
Total cash available $143,420.00 $179,275.00
Cash disbursements:
Payment for direct material $50,500.00 $75,750.00
Direct labor $30,300.00 $45,450.00
Manufacturing overhead $19,695.00 $23,735.00
Selling and administrative expenses $15,150.00 $20,200.00
Total Cash disbursements $115,645.00 $165,135.00
Excess of cash available over disbursments $27,775.00 $14,140.00
Borrowings (Repayments) $0.00 $6,060.00
Ending cash balance $27,775.00 $20,200.00
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 $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....
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;...
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...
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....
You are provided with the following information taken from Skysong, Inc.’s March 31, 2017, balance sheet....
You are provided with the following information taken from Skysong, Inc.’s March 31, 2017, balance sheet. Cash $ 11,520 Accounts receivable 22,360 Inventory 36,190 Property, plant, and equipment, net of depreciation 120,200 Accounts payable 22,980 Common stock 151,200 Retained earnings 11,790 Additional information concerning Skysong, Inc. is as follows. 1. Gross profit is 25% of sales. 2. Actual and budgeted sales data: March (actual) $ 47,600 April (budgeted) 71,100 3. Sales are both cash and credit. Cash collections expected in...
You are provided with the following information taken from Teal Mountain Inc.’s March 31, 2022, balance...
You are provided with the following information taken from Teal Mountain Inc.’s March 31, 2022, balance sheet. Cash $12,060 Accounts receivable 20,670 Inventory 36,800 Property, plant, and equipment, net of depreciation 122,800 Accounts payable 23,330 Common stock 152,400 Retained earnings 12,520 Additional information concerning Teal Mountain Inc. is as follows. 1. Gross profit is 27% of sales. 2. Actual and budgeted sales data: March (actual) $46,500 April (budgeted) 73,300 3. Sales are both cash and credit. Cash collections expected in...
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...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT