Question

Eye Trendy Corporation is a distributor of frames for sunglasses. The company’s controller is currently preparing a budget for the third quarter of the year. The following information is from company’s financial records: Projected Sales July 3,120 units August 2,000 units September 2,640 units October 3,000 units • Selling price is RM25 per unit • Collections from customers are normally 70 per cent in the month of sale, 20 per cent in the month following sale, and 9 per cent in the second month following the sale. The balance is expected to be uncollectible. Projected Purchases • Purchase price is RM18 per unit. • All frames purchases are on account. 70 per cent of the frames purchased are paid for in the month of purchase; the remaining 30 per cent are paid for in the month after acquisition. • Inventory of frames on 1st July is 1,200 units. The frames inventory at the end of each month equals 20 per cent of sales anticipated for the following month. • The company purchases the frames as needed in multiple quantities of 1,000 units per shipment. Operating Expenses • General and administrative expenses are projected to be RM33,000 for the quarter. The breakdown of these expenses is presented in the following schedule. All cash expenditures will be paid uniformly throughout the quarter: Promotion RM9,000 Insurance RM12,000 Utilities RM7,500 Depreciation RM4,500 Total RM33,000 Other information • Cash proceeds from sale of old equipment amounted to RM5,000 in the month of August. • Purchase of new equipment amounted to RM50,000 is to be made in the month of September. • Eye Trendy is expected to maintain a minimum cash balance of RM20,000 at all times. If the cash balance is less than RM20,000 at the end of each month, the company borrows amounts necessary to maintain this balance. All amounts are repaid out of the subsequent positive cash flow. • The company’s cash balance on 1st July is RM22,000. Required: a. Prepare the following schedules: (i) Expected cash collections for the sales of frames during the third quarter. Show computations by month and in total for the quarter. (ii) Expected Cash disbursements for the purchases of frames during the third quarter. Show computations by month and in total for the quarter. (iii) Expected Cash balance on 30th September. Show computations by month and in total for the quarter. b. Refer to your answer in requirement (a). Prepare a schedule that shows whether or not the company meets the minimum cash requirement and compute the amount of borrowing required, if any, to maintain the firm’s minimum cash balance. c. How can a company’s board of directors use the different types of budget to influence the future direction of the firm? Please answer point b and c only

Answer 1