proper answer of this question

in excel

The following information has been gathered to assit you in preparing the master budget for Fore Manufacturing Limited: July 1. Budgeted sales for the next four months are as follows: 20,000 August 25,000 September 22,000 October 21,000 The selling price is $60.00 per unit. Sales are 75% on credit & 25% cash. Of the credit sales 60% are collected in month of sale & 40% are collected in subsequent month. 2. The accounts receivable at June 30, 2021 of $346,000 will be collected in July. 3. The company produces enough units each month to meet the months sales plus a desired ending inventory equal to 20% of the next month's estimated sales. 4. Fore pays 50% of direct materials in the month of purchase & pays the remaining 50% in the following month. Each unit of product requires 8 kg of direct materials at a cost of $1.30 per kg. The company purchases enough direct materials each month for the current month's production and 15% of next month's production requirements. Beginning & ending inventory for the quarter of direct materials are budgeted to be 33,000 for beginning & 20,000 for ending. 5. The Accounts payable balance at June 30 of $120,588 will be paid in July. 6. The company plans to pays dividends of $10,000 in July & September. 7. Fore plans to purchase equipment for $15,000 in July & $75,000 in September. 8. Each unit produced requires 1.25 hours of direct labour at a cost of $20/hour. 9. The company wishes to maintain a minimum cash balance of $20,000 at the end of each month. 10. The company has an agreement with the local bank that allows them to borrow up to $100,000. The interest rate on the loans is 6% and there are no loans outstanding at June 30. All borrowing is done at the start of the month and all repayments are made at the end of the month. 11. The cash balance at June 30, 2021 is budgeted to be $26,500. Required: Using the excel file included in the assignment complete the following budgets for the third quarter of 2021 for Fore Manufacturing (July, August, September). Sales Budget & Schedule of Expected Cash Collections Production Budget Direct Materials - Purchases & Cash Disbursements Budget Direct Labour Budget Cash Budget