Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 For the Two Months Ending February 28, 2020February 28, 2020For the Quarter Ending February 28, 2020

January

February

$

$

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

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

$ $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

GAO Yellow Book Government Auditing Standar

Authors: Comptroller General United States Government

2011edition

1479245577, 978-1479245574

More Books

Students also viewed these Accounting questions

Question

Explain how to account for an interest in a joint operation.

Answered: 1 week ago

Question

please provide solution in java

Answered: 1 week ago