how do you do this?

Relevant data from the Poster Company's operating budgets are: Quarter 1 Quarter 2 Sales $208,470 $211,538 Direct material purchases 115,290 120,832 Direct labch 75,210 73,299 Manufacturing overhead 25,400 25,300 Selling and administrative expenses 33,400 33,600 Depreciation included in selling and administrative 1,500 1,100 Collections from customers 215,391 240,155 Cash payments for purchases 114,290 119,252 Additional data: Capital assets were sold in January for $9,000 and $4,600 in May. Dividends of $4,600 were paid in February. The beginning cash balance was $60,359 and a required minimum cash balance is $59,000. Use this information to prepare a cash budget for the first two quarters of the year: If an amount box does not require an entry, leave it blank. The Poster Company The Poster Company Cash Budget For the First Two Quarters Quarter 1 Quarter 2 Beginning Cash Balance Add: Cash Receipts Collections from Customers Other Collections Total Receipts