Prepare a production buals purchases

Prepare a direct material budget for July.

Prepare a direct labor cost and supporting budgets

Total direct labor $$293,850$ production manager, and satement for January: the budgeted income for January: $15,000$ units at $$25$ per unit

a$.$ Estimated sales for Janary: $.......................40,000$ units at $$15$ per unit

Bird house

Bird feeder.

EXCEL TEMPLATE

b$.$ Estimated inventories at January $1$:

Direct materials:

Wood $........600ft.$

Finished products:

Plastic....... $1,000$ lbs$.$

Bird house $......1,000$ units at $$15$ per unit

Bird feeder...... $2,500$ units at $$8$ per unit

c$.$ Desired inventories at January $31$ :

Direct materials:

Wood $........500ft.$

Finished products:

Plastic....... $1,250$ lbs$.$

Bird house $......1,500$ units at $$15$ per unit

Bird feeder...... $3,000$ units at $$8$ per unit

d$.$ Direct materials used in production:

In manufacture of bird house:

Wood $...........0\mathrm{.}80ft.$ per unit of product

In manufacture of bird feeder:

Plastic.......... $0\mathrm{.}10lb.$ per unit of product

Wood $..........0\mathrm{.}20ft.$ per unit of product

Plastic......... $1\mathrm{.}00lb.$ per unit of product

e$.$ Anticipated cost of purchases and beginning and ending inventory of direct Plastic......... $$0\mathrm{.}80$ per lb$.$

Wood $..........$ $$2\mathrm{.}50$ per ft$.$

f$.$ Direct labor requirements:

Bird house:

$0\mathrm{.}40hr.$ at $$18$ per hr$.$

Fabrication Department

$0\mathrm{.}20hr.$ at $$12$ per hr$.$

Assembly Department.

Bird feeder:

$0\mathrm{.}25hr.$ at $$18$ per hr$.$

Fabrication Department

$0\mathrm{.}10hr.$ at $$12$ per hr$.$

Assembly Department.

g$.$ Estimated factory overhead costs for January:

Indirect factory wages $$40,000$ Power and light

Depreciation $of$ plant and equipment $20,000$ Insurance and property tax

$$10,000$

Depreciation of plant and equipment

h$.$ Estimated operating expenses for January:

Sales salaries expense

$$125,000$

Advertising expense

$80,000$

Office salaries expense $,40,000$

Depreciation expense$-$office equipment $,4,000$

Travel expense$-$selling $,25,000$

Office supplies expense $,2,500$

Miscellaneous administrative expense $,3,500$