Please do it correct and do all four parts a, b, c and d of the Required Prepare as per chegg policy

Required Prepare: a. Prepare a sales budget, by month and in total, for the quarter. b. Prepare a schedule of expected cash collections, by month and in total, for the quarter. c. Prepare a production budget for each months of the quarter. d. Prepare a direct materials budget, by month and in total for the quarter. Prepare a schedule of expected cash disbursements, by month and in total, for the quarter. The data below pertains to the first quarter of Milo Company which manufactures umbrellas. Below is the estimated sales in units): January 50,250 February 70,250 March 60,250 April 40,250 May 30,250 June 20,250 a. The selling price of the umbrella is $15 per unit. b. All sales are on account. Based on past experience, sales are collected in the following pattern: Month of sale Month following sale Uncollectible 30% 65% 5% C. Sales for December of last year totaled $300,000. d. The company maintains finished goods inventories equal to 20% of the following month's sales. This requirement will be met at the end of December of the previous year. e. Each toy requires 5 pounds of raw materials. f. The company requires that the ending inventory of raw materials be equal to 30% of the following month's production needs. g. The raw material costs $1.20 per pound. h. 40% of a month's purchases of raw materials is paid for in the month of purchase; the remainder is paid for in the following month. i The accounts payable on December 31 of last year was $76,000