Question

In: Accounting

Activity Flexible Budgeting, Performance Report, Volume Variance Novo, Inc., wants to develop an activity flexible budget...

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

Solutions

Expert Solution

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

Related Solutions

Activity Flexible Budgeting, Performance Report, Volume Variance Novo, Inc., wants to develop an activity flexible budget...
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...
Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget...
Activity-Based Flexible Budgeting Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: • Four welding units, with a lease cost of $15,000 per year per unit • Six welding employees each paid a salary of $60,000 per year (A total of 9,000 welding hours are supplied by the six workers.) • Welding supplies: $300 per job • Welding hours: 3 hours used per job...
Foy Company has a welding activity and wants to develop a flexible budget formula for the...
Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: • Four welding units, with a lease cost of $15,000 per year per unit • Six welding employees each paid a salary of $58,000 per year (A total of 12,000 welding hours are supplied by the six workers.) • Welding supplies: $400 per job • Welding hours: 4 hours used per job During the year,...
Financial Versus Activity Flexible Budgeting Kelly Gray, production manager, was upset with the latest performance report,...
Financial Versus Activity Flexible Budgeting Kelly Gray, production manager, was upset with the latest performance report, which indicated that she was $100,000 over budget. Given the efforts that she and her workers had made, she was confident that they had met or beat the budget. Now, she was not only upset but also genuinely puzzled over the results. Three items—direct labor, power, and setups—were over budget. The actual costs for these three items follow: Actual Costs Direct labor $249,620      Power...
Performance Report Year Ended December 31, 2017 Actual Flexible-Budget Flexible Sales-Volume Static Results Variances Budget Variances...
Performance Report Year Ended December 31, 2017 Actual Flexible-Budget Flexible Sales-Volume Static Results Variances Budget Variances Budget Units sold 108,000 99,000 Revenues (sales) $702,000 $420,750 Variable costs 430,000 237,600 Contribution margin 272,000 183,150 Fixed costs 193,850 105,000 Operating income $78,150 $78,150 The Beekman Company produces engine parts for car manufacturers. A new accountant intern at Beekman has accidentally deleted the calculations on the​ company's variance analysis calculations for the year ended December​ 31, 2017. Requirement 1. Calculate all the required...
A different between the static-budget and flexible -budget amounts is called the sales -volume variance
A different between the static-budget and flexible -budget amounts is called the sales -volume variance
Problem 1) Static budget variance and Flexible budget variance Sonnet Inc. has the following information for...
Problem 1) Static budget variance and Flexible budget variance Sonnet Inc. has the following information for March 2018. Master Budget for March 2018 Sales volume………………………...……………….2,100 diskettes Average selling price per diskette……………………$5.00/diskette DM costs per diskette………………………………..$0.85/diskette DM cost per lb……………………………….$17.00/lb DM per diskette……………………………..0.05 lb/diskette Direct Labor: Direct labor cost per hour……………………..$15.00/hr # of diskettes produced per labor hour……….. 30 diskettes Direct Marketing costs………………………………$0.30 /diskette Fixed overhead costs………………………………..$850/month Actual for March 2018 Sales volume ………………………………………..1,800 diskettes Average selling price………………………………..$4,80/diskette DM costs per...
Calculating the sales volume and flexible budget variances, budget reconciliation report (LO1, LO2, LO3). During the...
Calculating the sales volume and flexible budget variances, budget reconciliation report (LO1, LO2, LO3). During the holiday season, Ajay Singh offers gift-wrapping services at the local mall. Ajay budgets to wrap 1,250 packages per month for $3 per package. Ajay estimates that his variable costs (supplies) will equal $1 per package wrapped and that his fixed costs (rent and utilities) will equal $600 per month. For the month of December, Ajay actually wrapped 1,500 packages, receiving $4,500 in revenue. However,...
Kite Company has the following report for August: Flexible Sales Actual budget Flexible activity Master Results...
Kite Company has the following report for August: Flexible Sales Actual budget Flexible activity Master Results variances budget variances budget Units ? 12000 4000 U ? Sales revenue ? 12000 F 168000 ? ? Variable mfg. costs 96000 ? ? ? 120000 Variable mktg. costs ? 4800 U 21600 ? ? Contribution margin 57600 ? ? 18800 U 75200 Fill in the missing amounts. For items in the variances columns, indicate F or U.
Flexible Budget In an attempt to improve budgeting, the controller for Meliore, Inc., has developed a...
Flexible Budget In an attempt to improve budgeting, the controller for Meliore, Inc., has developed a flexible budget for overhead costs. Meliore, Inc., makes two types of products, the standard model and the deluxe model. Meliore expects to produce 400,000 units of the standard model and 140,000 units of the deluxe model during the coming year. The standard model requires 0.10 direct labor hour per unit, and the deluxe model requires 0.16. The controller has developed the following cost formulas...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT