Expected Treatments= 1,000 Standard Cost Profile Lab Treatment SU #12 Expected Treatments= 1,000 Quantity Quantity. Variable Average Average Resource Unit Cost Variable Fixed Cost Fixed Cost Total Cost Labor 0.80 0.80 $16.00 $12.80 $12.80 $25.60 Supplies 7.0O 1.10 7.70 7.70 $20.50 $12.80 $33.30 Actual Month Cost Lab Treatment SU #12 Actual Treatments = 1,100 Home Health Agency Costs Resource Quantity Used Unit Cost Total Cost Labor 1,600 $17.00 $27,200 Supplies 7,500 1.00 7,500 $34,700 Calculate the following variances and indicate whether each variance is favorable or unfavorable:

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

Please provide answers in excel with formulas.

Calculate the following variances and indicate whether each variance is favorable or unfavorable:

1.5. Volume Variance
1.6. Total Variance

Expected Treatments= 1,000
Standard Cost Profile Lab Treatment SU #12 Expected Treatments= 1,000
Quantity
Quantity.
Variable
Average
Fixed Cost Total Cost
Average
Resource
Unit Cost
Variable
Fixed
Cost
Labor
0.80
0.80
$16.00
$12.80
$12.80
$25.60
Supplies 7.00
1.10
7.70
7.70
$20.50
$12.80
$33.30
Actual Month Cost
Lab Treatment SU #12
Actual Treatments = 1,100
Home Health Agency Costs
Resource Quantity Used
Unit Cost
Total Cost
Labor
1,600
$17.00
$27,200
Supplies
7,500
1.00
7,500
$34,700
Calculate the following variances and indicate whether each variance is favorable
or unfavorable:
Transcribed Image Text:Expected Treatments= 1,000 Standard Cost Profile Lab Treatment SU #12 Expected Treatments= 1,000 Quantity Quantity. Variable Average Fixed Cost Total Cost Average Resource Unit Cost Variable Fixed Cost Labor 0.80 0.80 $16.00 $12.80 $12.80 $25.60 Supplies 7.00 1.10 7.70 7.70 $20.50 $12.80 $33.30 Actual Month Cost Lab Treatment SU #12 Actual Treatments = 1,100 Home Health Agency Costs Resource Quantity Used Unit Cost Total Cost Labor 1,600 $17.00 $27,200 Supplies 7,500 1.00 7,500 $34,700 Calculate the following variances and indicate whether each variance is favorable or unfavorable:
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
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