Cash disbursements schedule Maris Brothers, Inc, needs a cash disbursement sched

ID: 2819783 • Letter: C

Question

Cash disbursements schedule Maris Brothers, Inc, needs a cash disbursement schedule for the months of Sales Febeuary $509,000, March $493,000, April $575,000, May $610,000, June $653,000 July $656.000 Apel. May, and Jjume Use the format givern here th's-8%ofprd ases we made in cash 51% of pedase-dfor 1m ihr purchase antermining 41% of purch-am pidier and the followinginformasion in ts preparation esanak lated as 56% of the next m Rent The fm pays rent of $8,020 per month wages and asanes Bae wage and salary costs are food at S5.500 per moth plas a variatk cal d67%ofte amet month's sis Taxes A tax payment of $54,100 is due in June Foxed asset outlays New equipment costing $74 500 wilbe bought and paid for in Apr Interest payments An interest payment of $30 200 is due in June Cash dividends Dividends of $12,500 will be paid in Apri Principal repayments and retirements No principal repayments or retirements are due during these months mempucha Complete cash dbursements schedule lor Maris B ters, he below (Rond to the nei-dla) Schedule of Projected Cash Disbursements for Maris Beothers, Inc. Feb 509000s 493,000S 575,000 Apr May Jun Jul Sales Purchase s 285040 276060 322000 Cash 1 month delay 2 month delay 5131 Rant 8,020 Wages and salary $ 5.500 S 38,525 Fued Taxes fked assets 74 500 5 S 12.500 Cash dividends

Explanation / Answer

Particulars

Apr

May

June

Sales (1)

575,000

610,000

653,000

Disburshments (2)

443,786

389,880

497,513

Purchase

304,741

335,490

355,942

Rent

8,020

Wages and Salary

44,025

46,370

49,251

Tax

54,100

Fixed assets

74,500

Interest payment

30,200

Divident

12,500

Total (1)-(2)

131,214

220,120

155,487

Purchase

Feb

Mar

Apr

May

June

July

Sales

509000

493000

575000

610000

653000

656000

Purchase (56% of next months sales

276080

322000

341600

365680

367360

In cash 8% (1)

22086.4

25760

27328

29254.4

29388.8

51% is paid after 1 month (2)

140800.8

164220

174216

186496.8

187353.6

41% is paid 2 months after purchase (3)

113192.8

132020

140056

149928.8

Payment of purchase (1+2+3)

304740.8

335490.4

355941.6

Wages and Salary

Fixed

5500

variable 6.7% of sales

38525

40870

43751

Total

44025

46370

49251