Question

8. The TS Company has budgeted sales for the year as follows: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Sales in units 10,000 12,000 14,000 16,000 The ending inventory of finished goods for each quarter should equal 25% of the next quarter's budgeted sales in units. The finished goods inventory at the start of the year is 2,500 units. Four pounds of raw materials are required for each unit produced. Raw materials on hand at the start of the year total 4,200 pounds. The raw materials inventory at the end of each quarter should equal 10% of the next quarter's production needs in material Required: • Prepare production budget. • Prepare direct material budget.

Answer 1

Answer:

Results are below.

Explanation:

First, we need to determine the production budget using the following formula:

Production= sales + desired ending inventory - beginning inventory

Quarter 1:

Production= 10,000 + (0.25*12,000) - 2,500

Production= 10,500

Quarter 2:

Production= 12,000 + (0.25*14,000) - 3,000

Production= 12,500

Quarter 3:

Production= 14,000 + (0.25*16,000) - 3,500

Production= 14,500

Quarter 4:

Production= 16,000 - 4,000

Production= 12,000

Now, the direct material purchase budget:

Purchases= production + desired ending inventory - beginning inventory

Quarter 1:

Purchase= 10,500*4 + (12,500*0.1) - 4,200

Purchase= 39,050 pounds

Quarter 2:

Purchase= 12,500*4 + (14,500*0.1) - 1,250

Purchase= 50,200 pounds

Quarter 3:

Purchase= 14,500*4 + (12,000*0.1) - 1,450

Purchase= 57,750 pounds

Quarter 4:

Purchase= 12,000*4 - 1,200

Purchase= 46,800 pounds