Question

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 of securities $15,820. Deitz wants to maintain a balance of at least $28,250 cash at the end of each quarter.

Prepare a cash budget for the first quarter.

DEITZ CORPORATION
Cash Budget

                                                          March 31, 2020For the Quarter Ended March 31, 2020For the Month Ended March 31, 2020

                                                          Selling and Administrative ExpensesPurchase of SecuritiesBeginning Cash BalanceDirect LaborSale of EquipmentRepaymentsBorrowingsTotal ReceiptsCollections from CustomersDirect MaterialsReceiptsTotal DisbursementsManufacturing OverheadExcess of Available Cash Over Cash DisbursementsFinancingDisbursementsTotal Available CashEnding Cash Balance

$

                                                          AddLess:                                                           Excess of Available Cash Over Cash DisbursementsManufacturing OverheadTotal Available CashFinancingDisbursementsPurchase of SecuritiesTotal ReceiptsRepaymentsBeginning Cash BalanceSale of EquipmentBorrowingsReceiptsDirect MaterialsDirect LaborCollections from CustomersEnding Cash BalanceSelling and Administrative ExpensesTotal Disbursements

                                                          Excess of Available Cash Over Cash DisbursementsTotal Available CashPurchase of SecuritiesDirect LaborReceiptsEnding Cash BalanceBorrowingsDirect MaterialsBeginning Cash BalanceDisbursementsTotal DisbursementsFinancingSelling and Administrative ExpensesSale of EquipmentCollections from CustomersTotal ReceiptsManufacturing OverheadRepayments

                                                          Total DisbursementsEnding Cash BalanceSale of EquipmentPurchase of SecuritiesSelling and Administrative ExpensesDirect MaterialsCollections from CustomersFinancingExcess of Available Cash Over Cash DisbursementsTotal Available CashRepaymentsDisbursementsBeginning Cash BalanceTotal ReceiptsBorrowingsReceiptsDirect LaborManufacturing Overhead

                                                          Purchase of SecuritiesBorrowingsDirect LaborBeginning Cash BalanceTotal Available CashSale of EquipmentTotal ReceiptsDisbursementsCollections from CustomersDirect MaterialsFinancingEnding Cash BalanceTotal DisbursementsSelling and Administrative ExpensesRepaymentsExcess of Available Cash Over Cash DisbursementsManufacturing OverheadReceipts

                                                          BorrowingsSelling and Administrative ExpensesSale of EquipmentRepaymentsEnding Cash BalanceFinancingExcess of Available Cash Over Cash DisbursementsTotal DisbursementsTotal Available CashBeginning Cash BalancePurchase of SecuritiesDirect MaterialsReceiptsDisbursementsCollections from CustomersDirect LaborManufacturing OverheadTotal Receipts

                                                          AddLess:                                                           Direct MaterialsTotal ReceiptsTotal Available CashReceiptsDirect LaborFinancingBeginning Cash BalanceSale of EquipmentExcess of Available Cash Over Cash DisbursementsRepaymentsBorrowingsTotal DisbursementsSelling and Administrative ExpensesCollections from CustomersPurchase of SecuritiesDisbursementsManufacturing OverheadEnding Cash Balance

                                                          Ending Cash BalanceFinancingManufacturing OverheadRepaymentsCollections from CustomersDisbursementsPurchase of SecuritiesExcess of Available Cash Over Cash DisbursementsReceiptsBorrowingsSale of EquipmentTotal DisbursementsDirect LaborBeginning Cash BalanceDirect MaterialsTotal Available CashSelling and Administrative ExpensesTotal Receipts

                                                          Ending Cash BalanceSelling and Administrative ExpensesReceiptsTotal DisbursementsManufacturing OverheadPurchase of SecuritiesDirect MaterialsDisbursementsCollections from CustomersTotal Available CashRepaymentsBeginning Cash BalanceBorrowingsExcess of Available Cash Over Cash DisbursementsFinancingDirect LaborTotal ReceiptsSale of Equipment

                                                          RepaymentsCollections from CustomersBeginning Cash BalanceReceiptsTotal DisbursementsSale of EquipmentBorrowingsManufacturing OverheadPurchase of SecuritiesDirect MaterialsTotal ReceiptsTotal Available CashExcess of Available Cash Over Cash DisbursementsSelling and Administrative ExpensesDirect LaborDisbursementsFinancingEnding Cash Balance

                                                          Ending Cash BalanceRepaymentsPurchase of SecuritiesReceiptsManufacturing OverheadTotal DisbursementsExcess of Available Cash Over Cash DisbursementsDisbursementsTotal ReceiptsSelling and Administrative ExpensesSale of EquipmentBorrowingsCollections from CustomersDirect MaterialsDirect LaborTotal Available CashFinancingBeginning Cash Balance

                                                          Manufacturing OverheadDirect MaterialsSale of EquipmentBorrowingsPurchase of SecuritiesCollections from CustomersReceiptsDisbursementsDirect LaborFinancingTotal Available CashRepaymentsExcess of Available Cash Over Cash DisbursementsEnding Cash BalanceTotal DisbursementsSelling and Administrative ExpensesTotal ReceiptsBeginning Cash Balance

                                                          Total DisbursementsRepaymentsDisbursementsExcess of Available Cash Over Cash DisbursementsDirect LaborReceiptsBorrowingsTotal Available CashSale of EquipmentBeginning Cash BalanceManufacturing OverheadEnding Cash BalancePurchase of SecuritiesFinancingCollections from CustomersSelling and Administrative ExpensesDirect MaterialsTotal Receipts

                                                          Excess of Available Cash Over Cash DisbursementsBorrowingsSelling and Administrative ExpensesPurchase of SecuritiesManufacturing OverheadCollections from CustomersReceiptsTotal Available CashTotal ReceiptsDisbursementsSale of EquipmentRepaymentsTotal DisbursementsDirect LaborEnding Cash BalanceBeginning Cash BalanceDirect MaterialsFinancing

                                                          Direct MaterialsDirect LaborSale of EquipmentCollections from CustomersDisbursementsBorrowingsReceiptsEnding Cash BalanceTotal DisbursementsFinancingExcess of Available Cash Over Cash DisbursementsSelling and Administrative ExpensesRepaymentsBeginning Cash BalanceTotal Available CashTotal ReceiptsManufacturing OverheadPurchase of Securities

                                                          LessAdd:

