SOLUTION
1. Schedule for expected cash collection
January ($) | February ($) | |
Collection from - | ||
November sales (285,000*20%) | 57,000 | |
December sales (364,800*30%), (364,800*20%) | 109,440 | 72,960 |
January sales (410,400*50%), (410,400*30%) | 205,200 | 123,120 |
February sales (456,000*50%) | 228,000 | |
Total | 371,640 | 424,080 |
Schedule of expected payments
January ($) | February ($) | |
December (114,000*40%) | 45,600 | |
January (136,800*60%), (136,800*40%) | 82,080 | 54,720 |
February (142,500*60%) | 85,500 | |
Total | 127,680 | 140,220 |
2. Cash budget-
January | February | |
Beginning cash balance | 68,400 | 58,140 |
Add: Cash receipts- | ||
Collections from credit sales | 371,640 | 424,080 |
Collection of notes receivable | 17,100 | |
Proceeds from sale of securities | 6,840 | |
Total cash receipts | 388,740 | 430,920 |
Total cash available (A) | 457,140 | 489,060 |
Less: Cash disbursements: | ||
Direct materials | 127,680 | 140,220 |
Direct labor | 102,600 | 114,000 |
Overhead | 79,800 | 85,500 |
Selling and administrative expenses (90,060-1,140),(96,900-1,140) | 88,920 | 95,760 |
Payment of dividend | 6,840 | |
Total disbursements (B) | 399,000 | 442,320 |
Excess/ (Deficiency) of cash (A-B) | 58,140 | 46,740 |
Borrowings | 0 | 10,260 |
Interest expense | 0 | 0 |
Repayment | 0 | 0 |
Ending cash balance | 58,140 | 57,000 |
CALCULATOR FULL SCREEN PRINTER VERSION BACK NEXT Problem 13-4 (Part Level Submission) Culver Company prepares monthly...
FULL SCREEN PRINTER VERSION BACK NEXT Problem 23-4A (Part Level Submission) Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows: January February Sales Direct materials purchases Direct labor $427,680 $475,200 142,560 148,500 106,920 118,800 89,100 93,852 100,980 Manufacturing overhead Selling and administrative expenses 83,160 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second...
STANDARD VEEW CES PRINTER VERSsiON BACK NEXT Problem 13-4 (Part Level Submission) Sheffield Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows: January February Sales $381,600 $424,000 Direct materials purchases 127,200 132,500 Direct labor 95,400 106,000 Manufacturing overhead Selling and administrative expenses 79,500 74,200 83,740 90,100 dy All sales are on account. Collections are explected to be 50% in the month of sale, 30 % in the first month following the sale, and 20%...
dicements CALCULATOR PRINTER VERSION oblem 9-4A (Part Level Submission) (Video) biter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows January February $435,600 $484,000 Direct materials purchases 145,200 151,250 Direct labor 108,900 121,000 Manafacturing overhead 84,700 90,750 Selling and administrative expenses 95,590 102,850 Sales All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month...
Problem 21-4A (Part Level Submission)
Colter Company prepares monthly cash budgets. Relevant data from
operating budgets for 2017 are as follows:
January
February
Sales
$405,360
$450,400
Direct materials purchases
135,120
140,750
Direct labor
101,340
112,600
Manufacturing overhead
78,820
84,450
Selling and administrative expenses
88,954
95,710
All sales are on account. Collections are expected to be 50% in the
month of sale, 30% in the first month following the sale, and 20%
in the second month following the sale. Sixty percent...
prepare a cash budget for January colter company
CALCULATOR PRINTER VERSION CRACK Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows: January February Sales Direct materials purchases Direct labor Manufacturing overhead Selling and administrative expenses $426,960 142,320 106,740 83,020 93,694 $474,400 148,250 118,600 88,950 100,810 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the...
Problem 21-4A (Part Level Submission) Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows: Sales Direct materials purchases Direct labor Manufacturing overhead Selling and administrative expenses January $403,200 134,400 100,000 78,400 88.480 February $448,000 140,000 112,000 84,000 95,200 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent...
CALCULATOR Problem 9-4A (Part Level Submission) (Video) Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows. January February Sales $435,600 $484,000 Direct materials purchases 145,200 151,250 Direct labor 108,900 121,000 Manufacturing overhead Selling and administrative expenses 84,700 90,750 95,590 102,850 be 50% in the month of sale, 30% in the first month following the sale, and 20 % in the All sales are on account. Collections are expected sale. Sixty percent (60 %)...
NEED HELP ASAP
CALCULATOR FULL SCREEN PRINTER VERSION BACK NET Problem 3-3A (Video) (Part Level Submission) Thakin Industries Inc, manufactures dorm furniture in separate processes. In each process, materials are entered at the beginning, and conversion costs are incurred uniformly. Production and cost data for the first process in making a product are as follows. Cutting Department T12-Tables Production Data-July Work in process units, July 1 Units started into production Work in process units, July 31 Work in process percent...
Problem 9-4A (Part Level Submission)
Colter Company prepares monthly cash budgets. Relevant data from
operating budgets for 2017 are as follows:
January
February
Sales
$432,000
$400,000
Direct materials purchases
144,000
150,000
Direct labor
108,000
120,000
Manufacturing overhead
84,000
90,000
Selling and administrative expenses
94,800
102,000
All sales are on account. Collections are expected to be 50% in the
month of sale, 30% in the first month following the sale, and 20%
in the second month following the sale. Sixty percent...
Marigold Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows: Sales Direct materials purchases Direct labor Manufacturing overhead Selling and administrative expenses January $380,160 126,720 95,040 73,920 83,424 February $422,400 132,000 105,600 79,200 89,760 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60% of direct materials purchases...