The purchasing department manager for Rooney Company prepared the following supplies purchases budget. Rooney’s policy is to maintain an ending supplies balance equal to 10 percent of the following month’s supplies expense. April’s budgeted supplies expense is $83,000.
Required
Complete the supplies purchases budget by filling in the missing amounts.
Determine the amount of supplies expense the company will report on its first quarter pro forma income statement.
Determine the amount of ending supplies the company will report on its pro forma balance sheet at the end of the first quarter.
Answer
--Requirement A
January | February | March | |
Budgeted supplies expense | $51,000 | $55,000 | $61,000 |
Plus: Desired ending supplies | $5,500 | $6,100 | $8,300 |
Supplies needed | $56,500 | $61,100 | $69,300 |
Less: Beginning supplies | $5,100 | $5,500 | $6,100 |
Required purchases (on account) | $51,400 | $55,600 | $63,200 |
>Working
January | February | March | |
Budgeted supplies expense | 51000 | 55000 | 61000 |
Plus: Desired ending supplies | =55000*10% | =61000*10% | =83000*10% |
Supplies needed | =51000+5500 | =55000+6100 | =61000+8300 |
Less: Beginning supplies | 5100 | =55000*10% | =61000*10% |
--Requirement [B] Supplies expense = 51000 + 55000 + 61000 = $ 167,000
--Requirement [C} Supplies ending balance = 83000 x 10% = $ 8,300
The purchasing department manager for Rooney Company prepared the following supplies purchases budget. Rooney’s policy is...
The purchasing department manager for Thornton Company prepared the following supplies purchases budget. Thornton’s policy is to maintain an ending supplies balance equal to 15 percent of the following month’s supplies expense. April’s budgeted supplies expense is $82,000. Required Complete the supplies purchases budget by filling in the missing amounts. Determine the amount of supplies expense the company will report on its first quarter pro forma income statement. Determine the amount of ending supplies the company will report on its...
The purchasing department manager for Munoz Company prepared the following supplies purchases budget. Munoz's policy is to maintain an ending supplies balance equal to 15 percent of the following month's supplies expense. April's budgeted supplies expense is $79,000. Required a. Complete the supplies purchases budget by filling in the missing amounts. b. Determine the amount of supplies expense the company will report on its first quarter pro forma Income statement. c. Determine the amount of ending supplies the company will...
The purchasing department manager for Jordan Company prepared the following supplies purchases budget. Jordan's policy is to maintain an ending supplies balance equal to 10 percent of the following month's supplies expense. April's budgeted supplies expense is $84,000 Required a. Complete the supplies purchases budget by filling in the missing amounts b. Determine the amount of supplies expense the company will report on its first quarter pro forma income statement c. Determine the amount of ending supplies the company will...
The purchasing department manager for Perez Company prepared the following supplies purchases budget. Perez's policy is to maintain an ending supplies balance equal to 15 percent of the following month's supplies expense. April's budgeted supplies expense is $80,000 Required a. Complete the supplies purchases budget by filling in the missing amounts. b. Determine the amount of supplies expense the company will report on its first quarter pro forma income statement. c. Determine the amount of ending supplies the company will...
Check + The purchasing department manager for Campbell Company prepared the following supplies purchases budget. Campbell's policy is to maintain an ending supplies balance equal to 15 percent of the following month's supplies expense. April's budgeted supplies expense is $81,000 Required a. Complete the supplies purchases budget by filling in the missing amounts b. Determine the amount of supplies expense the company will report on its first quarter pro forma income statement c. Determine the amount of ending supplies the...
The purchasing department manager for Franklin Company prepared the following supplies purchases budget. Franklin's policy is to maintain an ending supplies balance equal to 10 percent of the following month's supplies expense. April's budgeted supplies expense is $77,000. Required a. Complete the supplies purchases budget by filling in the missing amounts. b. Determine the amount of supplies expense the company will report on its first quarter pro forma income statement c. Determine the amount of ending supplies the company will...
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...
Walton Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Walton’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...
Zachary Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Zachary’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 $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...
Finch Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Finch'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...