can you please add a horizontal total column as well

Prepare the schedule of expected cash collection using the below for the second quarter (July, August and September): 1. A/R at the end of June = $ 136,000 2. Estimated sales for July, August, September, and October will be $210,000, $230,000, $220,000, and $240,000, respectively. 3. All sales are on credit and all credit sales are collected. Each month's credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at June 30 will be collected in July. Cash collection July June months accounts receivable + July month 35% of 210,000 = 136,000 + 73,500 = $ 209,500 August July month remaining sales + August month 35% of sale = 65% of 210,000 + 35% of 230,000 =136,500 + 80,500 =$ 217,000 September August month remaining sales + September month 35% of sale = 65% of 230,000 + 35% of 220,000 = 149,500 + 77,000 = $ 226,500 August September Schedule of Expected Cash Collection July Accounts receivable, June 30 $ 136,000 July sales (35% in July and 65% in August) $ 73,500 $ August sales (35% in August and 65% in September) $ September sales (35% in September) Total cash collection $ 209,500 $ 136,500 80,500 $ $ 217,000 $ 149,500 77,000 226,500