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:

Pkg Acc Infor Systems MS VISIO CD
10th Edition
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:Ulric J. Gelinas
Chapter17: Acquiring And Implementing Accounting Information Systems
Section: Chapter Questions
Problem 1SP
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
Pkg Acc Infor Systems MS VISIO CD
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:
9781133935940
Author:
Ulric J. Gelinas
Publisher:
CENGAGE L
EBK CFIN
EBK CFIN
Finance
ISBN:
9781337671743
Author:
BESLEY
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Essentials Of Business Analytics
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,