how to do this

or pts 116-6 (book/static) Jimenez 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) Question Helo Calculate the cash collected from receivables in each of the 4 quarters of 2017. (If a box is not used in the table la Data Table Schedule of Cash Collections Quarters 1 2 3 46000 Accounts receivable balance on 1-1-2017 (Fourth quarter sales from prior year) From first quarter 2017 sales From second-quarter 2017 sales From third-quarter 2017 sales From fourth quarter 2017 sales Total collections Accounts receivable (January 1, 2017) 45000 Budgeted sales in Quarter 1 (January 1 to March 31, 2017) 230.000 Budgeted swes in Quarter 2 (April to June 30, 2017) 245,000 Budgeted sales in Quarter 3 (July 1 to September 30, 2017) 210,000 Budgeted sales in Quarter 4 (October 1 to December 31, 2017) 240.000 All sales are made on account with 80% of sales made in a quarter collected in the same quarter and 20% collected in the following quarter. Print Done Enter any number in the edit fields and then click Check