Question: please help with the blank spaces ge us Pr onth Data table Number of planters to be sold 3,900 3,200 3,700 4,400 4,900 January ......






ge us Pr onth Data table Number of planters to be sold 3,900 3,200 3,700 4,400 4,900 January ...... February ..... March........ April...... May ******* Print Done - Xqual to f the po reach m tor 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. Print Done - X and f Austen Manufacturing produces self-watering planters 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 follows: (Click the icon to view additional information.) Inventory at the start of the year was 975 planters. The desired inventory of planters at the end of each month should be equal to 25% of the following month's budgeted sales. Each planter requires four pounds of polypropylene (a type of plastic). The company wants to have 30% 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 equirement 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. Austen Manufacturing Production Budget For the Months of January through March January February 3,200 925 3,900 800 4,700 975 3,725 4,125 800 March 3,325 Unit sales Plus: Desired ending inventory Total needed i Less: Beginning inventory 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 required 3,700 1.100 Quarter 4,800 925 3,875 10,800 1,100 11,900 975 10,925 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 Austen Manufacturing Austen 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: Quantity to purchase Desired ending inventory of direct materials Beginning inventory of direct materials January February 3,725 3,325 14,900 3,990 18,890 13,300 4,650 17,950 March 3,875 15,500 5,430 20,930 Quarter 10,925 43,700 5,430 49,130 For the Months of January through March January Units to be produced Multiply 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 cost of direct material purchases Desired ending inventory of direct materials Beginning inventory of direct materials 3,725 14,900 3,990 18,890 February March 3,325 13,300 4,650 17,950 3,875 15,500 5,430 20,930 Quarter 10,925 43,700 5,430 49.130
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
