Prepare the problems below using Excel. Upload the workbook using the link. 1. (12 points) Kawhi Corporation is a wholesaler of industrial goods. Data regarding the store's operations follow: Sales are budgeted at $298,000 for November, $274,000 for December and $262,000 for January. Cash sales are expected to be 30% of sales, and credit sales are expected to be 70% of sales. Collections of credit sales are expected to be 56% in the month of sale, 41% in the month following the sale, and 3% uncollectible. The cost of goods sold is 60% of sales. The company purchases 55% of its merchandise in the month prior to the month of sale and 45% in the month of sale without regard to beginning or ending merchandise inventory. Payment for merchandise is made in the month following the purchase. The November beginning balance in the accounts receivable account is $101,100. Required: a. Prepare a Schedule of Expected Cash Collections for November and December. b. Prepare a Merchandise Purchases Budget for November and December. 2 (12nointi