Flexible Budget for Assembly Department

Cabinaire Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it assembles filing cabinets in an Assembly Department. Assume the following information for the Assembly Department:

Direct labor per filing cabinet	30 minutes
Supervisor salaries	$111,000 per month
Depreciation	$29,000 per month
Direct labor rate	$12 per hour

Prepare a flexible budget for 13,000, 16,000, and 20,000 filing cabinets for the month of March in the Assembly Department similar to Exhibit 5. Enter all amounts as positive numbers.

Cabinaire Inc.
Assembly Department Budget
Month Ending March 31 (assumed data)
Units of production	13,000	16,000	20,000
Variable cost:
Direct labor	$	$	$
Total variable cost	$	$	$
Fixed cost:
Supervisor salaries	$	$	$
Depreciation
Total fixed cost	$	$	$
Total department costs

Sales and Production Budgets

Sonic Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget:

	Rumble		Thunder
Estimated inventory (units), June 1	284		70
Desired inventory (units), June 30	327		61
Expected sales volume (units):
Midwest Region	4,150		3,650
South Region	5,200		4,500
Unit sales price	$130		$185

a. Prepare a sales budget.

Sonic Inc.
Sales Budget
For the Month Ending June 30
Product and Area	Unit Sales Volume	Unit Selling Price	Total Sales
Model: Rumble
Midwest Region		$	$
South Region
Total			$
Model: Thunder
Midwest Region		$	$
South Region
Total			$
Total revenue from sales			$

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

Sonic Inc.
Production Budget
For the Month Ending June 30
	Units Rumble	Units Thunder
Expected units to be sold
Desired inventory, June 30
Total
Estimated inventory, June 1
Total units to be produced

Direct Materials Purchases Budget

Romanos Frozen Pizza Inc. has determined from its production budget the following estimated production volumes for 12'' and 16'' frozen pizzas for September:

	Units
	12" Pizza		16" Pizza
Budgeted production volume	13,200		25,100

There are three direct materials used in producing the two types of pizza. The quantities of direct materials expected to be used for each pizza are as follows:

		12" Pizza		16" Pizza
Direct materials:
	Dough	0.90	lb. per unit	1.50	lbs. per unit
	Tomato	0.60		1.00
	Cheese	0.80		1.30

In addition, Romano's has determined the following information about each material:

	Dough		Tomato		Cheese
Estimated inventory, September 1	560	lbs.	220	lbs.	300	lbs.
Desired inventory, September 30	590	lbs.	210	lbs.	330	lbs.
Price per pound	$1.20		$2.50		$3.30

Prepare September's direct materials purchases budget for Romanos Frozen Pizza Inc. For those boxes in which you must enter subtracted or negative numbers use a minus sign.

Romanos Frozen Pizza Inc.
Direct Materials Purchases Budget
For the Month Ending September 30
	Dough	Tomato	Cheese	Total
Units required for production:
12" pizza
16" pizza
Desired inventory, September 30
Total units available
Estimated inventory, September 1
Total units to be purchased
Unit Price	x $	x $	x $
Total direct materials to be purchased	$	$	$	$

Direct Labor Cost Budget

Ace Racket Company manufactures two types of tennis rackets, the Junior and Pro Striker models. The production budget for July for the two rackets is as follows:

	Junior	Pro Striker
Production budget	6,400 units	22,100 units

Both rackets are produced in two departments, Forming and Assembly. The direct labor hours required for each racket are estimated as follows:

	Forming Department	Assembly Department
Junior	0.25 hour per unit	0.4 hour per unit
Pro Striker	0.3 hour per unit	0.6 hour per unit

The direct labor rate for each department is as follows:

Forming Department	$20 per hour
Assembly Department	$11 per hour

Prepare the direct labor cost budget for July.

Ace Racket Company
Direct Labor Cost Budget
For the Month Ending July 31
	Forming Department	Assembly Department
Hours required for production:
Junior
Pro Striker
Total
Hourly rate	x$	x$
Total direct labor cost	$	$