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
Assume that you are a loan officer of a bank. A local church is seeking a $4 million, 20-year loan to construct a new classroom b
n200080 [17]

Answer:

Explanation:

a.

There is little information on how funds are used or how much money is spent to manage the church. The financial statements have been prepared incorrectly.

Interpretation:

While drafting the financial accounts, the church committed many errors. The church's revenue is equivalent to its daily operations operating expenditures. They have approximately $3 million in funding assets that they do not owe any money on.  

It may be deduced that the church is attempting to preserve asymmetric information, and therefore it will be better to justify its sources of income and use of money in order to determine whether they can or they cannot pay the debt.

b.

The revenue from various channels must be detailed in the yearly report so that the loan officer may make an informed judgment.

Interpretation:

Since payments and contributions account for 90% of revenue and revenue from other sources accounts for 10%, it's surprising how the church earns money in other ways as stated on the income statement. As a result, it's important to understand what other potential revenue streams the church has before approving the loan.

c.

The officer in charge of the loan should check the church's book records to make sure and guarantee that there are no outstanding loans. This situation necessitates a thorough examination and assessment.

Interpretation:

The church has $3 million worth of equipment. The church's expenses, on the other hand, are equivalent to the church's income. As a result, it's unclear how the church acquired the equipment without taking out a loan. As a result, the church must be urged to produce a full breakdown of its expenses, which may be thoroughly and fully studied to see whether there are any financing charges that the church is attempting to hide in its yearly reports.

d.

There is no direct or primary source of income for the church. It solely makes money from charity donations.

Interpretation:

The church's only sources of income are fundraisers and charitable donations. It also doesn't possess any significant revenue streams. Because the church is attempting to conceal numerous possible pieces of information, this may be a case of micro-management by the proprietors, and so these issues should be considered by the officer in charge of the loan before accepting the loan.

8 0
3 years ago
(Money matters)
Alexandra [31]

Answer:

No entiendo inglish ajaja

4 0
2 years ago
The marginal propensity to consume is the: ratio of consumption to income. amount consumed out of an additional dollar of income
cluponka [151]

Answer:

The correct answer is: amount consumed out of an additional dollar of income.

Explanation:

The marginal propensity to consume is a measure to show the increase in consumption of goods and services due to an increase in the disposable income of the consumer.  

It is measured by the ratio of change in consumption and change in income. It can also be calculated as 1 - MPS, where MPS is the marginal propensity to save. In other words, MPS is the ratio of change in savings and change in income.

6 0
3 years ago
By lowering production costs, _____ help domestic producers compete against foreign imports
Ann [662]

The policy that lowers production costs and helps domestic producers to compete with imports are <u>D. subsidies. </u>

<h3 /><h3>What are subsidies?</h3>

This is a government policy where the government pays for some of the costs of production for local firms.

This allows the local firms to then sell their goods at a lower price so that they can compete with cheaper imports.

Options for this question include:

A. tariffs

B. custom duties

C. tariff rate quotas

D. subsidies

Find out more on subsidies at brainly.com/question/6945210.

#SPJ12

3 0
2 years ago
Which of the following is used to explain the process managers go through in determining the reasons for effective or ineffectiv
inessss [21]

Answer: Attribution theory.

Explanation:

Managers most times makes use of the Attribution theory when trying interpret employees behavior. The Attribution theory is a theory that studies individual and their behavior, what makes an individual either motivated or demoralized on a job.

8 0
2 years ago
Read 2 more answers
Other questions:
  • Wesley's grandfather was a sharecropper, farming someone else's land. wesley's father was a farmer who farmed his own land. wesl
    6·1 answer
  • An arbiter is consulted when ______.
    12·1 answer
  • For each of the following independent situations, prepare journal entries to record the initial transaction on December 31 and t
    8·1 answer
  • _____ signs tell you how to drive safely in work zones.
    12·1 answer
  • Delaware Coatings Company uses the indirect method to prepare its statement of cash flows. Refer to the following information fo
    8·1 answer
  • According to the quantity theory:
    9·1 answer
  • A small publishing company is planning to publish a new book. The production costs will include one-time fixed costs (such as ed
    9·1 answer
  • Joan Wilder receives a phone call from a salesman who tries to sell her an insurance policy by scaring her about her high risk o
    15·1 answer
  • Hi there <br><br> Can anyone please explain to me what is meant by How would you conduct training?
    15·1 answer
  • a high school in a low-income area offers special programs to help students acquire the technical skills needed to find jobs as
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!