Ending raw materials inventory budget The following production quantity budget has just been received by the materials manager of Sid N. Reed Furniture Company:

Transcribed Image Text:

Production Quantity Budget for Chair Model 7D For Four Quarters Ending December 31 Budgeted sales..... Desired ending inventory Total requirement.. Less beginning inventory Budgeted production ... Quarter 1 2 3 6,000 8,000 9,000 7,000 1,000 1,500 2,000 1,800 7,000 9,500 11,000 8,800 800 1,000 1,500 2,000 6,200 8,500 9,500 6,800 Chair Model 7D requires the following materials and ending inventories: Required Ending Inventory at End of Material Quantity Previous Quarter Metal tubing 10 ft. 20% Plywood 2.5 sq. ft. 10% Vinyl 12 sq. ft. 20% Foam padding 2 lbs. 50% The percentages in the above schedule indicate how much of each quarter's material requirement should be in the ending inventory of the previous quarter. Beginning inventories are expected to be as follows: Metal tubing Plywood Vinyl Foam padding 11,000 ft. 1,800 sq. ft. 15,000 sq. ft. 5,000 lbs.