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:

EBK CFIN
6th Edition
ISBN:9781337671743
Author:BESLEY
Publisher:BESLEY
Chapter10: Project Cash Flows And Risk
Section: Chapter Questions
Problem 19PROB
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
EBK CFIN
EBK CFIN
Finance
ISBN:
9781337671743
Author:
BESLEY
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning