yards @ $2.75 yards @ $2.70 nours @ $18.00
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
Chapter10: Standard Costing And Variance Analysis
Section: Chapter Questions
Problem 39BEB: Variable Overhead Spending and Efficiency Variances, Columnar and Formula Approaches Aretha Company...
Related questions
Question
![Basic Variance Analysis and the Impact of Variances on Unit Costs - Excel
Sign In
FILE
HOME
INSERT
PAGE LAYOUT
FORMULAS
DATA
REVIEW
VIEW
Calibri
11
A A
%
Alignment Number Conditional Format as
Formatting Table Styles
Paste
В I U
Cell
Cells
Editing
Clipboard
Font
Styles
G26
fe
A
B
E
G
H
3 Direct materials:
4 Standard
$2.75 per yard
$2.70 per yard
2.4 yards @
$6.60
5 Actual
3 yards @
$8.10
6 Direct labor:
7 Standard
8 Actual
9 Variable overhead:
10 Standard
0.6 hours @
$18.00 per hour
$22.00 per hour
10.80
0.5 hours @
11.00
0.6 hours @
$7.00 per hour
$7.10 per hour
4.20
11 Actual
0.5 hours @
3.55
12
13 Total cost per unit
$21.60
$22.65
14
15 Excess of actual cost over standard cost per unit
$1.05
16
17 Actual production for the month
18 Variable overhead is assigned to products based on direct labor hours. There
19 was no beginning or ending inventory of materials for the month.
13,500 units
20
21 Using formulas, compute the following. Input all numbers as positive amounts.
Indicate whether the variances are F or U. Write if statements for variance cells F30 to F47. Use cell
22
references (formulas) for cells D53 - D60. Enter an For U to indicate the correct variance in cells
F54 to F62.
23
24
Sheeti
>](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ffa0e84d9-b938-4903-a683-f1a105a116b2%2F17f97d41-106a-4032-97f8-23d501c88382%2F828sim2_processed.png&w=3840&q=75)
Transcribed Image Text:Basic Variance Analysis and the Impact of Variances on Unit Costs - Excel
Sign In
FILE
HOME
INSERT
PAGE LAYOUT
FORMULAS
DATA
REVIEW
VIEW
Calibri
11
A A
%
Alignment Number Conditional Format as
Formatting Table Styles
Paste
В I U
Cell
Cells
Editing
Clipboard
Font
Styles
G26
fe
A
B
E
G
H
3 Direct materials:
4 Standard
$2.75 per yard
$2.70 per yard
2.4 yards @
$6.60
5 Actual
3 yards @
$8.10
6 Direct labor:
7 Standard
8 Actual
9 Variable overhead:
10 Standard
0.6 hours @
$18.00 per hour
$22.00 per hour
10.80
0.5 hours @
11.00
0.6 hours @
$7.00 per hour
$7.10 per hour
4.20
11 Actual
0.5 hours @
3.55
12
13 Total cost per unit
$21.60
$22.65
14
15 Excess of actual cost over standard cost per unit
$1.05
16
17 Actual production for the month
18 Variable overhead is assigned to products based on direct labor hours. There
19 was no beginning or ending inventory of materials for the month.
13,500 units
20
21 Using formulas, compute the following. Input all numbers as positive amounts.
Indicate whether the variances are F or U. Write if statements for variance cells F30 to F47. Use cell
22
references (formulas) for cells D53 - D60. Enter an For U to indicate the correct variance in cells
F54 to F62.
23
24
Sheeti
>
![|日
Basic Variance Analysis and the Impact of Variances on Unit Costs - Excel
FILE
INSERT
VIEW
Sign In
HOME
PAGE LAYOUT
FORMULAS
DATA
REVIEW
Calibri
11
A A
%
Alignment Number Conditional Format as
Formatting- Table Styles
Paste
BIU -
Cll
Cells
Editing
Clipboard
Font
Styles
G26
fe
A.
D
E
F
G
H
26 | Standard Quantity Allowed for Actual Output at Standard Price
27 Actual Quantity of Input, at Standard Price
28 Actual Quantity of Input, at Actual Price
29
30
Materials quantity variance
31
Materials price variance
32
33 Standard Cost Variance Analysis - Direct Labor
34 Standard Hours Allowed for Actual Output at Standard Rate
35 Actual Hours of Input, at Standard Rate
36 Actual Hours of Input, at Actual Rate
37
38
Labor efficiency variance
39
Labor rate variance
40
41 Standard Cost Variance Analysis - Variable Manufacturing Overhead
42 Standard Hours Allowed for Actual Output at Standard Rate
43 Actual Hours of Input, at Standard Rate
44 Actual Hours of Input, at Actual Rate
45
46
Variable overhead efficiency variance
47
Variable overhead rate variance
48
49 Using formulas, compute the amount of the unit cost difference
Sheet1
>
..](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ffa0e84d9-b938-4903-a683-f1a105a116b2%2F17f97d41-106a-4032-97f8-23d501c88382%2F63h1of_processed.png&w=3840&q=75)
Transcribed Image Text:|日
Basic Variance Analysis and the Impact of Variances on Unit Costs - Excel
FILE
INSERT
VIEW
Sign In
HOME
PAGE LAYOUT
FORMULAS
DATA
REVIEW
Calibri
11
A A
%
Alignment Number Conditional Format as
Formatting- Table Styles
Paste
BIU -
Cll
Cells
Editing
Clipboard
Font
Styles
G26
fe
A.
D
E
F
G
H
26 | Standard Quantity Allowed for Actual Output at Standard Price
27 Actual Quantity of Input, at Standard Price
28 Actual Quantity of Input, at Actual Price
29
30
Materials quantity variance
31
Materials price variance
32
33 Standard Cost Variance Analysis - Direct Labor
34 Standard Hours Allowed for Actual Output at Standard Rate
35 Actual Hours of Input, at Standard Rate
36 Actual Hours of Input, at Actual Rate
37
38
Labor efficiency variance
39
Labor rate variance
40
41 Standard Cost Variance Analysis - Variable Manufacturing Overhead
42 Standard Hours Allowed for Actual Output at Standard Rate
43 Actual Hours of Input, at Standard Rate
44 Actual Hours of Input, at Actual Rate
45
46
Variable overhead efficiency variance
47
Variable overhead rate variance
48
49 Using formulas, compute the amount of the unit cost difference
Sheet1
>
..
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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.Recommended textbooks for you
![Managerial Accounting: The Cornerstone of Busines…](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
![Principles of Cost Accounting](https://www.bartleby.com/isbn_cover_images/9781305087408/9781305087408_smallCoverImage.gif)
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
![Managerial Accounting: The Cornerstone of Busines…](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
![Principles of Cost Accounting](https://www.bartleby.com/isbn_cover_images/9781305087408/9781305087408_smallCoverImage.gif)
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning