Horngren's Accounting (12th Edition)
12th Edition
ISBN: 9780134486444
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 23, Problem E23.21E
Calculating
Learning Objective 4
1, VOH Cost Var. $1,600 U
Mills, Inc, is a competitor of Murry, Inc, from Exercise E23-18 Mills also uses a
Static budget variable overhead | $1,200 |
Static budget fixed overhead | $ 1,600 |
Static budget direct labor hours | 800 hours |
Static budget number of units | 400 units |
Standard direct labor hours | 2 hours per unit |
Mills allocates manufacturing overhead to production based on standard direct labor hours. Mills reported the following actual results for 2018: actual number of units produced, 1,000; actual variable overhead, $4,000; actual fixed overhead, $3,100; actual direct labor hours, 1,600
Requirements
1. Compute the variable overhead cost and efficiency variances and fixed overhead cost and volume variances.
2. Explain why the variances are favorable or unfavorable.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
ABSORPTION COSTING VERSUS THROUGHPUT COSTING
The book The Goal illustrates the concept of throughput costing. For the problem below
prepare all journal entries and determine the impact on the income statement of the
differences between absorption costing (normal accounting) and throughput costing.
HINT: pay very careful attention to definitions of throughput, inventory and operating
expense from the book
BUDGETED MANUFACTURING COSTS
DIRECT MATERIAL
$20
PER UNIT
DIRECT LABOR
$2
PER UNIT
VARIABLE OVERHEAD
$10
PER UNIT
FIXED OVERHEAD
$150,000
YEAR 1
NO BEGINNING INVENTORY
ACTUAL COSTS OF PRODUCTION EQUALS ABOVE MANUFACTURING COSTS
PURCHASE DIRECT MATERAILS OF
$200,000
INCUR SELLING AND ADMIN COSTS OF
$80,000
#UNITS PRODUCED
10,000
# UNITS SOLD
9,000
SALES PRICE OF UNITS SOLD
$100
YEAR 2
THERE…
D
F
G
H
1 Function: IF; Formula: Subtract, Multiply; CelI Referencing
3 Using Excel to Determine Overhead Variances
Student Work Area
4
PROBLEM
Required: Provide input into cells shaded in yellow in this template.
Use cell references to the Problem area with mathematical formulas
5 In October, Pine Company was determining its overhead variance. Its
6 predetermined overhead rate is based on direct labor hours. The
7 following information was provided.
in the input cells. In the last input field, input an IF function with cell
references to your work area.
8
$ 118,000
Manufacturing overhead costs incurred
Actual direct labor hours
9
10
11
21.000
Compute the amount of the total overhead variance and designate if
the variance is favorable or unfavorable using Excel's IF function.
Standard hours allowed for work done
20,600
12
Predetermined overhead rate
2$
6.00
13
Actual overhead
14
Overhead applied
15
16
17
18
19
Total overhead variance
Nature of variance
20
21
A manufacturer uses activity-based costing to assign overhead cost to products. Budgeted cost information for its activities follows.
Activity
Purchasing
Factory services
Setup
Budgeted Cost
$ 183,600
102,450
67,450
Activity Cost Driver
Purchase orders.
Square feet
Setups
Compute an activity rate for each activity. (Round your answers to 2 decimal places.)
Budgeted Activity Usage
5,100 purchase orders.
5,600 square feet
50 Setups
Activity
Budgeted Cost
Purchasing
$
183,600
Factory services
$
102,450
Setup
$
67,450
Budgeted Activity Usage
Activity Rate
Chapter 23 Solutions
Horngren's Accounting (12th Edition)
Ch. 23 - Prob. 1QCCh. 23 - MajorNet Systems is a start-up company that makes...Ch. 23 - MajorNet Systems is a start-up company that makes...Ch. 23 - MajorNet Systems is a start-up company that makes...Ch. 23 - MajorNet Systems has budgeted three hours of...Ch. 23 - MajorNet Systems has budgeted three hours of...Ch. 23 - FrontGrade Systems allocates manufacturing...Ch. 23 - FrontGrade Systems allocates manufacturing...Ch. 23 - FrontGrade Systems allocates manufacturing...Ch. 23 - The person probably most responsible for the...
Ch. 23 - HajorNet System’s static budget predicted...Ch. 23 - What is a variance?Ch. 23 - Explain the difference between a favorable and an...Ch. 23 - What is a static budget performance report?Ch. 23 - How do flexible budgets differ from static...Ch. 23 - How is a flexible budget used?Ch. 23 - What are the two components of the static budget...Ch. 23 - What is a flexible budget performance report?Ch. 23 - What is a standard cost system?Ch. 23 - Explain the difference between a cost standard and...Ch. 23 - Give the general formulas for determining cost and...Ch. 23 - How does the static budget affect cost and...Ch. 23 - List the direct materials variances, and briefly...Ch. 23 - List the direct labor variances, and briefly...Ch. 23 - List the variable overhead variances, and briefly...Ch. 23 - List the fixed overhead variances, and briefly...Ch. 23 - How is the fixed overhead volume variance...Ch. 23 - What is management by exception?Ch. 23 - List the eight product variances and the manager...Ch. 23 - Briefly describe how journal entries differ in a...Ch. 23 - What is a standard cost income statement?Ch. 23 - Matching terms Learning Objective 1 Match each...Ch. 23 - Preparing flexible budgets Learning Objective 1...Ch. 23 - Calculating flexible budget variances Learning...Ch. 23 - Matching terms Learning Objective 2 Match each...Ch. 23 - Identifying the benefits of standard costs...Ch. 23 - Calculating materials variances Learning Objective...Ch. 23 - Calculating labor variances Learning Objective 3...Ch. 23 - Interpreting material and labor variances Learning...Ch. 23 - Computing standard overhead allocation rates...Ch. 23 - Computing overhead variances Learning Objective 4...Ch. 23 - Understanding variance relationships Learning...Ch. 23 - Journalizing materials entries Learning Objectives...Ch. 23 - Journalizing labor entries Learning Objectives 6...Ch. 23 - Preparing a standard cost income statement...Ch. 23 - Preparing a flexible budget Learning Objective 1...Ch. 23 - Preparing a flexible budget performance report...Ch. 23 - Preparing a flexible budget performance report...Ch. 23 - Defining the benefits of setting cost standards...Ch. 23 - Calculating materials and labor variances Learning...Ch. 23 - Computing overhead variances Learning Objective 4...Ch. 23 - Calculating overhead variances Learning Objective...Ch. 23 - Preparing a standard cost income statement...Ch. 23 - Preparing journal entries Learning Objective 6 MOH...Ch. 23 - Preparing a standard cost income statement...Ch. 23 - Preparing a flexible budget performance report...Ch. 23 - Preparing a flexible budget computing standard...Ch. 23 - Computing standard cost variances and reporting to...Ch. 23 - Computing and journalizing standard cost variances...Ch. 23 - Prob. P23.29APGACh. 23 - Preparing a flexible budget performance report...Ch. 23 - Preparing a flexible budget and computing standard...Ch. 23 - Prob. P23.32BPGBCh. 23 - Prob. P23.33BPGBCh. 23 - Preparing a standard cost income statement...Ch. 23 - Prob. P23.35CTCh. 23 - Preparing a flexible budget and performance report...Ch. 23 - Prob. 23.1TIATCCh. 23 - Decision Case 23-1 Suppose you manage the local...Ch. 23 - Fraud Case 23-1 Drew Castello, general manager of...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Combat Fire, Inc. manufactures steel cylinders and nozzles for two models of fire extinguishers: (1) a home fire extinguisher and (2) a commercial fire extinguisher. The home model is a high-volume (54,000 units), half-gallon cylinder that holds 2 1/2 pounds of multi-purpose dry chemical at 480 PSI. The commercial model is a low-volume (10,200 units), two-gallon cylinder that holds 10 pounds of multi-purpose dry chemical at 390 PSI. Both products require 1.5 hours of direct labor for completion. Therefore, total annual direct labor hours are 96,300 or [1.5 hours x (54,000 + 10,200)]. Estimated annual manufacturing overhead is $1,588,566. Thus, the predetermined overhead rate is $16.50 or ($1,588,566 ÷ 96,300) per direct labor hour. The direct materials cost per unit is $18.50 for the home model and $26.50 for the commercial model. The direct labor cost is $19 per unit for both the home and the commercial models. The company's managers identified six activity cost pools and related cost…arrow_forwardA manufacturer uses activity-based costing to assign overhead cost to products. Budgeted cost information for its activities follows. Budgeted Cost $ 210,600 Activity Cost Driver Purchase orders Square feet Budgeted Activity Usage 5,400 purchase orders 5,900 square feet 50 Setups Factory services 104,250 Setup 67,750 Setups Compute an activity rate for each activity. (Round your answers to 2 decimal places.) Activity Purchasing Activity Purchasing Factory services Setup Budgeted Cost 210,600 104,250 67,750 $ $ $ Budgeted Activity Usage Activity Ratearrow_forwardCengageNOWv2 | Online teachin x * Cengage Learning + n/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false еВook E Print Item Equivalent Units of Production: Weighted Average Cost Method The following information concerns production in the Finishing Department for May. The Finishing Department uses the weighted average cost method. ACCOUNT Work in Process-Finishing Department ACCOUNT No. Balance Date Item Debit Credit Debit Credit May 1 Bal., 25,400 units, 70% completed 101,600 31 Direct materials, 124,500 units 303,780 405,380 31 Direct labor 188,300 593,680 31 Factory overhead 191.400 785,080 31 Goods transferred, 132,100 units 755,612 29,468 31 Bal., 2 units, 30% completed 29,468 a. Determine the number of units in work in process inventory at the end of the month. units b. Determine the number of whole units to be accounted for and to be assigned costs and the equivalent units of production for May. Whole units units Equivalent units of…arrow_forward
- 1. Assign Overhead Costs to Activity Cost Pools 国日 First-Stage Allocation to Activity Cost Pools - Excel Sign In FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri -A A 10 Paste BIU - A - Alignment Number Conditional Format as Cell Cells Formatting - Table - Styles - Clipboard Font Styles A1 fx A C E F G 1 == 2 Total costs and distribution of resource consumption across activity cost pools: 3 4 Activity Cost Pools Customer Product Customer Total Cost Orders Development Relations Other Total 6 Production Department: 7 Indirect factory wages $ 400,000 50% 30% 15% 5% 100% Factory equipment depreciation Factory utilities 10 Factory property taxes and insurance 8 150,000 55% 30% 0% 15% 100% 9 120,000 59% 34% 0% 7% 100% 75,000 57% 33% 0% 10% 100% 11 12 General Administrative Department: Administrative wages and salaries Office equipment depreciation 13 275,000 20% 10% 40% 30% 100% 14 40,000 32% 16% 15% 37% 100% 15 Administrative property taxes and insurance 60,000 0% 0% 0% 100%…arrow_forwardActivity Clerical support Facility services Client consultations Activity usage for each service follows. Activity Cost Driver Documents Billable hours Court dates Budgeted Cost Required 1 Required 2 $ 57,600 20,160 72,800 Activity Clerical support Facility services Client consultations Budgeted Activity Usage 360 documents 2,520 billable hours 28 court dates Activity Usage Litigation 210 920 20 Mediation 150 1,600 8 Required: 1. Compute an activity rate for each activity using activity-based costing. 2. Compute overhead cost per unit (case) for both litigation and mediation using activity-based Total 360 2,520 28 Complete this question by entering your answers in the tabs below. Compute an activity rate for each activity using activity-based costing. (Round "Activity rate" to 2 c Budgeted Cost Budgeted Activity Usage Activity Ratearrow_forwardComputing and using activity-based costing overhead allocation rates Koehler (see Exercise E19-15 and Exercise E19-16) makes handheld calculators in two models—basic and professional—and wants to further refine its costing system by allocating overhead using activity-based costing. The estimated $721,000 of manufacturing overhead has been divided into three primary activities: Materials Handling, Machine Setup, and Insertion of Parts. The following data have been compiled: Requirement 1 Koehler expects to produce 200,000 basic models and 200,000 professional models. Compute the predetermined overhead allocation rates using activity-based costing. How much overhead is allocated to the basic model? To the professional model? Requirement 2 Compare your answers for Exercise E19-15, Exercise E19-16, and Exercise E19-17. What conclusions can you draw? Note: Short Exercise S19-15 and ES19-16 must be completed before attempting Short Exercise 519-17.arrow_forward
- Activity-based costing Brooklyn Cycles produces custom bicycles and has used a traditional manufacturing overhead application rate based on direct labor hours. Currently, overhead is applied at the rate of $26/DLH. Brooklyn is now considering using activity-based driver rates to improve manufacturing overhead costing accuracy. Budgeted manufacturing overhead costs for expected driver activity are:Budgeted Cost Budgeted ActivityMachining time................... $250,000 10,000 hoursDirect labor time................. $280,000 20,000 hoursInspection time................... $ 32,000 4,000 hoursRequired:Calculate manufacturing overhead rates that would be applied to bicycles producedusing activity-based costing, and explain how Brooklyn Cycles could achieveimproved costing accuracy.arrow_forwardplease answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image) Question Content Area Activity rates and product costs using activity-based costing Idris Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the fixtures. These activities and their associated budgeted activity costs and activity bases are as follows: Activity BudgetedActivity Cost Activity Base Casting $640,000 Machine hours Assembly 125,000 Direct labor hours Inspecting 30,000 Number of inspections Setup 28,000 Number of setups Materials handling 20,000 Number of loads Corporate records were obtained to estimate the amount of activity to be used by the two products. The estimated activity-base usage quantities and units produced follow: Activity Base Entry Dining Total Machine hours 7,500 12,500 20,000…arrow_forwardes D ♪ Mc Graw Classes N Netflix Activity Assembly Product design Electricity Setup Total Craftmore Machining reports the following budgeted overhead cost and related data for this year. Budgeted Cost $ 477,750 73,500 24,500 61,250 $ 637,000 Activity Cost Driver Direct labor hours (DLH) Engineering hours (EH) Machine hours (MH) Setups Required 1 25 Required 2 Dashboard Activity Cost Driver Direct labor hours (DLH) Engineering hours (EH) Machine hours (MH) Setups Required: 1. Compute a single plantwide overhead rate assuming the company allocates overhead cost based on 13,000 direct labor hours. 2. Job 31 used 320 direct labor hours and Job 42 used 560 direct labor hours. Allocate overhead cost to each job using the single plantwide overhead rate from part 1. 3. Compute an activity rate for each activity using activity-based costing. 4. Allocate overhead costs to Job 31 and Job 42 using activity-based costing. 80 Job 31 Activity Usage Required 3 320 35 60 5 Complete this question by…arrow_forward
- Ice Cool produces two different models of air conditioners. The activities, costs, and cost drivers associated with the production processes follow. Budgeted Budgeted Cost Activity Cost Activity Driver Process Activity Usage Machine hours (MH) Setups $ Assembly Machining 7,800 311,400 20,000 Setups 120 331,400 Finishing Inspecting Inspections 840 226,000 $ 134,000 Support Purchasing Purchase orders 510 Additional production information concerning its two models follows. Units and Activities Units produced Machine hours Setups Inspections Model X Model Z 1,600 2,200 40 3,200 5,600 80 500 340 340 170 Purchase orders Per Unit Model X Model Z Selling price per unit Direct materials cost $ 410 $ 390 150 115 per unit Direct labor cost per unit 125 150 1. Compute the activity rate for each activity using activity-based costing. 2. Using activity-based costing, compute the overhead cost per unit for each model. 3. Compute the total product cost per unit for each model. 4. For each model,…arrow_forwardplease answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image) Churchill Products is considering updating its cost system to an activity-based costing system and is interested in understanding the effects. The company’s cost accountant has identified three overhead cost pools along with appropriate cost drivers for each pool. Cost Pools Costs Activity Drivers Utilities $ 315,000 63,000 machine-hours Scheduling and setup 300,000 600 setups Material handling 795,000 1,590,000 pounds of material The company manufactures three models of water basins (Oval, Round, and Square). The plans for production for the next year and the budgeted direct costs and activity by product line are as follows. Products Oval Round Square Total direct costs (material and labor) $ 80,000 $ 70,000 $ 80,000 Total…arrow_forwardE4-14 Venus Creations sells window treatments (shades, blinds, and awnings) to both commercial and residential customers. The following information relates to its budgeted operations for the current year. $300,000 Direct materials costs Direct labor costs 150,000 Setup time 500,000 Supervision $ 30,000 100,000 Commercial Operating income (loss) $480,000 Overhead costs Revenues $85,000 85,000 Estimated Overhead 90,000 60,000 $85,000 The controller, Peggy Kingman, is concerned about the residential product line. She cannot understand why this line is not more profitable given that the installations of window coverings are less complex for residential customers. In addition, the residential client base resides in close proximity to the company office, so travel costs are not as expensive on a per client visit for residential customers. As a result, she has decided to take a closer look at the overhead costs assigned to the two product lines to determine whether a more accurate product…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
What is variance analysis?; Author: Corporate finance institute;https://www.youtube.com/watch?v=SMTa1lZu7Qw;License: Standard YouTube License, CC-BY