Need completed in excel format

Managerial Accounting: Operating budgets 1. Abe Toys, LLC manufactures and distributes a number or products to retailers. One of these products, Playclay, requires three pounds of materials A135 in the manufacture of each unit. The company is now planning raw materials needs for the third quarter - July, August, and September. Peak sales of Playclay occur in the third quarter of each year. To keep production and shipments moving smoothly, the company has the following inventory requirements: a. The finished goods inventory on hand at the end of each month must be equal to 5,000 units plus 30% of the next month's sales. The finished goods inventory on June 30 is budgeted to be 17,000 units. b. The raw materials inventory on hand at the end of the month must be equal to one-half of the following month's production needs for raw materials. The raw materials inventory on June 30 for material A135 is budgeted to be 64,500 pounds. The cost per pound of raw material is $5.00. c. The company maintains no work in process inventories and the selling price per unit of Playclay is $39.50. A sales budget for Playclay for the last six months of the year follows: July August September October November December Budgeted Sales in Units 40,000 50.000 70.000 35,000 | 20,000 10.000 Required: a. Prepare a sales budget for Playclay for the months of July, August, and September, and for the quarter in total. b. Prepare a production budget (finished goods) for Playclay for the months of July, August, and September, and for the quarter in total. c. Prepare a direct materials budget showing the quantity of material A135 to be purchased and total direct materials purchased cost for July, August, and September and for the quarter in total