Requirement 1 Requirement 2 Chapter 10: Applying Excel Data Exhibit 10-1: Standard Cost Card Direct materials Direct labor Variable manufacturing overhead Actual results: Actual output Actual variable manufacturing overhead cost Actual direct materials cost Actual direct labor cost Inputs Enter a formula into each of the cells marked with a ? below Main Example: Chapter 10 Exhibit 10-4: Standard Cost Variance Analysis-Direct Materials Actual Quantity of Input, at Actual Price Actual Quantity of Input, at Standard Price Standard Quantity Allowed for the Actual Output, at Standard Price Direct materials variances: Materials price variance Materials quantity variance Materials spending variance Exhibit 10-6: Standard Cost Variance Analysis-Direct Labor Actual Hours of Input, at Actual Rate Actual Hours of Input, at Standard Rate Standard Hours Allowed for the Actual Output, at Standard Rate Direct labor variances: Labor rate variance Labor efficiency variance Labor spending variance Standard Quantity 3.0 pounds 0.50 hours 0.50 hours Actual Hours of Input, at Standard Rate Standard Hours Allowed for the Actual Output, at Standard Rate Variable overhead variances: Variable overhead rate variance Variable overhead efficiency variance Variable overhead spending variance Exhibit 10-8: Standard Cost Variance Analysis-Variable Manufacturing Overhead Actual Hours of Input, at Actual Rate 2,000 units $7,140 Actual Quantity 6,500 pounds 1,050 hours ? pounds x ? pounds x ? pounds x ? ? ? ? hours x ? hours x ? hours * ? ? ? ? hours x ? hours x ? hours x ? ? ? Standard Price $4.00 per pound $22.00 per hour $6.00 per hour Actual price $3.80 per pound $21.60 per hour ? per pound= ? per pound = ? per pound= ? per hour = ? per hour = ? per hour = ? per hour = ? per hour = ? per hour = ? ? ? ? ? ? ? ? ?

Accounting (Text Only)
26th Edition
ISBN:9781285743615
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Carl Warren, James M. Reeve, Jonathan Duchac
Chapter21: Cost Behavior And Cost-volume-profit Analysis
Section: Chapter Questions
Problem 21.26EX: Items on variable costing income statement In the following equations, based on the variable costing...
icon
Related questions
Topic Video
Question
Filling in the spaces that have “?”
Requirement 1 Requirement 2
Chapter 10: Applying Excel
Data
Exhibit 10-1: Standard Cost Card
Direct materials
Direct labor
Variable manufacturing overhead
Inputs
Actual results:
Actual output
Actual variable manufacturing overhead cost
Actual direct materials cost
Actual direct labor cost
Enter a formula into each of the cells marked with a ? below
Main Example: Chapter 10
Exhibit 10-4: Standard Cost Variance Analysis-Direct Materials
Actual Quantity of Input, at Actual Price
Actual Quantity of Input, at Standard Price
Standard Quantity Allowed for the Actual Output, at Standard Price
Direct materials variances:
Materials price variance
Materials quantity variance
Materials spending variance
Exhibit 10-6: Standard Cost Variance Analysis-Direct Labor
Actual Hours of Input, at Actual Rate
Actual Hours of Input, at Standard Rate
Standard Hours Allowed for the Actual Output, at Standard Rate
Direct labor variances:
Labor rate variance
Labor efficiency variance
Labor spending variance
Standard Quantity
3.0 pounds
0.50 hours
0.50 hours
2,000 units
$7,140
Actual Quantity
Exhibit 10-8: Standard Cost Variance Analysis-Variable Manufacturing Overhead
Actual Hours of Input, at Actual Rate
Actual Hours of Input, at Standard Rate
Standard Hours Allowed for the Actual Output, at Standard Rate
Variable overhead variances:
Variable overhead rate variance
Variable overhead efficiency variance
Variable overhead spending variance
6,500 pounds
1,050 hours
? pounds x
? pounds x
? pounds x
?
?
?
? hours x
? hours x
? hours x
?
?
?
? hours x
? hours x
? hours *
?
?
?
Standard Price
$4.00 per pound
$22.00 per hour
$6.00 per hour
Actual price
$3.80 per pound
$21.60 per hour
? per pound=
? per pound =
? per pound =
? per hour =
? per hour =
? per hour =
? per hour =
? per hour =
? per hour =
?
?
?
?
?
?
?
?
?
Transcribed Image Text:Requirement 1 Requirement 2 Chapter 10: Applying Excel Data Exhibit 10-1: Standard Cost Card Direct materials Direct labor Variable manufacturing overhead Inputs Actual results: Actual output Actual variable manufacturing overhead cost Actual direct materials cost Actual direct labor cost Enter a formula into each of the cells marked with a ? below Main Example: Chapter 10 Exhibit 10-4: Standard Cost Variance Analysis-Direct Materials Actual Quantity of Input, at Actual Price Actual Quantity of Input, at Standard Price Standard Quantity Allowed for the Actual Output, at Standard Price Direct materials variances: Materials price variance Materials quantity variance Materials spending variance Exhibit 10-6: Standard Cost Variance Analysis-Direct Labor Actual Hours of Input, at Actual Rate Actual Hours of Input, at Standard Rate Standard Hours Allowed for the Actual Output, at Standard Rate Direct labor variances: Labor rate variance Labor efficiency variance Labor spending variance Standard Quantity 3.0 pounds 0.50 hours 0.50 hours 2,000 units $7,140 Actual Quantity Exhibit 10-8: Standard Cost Variance Analysis-Variable Manufacturing Overhead Actual Hours of Input, at Actual Rate Actual Hours of Input, at Standard Rate Standard Hours Allowed for the Actual Output, at Standard Rate Variable overhead variances: Variable overhead rate variance Variable overhead efficiency variance Variable overhead spending variance 6,500 pounds 1,050 hours ? pounds x ? pounds x ? pounds x ? ? ? ? hours x ? hours x ? hours x ? ? ? ? hours x ? hours x ? hours * ? ? ? Standard Price $4.00 per pound $22.00 per hour $6.00 per hour Actual price $3.80 per pound $21.60 per hour ? per pound= ? per pound = ? per pound = ? per hour = ? per hour = ? per hour = ? per hour = ? per hour = ? per hour = ? ? ? ? ? ? ? ? ?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps

Blurred answer
Knowledge Booster
Performance measurements
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
Accounting (Text Only)
Accounting (Text Only)
Accounting
ISBN:
9781285743615
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781285866307
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,