Burr Corp. (Burr) is a manufacturer of recycling bins. Burr's statement of financial position at December 31, 2020, is as follows: Assets Cash $ 10,000 Accounts receivable (net of $2,400 allowance) 77,600 Inventory 24,750 Prepaid expenses 1,600 113,950 Property, plant, and equipment (net) 108,000 $221,950 Liabilities and shareholders' equity Bank loan $ 50,000 Accounts payable 46,025 Income taxes payable 2,000 98,025 Common shares 62,000 Retained earnings 61,925 123,925 $221,950 Information related to 2021 is as follows: 1. Burr collects cash from 60% of its sales in the quarter in which the sale is made and 37% in the following quarter. Historically, 3% of sales are uncollectable. 2. Burr's sales are cyclical, with the highest sales at the end of the year when customers stock up before the spring. Projected 2021 quarterly sales are as follows: 1st quarter $160,000 2nd quarter 160,000 3rd quarter 190,000 4th quarter 230,000 $740,000 The projected 2021 quarterly sales are based on the assumption that the bank will advance an additional $70,000 at the beginning of the first quarter to purchase replacement manufacturing equipment. Burr pays 4% interest per year on its bank loans, calculated quarterly on the opening balance. 3. Variable cost of goods sold equals 55% of sales. Variable selling and office expenses (excluding interest and taxes) amount to about 14% of the variable cost of goods sold. Burr's payments are made 65% in the quarter the expense is incurred and 35% in the following quarter. Page 5 Intermediate Management Accounting Copyright 2021 Chartered Professional Accountants of Canada. All rights reserved. (CONTINUED ON PAGE 6) 4. Rent, utilities, and other fixed payments relating to occupancy of the premises, excluding depreciation, will be $5,000 per quarter. Income tax instalment payments of $7,000 must be made each quarter. 5. Payments for fixed salaries are expected to amount to $12,000 per month, EXCEPT during the peak shipping months of September, October, and November, when payments should be $14,000 per month. 6. Burr's policy is to use any excess cash at the end of a given quarter to repay the bank loan. The cash balance must always remain above zero. Repayments of the bank loan must be made in increments of $10,000. Required: Prepare a cash budget, by quarter, for the year ending December 31, 2021. Show the bank loan balance at the end of each quarter, and show all calculations