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

Production Information

1st quarter, 2017 40,000 units

2nd quarter, 2017 36,000 units

3rd quarter, 2017 43,000 units

4th quarter, 2017 33,000 units

1st quarter, 2018 41,000 units

Finished units of production require 8 pounds of raw material per unit. The raw material cost is $7 per pound. There is $268,800 of raw material on hand at the beginning of the first quarter, 2017. Bellevue desires to have 12 percent of next quarter's material requirements on hand at the end of each quarter.

Prepare quarterly direct materials purchase budgets for Bellevue Industrial for 2017.

BellevueIndustrial

Direct Materials Purchases Budget

For the Year Ending December 31, 2017

Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year

Cost of raw material per unit (I am to choose one of the options at the left and then supply quarterly info)

Beginning inventory of raw material

Required raw material purchases

Desired ending inventory of raw material

Units to be produced

Cost of raw material needed for production

Total material needed

Cost of raw material per unit

Total material needed

Desired ending inventory of raw material (again, choose one from the list and provide quarterly info)

Beginning inventory of raw material

Cost of raw material needed for production

Required raw material purchases

Units to be produced

Total material needed

Cost of raw material per unit

Desired ending inventory of raw material

Cost of raw material needed for production (choose one from the left and provide quarterly info)

Required raw material purchases

Beginning inventory of raw material

Units to be produced

_________________________________________________________________________________________________

Less or Add

Total material needed

Cost of raw material per unit

Required raw material purchases (Choose one from the left and provide quarterly info)

Beginning inventory of raw material

Cost of raw material needed for production

Units to be produced

Desired ending inventory of raw material

Desired ending inventory of raw material

Units to be produced

Cost of raw material per unit (choose one from the left and provide quarterly info)

Total material needed

Beginning inventory of raw material

Required raw material purchases

Cost of raw material needed for production

_______________________________________________________________________________________________

Add or Less

Desired ending inventory of raw material

Total material needed

Cost of raw material needed for production

Units to be produced

Required raw material purchases

Cost of raw material per unit

Beginning inventory of raw material

Units to be produced

Desired ending inventory of raw material

Total material needed (choose one from left and provide quarterly information)

Cost of raw material per unit

Beginning inventory of raw material

Required raw material purchases

Cost of raw material needed for production

$ $ $ $ Year

I am so lost in this class.... I would appreciate any and all help.