Question

Concord Corporation is projecting a cash balance of $30,360 in its December 31, 2016, balance sheet....

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.)

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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
Add a comment
Know the answer?
Add Answer to:
Concord Corporation is projecting a cash balance of $30,360 in its December 31, 2016, balance sheet....
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Exercise 13-15 Blue Corporation is projecting a cash balance of $38,460 in its December 31, 2016, balance sheet. Blue's...

    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 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...

    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...

    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,...

    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

    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,...

    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;...

  • Prepare a cash budget for the first quarter.

    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...

    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....

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT