Required: In the space provided under the basic information for the problem create the following: **PLEASE SHOW FULL WORK for schedule of cash collections number 2 please** **PLEASE SHOW FULL Work ending balance of Accounts receivable** 1. Schedule of cash collections for the year, including monthly and annual totals 2. Ending balance of Accounts Receivable Every cell of your assignment must contain either a cell reference or a formula. You may not change anything within the boxed area that contains the basic information. Round your answers to the nearest whole dollar. BASIC INFORMATION Sales in units by month Selling price per unit January 6,500 $ 8.50 February 6800 March 7,000 April 9,000 May 8,800 June 7,900 July 6,900 August 10,500 September 9,200 October 8,500 November 5,700 December 4,300 15% Collection cycle for Sales Cash sales in month Collection of Sales on Account In current month In first subsequent month In second subsequent month Beginning Accounts Receivable balance 35% 50% 15% 54,000 70% of Accounts receivable balance respresents unpaid December sales; 30% represents unpaid November sales. $