Eye Trendy is a distributor of frames for sunglasses. The store owner is in the process prepare a budget for the third quarter of this year. The following information is from the record company finances: Sales estimates July 3,120 units August 2,000 units September 2,640 units October 3,000 units  The selling price is RM25 per unit  Collection from customers is usually 70% in the month of sales, 20% of which is collected in the month following and 9% was collected in the second month. It is estimated that the remaining balance cannot be collected. Purchase budget  The purchase price of goods per unit is RM18.  70% of the purchase of spectacle frames is paid in the month the item is purchased. 30% is paid per month next.  The stock of spectacle frames as of July 1 was 1,200 units. The final stock of each eyeglass frame month equivalent to 20% of the estimated sales in the following month.  The company buys spectacle frames in the amount of 1,000 units per shipment. Operating Expenses  General and administrative expenses are estimated at RM33,000 for the quarter. The breakdown of these expenses is shown in the following table. All cash expenses will be paid uniformly throughout the quarter: Promotion RM9,000 Insurance RM12,000 Utilities RM7,500 Depreciation of RM4,500 Total RM33,000 Other information  Revenue from the sale of old equipment amounted to RM5,000 in August in cash.  Purchased new equipment worth RM50,000 which will be paid in September.  Eye Trendy is estimated to maintain a minimum cash balance of RM20,000 at all times. If the cash balance is less than RM20.00 at the end of each month, the company will make the loan amount required balance maintains the minimum balance. The loan will be repaid when the cash balance becomes positive.  The cash balance on July 1 is RM22,000. Taking into account the above information, you are required to provide such the following: a. Cash budget by showing calculations in forming a cash budget for third quarter. (20 marks) b. Refer to your answer in condition (a). Prepare a table showing whether the company it meets the minimum cash requirement or not and calculate the loan amount required, if any, to maintain the companys minimum cash balance. (5 marks) c. Explain briefly how a budget can help the board determine the future of the company? (5 marks) (Total: 30 marks)

Kindly provide the detail calculation especially in purchase budget, TQ :)