Bellingham Company produced 15,400 units of product that required 4 standard direct labor hours per unit. The standard variable overhead cost per unit is $0.90 per direct labor hour. The actual variable factory overhead was $52,850. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Determine the variable factory overhead controllable variance. Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number.

Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter3: Cost Behavior And Cost Forecasting
Section: Chapter Questions
Problem 55E: (Appendix 3A) Method of Least Squares Using Computer Spreadsheet Program The controller for Beckham...
icon
Related questions
Topic Video
Question
100%

Factory overhead controllable variance

Bellingham Company produced 15,400 units of product that required 4 standard direct labor hours per unit. The standard variable overhead cost per unit is $0.90 per direct labor hour. The actual variable factory overhead was $52,850.

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.

Determine the variable factory overhead controllable variance. Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number.

XE Excel
View
Help
V Tell me what you want to do
Formulas
Data
Review
File
Home
Insert
Ev a Av
a Merge
Curre
Arial
10
C14
E
B
IC:
A
Factory overhead controllable variance
1
21
The following data is provided for Bellingham Company:
4.
DATA
6 Units produced
Standard direct labor hours per unit
Standard variable overhead cost per unit
Actual variable factory overhead
10
15,400
4
$0.90 per direct labor hour
$52,850
8.
Using formulas and cell references, perform the required analysis, and input your answer into the green cell in
the Amount column. Select the corresponding type of variance in the dropdown in cell D14. Transfer the numeric
result for the green entry cell C14 into the appropriate fields in CNOWV2 for grading.
11
12
13
14 Variable factory overhead controllable variance
15
16
Amount
Formula
Transcribed Image Text:XE Excel View Help V Tell me what you want to do Formulas Data Review File Home Insert Ev a Av a Merge Curre Arial 10 C14 E B IC: A Factory overhead controllable variance 1 21 The following data is provided for Bellingham Company: 4. DATA 6 Units produced Standard direct labor hours per unit Standard variable overhead cost per unit Actual variable factory overhead 10 15,400 4 $0.90 per direct labor hour $52,850 8. Using formulas and cell references, perform the required analysis, and input your answer into the green cell in the Amount column. Select the corresponding type of variance in the dropdown in cell D14. Transfer the numeric result for the green entry cell C14 into the appropriate fields in CNOWV2 for grading. 11 12 13 14 Variable factory overhead controllable variance 15 16 Amount Formula
Factory overhead controllable variance
Bellingham Company produced 15,400 units of product that required 4 standard direct labor hours per unit. The standard variable overhead cost per unit is $0.90 per
direct labor hour. The actual variable factory overhead was $52,850.
This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.
Open spreadsheet
Determine the variable factory overhead controllable variance. Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a
positive number.
ఉ -
Transcribed Image Text:Factory overhead controllable variance Bellingham Company produced 15,400 units of product that required 4 standard direct labor hours per unit. The standard variable overhead cost per unit is $0.90 per direct labor hour. The actual variable factory overhead was $52,850. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet Determine the variable factory overhead controllable variance. Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number. ఉ -
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Performance measurements
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
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
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,