May 2020 8,500 The selling price of the shirt is AED 60 b. All sales are on account. Based on past experience, sales are collected in the following pattern: Month of sale Month following sale Second month following sale 45% 45% 10% c. The company maintains finished goods inventories equal to 25% of the following month's sales. The beginning inventory of finished goods on January 15 was 2200 units d. Each Bag requires 4.5 yards of raw materials. e. The company requires that the ending inventory of raw materials be equal to 15% of the following month's production needs. The beginning inventory of raw materials inventory was on January 1" was 5750 units f. The raw material costs $12 per yard. 8.30% 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 31" will be $380,000. Required: Prepare: 1. Prepare a sales budget, by month and in total, for the First quarter. 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 10% Second month following sale c. The company maintains finished goods inventories equal to 25% of the following month's sales. The beginning inventory of finished goods on January 1 was 2200 units d. Each Bag requires 4.5 yards of raw materials. e. The company requires that the ending inventory of raw materials be equal to 15% of the following month's production needs. The beginning inventory of raw materials inventory was on January 1" was 5750 units f. The raw material costs $12 per yard. 2. 30% 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 $380,000 Required: Prepare: 1. Prepare a sales budget, by month and in total, for the First quarter. marks) Prepare a schedule of expected cash collections, by month and in total, for the First quarter. (15 marks) 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. marks) (15 7:32 Back Budget Project V4_Hessa, Noora Fitness World Company is a manufacturer and seller of sports bags. Information on budgeted sales in units is given below. Use this information to answer all parts of question one. Month Sales in Units November 2019 10,000 December 2019 8.000 January 2020 11,000 February 2020 13.000 March 2020 11,500 April 2020 17,000 May 2020 8.500 a. The selling price of the shirt is AED 60 b. All sales are on account. Based on past experience, sales are collected in the following pattern: Month of sale Month following sale Second month following sale 45% 45% 10% c. The company maintains finished goods inventories equal to 25% of the following month's sales. The beginning inventory of finished goods on January 15 was 2200 units d. Each Bag requires 4.5 yards of raw materials. .. The company requires that the ending inventory of raw materials be equal to 15% of the following month's production needs. The beginning inventory of raw materials inventory was on January 1" was 5750 units 1. The raw material costs $12 per yard. 30% 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