Scribd
Upload
76 views3 pages

Sales Budget: Mar April May

The document provides sales, collection, material purchase, and cash budgets for March through June 2013. It shows that total cash collections are expected to exceed total payments in each month. This will result in positive cash balances each month, growing from $215,330 in March to an ending balance of $614,026 in June.

Uploaded by

Muhammad Kashif
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
76 views3 pages

Sales Budget: Mar April May

The document provides sales, collection, material purchase, and cash budgets for March through June 2013. It shows that total cash collections are expected to exceed total payments in each month. This will result in positive cash balances each month, growing from $215,330 in March to an ending balance of $614,026 in June.

Uploaded by

Muhammad Kashif
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

1.

Sales budget:
Mar April May
Cash Sales $ 315,000 $ 254,400 $ 203,400
Credit Sales $ 210,000 $ 169,600 $ 135,600
sales $ $ 525,000 $ 424,000 $ 339,000

cash budget:
Mar April May
cash collection:
Cash Sales $ 308,700 $ 249,312 $ 199,332
1st month Collection Credit sale 40% $ 138,880 $ 102,900 $ 83,104
2nd month Collection credit sale 40% $ 138,880 $ 102,900

Total collection $ 447,580 $ 491,092 $ 385,336

Direct material budget


Mar April May
material purchased $ $ 342,000 $ 239,000 $ 178,000
Cash disbursement
Mar April May
Material purchased $ $ 342,000 $ 239,000 $ 178,000
Cash disbursement for material:
Payment in the Month of Purchase 50% $ 171,000 $ 119,500 $ 89,000
Payment next to month of purchase 50% $ 86,250 $ 171,000 $ 119,500
total $ 257,250 $ 290,500 $ 208,500

Cash budget
April May June
Collection:
sales collection $ 447,580 $ 491,092 $ 385,336
total $ 447,580 $ 491,092 $ 385,336
Payments:
purchases $ 257,250 $ 290,500 $ 208,500
labor $ 34,000 $ 29,000 $ 25,500
Other Disbursement $ 30,000 $ 10,000 $ 42,000

total payments $ 321,250 $ 329,500 $ 276,000


Net increase/(decrease) $ 126,330 $ 161,592 $ 109,336
opening balance $ 89,000 $ 215,330 $ 376,922
Ending Balance balance $ 215,330 $ 376,922 $ 486,258
Cash in Hand on June 2013 $ 614,026
Jun
$ 339,000
$ 226,000
$ 565,000

Jun

$ 332,220
$ 66,444
$ 83,104

$ 481,768

Jun
$ 389,000

Jun
$ 389,000

$ 194,500
$ 89,000
$ 283,500

July

$ 481,768
$ 481,768

$ 283,500
$ 38,500
$ 32,000

$ 354,000
$ 127,768
$ 486,258
$ 614,026

You might also like