i need detailed solutions to this please the ans for 17 is D and 18 D thanks

The next three questions are based on the following information is a retail store that purchases merchandizes from several makers of office equipment. Actual balance sheet is presented below Balance Sheet S25 Cash Accounts Receivable (Net of allowance for uncollectible accounts) $70,000 $79.625 $1.225.375 Inventory Property Plant Equipment (Net of $640,000 accumulated depreciation) Total Assets Accounts Payable Common Stock $1.400,000 $170,000 $1,050,000 8000 Retained Eamings $1,400,000 To prepare budgets, the budget officer gathered addition budget data Sales are budgeted at $350.000, 5260.000, and $230,000, all on credit, for October, November, and December respectively . The company will declare 15,000 dividend in October, which will be paid November Collections are expected to be 55% in the month of sale, 40% in the month following the sale, and 5% uncollectible, Copland Supplies recognizes bad debt expenses in the month sales are made The cost of goods sold is 65% of sales. . The ending merchandise inventory should be 35% of the following month sales needs. Payment for morchandise purchases is expoted to bs d0% in the month of purchase with the remaining paid in the following month. Monthly selling and administrative expenses to be paid in cash are $32.000 Monthly depreciation is $20,000. 16 What is the accounts receivable balance of Copland as of November 30 A. S104,000 B $192.500 C. $140,000 D. $143,000 E. None of the above S915 523S 17 Copland Supplies retained earnings balance at the end of November would be (Assume the company pays interest and income tax when answering this question) A. $64,000 $259,000 $218,000 D. $244,000 E. None of the above 18 In addition to information given above, assume Copland Supplies requires $30,000 minimum cash balance Cash can be borrowed at any exact amount at the beginning of each month from company's credit line at a bank. Interest, 2% monthly, are paid at the end of each month. Determine total amount of cash Copland Supplies needs to borrow from the bank for the month October A)$68,715 C. D. E. $38,715 $30,000 $70,118 None of the above