Answer:
March $6,000
April $134,400
Explanation:
Preparation of a monthly cash budget for March and April
SYSTEMS COMPANY CASH BUDGET FOR MARCH AND APRIL
March April
Estimated cash receipts from:
Cash sales $157,500 $182,000
($450,000*35%=$157,500)
($520,000*35%=$182,000)
Collections of accounts receivable
$285,000 $328,900
[$51,000+($450,000*65%*80%)=$285,000]
[($450,000*65%*20)+($520,000*65%*80%)=$328,900]
Total cash receipts $442,500 $510,900
($157,500+$285,000=$442,500)
($182,000+$328,900=$510,900)
Estimated cash payments for:
Manufacturing costs $174,500 $305,000
[$102,000+($290,000*1/4)=$174,500]
[($290,000*3/4)+($350,000*1/4=$305,000)]
Selling and administrative expenses $37,000 $37,500
[($41,400-$6,400)/2 + $19,500 $37,000]
[($46,400-$6,400)/2 +$19,500$37,500]
Capital additions $250,000 $0
Income taxes $0 $40,000
Total cash payments $461,500 $382,500
Cash increase (decrease) -$19,000 $128,400
($442,500-$461,500=-$19,000)
($510,900-$382,500=$128,400)
Cash balance at beginning of month $45,000 $26,000
Cash balance at end of month $26,000 $154,400
(-$19,000+$45,000=$26,000)
($128,400+$26,000=$154,400)
Minimum cash balance $20,000 $20,000
Excess (deficiency) $6,000 $134,400
($26,000-$20,000=$6,000)
($154,400-$20,000=$134,400)
Therefore The monthly cash budget for March and April will be :
March $6,000
April $134,400