A D 1 Chapter 09: Applying Excel 2 3 Data Exhibit 9-8: Standard Cost Card 4 Inputs Standard Quantity Standard Price 6 Direct materials 7 Direct labor 8 Variable manufacturing overhead 3.0 pounds 0.50 hours 4.00 per pound 22.00 per hour 0.50 hours 6.00 per hour 10 Actual results: 11 Actual output 1,930 units 12 Actual variable manufacturing overhead cost 6,667.00 13 Actual Quantity Actual price 5,650 pounds 3.70 per pound 21.60 per hour 14 Actual direct materials cost 15 Actual direct labor cost 1,130 hours %24

Principles of Cost Accounting
17th Edition
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Edward J. Vanderbeck, Maria R. Mitchell
Chapter4: Accounting For Factory Overhead
Section: Chapter Questions
Problem 4P: Using the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2....
icon
Related questions
Question

a-1. What is the materials quantity variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)).

 

 

 

 

 

a-2. What is the materials price variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)).

 

 

 

 

 

b-1. What is the labor efficiency variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)).

 

 

 

 

 

b-2. What is the labor rate variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Round your final answer to nearest whole dollar amount.)

 

 

 

 

 

c-1. What is the variable overhead efficiency variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)).

 

 

 

 

 

c-2. What is the variable overhead rate variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)).

 

 

 

 

Chapter 09: Applying Excel: Exercise (Part 2 of 2)
Requirement 2:
Revise the data in your worksheet to reflect the results for the subsequent period as shown below:
A
в
D
E
1 Chapter 09: Applying Excel
2
Data
4
Exhibit 9-8: Standard Cost Card
Inputs
Standard Quantity
Standard Price
6 Direct materials
7 Direct labor
Variable manufacturing overhead
3.0 pounds
$
4.00 per pound
0.50 hours
$
22.00 per hour
8
0.50 hours
$
6.00 per hour
9
10 Actual results:
11
Actual output
1,930 units
12
Actual variable manufacturing overhead cost
$
6,667.00
13
Actual Quantity
Actual price
5,650 pounds
1,130 hours
14
Actual direct materials cost
$
3.70 per pound
15
Actual direct labor cost
$
21.60 per hour
%24
%24
Transcribed Image Text:Chapter 09: Applying Excel: Exercise (Part 2 of 2) Requirement 2: Revise the data in your worksheet to reflect the results for the subsequent period as shown below: A в D E 1 Chapter 09: Applying Excel 2 Data 4 Exhibit 9-8: Standard Cost Card Inputs Standard Quantity Standard Price 6 Direct materials 7 Direct labor Variable manufacturing overhead 3.0 pounds $ 4.00 per pound 0.50 hours $ 22.00 per hour 8 0.50 hours $ 6.00 per hour 9 10 Actual results: 11 Actual output 1,930 units 12 Actual variable manufacturing overhead cost $ 6,667.00 13 Actual Quantity Actual price 5,650 pounds 1,130 hours 14 Actual direct materials cost $ 3.70 per pound 15 Actual direct labor cost $ 21.60 per hour %24 %24
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Risk Analysis
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781337119207
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning