Activity Flexible Budgeting, Performance Report, Volume Variance

Novo, Inc., wants to develop an activity flexible budget for the activity of moving materials. Novo uses eight forklifts to move materials from receiving to stores. The forklifts are also used to move materials from stores to the production area. The forklifts are obtained through an operating lease that costs $18,000 per year per forklift. Novo employs 25 forklift operators who receive an average salary of $50,000 per year, including benefits. Each move requires the use of a crate. The crates are used to store the parts and are emptied only when used in production. Crates are disposed of after one cycle (two moves), where a cycle is defined as a move from receiving to stores to production. Each crate costs $1.80. Fuel for a forklift costs $3.60 per gallon. A gallon of gas is used every 20 moves. Forklifts can make three moves per hour and are available for 280 days per year, 24 hours per day (the remaining time is downtime for various reasons). Each operator works 40 hours per week and 50 weeks per year.

Required:

1. Prepare a flexible budget for the activity of moving materials, using the number of cycles as the activity driver. If required, round your answers to the nearest cent.

Novo, Inc. Flexible Budget
	Formula
Resource	Fixed	Variable
Salaries	$fill in the blank f070d6fe5fc4f7f_2
Lease	fill in the blank f070d6fe5fc4f7f_4
Crates		$fill in the blank f070d6fe5fc4f7f_6
Fuel		fill in the blank f070d6fe5fc4f7f_8
Total	$fill in the blank f070d6fe5fc4f7f_9	$fill in the blank f070d6fe5fc4f7f_10

2. Calculate the activity capacity for moving materials. fill in the blank

Suppose Novo works at 80 percent of activity capacity and incurs the following costs:

Salaries	$1,290,000
Leases	144,000
Crates	118,000
Fuel	24,000

Prepare the budget for the 80 percent level for the moving materials activity. If required, round your answers to the nearest cent.

Novo, Inc.
Budget for the 80 percent level
	Formula
Resource	Fixed	Variable	60,000 Cycles (Activity Output)
Salaries	$fill in the blank 3062bbfb0079008_2		$fill in the blank 3062bbfb0079008_3
Lease	fill in the blank 3062bbfb0079008_5		fill in the blank 3062bbfb0079008_6
Crates		$fill in the blank 3062bbfb0079008_8	fill in the blank 3062bbfb0079008_9
Fuel		fill in the blank 3062bbfb0079008_11	fill in the blank 3062bbfb0079008_12
Total	$fill in the blank 3062bbfb0079008_13	$fill in the blank 3062bbfb0079008_14	$fill in the blank 3062bbfb0079008_15

Prepare a performance report for the moving materials activity. If an amount is zero, enter "0". Select "N/A" if there is no variance.

Novo, Inc.
Performance Report
For the Year 20XX
Resource	Actual Costs	Budgeted Costs	Budget Variance	Favorable (F) or Unfavorable (U)
Salaries	$fill in the blank a06a33fc4057058_2	$fill in the blank a06a33fc4057058_3	$fill in the blank a06a33fc4057058_4	Unfavorable
Lease	fill in the blank a06a33fc4057058_7	fill in the blank a06a33fc4057058_8	fill in the blank a06a33fc4057058_9	N/A
Crates	fill in the blank a06a33fc4057058_12	fill in the blank a06a33fc4057058_13	fill in the blank a06a33fc4057058_14	Unfavorable
Fuel	fill in the blank a06a33fc4057058_17	fill in the blank a06a33fc4057058_18	fill in the blank a06a33fc4057058_19	Unfavorable
Total	$fill in the blank a06a33fc4057058_21	$fill in the blank a06a33fc4057058_22	$fill in the blank a06a33fc4057058_23	Unfavorable

3. Calculate the amount of the volume variance for moving materials. $fill in the blank

4. Suppose that a redesign of the plant layout reduces the demand for moving materials to one-third of the original capacity. What is the budgeted cost for this new activity level? When making your calculations, round the number of required operators and the number of required forklifts to the next higher number (for example, a computed value of 6.2 rounds to 7). If required, round your answers to the nearest cent.

Budgeted Cost for New Activity Level
	Formula
Resource	Fixed	Variable	25,000 Cycles (Activity Output)
Salaries	$fill in the blank 22b0e002f029009_2		$fill in the blank 22b0e002f029009_3
Lease	fill in the blank 22b0e002f029009_5		fill in the blank 22b0e002f029009_6
Crates		$fill in the blank 22b0e002f029009_8	fill in the blank 22b0e002f029009_9
Fuel		fill in the blank 22b0e002f029009_11	fill in the blank 22b0e002f029009_12
Total	$fill in the blank 22b0e002f029009_13	$fill in the blank 22b0e002f029009_14	$fill in the blank 22b0e002f029009_15