Beca Industrial has estimated that production for the next five quarters will be:

Production Information

1st quarter, 2020

56,700 units

2nd quarter, 2020

51,200 units

3rd quarter, 2020

62,200 units

4th quarter, 2020

48,800 units

1st quarter, 2021

58,300 units

Finished units of production require 6 pounds of raw material per unit. The raw material cost is $ 7 per pound. There is $ 357,210 of raw material on hand at the beginning of the first quarter, 2020. Beca desires to have 15 percent of next quarter's material requirements on hand at the end of each quarter.

Prepare quarterly direct materials purchases budgets for Beca Industrial for 2020.

Beca Industrial

Direct Materials Purchases Budget

For the Year Ending December 31, 2020

Quarter 1

Quarter 2

Quarter 3

Quarter 4

Year

select an opening direct materials purchases budget item

enter a number of units

enter a number of units

enter a number of units

enter a number of units

enter a number of units

select an item

$ enter a dollar amount

$ enter a dollar amount

$ enter a dollar amount

$ enter a dollar amount

$ enter a dollar amount

select a summarizing line for the first part

enter a total dollar amount for the first part

enter a total dollar amount for the first part

enter a total dollar amount for the first part

enter a total dollar amount for the first part

enter a total dollar amount for the first part

select between addition and deduction

: select an item

enter a dollar amount

enter a dollar amount

enter a dollar amount

enter a dollar amount

enter a dollar amount

select a summarizing line for the second part

enter a total dollar amount for the second part

enter a total dollar amount for the second part

enter a total dollar amount for the second part

enter a total dollar amount for the second part

enter a total dollar amount for the second part

select between addition and deduction

: select an item

enter a dollar amount

enter a dollar amount

enter a dollar amount

enter a dollar amount

enter a dollar amount

select a closing direct materials purchases budget item

$ enter a total amount for the direct materials purchases budget

$ enter a total amount for the direct materials purchases budget

$ enter a total amount for the direct materials purchases budget

$ enter a total amount for the direct materials purchases budget

$ enter a total amount for the direct materials purchases budget

Attempts: 0 of 1 used

Units to be produced

Cost of raw material per unit

Desired ending inventory of raw material

Total material needed

Beginning inventory of raw material

Required raw material purchases

Cost of raw material needed for production

enteratotaldollaramountforthefirstpart

enteratotaldollaramountforthefirstpart

enteratotaldollaramountforthefirstpart

enteratotaldollaramountforthefirstpart

enteratotaldollaramountforthefirstpart

selectbetweenadditionanddeduction

Add

Less

:

selectanitem

Units to be produced

Cost of raw material per unit

Desired ending inventory of raw material

Total material needed

Beginning inventory of raw material

Required raw material purchases

Cost of raw material needed for production

enter a dollar amount

enter a dollar amount

enter a dollar amount

enter a dollar amount

enter a dollar amount

selectasummarizinglineforthesecondpart

Units to be produced

Cost of raw material per unit

Desired ending inventory of raw material

Total material needed

Beginning inventory of raw material

Required raw material purchases

Cost of raw material needed for production

enteratotaldollaramountforthesecondpart

enteratotaldollaramountforthesecondpart

enteratotaldollaramountforthesecondpart

enteratotaldollaramountforthesecondpart

enteratotaldollaramountforthesecondpart

selectbetweenadditionanddeduction

Add

Less

:

selectanitem

Units to be produced

Cost of raw material per unit

Desired ending inventory of raw material

Total material needed

Beginning inventory of raw material

Required raw material purchases

Cost of raw material needed for production

enteradollaramount

enteradollaramount

enteradollaramount

enteradollaramount

enteradollaramount

select a closing direct materials purchases budget item

Units to be produced

Cost of raw material per unit

Desired ending inventory of raw material

Total material needed

Beginning inventory of raw material

Required raw material purchases

Cost of raw material needed for production

$

enter a total amount for the direct materials purchases budget

$

enter a total amount for the direct materials purchases budget

$

enter a total amount for the direct materials purchases budget

$

enter a total amount for the direct materials purchases budget

$

enter a total amount for the direct materials purchases budget