Magrity Corporation manufactures and sells two types of decorative lamps, Knox and Ayer. The following data are available for the year 2017 Click the icon to view the additional information) All sales are made on account with 65% of sales made in a quarter collected in the same quarter and 35% collected in the following quarter, Calculate the cash collected from receivables in each of the 4 quarters of 2017. (1 a box is not used in the table leave the box empty, do not enter a zero) Schedule of Cash Collections Quarters 1 2 3 4 Accounts receivable balance on 1.1.2017 (Fourth quarter sales from prior year) From first quarter 2017 sales From second-quarter 2017 salos Erom sd quarter 2017 From fourth quarter 2017 sales Total collection Calculator Print Clear A Data Table 40,000 Accounts receivable (January 1, 2017) Budgeted sales in Quarter 1 (January 1 to March 31, 2017) Budgeted sales in Quarter 2 (April 1 to June 30, 2017) Budgeted sales in Quarter 3 (July 1 to September 30, 2017) Budgeted sales in Quarter 4 (October 1 to December 31, 2017) 255,000 260,000 190,000 270,000 Print Done