Homework: Ch. 9 MyAcctgLab Assignment Save Score: 0 of 1 pt 2 of 9 (3 complete) HW Score: 18.8%, 1.69 of 9 pts E9-23A (similar to) A Question Help O Monty Manufacturing produces self-watering planters for use in upscale retail establishments. Sales projections for the first months of the upcoming year show the estimated unit sales of the planters each month to be as follows: B. (Click the icon to view additional Information.) Inventory at the start of the year was 390 planters and 2,328 kg of polypropeylene (a type of plastic). 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 3 kg of polypropylene. 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 kilogram. Requirements 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. (Use parentheses or a minus sign for negative beginning inventory balances. Round all answers up to the nearest number.) i Data Table Monty Manufacturing Production Budget A Requirements For the Months of January through March Number of planters to be sold January February March Quarter January 3,900 Unit sales 4601000 4877060 5120913 5325750 1. Prepare a production budget for each month in the first quarter of the year. February ... 3,700 Including production in units for each month and for the quarter. Plus: Desired ending inventory March....... 2. Prepare a direct materials budget for the polypropylene for each month in the 3,100 first quarter of the year, including the kilograms of polypropylene required and Total needed April 4,500 the total cost of the polypropylene to be purchased. Less: Beginning inventory May 4,900 Units to produce Print Done Print Done