Austen Manufacturing produces self-watering planters for use in upscale retal establishments. Sales projections for the first...

Transcribed Image Text:

Austen Manufacturing produces self-watering planters for use in upscale retal establishments. Sales projections for the first five months of the upcoming year show the estimated unit sales of the planters each month to be as follows (Cack the icon to view additional information) wwentory at the start of the year was 350 planters. The desired inventory of planters at the end of each month should be equal to 10% of the following month's budgeted sales. Each planter requires two pounds of polypropylene (a type of plastic). The company wants to have 20% of the polypropylene required for next month's production on hand at the end of each month. The polypropylene costs $0.25 per pound Read the requirements Data table: Requirements Number of planters to be sold 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 January 3,500 2. February 3,400 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 March... 3,000 April... 4,000 May 4,200 Print Done Print Done - X Production Budget For the Months of January through March January February March Quarter Unit sales 3,500 3,400 3,600 10,500 Plus: Desired ending inventory 340 360 400 400 Total needed 3,840 3,760 4,000 10,900 Less: Beginning inventory 350 340 360 350 3,490 3,420 3,640 10,550 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 Start by preparing the direct materials budget through the total quantity needed, then complete the budget McKnight Manufacturing Direct Materials Budget For the Months of January through March January February March Quarter Units to be produced 3,490 3,420 3,640 10,550 Multiply by: Quantity of direct materials needed per unit 2' Quantity needed for production 6,980 6,840 7,280 21,100 Plus: Desired ending inventory of direct materials 1,368 1,456 1,608 1,608 Total quantity needed 8,348 8,296 8,888 22,708 Less: Beginning inventory of direct materials 1,396 1,368 1,456 1,396 Quantity to purchase 6,952 6,928 7,432 21,312 $ 0.25 $ 0.25 $ 0.25 $ 0.25 Multiply by: Cost per pound 1,738 $ 1,732 $ 1,858 $ 5,328 Total cost of direct material purchases Austen Manufacturing produces self-watering planters for use in upscale retal establishments. Sales projections for the first five months of the upcoming year show the estimated unit sales of the planters each month to be as follows (Cack the icon to view additional information) wwentory at the start of the year was 350 planters. The desired inventory of planters at the end of each month should be equal to 10% of the following month's budgeted sales. Each planter requires two pounds of polypropylene (a type of plastic). The company wants to have 20% of the polypropylene required for next month's production on hand at the end of each month. The polypropylene costs $0.25 per pound Read the requirements Data table: Requirements Number of planters to be sold 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 January 3,500 2. February 3,400 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 March... 3,000 April... 4,000 May 4,200 Print Done Print Done - X Production Budget For the Months of January through March January February March Quarter Unit sales 3,500 3,400 3,600 10,500 Plus: Desired ending inventory 340 360 400 400 Total needed 3,840 3,760 4,000 10,900 Less: Beginning inventory 350 340 360 350 3,490 3,420 3,640 10,550 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 Start by preparing the direct materials budget through the total quantity needed, then complete the budget McKnight Manufacturing Direct Materials Budget For the Months of January through March January February March Quarter Units to be produced 3,490 3,420 3,640 10,550 Multiply by: Quantity of direct materials needed per unit 2' Quantity needed for production 6,980 6,840 7,280 21,100 Plus: Desired ending inventory of direct materials 1,368 1,456 1,608 1,608 Total quantity needed 8,348 8,296 8,888 22,708 Less: Beginning inventory of direct materials 1,396 1,368 1,456 1,396 Quantity to purchase 6,952 6,928 7,432 21,312 $ 0.25 $ 0.25 $ 0.25 $ 0.25 Multiply by: Cost per pound 1,738 $ 1,732 $ 1,858 $ 5,328 Total cost of direct material purchases