Question

Lumpkin Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Lumpkin’s policy is to maintain an ending inventory balance equal to 10 percent of the following month’s cost of goods sold. April’s budgeted cost of goods sold is $40,000. Required Complete the inventory purchases budget by filling in the missing amounts.

Answer 1

February.

Desired ending inventory = 10% of March Cost of goods(COGS):

= 10% * 35,000

= $3,500

Inventory needed = COGS + ending inventory

= 32,000 + 3,500

= $35,500

Beginning inventory = January ending inventory = $3,200

Required Purchases = Inventory needed - Beginning inventory

= 35,500 - 3,200

= $32,300

March

Desired ending inventory = 10% of April COGS:

= 10% * 40,000

= $4,000

Inventory needed:

= 35,000 + 4,000

= $39,000

Beginning inventory = February ending inventory = $3,500

Required purchases:

= 39,000 - 3,500

= $35,500