Please help.

Pronghorn Inc. has budgeted sales for the second quarter of $300,000 for April; $535,000 for May; and $610,000 for June. Normally, 20% are cash sales and 80% of sales are on account. As well, 30% of the sales on account are normally collected during the month of sale, 50% in the following month, and 20% in the second month following sale. The accounts receivable balance as of April 1 is $250,000. Prepare the schedule of cash collections for the second quarter by month and in total. (Round intermediate calculations and final answers to 0 decimal places, e.g. 15 or 15%.) Cash Collection Schedule Apr. May Jun. Quarter Total planned sales 300000 535000 610000 $ 1445000 Credit sales 240000 428000 488000 1156000 Cash sales 60000 107000 122000 289000 Credit sales collected during month 72000 128400 146000 346800 Credit sales collected one month later 120000 214000 244000 578000 Credit sales collected two months later 48000 85600 97600 231200 April 1st A/R collected during month April 1st A/R collected following month