Assignment is due December 17, 2021 at 4:00 pm but can be submitted early.

The following information has been gathered to assit you in preparing the master

budget for Fore Manufacturing Limited:

1. Budgeted sales for the next four months are as follows:

July 20,000

August 30,000

September 22,000

October 21,000

The selling price is $50.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 $417,870 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 40% of direct materials in the month of purchase & pays the remaining 60% in the

following month. Each unit of product requires 8 kg of direct materials at a cost of $1.25 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.

The Accounts payable balance at June 30 of $146,200 will be paid in July.

The company plans to pays dividends of $10,000 in July & September.

Fore plans to purchase equipment for $15,000 in August & $25,000 in September.

Each unit produced requires 1 hours of direct labour at a cost of $20/hour.

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 $21,000.

Required:

Using the excel file included in the assignment complete the following budgets for the

third quarter of 2021 for Fore Manufacturing Limited (July, August, September).

Sales Budget & Schedule of Expected Cash Collections

Production Budget

Direct Materials - Purchases & Cash Disbursements Budget

Direct Labour Budget

Cash Budget

You may complete the assignment in excel or print out the template & complete it by hand.