1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Serggg [28]
3 years ago
10

The manager of the main laboratory facility at Elmhurst HealthElmhurst Health Center is interested in being able to predict the

overhead costs each month for the lab. The manager believes that total overhead varies with the number of lab tests performed but that some costs remain the same each month regardless of the number of lab tests performed. The lab manager collected the following data for the first seven months of the year.
Requirements

1.

Determine the​ lab's cost equation​ (use the output from the Excel​ regression).

2.

Determine the​ R-square (use the output from the Excel​regression).

3.

Predict the total laboratory overhead for the month if 3,100 tests are performed

Data Table

Number of Lab Tests

Total Laboratory

Month

Performed

Overhead Costs

January. . . . . . . . .

3,000

$21,900

February. . . . . . . .

2,850

$20,600

March. . . . . . . . . . .

3,400

$28,900

April. . . . . . . . . . . .

3,700

$31,000

May. . . . . . . . . . . .

3,900

$28,000

June. . . . . . . . . . . .

1,900

$20,200

July. . . . . . . . . . . .

2,050

$14,000

The laboratory manager performed a regression analysis to predict total laboratory overhead costs. The output generated by Excel is as​ follows:

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.878214

R Square

0.77126

Adjusted R Square

0.725512

Standard Error

3156.338706

Observations

7

ANOVA

df

SS

MS

F

Significance F

Regression

1

167956201.3

167956201.3

16.858885

0.009301

Residual

5

49812370.15

9962474.03

Total

6

217768571.4

Standard

Lower

Upper

Coefficients

Error

t Stat

P-value

95%

95%

Intercept

3187.94

5092.169

0.626

0.559

-9901.898

16277.778

X Variable 1

6.84

1.666

4.106

0.009

2.558

11.123
Business
1 answer:
raketka [301]3 years ago
4 0

Answer:

1.  Lab's cost= 3187.94 +6.84 number of lab test performed

2. 0.77126

3. $24391.94

Explanation:

1.

The Lab's cost depends on the number of lab test performed. So, Lab's cost is a dependent variable while number of lab test is an independent variable. The linear regression equation is written as

Y= a+bx

Where,

y= dependent variable

x= independent variable

a= intercept

b= slope

So, the equation can be written as

Lab's cost= a+b number of lab test performed

From the Excel output we know that

Intercept = a= 3187.94

Slope= b =6.84

So, the required regression equation is

Lab's cost= 3187.94 +6.84 number of lab test performed

2.

The Excel output shows that R-square is 0.77126. R²=0.77126 means that only 77.13% of variation in Lab's cost is explained by its linear relationship with number of lab test performed.

3.

We have to predict the lab's cost for 3100 test.

We know that

Lab's cost= 3187.94 +6.84 number of lab test performed.

Here, number of lab test performed=3100.

So,

Lab's cost= 3187.94 +6.84(3100)

Lab's cost= 3187.94 +21204

Lab's cost=$24391.94

Thus, the predicted total laboratory overhead for the month if 3,100 tests are performed is $24391.94.

You might be interested in
To reduce product development time, Caterpillar connected its engineering and manufacturing divisions with its active suppliers,
Sergio [31]

Answer: an extranet

Explanation:

An extranet is a private network that is controlled that gives access to vendors, suppliers, partners, vendors or a group of customers that are authorized.

Therefore, to reduce product development time, Caterpillar connected its engineering and manufacturing divisions with its active suppliers, distributors, overseas factories, and customers, through an extranet.

4 0
3 years ago
Rent control is usually justified on the grounds that it protects moderate- to low-income families from the burden of rapidly ri
horsena [70]

Answer:

c. equality.

Explanation:

Rent control is a government directive that limits the amount a landlord can charge as rent or for rent renewal. When the landlord is renewing rent there is a maximum percentage for rent increase.

Rent control is intended to create a level of equality for low-income earners and elderly people on fixed income.

This has been a successful initiative and has helped in balancing the standard of living of the target population.

5 0
3 years ago
The first step in the rational decision-making model is to:
DerKrebs [107]
I would say define the situation. 

8 0
4 years ago
As the average income in China continues to​ increase, explain how the following will​ change: a. The demand for beef b. The dem
7nadin3 [17]

Answer:

C. increase if beef is a normal​ good; decrease if rice is an inferior good.

Explanation:

As the average income in China continues to​ increase, we would expect the demand for beef to increase if beef is a normal​ good and the demand for rice to decrease if rice is an inferior good.

Normal goods are goods whose demand increase with the increase in income of consumer, however, demand decreases with the decrease in the income of consumer as we know Income is a key factor, which affect the demand of goods and services. Examples of Normal goods are Beef, Pizza, etc.

Inferior goods are goods whoes demand decreases with the increase in income of consumer, however, demand increases with the decrease in the income of consumer. Examples of Inferior goods are Cereal, Rice, non branded noodles etc.

7 0
3 years ago
Calculate the IRR of a machine that is purchased for $5,500, sold at the end of year 4 for $2,500, and produces the following ca
prohojiy [21]

Answer:

2.21%

Explanation:

The internal rate of return is the rate of return on the project where the present value of future cash flows equals the initial investment outlay. It is known as the break-even discount rate since, at IRR, the net present value is zero.

The IRR can be determined using the excel IRR function as shown thus:

=IRR(values)

values are the cash flows from years 0-4

Find attached excel file for IRR computation

Download xlsx
5 0
2 years ago
Other questions:
  • All states withhold state income taxes. true false
    15·1 answer
  • When a monopolist switches from charging a single price to perfect price discrimination, it reduces the quantity produced. the f
    6·1 answer
  • The _____ adds up the market prices of final goods and services to calculate Gross Domestic Product (GDP).
    5·2 answers
  • Hassock Corp. produces woven wall hangings. It takes 4 hours of direct labor to produce a single wall hanging. Hassock standard
    7·1 answer
  • what tax preparation option do you think you are most likely to use? Why? What are the advantages and disadvantages to using thi
    5·1 answer
  • _____ is a method for determining the estimated annual costs and benefits for a project.
    14·1 answer
  • Referral management transforms the bureaucratic paper-shuffling referral process into a disciplined and effective workflow that
    7·1 answer
  • g Unearned revenues are classified as: Group of answer choices Assets. Liabilities. Revenues. Stockholders' equity.
    6·1 answer
  • What is the best brand of pillar candles?
    12·1 answer
  • A. Define progressive income tax. Briefly create a few numbers to explain it.
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!