Need help creating master budget

Beginning cash balance of 2,000,000

Minimum ending cash balance of 200,000

Paste Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check f Sales budget and cash receipts Quarter Quarterly sales percent | Sales 2 4 Total 100% 3,278 $500 60%, 10% 328 500 $500 $500 20% 655 10% 328 1,967 $500 983,500 1 selling price 27,500 164,000 164,000 1,639,000 Total sales credit sales Bad debts collections month of sale Collections 1st month after sale Collection 2nd month after sale cash sales Total collections 1,311,200J 131,120 J 262,240 262,200 78,640 327,800 930,880 262,000 131,200 131,200786,800 26,200 13,120 13,120 2,40026,240 157,360 131,00065,600 52,400 65,500 32,800 32,800 117,900 190,040 308,160 78,680 26,240 65,600 26,240 196,700 314,780