Data table Number of planters to be sold January.. 3,600 February..... 3,300 March...... 3,100 April........ 4,700 May 4,900 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. Requirement 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. Johnson Manufacturing Production Budget For the Months of January through March Unit sales Plus: Desired ending inventory Total needed Less: Beginning inventory Units to produce January February March Quarter 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 required and the total cost of the polypropylene to be purchased Start by preparing the direct materials budget through the total quantity needed, then complete the budget. Johnson Manufacturing Direct Materials Budget For the Months of January through March January February March Quarter Multiply by Units to be produced Quantity of direct materials needed per unit Desired ending inventory of direct materials Quantity needed for production Plus: Total quantity needed Less Beginning inventory of direct materials Quantity to purchase Multiply by: Cost per pound Total cost of direct material purchases Solowy Johnson Manufacturing produces self watering planters for use in spscale retal establishments Sales projections for the test five months of the upcoming year show the estimated unt ses of the planters wich month Click the icon to view addnional information) Inventory at the start of the year was 000 planters. The desired inventory of planners at the end of each month should be equal to 25% of the following month's budgeted as Each par request of type of plastic). The company wants to have 10% of the polypropylene required for next month's production on hand at the end of each month. The polypropylene costs $0.20 per pound Read the auments Data table Number of planters to be sold Jaary. 3,600 February 3,300 March........ 3,100 April....... 4,700 May 4,900 - X 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. Requirement 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. Johnson Manufacturing Production Budget For the Months of January through March Unit sales Plus: Desired ending inventory Total needed Less: Beginning inventory Units to produce January February March Quarter 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 required and the total cost of the polypropylene to be purchased Start by preparing the direct materials budget through the total quantity needed, then complete the budget Johnson Manufacturing Direct Materials Budget For the Months of January through March Units to be produced Multiply by Quantity of direct materials needed per unit Quantity needed for production Plus Desired ending inventory of direct material Beginning inventory of direct materials Total quantity needed Less Quantity to purchase Multiply by Cost per pound January February March Quarter Johnson Manufacturing Direct Materials Budget For the Months of January through March Units to be produced Multiply by: Quantity of direct materials needed per unit Quantity needed for production Plus: Total quantity needed Less: Desired ending inventory of direct materials Beginning inventory of direct materials Quantity to purchase Multiply by: Cost per pound Total cost of direct material purchases January February March Quarter