Cash Receipts Budget April May June Total

Cash Sales $(30\%)97,200108,000111,600316,800$

AR Collections:

Month of Sale $(10\%)9,72010,80011,16031,680$

Month after Sale $(50\%)46,80048,60054,000149,400$

Second Month after sale $(10\%)9,0009,3609,72028,080$

Total Cash Collected $153,720176,760186,480516,960$

Cash Payments Budget: April May June Total

Materials Purchases:

Month of Purchase $(25\%)20,43421,96022,39264,786$

$2$nd Month of Purchase $(75\%)49,03161,30165,880176,212$

Total Materials Purchases $69,46583,26188,272240,998$

Direct Labor $83,70090,90093,900268,500$

Variable Overhead $50,22054,54056,340161,100$

Fixed Overhead $33,48036,36037,560107,400$

Selling Expenses $35,64039,60040,920116,160$

General & Administrative $32,00032,00032,00096,000$

Less Depreciation:

General & Administrative $12,80012,80012,80038,400$

Cash paid for Equipment $54,000--54,000$

Cash Paid for Dividends $--65,00065,000$

Total Cash Payments $237,705240,600182,920661,225$

$832,758$

Cash Budget April May June Total

Cash Balance, Beginning of Period $20,000$

Cash Receipts $153,720$

Cash Payments

Cash Balance Before Financing

Cash Borrowed or $($Repaid$)$

Ending Cash Balance