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
Your friend Burrell says that the government should hire fewer social workers in order to reduce the cost of federal assistance
BARSIC [14]

Answer: b) peoples' responses to financial incentives.

Explanation:

Burrell would be wrong because the most leakage in federal assistance programs comes from the way people respond to financial incentives.

Some people who have received this assistance from the Federal government have decided that it would be better to keep receiving this assistance instead of working to actually get paid.

This has led to more people seeking assistance thereby increasing the number of people needing assistance and invariably increasing the cost of these federal assistance programs.

4 0
3 years ago
Which of these is a private sector consumer-advocacy group?
victus00 [196]
D. Consider reports
5 0
3 years ago
How to calculate bank balance if the opening balance was R26041 and the total receipts were R39567​
Helen [10]

Answer:

Answer:the the opening balance is =26041the total receive were=39567the the bank balance if opening=13526.

Explanation:

7 0
2 years ago
Joe Santos owns the only pizza parlor in a small town that is also home to a McDonald's, a Taco Bell, and a Kentucky Fried Chick
astra-53 [7]

Answer:

True

Explanation:

A more precise way to describe the situation is that Joe's pizza parlor is a monopolistic competition. But that definition considers that all 'food' items have some degree of close substitute relation.

But yes, if you consider this two conditions:

  1. a broad definition of monopoly
  2. other restaurants are not considered close substitutes for the food sold at the pizza parlor

Then yes, Joe has monopoly

5 0
3 years ago
If the best surgeon in town is also the best at cleaning swimming pools, then according to the theory of comparative advantage,
tamaranim1 [39]

Answer:

tspecialize in being a surgeon because its opportunity cost is lower

Explanation:

A person has comparative advantage in production if it produces at a lower opportunity cost when compared to other people.

Implicit cost is the cost of the next best option forgone when one alternative is chosen over other alternatives

What the surgeon would give up to pratice as a surgeon would be lower compared than if he decided to specialise in cleaning pools

thus he should specialize in being a surgeon because its opportunity cost is lower

7 0
3 years ago
Other questions:
  • Exercise 8-07 At December 31, 2019, Pharoah Company Company had a credit balance of $18,100 in Allowance for Doubtful Accounts.
    14·1 answer
  • Jon owns a house on an acre of land and can decide how to use these resources. This privilege is called a(n) _____.
    7·2 answers
  • Ronnie, the advertising manager of a leading newspaper, congratulates every member of the space selling team who achieves his or
    5·2 answers
  • Suppose the economy is operating at a point where output is less than the natural level of output. Which of the following statem
    6·1 answer
  • A simple linear demand function may be stated as q = a - bp + ci where q is quantity demanded, p is the product price, and i is
    13·1 answer
  • In Firm A, each division is a self-contained, largely autonomous entity with full responsibility for its own value creation acti
    8·1 answer
  • The innovation paradox implies that consistency in products and services provokes a tension with the need for new products. This
    14·1 answer
  • Which of the following are advantages of working for a for-profit healthcare facility? Check all of the boxes that apply.
    13·1 answer
  • Why would a producer conduct a marginal analysis?
    5·1 answer
  • Teall Corporation has a standard cost system in which it applies manufacturing overhead to products on the basis of standard mac
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!