A company want to find out if there is a linear relationship between indirect labor expense...
A company want to find out if there is a linear relationship between indirect labor expense (ILE), in dollars, and direct labor hours (DLH). Data for direct labor hours and indirect labor expense for 25 months are given.
Please see attached Excel for data.
Based on your results, If direct labor hours (DLH) increases by one
hour, the indirect labor expense (ILE), on average, increases by
approximately how much?
Place your answer, rounded to 2 decimal places, in the blank. Do
not use any stray punctuation marks or a dollar sign. For example,
34.56 would be a legitimate entry.
| DLH(X) | ILE(Y) |
| 20 | 361 |
| 25 | 355 |
| 22 | 376 |
| 23 | 384 |
| 20 | 374 |
| 19 | 311 |
| 24 | 427.2 |
| 28 | 387.5 |
| 26 | 450.8 |
| 29 | 475.2 |
| 27 | 462.6 |
| 22 | 333.3 |
| 26 | 389.9 |
| 25 | 445 |
| 28 | 511 |
| 32 | 501.1 |
| 33 | 544.9 |
| 35 | 423.8 |
| 34 | 574.1 |
| 30 | 535.4 |
| 36 | 444.7 |
| 37 | 578.4 |
| 37 | 399.6 |
| 31 | 355 |
| 20 | 313 |
Homework Answers
Solution: If direct labor hours (DLH) increases by one hour, the indirect labor expense (ILE), on average, increases by approximately 9.32
Explanation:
We need to find the slope of the regression equation in order to find by how much on average ILE will be increased If direct labor hours (DLH) increases by one hour,
We can use the excel function to find the slope of the given data.
The excel function is:
If direct labor hours (DLH) increases by one hour, the indirect labor expense (ILE), on average, increases by approximately how much?
Answer: 
Add Answer to:
A company want to find out if there is a linear relationship
between indirect labor expense...
need the formulas and budget Bumblebee Company estimates that 300,000 direct labor hours will be worked...
need the formulas
and budget Bumblebee Company estimates that 300,000 direct labor hours will be worked during the coning year, 2017, in the Packaging Departmemt. On this basis, the budgeted manufacturing overhend cost data, shown below, ire computed for the year 2 3 Fixed Overhead Costs Variable Overhead Costs Variable Per Unit 7Supervision Indirect labor Indirect materials Repairs Utilities Lubricants $126,000 90,000 69,000 S0.42 30,000 24,000 18,000 $240,000 10 Rent 1Property taces 12 S0.24 $0.06 $1.25 18,000 $375,000 14 I...
Assignment 11A - Problem 1 A manufacturing company uses direct labor hours as the basis for...
Assignment 11A - Problem 1 A manufacturing company uses direct labor hours as the basis for the predetermined manufacturing overhead rate. Amounts and transactions for the year are as follows: $500,000 100,000 Estimated total manufacturing overhead Estimated total direct labor hours 40,000 Estimated total machine hours Actual total manufacturing overhead incurred (not paid) Actual direct labor costs incurred (not paid) Actual total direct labor hours $467,000 $805,000 89,405 2 3 4 39,100 Actual total machine hours Raw materials purchased on...
Create an Assumptions page, Sales budget, cash collections schedule, production budget, direct materials budget, direct labor...
Create an Assumptions page, Sales budget, cash collections
schedule, production budget, direct materials budget, direct labor
budget, ending finished goods schedule per unit, sales and
administrative budget, Cash budget, income statement and balance
sheet for the quarter ended.
1 2 3 Instructions: Prepare all schedules on the following tabs for the below problem If you do this correctly, your balance sheet will balance. You must create an input tab for this project, and the link all numbers on the other...
20. Amelia Company had the following information for the year: Direct materials used S295,000 Direct labor...
20. Amelia Company had the following information for the year: Direct materials used S295,000 Direct labor incurred (9,000 hours) $245.000 Actual manufacturing overhead incurred $343,000 Amelia Company used a predetermined overhead rate using estimated overhead of S320,000 and 8,000 estimated direct labor hours. How much overhead was applied during the year? A. $245.000 B. $343.000 C. $360,000 D. $320,000 21. Pima, Inc. manufactures calculators that sell for $40 each. Each calculator uses S15 in direct materials and $5 in direct...
Variance Analysis 2 Insert a formula into each cell containing a ? 3 4 chatham Company...
Variance Analysis 2 Insert a formula into each cell containing a ? 3 4 chatham Company produces a beach towel and incurs the fallowing variable manufacturing costs 5 Std Price/Rate Б Std Qty 7 1.80 per yd 8Direct material (clath) 3 yds Direct labor 9 12.00 per hour 0.75 hours 10 Variable /H (based an direct labor haurs) 4.00 ner bour 0.75 hours 11 12 Standard Cost per Unit: Std Cast per towel 13 14 Direct Material S.4D 15 Direct...
1. Change the total fixed manufacturing overhead cost for the Milling Department in Data area back...
1. Change the total fixed manufacturing overhead cost for the Milling Department in Data area back to $390,000, keeping all of the other data the same as in the original example. Consider a new job, Job 408, with the following characteristics: A B с 1 Chapter 2: Applying Excel 2 3 Cost summary for Job 408 4 5 Department Milling Assembly 50 2 8 20 820 $ 270 144 $ 320 Machine-hours Direct labor-hours Direct materials cost Direct labor cost...
2. Change the total fixed manufacturing overhead cost for the Milling Department in Data area back...
2. Change the total fixed manufacturing overhead cost for the Milling Department in Data area back to $390,000, keeping all of the other data the same as in the original example. Consider a new job, Job 408, with the following characteristics: А B с 1 Chapter 2: Applying Excel Cost summary for Job 408 2 3 4 5 Machine-hours Direct labor hours Direct materials cost Direct labor cost Department Milling Assembly 70 2 5 40 880$ 440 95 $ 640...
I need help with JUST 5,6, and 7 please 3 L12 x ✓ fx I B C D E F G H I 1 Thunder Creek Company expects sales of 18,000...
I need help with JUST 5,6, and 7 please
3 L12 x ✓ fx I B C D E F G H I 1 Thunder Creek Company expects sales of 18,000 units in January 2018, 24,000 units in February, 30,000 units in March, 34,000 in April, and 36,000 in May. The sales price is $34 per unit. 2 Prepare a sales budget. 2018 4 Budget #1: Sales Budget Jan Feb Mar 01 Total April May 5 Budgeted units to be...
Required information Chapter 3: Applying Excel Step 1: Download the Applying Excel form located on the...
Required information Chapter 3: Applying Excel Step 1: Download the Applying Excel form located on the left-hand side, under files. If you have trouble, the file is also located in D2L under Course Administration. Step 2: Then enter formulas in all cells that contain question marks. For example, in cell B13 enter the formula "=B5". Step 3: Check your worksheet by changing the estimated total amount of the allocation base in the Data area to 50,000 machine-hours, keeping all of...
Crispin Company’s sales from last year were $8 million. The company maintains no beginning or ending...
Crispin Company’s sales from
last year were $8 million. The company maintains no beginning or
ending inventories. It has assembled all of its costs from last
year and would like your assistance in sorting these costs into
various categories, depicting them graphically, and preparing
traditional and contribution format income statements. (Using
Excel)
1. Go to the “Cost Summary” tab. Using
PivotTable and Charts:
a. Calculate the company’s total product costs
and total period costs.
b. Calculate the portions of the...
need the formulas
and budget Bumblebee Company estimates that 300,000 direct labor hours will be worked during the coning year, 2017, in the Packaging Departmemt. On this basis, the budgeted manufacturing overhend cost data, shown below, ire computed for the year 2 3 Fixed Overhead Costs Variable Overhead Costs Variable Per Unit 7Supervision Indirect labor Indirect materials Repairs Utilities Lubricants $126,000 90,000 69,000 S0.42 30,000 24,000 18,000 $240,000 10 Rent 1Property taces 12 S0.24 $0.06 $1.25 18,000 $375,000 14 I...
Assignment 11A - Problem 1 A manufacturing company uses direct labor hours as the basis for the predetermined manufacturing overhead rate. Amounts and transactions for the year are as follows: $500,000 100,000 Estimated total manufacturing overhead Estimated total direct labor hours 40,000 Estimated total machine hours Actual total manufacturing overhead incurred (not paid) Actual direct labor costs incurred (not paid) Actual total direct labor hours $467,000 $805,000 89,405 2 3 4 39,100 Actual total machine hours Raw materials purchased on...
Create an Assumptions page, Sales budget, cash collections
schedule, production budget, direct materials budget, direct labor
budget, ending finished goods schedule per unit, sales and
administrative budget, Cash budget, income statement and balance
sheet for the quarter ended.
1 2 3 Instructions: Prepare all schedules on the following tabs for the below problem If you do this correctly, your balance sheet will balance. You must create an input tab for this project, and the link all numbers on the other...
20. Amelia Company had the following information for the year: Direct materials used S295,000 Direct labor incurred (9,000 hours) $245.000 Actual manufacturing overhead incurred $343,000 Amelia Company used a predetermined overhead rate using estimated overhead of S320,000 and 8,000 estimated direct labor hours. How much overhead was applied during the year? A. $245.000 B. $343.000 C. $360,000 D. $320,000 21. Pima, Inc. manufactures calculators that sell for $40 each. Each calculator uses S15 in direct materials and $5 in direct...
Variance Analysis 2 Insert a formula into each cell containing a ? 3 4 chatham Company produces a beach towel and incurs the fallowing variable manufacturing costs 5 Std Price/Rate Б Std Qty 7 1.80 per yd 8Direct material (clath) 3 yds Direct labor 9 12.00 per hour 0.75 hours 10 Variable /H (based an direct labor haurs) 4.00 ner bour 0.75 hours 11 12 Standard Cost per Unit: Std Cast per towel 13 14 Direct Material S.4D 15 Direct...
1. Change the total fixed manufacturing overhead cost for the Milling Department in Data area back to $390,000, keeping all of the other data the same as in the original example. Consider a new job, Job 408, with the following characteristics: A B с 1 Chapter 2: Applying Excel 2 3 Cost summary for Job 408 4 5 Department Milling Assembly 50 2 8 20 820 $ 270 144 $ 320 Machine-hours Direct labor-hours Direct materials cost Direct labor cost...
2. Change the total fixed manufacturing overhead cost for the Milling Department in Data area back to $390,000, keeping all of the other data the same as in the original example. Consider a new job, Job 408, with the following characteristics: А B с 1 Chapter 2: Applying Excel Cost summary for Job 408 2 3 4 5 Machine-hours Direct labor hours Direct materials cost Direct labor cost Department Milling Assembly 70 2 5 40 880$ 440 95 $ 640...
I need help with JUST 5,6, and 7 please
3 L12 x ✓ fx I B C D E F G H I 1 Thunder Creek Company expects sales of 18,000 units in January 2018, 24,000 units in February, 30,000 units in March, 34,000 in April, and 36,000 in May. The sales price is $34 per unit. 2 Prepare a sales budget. 2018 4 Budget #1: Sales Budget Jan Feb Mar 01 Total April May 5 Budgeted units to be...
Required information Chapter 3: Applying Excel Step 1: Download the Applying Excel form located on the left-hand side, under files. If you have trouble, the file is also located in D2L under Course Administration. Step 2: Then enter formulas in all cells that contain question marks. For example, in cell B13 enter the formula "=B5". Step 3: Check your worksheet by changing the estimated total amount of the allocation base in the Data area to 50,000 machine-hours, keeping all of...
Crispin Company’s sales from
last year were $8 million. The company maintains no beginning or
ending inventories. It has assembled all of its costs from last
year and would like your assistance in sorting these costs into
various categories, depicting them graphically, and preparing
traditional and contribution format income statements. (Using
Excel)
1. Go to the “Cost Summary” tab. Using
PivotTable and Charts:
a. Calculate the company’s total product costs
and total period costs.
b. Calculate the portions of the...
Most questions answered within 3 hours.
-
For each of the following strong base solutions, determine
[OH−],[H3O+], pH, and pOH 4.8 x 10^-4...
asked 1 minute ago -
The magnitude of the electric field inside a capacitor is 6.6 x
106 N/C. What is...
asked 1 minute ago -
On the night of April 18, 1775, a signal was to be sent from the
Old...
asked 5 minutes ago -
Organizations may have only a few products or many products in a
product line. Consider Campbell...
asked 14 minutes ago -
could you please help me to explain the nmr splitting
integration and chemical shift and assignment...
asked 10 minutes ago -
A
29.0 cm diameter coil consists of 23 turns of cylindrical copper
wire 2.00 mm in...
asked 16 minutes ago -
(1) Write the net ionic equation for the reaction that occurs
when equal volumes of 0.191...
asked 22 minutes ago -
Q1
Two of your friends each received the results of their
first midterm exam this term....
asked 33 minutes ago -
A 0.500-kg object, suspended from an ideal spring of spring
constant 30.2 N/m, is oscillating vertically....
asked 31 minutes ago -
Please help and show work. I keep getting the wrong answers for
these problems
1. Cell...
asked 29 minutes ago -
If there is a SNP in the read with respect to the
reference genome, how would a...
asked 31 minutes ago -
Early black-and-white television sets used an electron beam to
draw a picture on the screen. The...
asked 33 minutes ago