Messinger

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:

LOADING...

(Click the icon to view additional information.) Inventory at the start of the year was

900

planters and

2,130

kg of polypropeylene (a type of plastic). 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

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.10

per kilogram.Requirements

LOADING...

Question content area bottom

Part 1

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.)

Messinger Manufacturing
Production Budget
For the Months of January through March
	January	February	March	Quarter
Unit sales
Plus: Desired ending inventory
Total needed
Less: Beginning inventory
Units to produce

	Number of planters to be sold
January. . . . .	3,600
February. . . .	3,400
March. . . . . .	3,200
April. . . . . . . .	4,800
May. . . . . . .	4,000