Question

Complete a cash budget for Graham Company for January, February, and March. (Complete all answer boxes. Enter a "0" for any zero balances. Round all amounts entered into the cash budget to the nearest whole dollar. Enter a cash deficiency with a minus sign or parentheses.)

i Reference Cash Receipts from Customers Total sales January February March $ 15,800 $ 12,200 $ 10,500||$ January February March Total 38,500 Total Cash Receipts from Customers: Accounts Receivable balance, January 1 January—Cash sales 9,480 3,160 January-Credit sales, collection of January sales in January $ 3,160 7,320 2,440 January-Credit sales, collection of January sales in February February—Cash sales February—Credit sales, collection of February sales in February February-Credit sales, collection of February sales in March March—Cash sales March-Credit sales, collection of March sales in March $ 2,440 6,300 2,100 10,840 $ $ 12 12,640 $ 12,920 $ Total cash receipts from customers 36,400 Accounts Receivable balance, March 31: March—Credit sales, collection of March sales in April $ 2,100 Print Done

CAN SOMEONE HELP ME PLS?? I NEED THE ANSWER FOR THREE MONTHS January, February, and March.

Answer 1

Graham Company
Cash Budget
Particulars	January	February	March
Beginning Cash Balance	$3,500	$         4,380	$   3,687
Cash Receipts	$12,640	$12,920	$10,840
Total Cash Available	$16,140	$17,300	$14,527
Cash Payments:
Purchases of Direct Materials	$              -	$         3,900	$   4,200
Direct Labour	$       3,300	$         3,400	$   4,100
Manufacturing Overhead	$       2,400	$            440	$       440
S & D Expenses	$       8,060	$         6,850	$   6,850
Interest Expenses		$              23	$         35
Total Cash Payments	$     13,760	$      14,613	$ 15,625
Ending Cash Balance before financing	$2,380	$2,687	($1,098)
Minimum Cash Balance Desired	$       3,500	$         3,500	$   3,500
Projected Cash Efficiency/ Deficiency	($1,120)	($813)	($4,598)
Financing
Borrowing	($2,000)	($1,000)	($5,000)
Principal Repayment	0	0	0
Total Effects	($2,000)	($1,000)	($5,000)
Ending Cash Balance	$       4,380	$        3,687	$   3,902