Question

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. Using that data, find the estimated regression equation which can be used to estimate ILE when using DLH as the predictor variable.

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
  • A. ILE = 0.4291 + 59.4174(DLH)
  • B. ILE = 60.0419 + 2.1355(DLH)
  • C. ILE = 47.5504 + 4.8996(DLH)
  • D. ILE = 171.7567 + 9.3172(DLH)

Homework Answers

Answer #1


The statistic software output for this problem is :

Intercept = 171.7567

slope =   9.3172

ILE = 171.7567 + 9.3172 (DLH)

Option D) is correct .

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A company has observed that there is a linear relationship between indirect labor expense (ILE) ,...
A company has observed that 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 18 months are given in the file ILE_and_DLH.xlsx (this is the ILE a nd DLH File below ) DLH(X) ILE(Y) 20 361 25 400 22 376 23 384 20 361 19 360 24 427.2 28 458.4 26 450.8 29 475.2 27 462.6 25 445 28 511 32...
Orchard Relief is a product that is designed to improve sleep at night. The company, Eli...
Orchard Relief is a product that is designed to improve sleep at night. The company, Eli Orchard, is guessing that sales of the product is somewhat related to sleeping patterns of customers over the days of the week. Before mass production of the product, Eli Orchid has market-tested Orchid Relief in only Orange County over the past 8 weeks. The weekly demand is recorded. Eli Orchid is now trying to use the sales pattern over the past 8 weeks to...
Orchard Relief is a product that is designed to improve sleep at night. The company, Eli...
Orchard Relief is a product that is designed to improve sleep at night. The company, Eli Orchard, is guessing that sales of the product is somewhat related to sleeping patterns of customers over the days of the week. Before mass production of the product, Eli Orchid has market-tested Orchid Relief in only Orange County over the past 8 weeks. The weekly demand is recorded. Eli Orchid is now trying to use the sales pattern over the past 8 weeks to...
PLEASE answer all of the follwing, thank you! The Ramapo Company produces two products, Blinks and...
PLEASE answer all of the follwing, thank you! The Ramapo Company produces two products, Blinks and Dinks. They are manufactured in two departments, Fabrication and Assembly. Data for the products and departments are listed below. Product Number of Units Labor Hours Per Unit Machine Hours Per Unit Blinks 1,171 1 5 Dinks 1,954 7 6 All of the machine hours take place in the Fabrication department, which has an estimated overhead of $93,900. All of the labor hours take place...
Sales, Production, Direct Materials Purchases, and Direct Labor Cost Budgets The budget director of Royal Furniture...
Sales, Production, Direct Materials Purchases, and Direct Labor Cost Budgets The budget director of Royal Furniture Company requests estimates of sales, production, and other operating data from the various administrative units every month. Selected information concerning sales and production for February is summarized as follows: a. Estimated sales of King and Prince chairs for February by sales territory: Northern Domestic:   King 610 units at $780 per unit   Prince 750 units at $550 per unit Southern Domestic:   King 340 units at...
A loan made on March 14 is due September 13 of the following year. Find the...
A loan made on March 14 is due September 13 of the following year. Find the exact time for the loan in a​ non-leap year and a leap year. days. The exact time in a​ non-leap year is ? days The exact time in a leap year is ? days. Data Table Sequential Numbers for Dates of the Year Day of Month Jan. Feb. Mar. Apr. May June July Aug. Sept. Oct. Nov. Dec. 1 1 32 60 91 121...
The data set entitled ‘Salmon’ contains 40 annual counts of the numbers of recruits and spawners...
The data set entitled ‘Salmon’ contains 40 annual counts of the numbers of recruits and spawners in a salmon population. The units are thousands of fish. Recruits are fish that enter the catchable population. Spawners are fish that are laying eggs. Spawners die after laying eggs. The classic Beaverton-Holt model for the relationship between spawners and recruits is R = 1 /(β1 + β2/S) where R and S are the numbers of recruits and spawners, respectively. This model may be...
PHP, HTML5 Accounting Import The Mammoth Island Tourism Company is undergoing a project to digitize a...
PHP, HTML5 Accounting Import The Mammoth Island Tourism Company is undergoing a project to digitize a large quantity of paper documents, sales records going back 100 years. They’ve already commissioned a company to digitize the documents into a text format, but now they require an application to extract a small amount of useful information from the documents. Unfortunately, their accounting format changed several times over the course of business, so the application must be intelligent enough to find the data....
Score for this attempt: 69 out of 75 Submitted Apr 10 at 10:59am This attempt took...
Score for this attempt: 69 out of 75 Submitted Apr 10 at 10:59am This attempt took 74 minutes. Question 1 1.5 / 1.5 pts Process manufacturing usually reflects a manufacturer that produces small quantities of unique items.    True Correct!   False Question 2 1.5 / 1.5 pts On a common-sized income statement, all items are stated as a percent of total assets or equities at year-end. Correct!   False     True Question 3 1.5 / 1.5 pts A single plantwide overhead...
Use the Manufacturing database from “Excel Databases.xls” on Blackboard. Use Excel to develop a multiple regression...
Use the Manufacturing database from “Excel Databases.xls” on Blackboard. Use Excel to develop a multiple regression model to predict Cost of Materials by Number of Employees, New Capital Expenditures, Value Added by Manufacture, and End-of-Year Inventories. Locate the observed value that is in Industrial Group 12 and has 7 employees. Based on the model and the multiple regression output, what is the corresponding residual of this observation? Write your answer as a number, round to 2 decimal places. SIC Code...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT