Concept explainers
Variance analysis, nonmanufacturing setting. Joyce Brown has run Medical Maids, a specialty cleaning service for medical and dental offices, for the past 10 years. Her static budget and actual results for April 2017 are shown below. Joyce has one employee who has been with her for all 10 years that she has been in business. In addition, at any given time she also employs two other less-experienced workers. It usually takes each employee 2 hours to clean an office, regardless of his or her experience. Brown pays her experienced employee $30 per office and the other two employees $15 per office. There were no wage increases in April.
Medical Maids Actual and
Budget | Actual | |
Offices cleaned | 140 | 160 |
Revenue | $26,600 | $36,000 |
Variable costs: | ||
Costs of supplies | 630 | 680 |
Labor | 3,360 | 4,200 |
Total variable costs | 3,990 | 4,880 |
Contribution margin | 22,610 | 31,120 |
Fixed costs | 4,900 | 4,900 |
Operating income | $17,710 | $26,220 |
- 1. How many offices, on average, did Brown budget for each employee? How many offices did each employee actually clean?
Required
- 2. Prepare a flexible budget for April 2017.
- 3. Compute the sales price variance and the labor efficiency variance for each labor type.
- 4. What information, in addition to that provided in the income statements, would you want Brown to gather if you wanted to improve operational efficiency?
Want to see the full answer?
Check out a sample textbook solutionChapter 7 Solutions
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
- Pease Contractors is a local home remodeling company. In analyzing financial performance, the accountant compares actual results with a flexible budget. The standard direct labor rates used in the flexible budget are established each year at the time the annual plan is formulated and held constant for the entire year. The standard direct labor rates in effect for the current fiscal year and the standard hours allowed for the actual output of work for August are shown in the following schedule. Worker Classification Standard Direct Labor Rate per Hour Standard Direct Labor-Hours Allowed for Output Supervisor $ 50 1,800 Skilled 30 2,250 General 20 4,950 The actual direct labor-hours worked and the actual direct labor rates per hour experienced for the month of August were as follows. Worker Classification Actual Direct Labor Rate per Hour Actual Direct Labor-Hours Supervisor $ 54 2,112 Skilled 32 2,112 General 18 5,376 Required: Calculate the dollar…arrow_forwardSkulas, Inc., manufactures and sells snowboards. Skulas manufactures a single model, the Pipex. In late 2017, Skulas’s management accountant gathered the following data to prepare budgets for January 2018: Materials and Labor Requirement Direct Materials Wood 9 Boards Feet (b.f.) per snowboard Fiberglass 10 Yards per snowboard Direct manufacturing labor 5 hours per snowboard Skulas’s CEO expects to sell 2,900 snowboards during January 2018 at an estimated retail price of $650 per board. Further, the CEO expects 2018 beginning inventory of 500 snowboards and would like to end January 2018 with 200 snowboards in stock. Direct Materials Inventories Begining Inventory 1/1/2018 Ending Inventory 1/31/2018 Wood 2,040 b.f. 1,540 b.f. Fiberglass 1,040 yards 2,040 yards Alternative Text Variable manufacturing…arrow_forwardSkulas, Inc., manufactures and sells snowboards. Skulas manufactures a single model, the Pipex. In late 2017, Skulas’s management accountant gathered the following data to prepare budgets for January 2018: Materials and Labor Requirement Direct Materials Wood 9 Boards Feet (b.f.) per snowboard Fiberglass 10 Yards per snowboard Direct manufacturing labor 5 hours per snowboard Skulas’s CEO expects to sell 2,900 snowboards during January 2018 at an estimated retail price of $650 per board. Further, the CEO expects 2018 beginning inventory of 500 snowboards and would like to end January 2018 with 200 snowboards in stock. Direct Materials Inventories Begining Inventory 1/1/2018 Ending Inventory 1/31/2018 Wood 2,040 b.f. 1,540 b.f. Fiberglass 1,040 yards 2,040 yards Alternative Text Variable manufacturing…arrow_forward
- Ruth, the owner of Crystal Clean, is planning for the next year. She uses the absorption method to determine the evaluation of employees and how much to increase their hourly wage. She has budgeted the following information: Variable operating expenses $4 per unitFixed operating expenses $211900 Variable manufacturing cost $11 per unitFixed manufacturing cost $253000 Units to be produced 25300 unitsUnit selling price $31 per unit Year 1 Year 2 Beginning inventory (units) 0 1400 Actual production (units) 23800 25800 Sales volume (units) 22400 26500 There were no price or efficiency variances for either year. Ruth writes off any fixed MOH volume variance directly to COGS. Calculate the gross margin for year 1.…arrow_forwardJoseph is working on the budget for his summer window-washing business, trying to figure out what his total costs are going to be for the season. He has monthly data from last summer, so he decided to start with that. Using the observations below, use the high-low method to estimate a total monthly cost function for Joseph's business. Month 1 2 3 Number of Labor Hours Spent Y = $ 60 105 85 (Round answers to 2 decimal places, e.g. 15.25.) X + $ Total Cost $196 $322 $250arrow_forwardGreiner Company makes and sells high-quality glare filters for microcomputer monitors. John Craven, controller, is responsible for preparing Greiners master budget and has assembled the following data for the coming year. The direct labor rate includes wages, all employee-related benefits, and the employers share of FICA. Labor saving machinery will be fully operational by March. Also, as of March 1, the companys union contract calls for an increase in direct labor wages that is included in the direct labor rate. Greiner expects to have 5,600 glare filters in inventory on December 31 of the current year, and has a policy of carrying 35 percent of the following month's projected sales in inventory. Information on the first four months of the coming year is as follows: Required: 1. Prepare the following monthly budgets for Greiner Company for the first quarter of the coming year. Be sure to show supporting calculations. a. Production budget in units b. Direct labor budget in hours c. Direct materials cost budget d. Sales budget 2. Calculate the total budgeted contribution margin for Greiner Company by month and in total for the first quarter of the coming year. Be sure to show supporting calculations. (CMA adapted)arrow_forward
- Firenza Company manufactures specialty tools to customer order. Budgeted overhead for the coming year is: Previously, Sanjay Bhatt, Firenza Companys controller, had applied overhead on the basis of machine hours. Expected machine hours for the coming year are 50,000. Sanjay has been reading about activity-based costing, and he wonders whether or not it might offer some advantages to his company. He decided that appropriate drivers for overhead activities are purchase orders for purchasing, number of setups for setup cost, engineering hours for engineering cost, and machine hours for other. Budgeted amounts for these drivers are 5,000 purchase orders, 500 setups, and 2,500 engineering hours. Sanjay has been asked to prepare bids for two jobs with the following information: The typical bid price includes a 40 percent markup over full manufacturing cost. Required: 1. Calculate a plantwide rate for Firenza Company based on machine hours. What is the bid price of each job using this rate? 2. Calculate activity rates for the four overhead activities. What is the bid price of each job using these rates? 3. Which bids are more accurate? Why?arrow_forwardBig Mikes, a large hardware store, has gathered data on its overhead activities and associated costs for the past 10 months. Nizam Sanjay, a member of the controllers department, believes that overhead activities and costs should be classified into groups that have the same driver. He has decided that unloading incoming goods, counting goods, and inspecting goods can be grouped together as a more general receiving activity, since these three activities are all driven by the number of receiving orders. The 10 months of data shown below have been gathered for the receiving activity. Required: 1. Prepare a scattergraph, plotting the receiving costs against the number of purchase orders. Use the vertical axis for costs and the horizontal axis for orders. 2. Select two points that make the best fit, and compute a cost formula for receiving costs. 3. Using the high-low method, prepare a cost formula for the receiving activity. 4. Using the method of least squares, prepare a cost formula for the receiving activity. What is the coefficient of determination?arrow_forwardOlympus, Inc., manufactures three models of mattresses: the Sleepeze, the Plushette, and the Ultima. Forecast sales for next year are 15,000 for the Sleepeze, 12,000 for the Plushette, and 5,000 for the Ultima. Gene Dixon, vice president of sales, has provided the following information: a. Salaries for his office (including himself at 65,000, a marketing research assistant at 40,000, and an administrative assistant at 25,000) are budgeted for 130,000 next year. b. Depreciation on the offices and equipment is 20,000 per year. c. Office supplies and other expenses total 21,000 per year. d. Advertising has been steady at 20,000 per year. However, the Ultima is a new product and will require extensive advertising to educate consumers on the unique features of this high-end mattress. Gene believes the company should spend 15 percent of first-year Ultima sales for a print and television campaign. e. Commissions on the Sleepeze and Plushette lines are 5 percent of sales. These commissions are paid to independent jobbers who sell the mattresses to retail stores. f. Last year, shipping for the Sleepeze and Plushette lines averaged 50 per unit sold. Gene expects the Ultima line to ship for 75 per unit sold since this model features a larger mattress. Required: 1. Suppose that Gene is considering three sales scenarios as follows: Prepare a revenue budget for the Sales Division for the coming year for each scenario. 2. Prepare a flexible expense budget for the Sales Division for the three scenarios above.arrow_forward
- The controller for Muir Companys Salem plant is analyzing overhead in order to determine appropriate drivers for use in flexible budgeting. She decided to concentrate on the past 12 months since that time period was one in which there was little important change in technology, product lines, and so on. Data on overhead costs, number of machine hours, number of setups, and number of purchase orders are in the following table. Required: 1. Calculate an overhead rate based on machine hours using the total overhead cost and total machine hours. (Round the overhead rate to the nearest cent and predicted overhead to the nearest dollar.) Use this rate to predict overhead for each of the 12 months. 2. Run a regression equation using only machine hours as the independent variable. Prepare a flexible budget for overhead for the 12 months using the results of this regression equation. (Round the intercept and x-coefficient to the nearest cent and predicted overhead to the nearest dollar.) Is this flexible budget better than the budget in Requirement 1? Why or why not?arrow_forwardSkulas, Inc., manufactures and sells Skulas manufactures a single model, the Pipex. In late 2017, Skulas's management accountant gathered the following data to prepare budgets for January 2018: Data Table Materials and Labor Requirements Direct materials Wood 9 board feet (b.f.) per snowboard Fiberglass 7 yards per snowboard Direct manufacturing labor 8 hours per snowboard Skulas's CEO expects to sell 1 comma 300 snowboards during January 2018 at an estimated retail price of $ 650 per board.Further, the CEO expects 2018 beginning inventory of 600 snowboards and would like to end January 2018 with 600 snowboards in stock. Direct Materials Inventories Beginning Inventory 1/1/2018 Ending Inventory 1/31/2018 Wood 2,020 b.f. 1,520 b.f. Fiberglass 1,020 yards 2,020 yards Variable manufacturing overhead is $ 8 per direct manufacturinglabor-hour. There are also $ 20 comma 800 in fixed manufacturing…arrow_forwardTake me to the text Adrian's Restaurant is a 57-seat restaurant open every day for lunch and dinner. For the month of May, it plans to turn over the restaurant 1.5 times at lunch and 2.5 times at dinner. Each server can handle 19 guests at a time. Lunch shifts are typically 3 hours and dinner shifts are typically 5 hours. Servers earn $16 per hour. Calculate the cost of server labour for lunch, dinner and in total for the month of May. Do not enter dollar signs or commas in the input boxes. Round all answers to the nearest whole number. Lunch Labour Cost = $ 240 Dinner Labour Cost = $ 640 Total Labour Cost = $ 880 Checkarrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning