Student Services Incorporated (SSI) acts as a wholesaler to the various student retail shops that operate on campuses throughout Canada. It supplies clothing, records, and confectionary items. The company has a $150,000 line of credit available with a local bank, and it draws on its account in amounts of $10,000 at a time. SSI has not drawn on the credit line yet. As at December 31, 2020, the firm had a cash balance of $14,000, which is the minimum balance that it wants to maintain. Any excess cash is used to repay the line of credit. [ignore interest on the line of credit.] The following additional information is available. Actual Sales Forecasted sales October 2020$100,000 January 2021 $200,000 November 2020$150,000 February 2021 $100,000 December 2020$80,000 March 2021 $60,000 April 2021 $200,000 May 2021 $140,000 June 2021 $140,000 Sales/Accounts Receivable: 80% of sales are on credit and terms are net 30 days (1 month). From past experience 60 percent of the accounts are collected 1 month after the sale, 30 percent are collected 2 months after the sale, and 10 percent are collected 3 months after the sale. Bad debts are negligible. Cost of Goods Sold/Purchases: The goods are ordered, received, and paid for in the month prior to sale. Purchases are equal to 80% of next month's sales and the gross profit margin is 40%. Administrative Expense: The administrative expense is $8,000 per month (which includes $2,000 for depreciation expense) plus a bonus of 5 percent of sales realized during the last quarter of the calendar year. This bonus is paid in February of each year. Dividends: In March, $12,000 in dividends will be paid. Taxes: The tax rate is 40 percent. For the past year, $4,000 in taxes must be paid by January 15, and no other taxes are payable in the period January to April. Salaries: Wages and salaries amount to 15 percent of the monthly dollar sales or $24,000, whichever is greater. Capital Expenditures: The company will buy new fixed assets for $40,000 in January. These assets have a five-year life with no residual value. 2 Prepare a schedule of cash receipts, a schedule of cash payments and a cash budget for the period January to April 2021. IF YOU USE EXCEL, COPY THE SPREADSHEET INTO YOUR PDF SUBMISSION. Schedule of Cash Receipts (in thousands of dollars) JAN. FEB. MARCH APRIL Taxes: The tax rate is 40 percent. For the past year, $4,000 in taxes must be paid by January 15, and no other taxes are payable in the period January to April. Salaries: Wages and salaries amount to 15 percent of the monthly dollar sales or $24,000, whichever is greater. Capital Expenditures: The company will buy new fixed assets for $40,000 in January. These assets have a five-year life with no residual value. 2 Prepare a schedule of cash receipts, a schedule of cash payments and a cash budget for the period January to April 2021. IF YOU USE EXCEL, COPY THE SPREADSHEET INTO YOUR PDF SUBMISSION. Schedule of Cash Receipts (in thousands of dollars) JAN. FEB. MARCH APRIL SHOW YOUR WORK (where needed): Schedule of Cash Payments (in thousands of dollars) JAN. FEB. MARCH APRIL SHOW YOUR WORK (where needed)