NEED HELP WITH Expected Cash Disbursements (to Cash Budget)

LABOR =

$ 252,588

$ 228,300

$ 260,100

$ 291,900

Manufacturing overhead incurred averages 85% of direct labor cost.

Manufacturing overhead percentage includes warehouse rent, insurance, utilities, etc.

Manufacturing overhead is paid 40% in the current month with the remaining balance paid the following month.

Don't worry about QTR TOTAL or INCOMPLETE INFORMATION FOR APRIL

I NEED JAN FEB MAR

Section 1: Manufacturing Overhead Budget
	Jan	Feb	Mar	Apr	Qtr Total
Total Labor Cost, in $ (from Direct Labor)	$ 252,588	$ 228,300	$ 260,100	$ 291,900
% of Direct Labor to MOH	85%	85%	85%	85%
Manufacturing Overhead, in $	$ 214,700	$ 194,055	$ 221,085	$ 248,115
Section 2: Expected Cash Disbursements (to Cash Budget)
	Jan	Feb	Mar	Apr	Qtr Total
Jan MOH, in $	$ 85,880	$ 128,820
Feb MOH, in $		77,622	116,433
Mar MOH, in $			88,434	132,651
Total Cash Disbursement, in $	$ 85,880	$ 206,442	$ 204,867	$ 132,651
Section 3: Accounts Payable (to Balance Sheet)
	Jan	Feb	Mar	Apr	Qtr Total
Accounts Payable, Beginning Balance, in $	$ -	$ 128,820	$ 116,433	$ 132,651
Accounts Payable, Ending Balance, in $	$ 85,880	$ 206,442	$ 204,867	$ 132,651