A D 1 Chapter 09: Applying Excel 2 3 Data Exhibit 9-8: Standard Cost Card 4 Inputs Standard Quantity Standard Price 6 Direct materials 7 Direct labor 8 Variable manufacturing overhead 3.0 pounds 0.50 hours 4.00 per pound 22.00 per hour 0.50 hours 6.00 per hour 10 Actual results: 11 Actual output 1,930 units 12 Actual variable manufacturing overhead cost 6,667.00 13 Actual Quantity Actual price 5,650 pounds 3.70 per pound 21.60 per hour 14 Actual direct materials cost 15 Actual direct labor cost 1,130 hours %24

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

a-1. What is the materials quantity variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)).

 

 

 

 

 

a-2. What is the materials price variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)).

 

 

 

 

 

b-1. What is the labor efficiency variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)).

 

 

 

 

 

b-2. What is the labor rate variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Round your final answer to nearest whole dollar amount.)

 

 

 

 

 

c-1. What is the variable overhead efficiency variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)).

 

 

 

 

 

c-2. What is the variable overhead rate variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)).

 

 

 

 

**Chapter 09: Applying Excel: Exercise (Part 2 of 2)**

**Requirement 2:**
Revise the data in your worksheet to reflect the results for the subsequent period as shown below:

---

### Data

**Exhibit 9-8: Standard Cost Card**

| Inputs                        | Standard Quantity | Standard Price        |
|------------------------------|-------------------|-----------------------|
| **Direct materials**         | 3.0 pounds        | $4.00 per pound       |
| **Direct labor**             | 0.50 hours        | $22.00 per hour       |
| **Variable manufacturing overhead** | 0.50 hours    | $6.00 per hour        |

---

### Actual results:

- **Actual output:** 1,930 units
- **Actual variable manufacturing overhead cost:** $6,667.00

|                                   | Actual Quantity  | Actual Price         |
|-----------------------------------|------------------|-----------------------|
| **Actual direct materials cost**   | 5,650 pounds     | $3.70 per pound      |
| **Actual direct labor cost**       | 1,130 hours      | $21.60 per hour      |

This table provides the standard and actual cost details necessary for analyzing production efficiency and cost management.
Transcribed Image Text:**Chapter 09: Applying Excel: Exercise (Part 2 of 2)** **Requirement 2:** Revise the data in your worksheet to reflect the results for the subsequent period as shown below: --- ### Data **Exhibit 9-8: Standard Cost Card** | Inputs | Standard Quantity | Standard Price | |------------------------------|-------------------|-----------------------| | **Direct materials** | 3.0 pounds | $4.00 per pound | | **Direct labor** | 0.50 hours | $22.00 per hour | | **Variable manufacturing overhead** | 0.50 hours | $6.00 per hour | --- ### Actual results: - **Actual output:** 1,930 units - **Actual variable manufacturing overhead cost:** $6,667.00 | | Actual Quantity | Actual Price | |-----------------------------------|------------------|-----------------------| | **Actual direct materials cost** | 5,650 pounds | $3.70 per pound | | **Actual direct labor cost** | 1,130 hours | $21.60 per hour | This table provides the standard and actual cost details necessary for analyzing production efficiency and cost management.
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
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