please can you help me finish requirement 2? i cant get this problem at all! thanks!
Requirements 1. Prepare a production budget for each month in the first quarter of the year, including production in units for each month and for the quarter. 2. Prepare a direct materials budget for the polypropylene for each month in the first quarter of the year, including the pounds of polypropylene required and the total cost of the polypropylene to be purchased. Done Print quarter Data Table Number of planters to be sold January 3,400 ... ... 3,800 February ... March..... 3,300 4,900 April .... 4,600 May . ... Done Print A E9-22A (similar to) Question Help Austen Manufacturing produces self-watering planters for use in upscale retail establishments. Sales projections for the fist fve months of the upcoming year show the estimated unit sales of the planters each month to be as ollows: Em Cick the icon to view additional information.) Inventory at the start of the year was 850 planters. The desired inventory of planters at the end of each month should be equal to 25% of the folowing month's budgeted sales. Each planter requires tvee pounds of polypropylere ja hpe of plastic). The company wants to have 20% of the polypropylene required for next monts production on hand at the end of each month. The polypropylene costs S0 20 per pound Read the requirements Requirement 1. Prepare a production budget for each month in he frst quarter of the year, including production in unts for each month and for the quarter. Austen Manufacturing Production Budget For the Months of January through March February Quarter January March 3,300 10.500 3,400 3,800 Unit sales 825 1.225 1,225 950 Plus: Desired ending inventory 4.525 11,725 4,350 4,625 Total needed 850 960 25 850 Less Beginning inventory 10,A75 3,675 3,700 3,500 Units to produce Requirement 2. Prepare a direct materials budget for the polypropylene for each month in the first quarter of the year, including the pounds of polypropylene reguired and the total ocost of the polprapyere to be purchased Start by preparing the direct materials budget through the totat quantty needed, then complete the budget Austen Manufacturing Direct Materials Budget For the Months of January through March Quarter March February January 10.875 3.700 3.675 3,500 Units to be produced Check Anwer Enter any number in the edit fields and then click Check