Question

In: Accounting

Thornton Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory...

Thornton Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Thornton’s policy is to maintain an ending inventory balance equal to 15 percent of the following month’s cost of goods sold. April’s budgeted cost of goods sold is $84,000

Required

  1. Complete the inventory purchases budget by filling in the missing amounts.

  2. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement.

  3. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter.

A.
Inventory Purchases Budget
January February March
Budgeted cost of goods sold $56,000 $60,000 $66,000
Plus: Desired ending inventory 9,000
Inventory needed 65,000
Less: Beginning inventory 8,400
Required purchases (on account) $56,600

Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter.

b. Cost of goods sold:   
c. Ending inventory:

Solutions

Expert Solution

  1. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter.

A.
Inventory Purchases Budget
January February March
Budgeted cost of goods sold $56,000 $60,000 $66,000
Plus: Desired ending inventory 9,000 9900 12600
Inventory needed 65,000 69900 78600
Less: Beginning inventory 8,400 9000 9900
Required purchases (on account) $56,600 60900 68700

Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter.

b. Cost of goods sold: 56000+60000+66000 = 182000
c. Ending inventory: 12600

Related Solutions

Rundle Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory...
Rundle Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Rundle’s policy is to maintain an ending inventory balance equal to 15 percent of the following month’s cost of goods sold. April’s budgeted cost of goods sold is $83,000. Required Complete the inventory purchases budget by filling in the missing amounts. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. Determine...
Perez Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory...
Perez Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Perez’s policy is to maintain an ending inventory balance equal to 20 percent of the following month’s cost of goods sold. April’s budgeted cost of goods sold is $78,000. Required Complete the inventory purchases budget by filling in the missing amounts. Inventory Purchases Budget January February March Budgeted cost of goods sold $53,000 $57,000 $63,000 Plus: Desired ending inventory 11,400 Inventory needed...
Campbell Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget.
 Campbell Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Campbell'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 $79,000. Required a. Complete the inventory purchases budget by filling in the missing amounts. b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. c. Determine the...
Adams Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget.
 Adams Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Adams'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 $83,000. Required a. Complete the inventory purchases budget by filling in the missing amounts. b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. c. Determine...
Baird Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget.
 Baird Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Baird'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 $79,000. Required a. Complete the inventory purchases budget by filling in the missing amounts. b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. c. Determine the...
Galaxy Lighting Company manufactures and sells lighting fixtures. Estimated sales for the next three months are:...
Galaxy Lighting Company manufactures and sells lighting fixtures. Estimated sales for the next three months are: September $ 350,000 October $ 500,000 November $ 400,000 Sales for August were $400,000 and December is estimated as $420,000. All sales are on account. Galaxy Lighting Company estimates that 80% of the accounts receivable are collected in the month of sale with the remaining 20% collected the following month. The units sell for $40 each. Generally, 60% of purchases are due and payable...
Laval produces lamps and home lighting fixtures. Its most popular product is a brushed aluminum desk...
Laval produces lamps and home lighting fixtures. Its most popular product is a brushed aluminum desk lamp. This lamp is made from components shaped in the fabricating department and assembled in the assembly department. Information related to the 25,000 desk lamps produced annually follows. Direct materials $ 260,000 Direct labor Fabricating department (5,500 DLH × $27 per DLH) $ 148,500 Assembly department (16,200 DLH × $22 per DLH) $ 356,400 Machine hours Fabricating department 14,900 MH Assembly department 20,350 MH...
Laval produces lamps and home lighting fixtures. Its most popular product is a brushed aluminum desk...
Laval produces lamps and home lighting fixtures. Its most popular product is a brushed aluminum desk lamp. This lamp is made from components shaped in the fabricating department and assembled in the assembly department. Information related to the 31,000 desk lamps produced annually follows. Direct materials $ 255,000 Direct labor Fabricating department (6,000 DLH × $23 per DLH) $ 138,000 Assembly department (15,400 DLH × $22 per DLH) $ 338,800 Machine hours Fabricating department 14,700 MH Assembly department 20,400 MH...
Laval produces lamps and home lighting fixtures. Its most popular product is a brushed aluminum desk...
Laval produces lamps and home lighting fixtures. Its most popular product is a brushed aluminum desk lamp. This lamp is made from components shaped in the fabricating department and assembled in the assembly department. Information related to the 27,000 desk lamps produced annually follows. Direct materials $ 270,000 Direct labor Fabricating department (9,500 DLH × $32 per DLH) $ 304,000 Assembly department (16,200 DLH × $25 per DLH) $ 405,000 Machine hours Fabricating department 14,400 MH Assembly department 20,350 MH...
Laval produces lamps and home lighting fixtures. Its most popular product is a brushed aluminum desk...
Laval produces lamps and home lighting fixtures. Its most popular product is a brushed aluminum desk lamp. This lamp is made from components shaped in the fabricating department and assembled in the assembly department. Information related to the 25,000 desk lamps produced annually follows. Direct materials $ 265,000 Direct labor Fabricating department (9,500 DLH × $31 per DLH) $ 294,500 Assembly department (16,000 DLH × $23 per DLH) $ 368,000 Machine hours Fabricating department 14,300 MH Assembly department 21,200 MH...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT