I need help with the second table! thanks

Rainbow Enterprises has presented the following estimates relating to 2018 activities: Sales revenue Purchases Cost of sales Marketing and administration expenses Occupancy expenses Depreciation expense 31 March $700,000 450,000 350,000 170,000 78,000 13,500 Quarter ending 30 June 30 September $800,000 $900,000 420,000 400,000 400,000 450,000 170,000 170,000 78,000 78,000 13,500 13,500 31 December $950,000 430,000 475,000 170,000 78,000 13,500 Sales in the December quarter of 2017 were $600,000. All sales are on credit, of which 70 per cent are collected in the quarter of sale and 30 per cent in the following quarter. Purchases are on credit, and entity policy is such that all purchases are paid for in the same quarter. The marketing and administration expenses incurred and paid are the same. Occupancy expenses incurred and paid are usually the same, except that the electricity bill (estimated to be $610) for December 2018 will not be paid until January 2019. A major IT hardware acquisition of $26,400, to be paid for in cash, is expected in the December quarter. The bank balance at 31 December 2017 was $18,360. (a) ZYour answer has been saved and sent for grading. See Gradebook for score details. Prepare a schedule of receipts from accounts receivable showing cash collections for each quarter of 2018. (Please leave any answer fields without an entry blank. Enter negative amounts using either a negative sign preceding the number, e.g. -45, or parentheses, e.g. (45).) Rainbow Enterprises Schedule of receipts from accounts receivable for the quarters ending 31 December 2018 Receipts ($) Month Sales March June September December December 2017 $600,000 180,000 March $700,000 490,000 210,000 June $800,000 560,000 240,000 September $900,000 630,000 270,000 December 2018 $950,000 665,000 Total 670,000 770,000 870,000 935,000 Perhe (1) Prepare a cash budgetcon 3 quarterly basis for the 12 months ending 31 December 2008. (Please leave any answer fields without an entry blank Enter negative amounts using either a negative sign preceding the number, eg. -45, or parentheses, eg. (45) Rainbow Enterpris Cash buy furtherten undnu 31 Desember 2018 March (6) June (5) September ($) December (5) Total (5) 2 3 4 6 7 9 9 14 11 12 v Purchases Cash recepts Cererea IT hardware acquisition Cechy Cash Cayments Cost of Sales Nutcash flow Fermentate sunt payahla Marketing and administration experie Receipts from accounts receivable 1 Se Haven Purchases Deep Bank balenes at start of month IT hendre aquisition Marketing and administration experts Market and administration experims Bank balance at start of months Bank balance at wart ufanih La cita Depreciation Expense Purchases Total she Occupancy excenses Sal Rem Bank baloncest and of month Sales Revenue Cashment Cash payment Cash payments Total cash payments Payments to accounts payable Oct.pny Xpe Reply from a wide Sales Revenue Csh recepts Marketing and administration Net cach to Topal payments Recipta frumentaria Receipts from accounts receivable Purchases Bank dan alart of moth Occupancy expenses IT hardware squilion Bank balance al unu month Cupancy wspanse Total cual payment Deprecisbon Expand Total chrocita Occupancy expenses Cost of Sales Pet :sh fire Payment to attenta wyl Bank biance end of month Nutcash now Parchers Depreciation pence Cuari Bank batendom Denk balance at end of month Tulalas Bank balance st ens moet Receipts from accounts receivable Cool payments Torel rach Total cash payments Lutol Sol Cech psy Cach receipt Payment payable Payments to accoula poyable Bank laat of Deprecation penca Net cash flow Cost of Saar Cost of Sales Marketing and administration expenses Martin and ministon van IT broware ausio Purchaser IT hardwaresia con Depreciation Paper Natasha Ocean expenses Payment to payable Total Curents Cash receipta Payment to arm VANA IT hardenin IT hardware bouton Total cash receipt Net cashow Depreciation Expense Recipe from one receive Total cash receipts Bank balance at start of month Total rath y menta Deprecison th Bank balance at start of month Berit from enterere vele Total cash receipts Marketing and siministration expers Bank balancent and of month - Cu of S. Depreciation Excerce Total cash payments Marketing and administration exceros IT hardware question Cash payments Total cual recepta Parrhea Tank holence at end of month Payments to rent bayable Cash recipe Purches NA pencer Total cash receipts Bank balance at end of month IT hardware Son Occupancy excorses Het cash flow Depreciation Expense Talah Site Marketing and administration expertos Totalcanhar ODAY NE IT hardware soquisition Cachment Cost of Sales Bank balance at start of month Deputation Paper Total cash payment Occuency expenses IT Hardware Equisitian Bank balenes at end of month SNAR Raven Total cash paymento Nutcash flow IT hwristian 5 Revenue Marketing and administration expenses Recipe from man Depreciat on Expanse Total cash payments Cost of Sales Bank ble start of month Payments to accounts payable Recipts from the rewable Sales Rev Cash receipt Met cash flow Bank balance at start ct morth Cost of Sales Net cash flow Cah recipe Bank balance at start of month Cash Depreciation Expert Cash payment Total cash payments Bank balance at end of month Cach payment Total cash receipts Eark balance at start of month Receipts from accounts recevable Sales Revenue Payments to accounts payable Receipts from counts receivable Receiptstromscounts receivable Futbah flow Purchases Bane Lancet und of month Curali pay Payment to actuurba payable Ocupancy expenses Cuatul de Market ng and administration expenses Hartleting and administration expenses Cost of Sales Sala Raven 100 Tu Purchases