Master Budget Shilow Company ACCT346

Sheet1

Managerial Accounting - Course Project
Budgeted Sales
March	April	May	June	July
Schedule of Expected Cash Collections
	April	May	June	Quarter
Cash Sales	$ 36,000
Credit Sales	20,000
Total Collections	$ 56,000
Merchandise Purchases Budget
	April	May	June	Quarter
Budgeted Cost of Goods Sold	$ 45,000
add: Desired Ending Inventory	43,200
Total Needs	88,200
less: Beginning Inventory	36,000
Required Purchases	$ 52,200
Schedule of Expected Cash Disbursements - Merchandise Purchaes
	April	May	June	Quarter
March Purchases	$ 21,750			$ 21,750
April Purchases	26,100	26,100		52,200
May Purchases
June Purchases
Total Disbursements	$ 47,850
Schedule of Expected Cash Disbursements - Selling & Administrative
	April	May	June	Quarter
Commissions	$ 7,200
Rent	2,500
Other Expenses	3,600
Total Disbursements	$ 13,300
Cash Budget
	April	May	June	Quarter
Cash Balance Beginning	$ 8,000
Add: Cash Collections	56,000
Total Cash Available	64,000
Less Cash Disbursements
For Inventory	47,850
For Expenses	13,300
For Equipment	1,500
Total Cash Disbursements	62,650
Excess (deficiency) of Cash	1,350
Borrowing
Repayments
Interest Paid
Ending Cash Balance