I need solution please

Question 2 (20 marks) Maxworth manufactures and sells formal coats. It is ready to begin its fourth quarter, in which they have their highest sales. The company has approached the Bank for a 90 -day loan of $12,000. The Bank has asked the corporation to submit a cash budget for the 90 days period. The following data has provided to you: a. At the beginning of the fourth quarter the cash balance will be $15,000 b. Sales figures is given below c. Budaeted raw materials purchase and expenses is aiven below d. Rent is always paid in the following month. e. Rent due for the month of September to be paid in October is $2,000 f. The company paid a dividend of $2,600 in December g. They bought a computer for $2,800 and paid in cash in November h. In preparing the cash budget, assume that the $12,000 loan will be taken in the beginning of October and repaid in December with interest of $120. Required: Prepare 1. Prepare a schedule of cash collections for the fourth quarter