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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education