Homework Answers

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
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 $ 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 $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,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;...
Easton Company is projecting a cash balance of $41,000 in its December 31, 2012, balance sheet....
Easton Company is projecting a cash balance of $41,000 in its December 31, 2012, balance sheet. Easton’s schedule of expected collections from customers for the first quarter of 2013 shows total collections of $150,000. The schedule of expected payments for direct materials for the first quarter of 2013 shows total payments of $30,000. Other information gathered for the first quarter of 2013 is: sale of equipment $4,000; direct labor $60,000, manufacturing overhead $35,000, selling and administrative expenses $45,000; and purchase...
Krause Industries’ balance sheet at December 31, 2019, is presented below. KRAUSE INDUSTRIES Balance Sheet December...
Krause Industries’ balance sheet at December 31, 2019, is presented below. KRAUSE INDUSTRIES Balance Sheet December 31, 2019 Assets Current Assets     Cash $7,500     Accounts receivable 73,500     Finished goods inventory (1,500 units) 26,840       Total current assets 107,840 Property, Plant, and Equipment     Equipment $40,780     Less: Accumulated depreciation 10,490 30,290             Total assets $138,130 Liabilities and Stockholders' Equity Liabilities     Notes payable $25,730     Accounts payable 47,150       Total liabilities 72,880 Stockholders' Equity     Common stock $39,110     Retained earnings 26,140       Total stockholders' equity 65,250             Total liabilities and stockholders'...
Gulf Shipping Company Balance Sheet As of December 31, 2019 (amounts in thousands) Cash 38,000 Liabilities...
Gulf Shipping Company Balance Sheet As of December 31, 2019 (amounts in thousands) Cash 38,000 Liabilities 22,000 Other Assets 27,000 Equity 43,000 Total Assets 65,000 Total Liabilities & Equity 65,000 Gulf Shipping Company Income Statement January 1 to March 31, 2020 (amounts in thousands) Revenue 5,100 Expenses 2,800 Net Income 2,300 Between January 1 and March 31, 2020: 1. Cash decreases by $100,000 2. Other Assets do not change 3. Paid-In Capital does not change 4. Dividends paid of $400,000...
Hopewell Corporation Balance Sheet As of December 31, 2019 (amounts in thousands) Cash 125,000 Accounts Payable...
Hopewell Corporation Balance Sheet As of December 31, 2019 (amounts in thousands) Cash 125,000 Accounts Payable 24,000 Accounts Receivable 36,000 Debt 37,000 Inventory 52,000 Other Liabilities 30,000 Property Plant & Equipment, Gross 226,000 Total Liabilities 91,000 Accumulated Depreciation 59,000 Paid-In Capital 56,000 Property Plant & Equipment, Net 167,000 Retained Earnings 239,000 Other Assets 6,000 Total Equity 295,000 Total Assets 386,000 Total Liabilities & Equity 386,000 Hopewell Corporation Statement of Cash Flows January 1 to March 31, 2020 (amounts in thousands)...
Exercise 9-18 Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The...
Exercise 9-18 Green Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. Clients usually pay 60% of their fee in the month that service is performed, 30% the month after, and 10% the second month after receiving service. Actual service revenue for 2019 and expected service revenues for 2020...
The following are the trial balance and the other information related to Kevin Consulting Engineer. KEVIN...
The following are the trial balance and the other information related to Kevin Consulting Engineer. KEVIN CONSULTING ENGINEER TRIAL BALANCE DECEMBER 31, 2020 Debit Credit Cash $29,500 Accounts Receivable 55,700 Allowance for Doubtful Accounts $803 Supplies 2,300 Prepaid Insurance 1,120 Equipment 29,000 Accumulated Depreciation-Equipment 6,145 Notes Payable 7,200 Common Stock 10,000 Retained Earnings 23,254 Service Revenue 115,957 Rent Expense 10,439 Salaries and Wages Expense 32,900 Utilities Expenses 1,760 Office Expense 640 $163,359 $163,359 1. Fees received in advance from clients...