Question: SECTION B: PROBLEM QUESTIONS Answer ALL questions. QUESTION 1 Hazlett Company operates at capacity and makes plastic hairbrushes. Hazlett is preparing its cash budget for

 SECTION B: PROBLEM QUESTIONS Answer ALL questions. QUESTION 1 Hazlett Company
operates at capacity and makes plastic hairbrushes. Hazlett is preparing its cash

SECTION B: PROBLEM QUESTIONS Answer ALL questions. QUESTION 1 Hazlett Company operates at capacity and makes plastic hairbrushes. Hazlett is preparing its cash budget for the first quarter of 2020 and has estimated sales based on past experience. The following information is gathered by the management accountant. However, some of the information is missing or incomplete, which requires further attention. January RM80,000 RM16,830 February RM95,000 RM18,790 March RM92,500 RM17,520 RM18,150 RM16,300 RM18,950 Budgeted sales (RM5 per unit) Budgeted direct material purchases (RM5 per kg) Budgeted direct labour costs (RM10 per direct labour hour) Allocation of manufacturing overhead cost (based on direct labour hours): Fixed Variable (RM0.20 per direct labour hour) RM10,680 ? RM10,680 ? RM10,680 ? Budgeted monthly operating expenses: Selling RM0.15 per unit sold General administration RM14,200 per month RM 5,100 Statement of Financial Position as at 31 December 2019 RM Assets Cash Account receivable 21,400 Less: Allowance for bad debts 900 Inventories Direct materials 5,600 20,500 14,200 8,000 200,000 50,200 Finished goods Fixed assets Less: Accumulated depreciation Total assets 149,800 189,600 had debt. . . Liabilities 7.245 Accounts payable 6,500 Insurance payable 8,700 Taxes payable 100,000 Common stocks Retained earnings 67,155 Total liabilities and equity 189,600 Ten percent of the sales are for cash. Of the credit sales, 60% are collected in the month of sales, 35% are collected the following month, and 5% are never collected and written off All purchases of materials are on account. Hazlett pays for 50% of purchase in the month of purchase and the remaining in the following month. All other operating costs are paid in the month incurred, including: the declaration and distribution of a RM4.000 cash dividend in January, and the distribution of a RM5,000 cash donation in February. RM2,680 of the budgeted fixed manufacturing overhead costs, and 10% of budgeted general administration costs are allocation for depreciation. Hazlett plans to pay the taxes payable and insurance payable owed as of December 31, 2019 in the month of January A new machine costing RM50,000 will be purchased in the month of February. Hazlett plans to pay a deposit of RM10,000 in the month of purchase, and the balance shall be paid in two equal instalments - in March and April Under new management, Hazlett is required to maintain a minimum monthly cash balance of RM10,000. If borrowing is necessary to meet the monthly cash balance requirement, Hazlett can apply for a short-term loan (0.5% interest per month) from KHF Bank in increments of RM1,000, up to a total loan balance of RM40.000. The repayment of the loan, including the interest, will be initiated when excess cash is available (assume the borrowing occurs at the beginning of the month and repayment at the end of the month). . . . . Required: 1. For the months of January, February, March and the quarter (total), prepare the: a schedule of expected cash collections, b. schedule of expected cash disbursement for direct material purchases, and c. cash budget. (18 marks) 2. Suppose that a unit of hairbrush requires 200 grams of blended plastic mixture (materials) and 0.1 hours of direct labour. Calculate the expected gross margin for the first quarter of 2020

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!