Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Danner Company expects to have a cash balance of $52,900on January 1, 2014. Relevant monthly budget data for the first 2 months of 2014 are

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

Collections from customers: January $97,750, February $172,500.
Payments for direct materials: January $57,500, February $80,500.
Direct labor: January $34,500, February $51,750. Wages are paid in the month they are incurred.
Manufacturing overhead: January $24,150, February $28,750. These costs include depreciation of $1,150per month. All other overhead costs are paid as incurred.
Selling and administrative expenses: January $17,250, February $23,000. These costs are exclusive of depreciation. They are paid as incurred.

Sales of marketable securities in January are expected to realize $11,500in cash. Danner Company has a line of credit at a local bank that enables it to borrow up to $28,750. The company wants to maintain a minimum monthly cash balance of $23,000.

Prepare a cash budget for January and 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 $

$

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

Accounting Terminology

Authors: Michael P Griffin

1st Edition

1423229371, 9781423229377

More Books

Students also viewed these Accounting questions

Question

What is the use of bootstrap program?

Answered: 1 week ago