ariance Analysis llen Francis Doyle, LLC is a small manufacturer of Monster Candy, a gummy candy haped as monsters. The following information pertains to November's production. Material: 2.3 ounces per unit @ $0.4 per ounce abor: 2 hours per unit @ $13.5 per hour /ariable OH: 2 hours per unit @ $3 per hour Fixed OH: 2 hours per unit @ $0.85 per hour* based on budgeted production of 2,700 units Actuals Production: 3,000 units produced during the month Material: 7,200 ounces purchased and used @ $0.385 per ounce abor: 6,450 direct labor hours @ $13.6 per hour lariable OH: $18,060 Fixed OH: $5,676 REQUIRED Determine the following: .. Material price variance . Material usage (quantity) variance E. Labor rate variance

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
Excel Variance Problem ,
Variance Analysis
Allen Francis Doyle, LLC is a small manufacturer of Monster Candy, a gummy candy
shaped as monsters. The following information pertains to November's production.
Material: 2.3 ounces per unit @ $0.4 per ounce
Labor: 2 hours per unit @ $13.5 per hour
Variable OH: 2 hours per unit @ $3 per hour
Fixed OH: 2 hours per unit @ $0.85 per hour*
*based on budgeted production of 2,700 units
Actuals
Production: 3,000 units produced during the month
Material: 7,200 ounces purchased and used @ $0.385 per ounce
Labor: 6,450 direct labor hours @ $13.6 per hour
Variable OH: $18,060
Fixed OH: $5,676
REQUIRED Determine the following:
1. Material price variance
2. Material usage (quantity) variance
3. Labor rate variance
4. Labor efficiency variance
5. Variable overhead spending variance
6. Variable overhead usage variance
7. Fixed overhead spending variance
8. Fixed overhead volume variance
Transcribed Image Text:Excel Variance Problem , Variance Analysis Allen Francis Doyle, LLC is a small manufacturer of Monster Candy, a gummy candy shaped as monsters. The following information pertains to November's production. Material: 2.3 ounces per unit @ $0.4 per ounce Labor: 2 hours per unit @ $13.5 per hour Variable OH: 2 hours per unit @ $3 per hour Fixed OH: 2 hours per unit @ $0.85 per hour* *based on budgeted production of 2,700 units Actuals Production: 3,000 units produced during the month Material: 7,200 ounces purchased and used @ $0.385 per ounce Labor: 6,450 direct labor hours @ $13.6 per hour Variable OH: $18,060 Fixed OH: $5,676 REQUIRED Determine the following: 1. Material price variance 2. Material usage (quantity) variance 3. Labor rate variance 4. Labor efficiency variance 5. Variable overhead spending variance 6. Variable overhead usage variance 7. Fixed overhead spending variance 8. Fixed overhead volume variance
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Cost Sheet
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
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