(THIS IS ALL THE information I HAVE )

I NEED A CASH DISBURSEMENTS BUDGET IN THIS FORMAT PLEASE HELP

EXAMPLE OF FORMAT :

Azia Company manufactures and sells Musk Perfumes. Information on budgeted sales in units is given below. Use this information to answer all parts of question one. a. The selling price of the Musk perfume is AED 140. b. All sales are on account. Based on past experience, sales are collected in the following pattern: c. The company maintains finished goods inventories equal to 22% of the following month's sales. The beginning inventory of finished goods on January 1st was 5,000 units d. Each bottle of perfume requires 7.5 grams of raw materials. e. The company requires that the ending inventory of raw materials be equal to 14% of the following month's production needs. The beginning inventory of raw materials inventory was on January 1st was 25,000 units f. The raw material costs AED 11 per gram. g. 65% of a month's purchases of raw materials is paid for in the month of purchase; the remaining is paid for in the following month. h. The accounts payable on December 31st will be AED 850,000 Required: Prepare: 1. Prepare a sales budget, by month and in total, for the First quarter. (3 marks) 2. Prepare a schedule of expected cash collections, by month and in total, for the First quarter. (15 marks) 3. Prepare a production budget for each of the months January, February, March and April. (10 marks) 4. Prepare a direct materials budget, by month and in total, for the First quarter. (12 marks) 5. Prepare a schedule of expected cash disbursements, by month and in total, for the First quarter. (10 marks) Accounts payable 3/31