B Caprice Corporation is a wholesaler of industrial goods. Data regarding the store's operations follow: . Sales are budgeted at $250,000 for November, $260,000 for December, and $240,000 for January. Collections are expected to be 40% in the month of sale, 58% in the month following the sale, and 2% uncollectible. The cost of goods sold is 70% of sales. .The company desires an ending merchandise inventory equal to 20% of the following month's cost of goods sold. Payment for merchandise is made in the month following the purchase. . The November beginning balance in the accounts receivable account is $60,000. The November beginning balance in the accounts payable account is $247,000. Required: a. Prepare a Schedule of Expected Cash Collections for November and December. CAPRICE CORPORATION Schedule of Expected Cash Collections Sales Schedule of Expected Cash Collections Accounts receivable November sales December sales Total cash collections November December