Beckett Manufacturing produces self-watering panters for use in upscale retail 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 fol lows E (Click the icon to view additional information.) r entory a ne 8 arto the year was 775 planters. The desired im entory o plantera at he end of each month should be equal to 25% o the o owing month's budgeted sales. Each planter requires three pounda o polypro 20% of the polypropylene required for next month's production on hand at the end of each month. The polypropylene costs $0.20 per pound. ene a pe o plastic The company wants to have 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. Beckett Manufacturing Production Budget For the Months of Jan uary through March January February March Quarter Unit sales Plus: Desired ending inventory Total needed Less: Beginning inwentory Units to produce Requirement 2. Prepare a direct materia's 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 budgst through the total quantity needed, then complete the budget Beckett Manufacturing Direct Materials Budget For the Months of January through March Data Table January February March Quarter Units to be produced Muliply by: Quantity of direct materials needed per unit Quantity needed for production Plus: Total quantity needed Less: Quantity to purchase Multiply by: Cost per pound Total coet of direct material purchases Number of planters to be sold January February March Aprl May 3,100 3,200 3,000 4,200 4,400 Desired ending inventory of direct materials Beginning inventory of direct materials Print Done