Sales, production, direct materials purchases, and direct labor cost budgets

a$.$ Estimated sales for July by sales territory:

Maine: Backy

Backyard Chef $310$ units at $$700$ per unit

Vermont:

Backyard Chef $240$ units at $$750$ per unit Master Chef $110$ units at $$1,300$ per unit

wampshire:

New Hampshire: Backyard Chef $360$ units at $$750$ per unit Master Chef $180$ units at $$1,400$ per unit

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

Direct materials:

Grates $290$ units Stainless steel $1,500$

Stainless steel $1,500$ lbs$.$ Burner subassemblies $170$ units

Shelves $340$ units

Finished products:

Backyard Chef $30$ units Master Chef $32$ units

c$.$ Desired inventories at July $31$ ;

Direct materials:

Grates $340$ units Stainless steel $1,800lbs$

Stainless steel $1,800$ lbs$.$ Burner subassemblies $155$ units Shelves $315$ units

Shelves $315$ units

Finished products:

Backyard Chef $40$ units Master Chef $22$ units

d$.$ Direct materials used in production:

In manufacture of Backyard Chef:

Grates $3$ units per unit of product Stainless steel $24$ lbs$.$ per unit of prod

Stainless steel $24$ lbs$.$ per unit of product Burner subassemblies $2$ units per unit of product Shelves $4$ units per unit of product

In manufacture of Master Chef:

Grates $6$ units per unit of product

Stainless steel $42$ lbs$.$ per unit of product

Burner subassemblies $4$ units per unit of product

Shelves $5$ units per unit of product

e$.$ Anticipated purchase price for direct materials:

Grates $$15$ per unit

Stainless steel $$6$ per lb$.$

Burner subassemblies $$110$ per unit

Shelves $$10$ per unit

I f$.$ Direct labor requirements:

Backyard Chef:

Stamping Department $0\mathrm{.}50hr.$ at $$17$ per hr$.$

Forming Department $0\mathrm{.}60hr.$ at $$15$ per hr$.$

Assembly Department $1\mathrm{.}00hr.$ at $$14$ per hr$.$

Master Chef:

Stamping Department $0\mathrm{.}60hr.$ at $$17$ per hr

Forming Department $0\mathrm{.}80hr.$ at $$15$ per hr$.$

Assembly Department $1\mathrm{.}50hrs.$ at $$14$ per hr

Required:

Prepare a sales budget for July

Prepare a production budget for July. For those boxes in which you must enter subtracted or negative numbers use a minus sign.

Gourmet Grill Company

Production Budget

For the Month Ending July $31$

Prepare a direct materials purchases budget for July. For those boxes in which you must enter subtracted or negative numbers use a minus sign,

Gourmet Grill Company Direct Materials Purchases Budget For the Month Ending July $31$

For the Month Ending July $31$

Grates $($units$)$

$($lbs$.)$

$($Ibs$.)$

Burner Sub assemblies

assembli

$($units$)$

Shelves $($units$)$

$($units$)$

$($units$)$

Total

Total

$|+$Total direct labor costAssembly DepartmentTotal

Backyard Chef

Master Chef

Total