Johnson 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 EE (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% ofthe polypropylene required for next month's production on hand at the end of each month. The polypropylene costs $0.20 per pound. Read the 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. Johnson Manufacturing Production Budget For the Months of January through March Data Table January February March Quarter Number of planters to be sold Unit sales Plus: Desired ending inventory Total needed Less: Beginning inventory Units to produce January . Fobruary March April May 3,900 3,200 3,700 4,400 4,900 Print Done Enter any number in the edit fields and then click Check