I NEED A DIRECT MATERIAL BUDGET IN THIS FORMAT PLEASEEEE!!!!!

EXAMPLE::::

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 4. Prepare a direct materials budget, by month and in total, for the First quarter. (12 marks) Forever Tuna, Inc. Direct Materials Budget For the Year Ended December 31, 2013