New Jersey Produce Company is preparing its cash budget for July. The following information is available concerning its accounts receivable:

Estimated'credit'Sales forvulyinis 72! Met) arenesc,er e:a e Z So pavinine* $380,000 xas %

Actual credit salfeors JUN G w...ccccccsssesssssevessssseseseeeeeeeee tel D&e pats am Vel 250,000 x 75%

Estimated collections in July for credit sales in JUIY ...ccccccsssssssseesssssssessessssseeseseesen 25%

Estimated collections in July for credit saleS in JUNC......... eee ceeteeestteeestnereenenns 0%

Estimated collections in July for credit sales prior to June AP OOO mee G 29,0003 Estimated write-offs in July for uncollectible Credit SAl€S......... ee eeeeetetteestteeerneees Pettey Die Estimated provision for bad debts in July for credit sales in JUIY oo... eee 14,000 Required

a. What are the estimated cash receipts from accounts receivable collections in July?

b. BUILD YOUR OWN SPREADSHEET. Build an Excel spreadsheet to complete requirement (a).