DUnique Enterprise, a company that manufactures hair growth oil is preparing for its upcoming financial year (2021). DUnique is seeking a loan from JNT Bank to purchase equipment that will be used to package the oils in anticipation of sales. The loans officer at the bank is requesting the companys upcoming financial years budget to assess their cash position to repay the loan

The following information was used to prepare the master budget for DUnique Enterprise:

A. Sales/Collection

Sales unit in the fourth quarter of 2020 will be 2500 units and is expected to increase by 500 units over each quarter in 2021. Selling price is $60 per unit.

All sales are on account. Management expects future sales collection to follow past experiences. Customers pay 60% in the quarter of sales and 40% in the quarter following sales. Accounts receivable for December 31, 2020 is expected to be $60,000.

B. Production

To reduce the risk of a stock-out or idle time, DUnique Co. has maintained an ending inventory policy of 20% of the following quarters sales unit.

C. Direct material

Each bottle of hair growth oil requires four ounces of liquid which cost $3.50 per ounce.

The company wants to maintain an ending inventory of raw materials equal to 10% of the next quarters production requirements. Ending inventory of raw material for the fourth quarter of 2020 will be 1,520 ounces.

Payments to suppliers for the purchase of direct material are done in two tranches - 70% in the quarter of purchase and 30% the quarter following purchase. Accounts payable of $10,600 at December 31, 2020, is expected to be paid in full in the first quarter of 2021.

D. Direct Labour

As the company is still labour intensive, one bottle takes an employee one hour to package. The standard wages rate of direct labour is $10.00 per hour.

E. Manufacturing Overhead

DUnique Company manufacturing overheads is absorbed on the basis of direct labour hours. The following variable cost rates are:

1. Indirect materials $1.00

2. Indirect labor $1.40

3. Utilities $0.40

4. Maintenance $0.20

DUnique also recognizes the following fixed manufacturing overheads costs per quarter:

Fixed Overhead $

Supervisors salary 20,000

Depreciation 3,800

Property tax 9,000

maintenance 5,700

F. Selling and Administrative Expense

Variable selling and administrative expense rates per unit of sales are: sales commissions $3.00 and freight-out $1.00.

Fixed expenses for each quarter are:

Fixed Costs $

Advertising 6,500

sales salaries 15,000

office salaries 4,000

depreciation 3,500

property taxes and insurance 2,500

G. Other expenses

1. Management plans to purchase a delivery truck in the first quarter for $100,000 cash. This will be a loan from the bank in the first quarter of 2021. Interest rate on the loan is 4% per annum.

2. DUnique makes equal quarterly payments of its estimated annual income taxes of $36,000.

H. Other information

The company is expected to have a cash balance of 65,000 on January 1, 2021. The company wants to maintain a minimum cash balance of $15,000.

Loan and interest payments are made in multiples of 10,000 in the earliest quarter in which there is sufficient cash (that is, when the cash on hand exceeds the $15,000 minimum required balance).

Required

Prepare the following budgets:

1. Sales Budget [7 marks]

2. Cash collection Schedule [10 marks]

3. Production [17 marks]

4. Direct material [21 marks]

5. Cash disbursement schedule [9 marks]

6. Labour [11 marks]

7. Manufacturing overheads [29 marks]

8. Selling and admin [20 marks]

9. Cash budget [36 marks]

1-4 has already been answred my issues is really the last parts as I have attemted them myself. can someone post 7-9?

I know chegg only allows 4 so please post 6-9

1 02 Q3 Budgeted Sales units Budgeted Selling price per unit Budgeted Sales (value) Sales Budget Q1 3,000 $60 180,000 3,500 $60 210,000 4,000 $60 240,000 Q4 4,500 $60 270,000 Full year 15,000 $60 900,000 2 Schedule of cash collections Q1 Current quarter collection (60% of sales) 108,000 Prior quarter collection (40% of sales) 60,000 Total cash collections 168,000 In Q1, Accounts receivable balance is collected in prior quarter collection Q2 126,000 72,000 198,000 Q3 144,000 84,000 228,000 Q4 162,000 96,000 258,000 Full year 540,000 96,000 852,000 3 Full year Q2 5,500 Production Budget Q1 Budgeted Sales 3,000 Add: Desired Ending inventory (20% of next month sales) 700 Total Needs 3,700 Less: Beginning Inventory Production Budget 3,100 Q2 3,500 800 4,300 Q3 4,000 900 04 4,500 1,000 5,500 900 4,600 2022 Q1 5,000 1,100 6,100 1,000 5,100 15,000 1,000 16,000 600 15,400 4,900 600 700 800 3,600 4,100 4 Full year 4 Direct Material Purchase Budget Q1 Q2 Budgeted production 3,100 3,600 Material needed per production unit (ounces) Budgeted material needed for production 12,400 14,400 Add: Closing inventory (10% of following month need) 1,440 1,640 Total Needs 13,840 16,040 Less: Beginning Inventory 1,520 1,440 Purchase Budget-Direct Material (ounces) 12,320 14,600 Purchase price per ounce $3.50 $3.50 Total Direct Material Purchase Budget (Value) $43,120 $51,100 Q3 4,100 4 16,400 1,840 18,240 1,640 16,600 $3.50 $58,100 Q4 4,600 4 18,400 2,040 20,440 1,840 18,600 $3.50 $65,100 Q1 2022 15,400 5,100 4 61,600 20,400 2,040 63,640 1,520 62,120 a $3.50b $21,420 *