1 Lewis Company reports the following fixed budget and actual results for May. Prepare a flexible budget performance report showing variances between budgeted and actual results. (Indicate the effect of the variance by selecting favorable, unfavorable, or no variance.) Sales (units produced and sold) Sales (in dollars) Variable costs Fixed costs Fixed Budget 1,350 Actual Results 1,550 $ 1,050 per unit $ 420 per unit $ 1,678,000 $ 652,000 $ 147,500 $ 137,000 For Month Ended May 31 Sales Variable costs Contribution margin Fixed costs Income LEWIS COMPANY Flexible Budget Performance Report Flexible Budget Actual Results (1,550 units) (1,550 units) Variances Favorable/Unfavorable

1 Lewis Company reports the following fixed budget and actual results for May. Prepare a flexible budget performance report showing variances between budgeted and actual results. (Indicate the effect of the variance by selecting favorable, unfavorable, or no variance.) Sales (units produced and sold) Sales (in dollars) Variable costs Fixed costs Fixed Budget 1,350 Actual Results 1,550 $ 1,050 per unit $ 420 per unit $ 1,678,000 $ 652,000 $ 147,500 $ 137,000 For Month Ended May 31 Sales Variable costs Contribution margin Fixed costs Income LEWIS COMPANY Flexible Budget Performance Report Flexible Budget Actual Results (1,550 units) (1,550 units) Variances Favorable/Unfavorable

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter9: Profit Planning And Flexible Budgets

Section: Chapter Questions

Problem 34BEA: Performance Report Based on Budgeted and Actual Levels of Production Bowling Company budgeted the...

See similar textbooks

Similar questions

Georgia Gasket Co. budgets 8,000 direct labor hours for the year. The total overhead budget is expected to amount to 20,000. The standard cost for a unit of the companys product estimates the variable overhead as follows: The actual data for the period follow: Using the four-variance method, calculate the overhead variances. (Hint: First compute the budgeted fixed overhead rate.)
Preparing a performance report Use the flexible budget prepared in P7-6 for the 31,000-unit level and the actual operating results listed below for the 31,000-unit level. Required: 1. Prepare a performance report. 2. List the major reasons why the actual operating income at 31,000 units differs from the master budget operating income at 30,000 units in Figure 7-12. 3. Given the level at which the company operated, how was its cost control? Item Direct materials: Direct labor:
Digital Solutions Inc. uses flexible budgets that are based on the following data: Prepare a flexible selling and administrative expenses budget for October for sales volumes of 500,000, 750,000, and 1,000,000.
Preparing a performance report Use the flexible budget prepared in P7-6 for the 29,000-unit level of activity and the actual operating results listed below for the 29,000- unit level. Required: 1. Prepare a performance report. 2. List the major reasons why the actual operating income at 29,000 units differs from the master budget operating income at 30,000 units in Figure 7-12. 3. Given the level at which the company operated, how was its cost control? Item Direct materials: Direct labor:
Determining Budgeted Overhead The overhead application rate for a company is 10 per unit, made up of 6 per unit of fixed overhead and 4 per unit of variable overhead. Normal capacity is 10,000 units. In one month there was a favorable flexible budget variance of 2,500. Actual overhead for the month was 110,000 and actual units produced were 13,125. Based on this information, determine the amount of the budgeted overhead for the actual level of production.
Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Refer to the information for Pizza Vesuvio on the previous page. Assume that this information was used to construct the following formula for monthly labor cost. TotalLaborCost=5,237+(7.40EmployeeHours) Required: Assume that 675 employee hours are budgeted for the month of September. Use the total labor cost formula for the following calculations: 1. Calculate total variable labor cost for September. 2. Calculate total labor cost for September.
Nashler Company has the following budgeted variable costs per unit produced: Budgeted fixed overhead costs per month include supervision of 98,000, depreciation of 76,000, and other overhead of 245,000. Required: 1. Prepare a flexible budget for all costs of production for the following levels of production: 160,000 units, 170,000 units, and 175,000 units. 2. What is the per-unit total product cost for each of the production levels from Requirement 1? (Round each unit cost to the nearest cent.) 3. What if Nashler Companys cost of maintenance rose to 0.22 per unit? How would that affect the unit product costs calculated in Requirement 2?
Flexible budget for factory overhead Presented below are the monthly factory overhead cost budget (at normal capacity of 5,000 units or 20,000 direct labor hours) and the production and cost data for a month. The predetermined overhead rate is based on normal capacity. Required: 1. Assuming that variable costs will vary in direct proportion to the change in volume, prepare a flexible budget for production levels of 80%, 90%, and 110% of normal capacity. Also determine the predetermined factory overhead rate at each level of volume in both units and direct labor hours. 2. Prepare a flexible budget for production levels of 80%, 90%, and 110%, assuming that variable costs will vary in direct proportion to the change in volume, but with the following exceptions. (Hint: Set up a third category for semi-variable expenses.) a. At 110% of capacity, another supervisor will be needed at a salary of 24,000 annually. b. At 80% of capacity, the repairs expense will drop to one-half of the amount at 100% capacity. c. At 80% of capacity, one part-time maintenance worker, earning 10,000 a year, will be laid off. d. At 110% of capacity, a machine not normally in use and on which no depreciation is normally recorded will be used in production. Its cost was 12,000, it has a 10-year life, and straight-line depreciation will be taken.
Performance Report Based on Budgeted and Actual Levels of Production Balboa Company budgeted production of 4,500 units with the following amounts: At the end of the year, Balboa had the following actual costs for production of 4,700 units: Required: 1. Calculate the budgeted amounts for each cost category listed above for the 4,500 budgeted units. 2. Prepare a performance report using a budget based on expected (budgeted) production of 4,500 units. 3. Prepare a performance report using a budget based on the actual level of production of 4,700 units.
Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Refer to the information for Pizza Vesuvio on the previous page. Coefficients shown by a regression program for Pizza Vesuvios data are: Required: Use the results of regression to make the following calculations: 1. Calculate the fixed cost of labor and the variable rate per employee hour. 2. Construct the cost formula for total labor cost. 3. Calculate the budgeted cost for next month, assuming that 675 employee hours are budgeted. (Note: Round answers to the nearest dollar.) Use the following information for Brief Exercises 3-17 through 3-20: Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected:
Judges Gavel uses this information when preparing their flexible budget: direct materials of $3 per unit, direct labor of $2.50 per unit, and manufacturing overhead of $1.25 per unit. Fixed costs are $49,000. What would be the budgeted amounts for 33,000 and 35,000 units?
Refer to the data in Exercise 9.15. Required: 1. Compute overhead variances using a two-variance analysis. 2. Compute overhead variances using a three-variance analysis. 3. Illustrate how the two- and three-variance analyses are related to the four-variance analysis. Oerstman, Inc., uses a standard costing system and develops its overhead rates from the current annual budget. The budget is based on an expected annual output of 120,000 units requiring 480,000 direct labor hours. (Practical capacity is 500,000 hours.) Annual budgeted overhead costs total 787,200, of which 556,800 is fixed overhead. A total of 119,400 units using 478,000 direct labor hours were produced during the year. Actual variable overhead costs for the year were 230,600, and actual fixed overhead costs were 556,250. Required: 1. Compute the fixed overhead spending and volume variances. How would you interpret the spending variance? Discuss the possible interpretations of the volume variance. Which is most appropriate for this example? 2. Compute the variable overhead spending and efficiency variances. How is the variable overhead spending variance like the price variances of direct labor and direct materials? How is it different? How is the variable overhead efficiency variance related to the direct labor efficiency variance?