Bank Organizer Printers Inc, produces luxury checkbooks with three checks and stubs per page. Each checkbook is designed for an individual customer and is ordered through the customers bank. The company's preparing budget for September 2017 included this data.
1. Prepare a static-budget- based variance analysis of
the September performance.
2. Prepare a flexible-budget-based variance analysis of the
September performance.
3. Why might Bank organizer find the flexible budget based variance
analysis more informative than the static budget based variance
analysis? explain your answer
1. Prepare a static-budget- based variance analysis of the September performance.
Actual Results | Static Budget Variance | Static Budget | ||
Units sold | 15800 | 2200 | U | 18000 |
Sales revenue | (15800*$24)= $379200 | (379200-414000)= 34800 | U | (18000*$23)= $414000 |
Less: Variable costs | (15800*$5)= 79000 | (79000-108000)= 29000 | F | (18000*$6)= 108000 |
Contribution margin | 300200 | 5800 | U | 306000 |
Less: Fixed costs | -155700 | (155700-150000)= 5700 | U | -150000 |
Operating income | $144500 | $11500 | U | $156000 |
2. Prepare a flexible-budget-based variance analysis of the September performance.
Actual Results | Flexible Budget Variance | Flexible Budget | Sales Volume Variance | Static Budget | |||
Units sold | 15800 | 15800 | 18000 | ||||
Sales revenue | (15800*$24)= $379200 | (379200-363400)= 15800 | F | (15800*23)= $363400 | (363400-414000)= 50600 | U | (18000*$23)= $414000 |
Less: Variable costs | (15800*$5)= 79000 | (79000-94800)= 15800 | F | (15800*$6)= 94800 | (94800-108000)= 13200 | F | (18000*$6)= 108000 |
Contribution margin | 300200 | 31600 | F | 268600 | 37400 | U | 306000 |
Less: Fixed costs | -155700 | (155700-150000)= 5700 | U | -150000 | 0 | NONE | -150000 |
Operating income | $144500 | 25900 | F | $118600 | 37400 | U | $156000 |
3. Why might Bank organizer find the flexible budget based variance analysis more informative than the static budget based variance analysis? explain your answer
Bank organizer find the flexible budget based variance analysis more informative than the static budget based variance analysis because flexible budget based variance is calculated on the actual number of units sold while static budget based variance is calculated on the budgeted number of units sold. In static budget variance the difference in the operating income is shown as $11500 Unfavorable but in actual if we compare the flexible budget based variance there is $25900 Favorable operating income. That is because of the difference in the number of units sold. In static budget we take the budgeted number of units sold i.e., 18000 units while in flexible budget we take the actual number of units sold i.e., 15800 units. So, the Bank prefer flexible budget based variance over static budget based variance because of the difference in the number of units sold.
Bank Organizer Printers Inc, produces luxury checkbooks with three checks and stubs per page. Each checkbook...
Bank Organizer Printers, Inc., produces luxury checkbooks with three checks and stubs per page. Each checkbook is designed for an individual customer and is ordered through the customer's bank. Thecompany's operating budget for September 2017 included these data: The budgeted amounts for September 2017 were: Number of checkbooks 13,000 Selling price per book $22 Variable cost per book $8 Fixed costs for the month $140,000 The actual results for September 2017 were as follows: Number of checkbooks produced and sold...
Check Plus Printers, Inc., produces luxury checkbooks with three checks and stubs per page. Each checkbook is designed for an individual customer and is ordered through the customer's bank. The company's operating budget for September 2017 included these data: The budgeted amounts for September 2017 were: Number of checkbooks 13,000 Selling price per book $19 Variable cost per book $6 Fixed costs for the month $125,000 The actual results for September 2017 were as follows: Number of checkbooks produced and...
Personal Assistant Printers, Inc., produces luxury checkbooks with three checks and stubs per page. Each checkbook is designed for an individual customer and is ordered through the customer's bank. The company's operating budget for September 2017 included these data: m (Click the icon to view the operating budget and actual results.) The executive vice president of the company observed that the operating income for September was much lower than anticipated, despite a higher than-budgeted selling price and a lower-than-budgeted variable...
Check It Off Printers, Inc., produces luxury checkbooks with three checks and stubs per page. Each checkbook is designed for an individual customer and is ordered through the customer's bank. The company's operating budget for September 2017 included these data: (Click the icon to view the operating budget and actual results.) The executive vice president of the company observed that the operating income for September was much lower than anticipated, despite a higher-than-budgeted selling price and a lower-than-budgeted variable cost...
Check PlusCheck Plus Printers, Inc., produces luxury checkbooks with three checks and stubs per page. Each checkbook is designed for an individual customer and is ordered through the customer's bank. The company's operating budget for September 20172017 included these data: LOADING... (Click the icon to view the operating budget and actual results.) The executive vice president of the company observed that the operating income for September was much lower than anticipated, despite a higher-than-budgeted selling price and a lower-than-budgeted variable...
Requirement 2. Comment on the results in requirement 1. Please help with choosing the comments based on the answer above The total static-budget variance in operating income is $ (number) There is a(n) (Favorable/Unfavorable) total flexible-budget variance and a(n) (Favorable/Unfavorable) sales-volume variance. The sales-volume variance arises solely because actual units manufactured and sold were (less/more) than the budgeted 3,700 units. The flexible-budget variance in operating income is due primarily to the (increase/decrease) in unit variable costs. Anderson Enterprises manufactures tires...
The Edinburg Company produces engine parts for car manufacturers. A new accountant intern at Edinburg has accidentally deleted the calculations on the company's variance analysis calculations for the year ended December 31, 2017. The following table is what remains of the data. (Click the icon to view the data.) Read the requirements. Requirement 1. Calculate all the required variances. (If your work is accurate, you will find that the total static-budget variance is $0.) Begin with the flexible budget columns,...
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. The following table is what remains of the data. Performance Report Year Ended December 31, 2017 Actual Flexible-Budget Flexible Sales-Volume Static Results Variances Budget Variances Budget Units sold 103,000 97,000 Revenues (sales) $695,250 $412,250 Variable costs 450,000 218,250 Contribution margin 245,250 194,000 Fixed costs 156,250 105,000 Operating...
The Groton Company produces engine parts for car manufacturers. A new accountant intern at Groton has accidentally deleted the calculations on the company's variance analysis calculations for the year ended December 31, 2017. The following table is what remains of the data. Performance Report Year Ended December 31, 2017 Flexible-Budget Flexible Variances Budget Actual Results 103,000 Sales-Volume Variances Static Budget 92.000 $ Units sold Revenues (sales) Variable costs Contribution margin 695,250 455,000 377,200 193,200 240,250 151,250 184,000 95,000 Fixed costs...
CellBase Technologies manufactures capacitors for cellular base stations and other communications applications. The company's July 2018 flexible budget shows output levels of 7,000, 9,000 and 11,000 units. The static budget was based on expected sales of 9,000 units. The company sold 11,000 units during July. (1) Please help me with preparing a flexible budget performance report for July (2) What was the effect on CellBase’s operating income of selling 2,000 units more than the static budget level of sales? (3)...