how to do this

Save HW Score: 86.81%, 79 of 91 pts Homework: DUE June 8 - Chapter 6 Homework - Part 1 of 2 Score: 0 of 12 pts 28 of 28 (27 complete) T16-6 (book/static) Jimenez Corporation manufactures and sels two types of decorative lamps, Knax and Ayer The following data are available for the year 2017 Click the icon to view the additional information) Calculate the cash collected from receivables in each of the 4 quarters of 2017. (If a box is not used in the table leave the box empty, do not enter a zero) Question Help Schedule of Cash Collections Quarters Data Table 1 2 3 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) $ 48.000 Budgeted sales in Quarter 1 (January 1 to March 31, 2017) 230,000 Budgeted sales in Quarter 2 (April 1 to 90.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) 200.000 Al 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