Concord Corporation is projecting a cash balance of $30,360 in its December 31, 2016, balance sheet. Concord’s schedule of expected collections from customers for the first quarter of 2017 shows total collections of $187,220. The schedule of expected payments for direct materials for the first quarter of 2017 shows total payments of $43,516. Other information gathered for the first quarter of 2017 is sale of equipment $3,036; direct labor $70,840, manufacturing overhead $35,420, selling and administrative expenses $45,540; and purchase of securities $14,168. Concord wants to maintain a balance of at least $25,300 cash at the end of each quarter. Prepare a cash budget for the first quarter. (Do not leave any answer field blank. Enter 0 for amounts.)
Cash budget
First quarter | |
Beginning Cash balance | 30360 |
Cash collection from customer | 187220 |
Sale of equipment | 3036 |
Total Cash receipts | 190256 |
Total Cash available | 220616 |
Cash disbursement | |
Payment for direct materials | 43516 |
Direct labor | 70840 |
Manufacturing overhead | 35420 |
Selling and administrative expense | 45540 |
Purchase of securities | 14168 |
Total Cash payment | 209484 |
Preliminary Cash balance | 11132 |
Borrowing | 14168 |
Ending Cash balance | 25300 |
Concord Corporation is projecting a cash balance of $30,360 in its December 31, 2016, balance sheet....
Exercise 13-15 Blue Corporation is projecting a cash balance of $38,460 in its December 31, 2016, balance sheet. Blue's schedule of expected collections from customers for the first quarter of 2017 shows total collections of $237,170. The schedule of expected payments for direct materials for the first quarter of 2017 shows total payments of $55,126. Other information gathered for the first quarter of 2017 is sale of equipment $3,846; direct labor $89,740, manufacturing overhead $44,870, selling and administrative expenses $57,690;...
Oriole Corporation is projecting a cash balance of $34.800 in its December 31, 2019, balance sheet. Oriole's schedule of expected collections from customer for the first quarter of 2020 shows total collections of $214,600. The schedule of expected payments for direct materials for the first quarter of 2020 shows total payments of $49,880. Other information gathered for the first quarter of 2020 is sale of equipment $3,480, direct labor $81,200, manufacturing overhead $40,600, selling and administrative expenses $52.200; and purchase...
Deitz Corporation is projecting a cash balance of $35,400 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 $218,300. The schedule of expected payments for direct materials for the first quarter of 2020 shows total payments of $50,740. Other information gathered for the first quarter of 2020 is sale of equipment $3,540; direct labor $82,600, manufacturing overhead $41,300, selling and administrative expenses $53,100; and purchase...
Deitz Corporation is projecting a cash balance of $ 37,830 in its December 31, 2016, balance sheet. Deitz's schedule of expected collections frarn customers for the first quarter of 2017 shows total callections af $233,285. The schedule of expected payments for direct materials for the first quarter of 2017 shows total payments of $ 54,223. Other information gathered for the first quarter of 2017 is sale of equipment s 3,783 ; direct labor $ aa, 270, manufacturing overhead $ 44,135,...
Exercise 23-15 Deitz Corporation is projecting a cash balance of $ 33,150 in its December 31, 2016, balance sheet. Deitz's schedule of expected collections from customers for the first quarter of 2017 shows total collections of $ 204,425 . The schedule of expected payments for direct materials for the first quarter of 2017 shows total payments of $ 47,515 . Other information gathered for the first quarter of 2017 is sale of equipment $ 3,315; direct labor $ 77,350, manufacturing...
Deitz Corporation is projecting a cash balance of $37,500 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 $231,250. The schedule of expected payments for direct materials for the first quarter of 2020 shows total payments of $53,750. Other information gathered for the first quarter of 2020 is sale of equipment $3,750; direct labor $87,500, manufacturing overhead $43,750, selling and administrative expenses $56,250; and purchase of...
Exercise 21-15 Deitz Corporation is projecting a cash balance of $36,960 in its December 31, 2016, balance sheet. Deitz’s schedule of expected collections from customers for the first quarter of 2017 shows total collections of $227,920. The schedule of expected payments for direct materials for the first quarter of 2017 shows total payments of $52,976. Other information gathered for the first quarter of 2017 is sale of equipment $3,696; direct labor $86,240, manufacturing overhead $43,120, selling and administrative expenses $55,440;...
Aaron Corporation is projecting a cash balance of $31,076 in its December 31, 2013, balance sheet. Aaron's schedule of expected collections from customers for the first quarter of 2014 shows total collections of $180,326. The schedule of expected payments for direct materials for the first quarter of 2014 shows total payments of $40,898.Other information gathered for the first quarter of 2014 is sale of equipment $3,218, direct labor $69,511, manufacturing overhead $35,470, selling and administrative expenses $44,510 and purchase of...
Balance Sheet December 31, 2016 Assets $7,500 73,500 24,790 105,790 Current Assets Cash Accounts receivable Finished goods inventory (1,500 units) Total current assets Property, Plant, and Equipment Equipment $40,770 Less: Accumulated depreciation 10,800 Total assets Liabilities and Stockholders' Equity Liabilities Notes payable Accounts payable Total liabilities Stockholders' Equity Common stock $36,940 Retained earnings 25,620 29,970 $135,760 $26,810 46,390 73,200 CALCULATOR PRINTER VERSION BACK TO Sockholders cquity Total liabilities and stockholders' equity $135,760 Budgeted data for the year 2017 Include the...
Problem 21-6A (Part Level Submission) Krause Industries' balance sheet at December 31, 2016, is presented below. KRAUSE INDUSTRIES Balance Sheet December 31, 2016 Assets Current Assets Cash Accounts receivable Finished goods inventory (1,500 units) $7,500 73,500 25,070 106,070 Total current assets Property, Plant, and Equipment Equipment Less: Accumulated depreciation $40,130 10,660 29,470 Total assets $135,540 Liabilities and Stockholders' Equity Liabilities Notes payable Accounts payable $27,270 46,490 73,760 Total liabilities Stockholders' Equity Common stock Retained earnings Total stockholders' equity Total liabilities...