In: Accounting
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 | $ | |
Lease | ||
Crates | $ | |
Fuel | ||
Total | $ | $ |
Feedback
Review what you have learned in the chapter.
2. Calculate the activity capacity for moving
materials.
cycles
Feedback
Incorrect
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 | $ | $ | |
Lease | |||
Crates | $ | ||
Fuel | |||
Total | $ | $ | $ |
Feedback
See Cornerstone 12.4.
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 | $ | $ | $ | Unfavorable |
Lease | N/A | |||
Crates | Unfavorable | |||
Fuel | Unfavorable | |||
Total | $ | $ | $ | Unfavorable |
Feedback
See Cornerstone 12.4.
3. Calculate the amount of the volume variance
for moving materials.
$
Feedback
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 | |||||
Resource | Fixed | Variable | |||
Salaries (25 x 50,000) | $ 1,250,000.00 | ||||
Lease (8 forklifts x 18000) | $ 144,000.00 | ||||
Crates | $ 1.80 | ||||
Fuel ($3.60/20 moves) x 2 moves per cycle) | $ 0.36 | ||||
Total | $ 1,394,000.00 | $ 2.16 | |||
2. Calculate the activity capacity for moving materials. | |||||
Forklift capacity = 3 × 24 × 280 × 8 = | 161280 | Moves | 80640 | Cycles | |
Operator capacity = 3 × 25 × 2,000 = | 150000 | moves | 75000 | cycles | |
75,000 cycles is the activity capacity and 80 percent of that capacity is 60,000 cycles. | |||||
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 | |||||
Resource | Fixed | Variable | 60,000 Cycles (Activity Output) | ||
Salaries | $ 1,250,000.00 | $ 1,250,000.00 | |||
Lease | $ 144,000.00 | $ 144,000.00 | |||
Crates | $ 1.80 | $ 108,000.00 | |||
Fuel | $ 0.36 | $ 21,600.00 | |||
Total | $ 1,394,000.00 | $ 2.16 | $ 1,523,600.00 | ||
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 | $1,290,000 | $ 1,250,000.00 | $40,000.00 | Unfavorable | |
Lease | 144,000 | $ 144,000.00 | $0.00 | N/A | |
Crates | 118,000 | $ 108,000.00 | $10,000.00 | Unfavorable | |
Fuel | 24,000 | $ 21,600.00 | $2,400.00 | Unfavorable | |
Total | $1,576,000 | $1,523,600 | $52,400 | Unfavorable | |
3. Calculate the amount of the volume variance for moving materials. | |||||
The volume variance is the capacity acquisition cost | $ 1,394,000.00 |