Rosie owns and operates Sunshine Berries, which sells a variety of berries and other summer fruits. Rosie is unsure why the business is not doing as well as she thought it would, especially given recent growth in sales. Her accountant suggested that she start preparing cash budgets for the business. Rosie has compiled the following figures: 2022 Estimates Apr May Jun Jul Sales $35,750 $41,250 $42,900 $42,900 Purchases 17,875 20,625 21,450 21,450 Wages 6,000 6,000 6,000 6,000 Selling expenses 3,600 3,600 3,600 2,600 Depreciation 750 750 750 750 Additional information: The bank balance at March 31, 2022 is expected to be $3,000. All customers are given 30-day credit terms, however 60 per cent choose to pay cash. Past experience shows that debtors usually settle their accounts according to the following pattern: 80 per cent in the month following the sale 15 per cent in the second month following the sale 5 per cent in the third month following the sale Actual sales figures for 2022 are as follows: January: $32,450 February: $33,000 March: $30,800 Seventy (70) per cent of the purchases of the berries and fruit are paid for in the month of purchase, with the remainder paid for in the following month. Purchases in March 2022 are $15,400. Annual insurance expense of $4,800 for the 12-month period from January to December 2022 was paid in January 2022. The monthly insurance amount is included in the selling expenses figure above. New office equipment will be purchased in April for $7,200 and will be paid for in May. Interest of $1,200 is charged at the end of each quarter for the existing loan and paid in the first month of the following quarter. Principal repayments are $6,500 per month. Additional cash can be borrowed from the bank monthly at an interest rate of 9.00 per cent per annum. Interest is charged monthly in the month following the borrowing, 5. Using the Cash Budget Template (MS Excel) provided in Module 3, prepare a cash receipts budget for Sunshine Berries for the April - June 2022 quarter. Include a copy of the cash receipts budget in your document containing your written assignment answers. (15 marks) 6. Using the Cash Budget Template (MS Excel) provided in Module 3, prepare a cash disbursements budget for Sunshine Berries for the April - June 2022 quarter. Include a copy of the cash disbursements budget in your document containing your written assignment answers. (14 marks) Assignment 1 continues on the next page Assignment 1 continued 7. Using the Cash Budget Template (MS Excel) provided in Module 3, prepare a summary cash budget for Sunshine Berries for the April - June 2022 quarter. Include a copy of the summary cash budget in your document containing your written assignment answers. (9 marks) 8. Explain to Rosie, using specific examples, how a minimum cash balance of $2,000 would benefit her business AND the effect it would have on her cash budget