Melinda Horan is one of Texas's premiere party planners. She purchases a variety of supplies, such as plastic tableware, stemware, and decorations, throughout the year. Melinda has prepared the following purchases budget for the coming year 1st Quarter $348,000 2nd Quarter $412,000 3rd Quarter $469,000 4th Quarter $531,000 Budgeted purchases Historically, Melinda has paid for 38 percent of her purchases in the quarter of purchase and 62 percent in the quarter following purchase. On December 31 of this year Melinda had a $337,400 accounts payable balance Prepare Melinda's cash payments budget for the coming year. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.) 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter A/P from last quarter 1st quarter purchases 2nd quarter purchases 3rd quarter purchases 4th quarter purchases Total Calculate the accounts payable balance at the end of 4th Quarter Accounts Payable balance at the end of 4th Quarter s