Your friend, Catherine Ross, owns Knockoffs Unlimited, a nationwide distributor of low-cost imitation designer necklaces.She has contacted you for some assistance because the accounting clerk, George Forrest, recently won a sum of money and decided to resign immediately. Catherine knows that you are completing an accounting course at Cape Breton University and hopes you can prepare the cash budget for the upcoming quarter (April, May and June, 2021).

Catherine has provided you with the budgets completed by George. She has also provided you with additional information that will assist with the completion of the cash budget.

Completed Budgets (April, May, June, and Quarter Total, 2021)

Continued on the next page.

ADDITIONAL INFORMATION:

Cash balance, April 1, 2021 = $5,000

The company'smonthlyselling and administrative expenses are provided below. All selling and administrative expenses are paid in the month incurred, with the exception of depreciation and insurance. Insurance is paid on an annual basis in December of each year.

Variable expenses:

Commissions4% of sales

Fixed expenses:

Advertising$21,500

Rent20,500

Wages & salaries125,000

Utilities9,000

Insurance4,000

Depreciation19,000

The company plans to purchase new equipment for cash in May ($18,000) and June ($45,000).

The company wants to have an ending cash balance each month of $40,000. All borrowing is done at the beginning of the month. The interest on outstanding loans is 1% per month. Loan repayments and interest is only paid at the end of the month when there is sufficient cash to do so. (The company does not borrow to pay interest or repay loans.)

REQUIRED:

a.Prepare acash budget in good form. Show the budget by month and in total.

b.What will be reported on the budgeted balance sheet at June 30, 2021 for accounts receivable?Supporting calculations required.

c.What will be reported on the budgeted balance sheet at June 30, 2021 for merchandise purchases payable?Supporting calculations required.

You may use the template on the next page for the cash budget if you wish.