I am having a hard time solving this problem, and have not found any examples on course hero. I know that the top row is 3,000, 3200, 3100, then quarter is added, however I do not know how to find the plus desired. For less beg. inventory is it 3000 x .25?

Juda 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 750 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 two pounds of polypropylene (a type of plastic). 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.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. Juda Manufacturing Production Budget i Data Table - X For the Months of January through March January February March Quarter Unit sales Number of planters to be sold Plus: Desired ending inventory January . . . . . . 3,000 Total needed February . . . . . 3,200 Less: Beginning inventory March . . . . . . . . 3,100 Units to produce April . . . 4.200 May . . . . . . . . . 4,000