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 General Electric (GE)'s current assets are $401 billion, fixed assets are $797 billion, current liabilities are $323
notka56 [123]

Answer:

Answer is explained below in the explanation section.

Explanation:

Solution:

We can not solve this question as it lacks necessary data.

1. GE's Translation Exposure using current/noncurrent:

$401 billion - $401 billion = 0.

0 is the GE's translation exposure using current/noncurrent method.

2. Using Monetary/Non-monetary:

We can not calculate this requirement as we don't have the breakdown of GE's assets and liabilities under monetary/nonmonetary. So, it is not possible under the given information.

3. GE's Translation Exposure using Temporal method:

Again, we do lack necessary data to solve for this requirement. We need GE's breakdown of current assets and inventory and monetary assets to solve this question. Therefore, it is not possible to solve this question.

4. GE's Translation Exposure Using Current Rate methods:

GE's Exposure = (Current Assets + Fixed Assets) - Current Liabilities

GE's Exposure = ($401 billion + $797 billion) - $323 billion

GE's Exposure = ($1198 billion) - $323 billion

GE's Exposure = $875 billion

8 0
3 years ago
The following income statement is provided for Vargas, Inc. Sales revenue (2,600 units × $20.10 per unit) $ 52,260 Cost of goods
leva [86]

Answer: 3.91

Explanation: We can calculate operating leverage by using following formula:-

operating\:leverage=\frac{contribution}{net\:income}

where,

contribution = sales - variable cost

                     =  sales - ( variable cost of goods sold + supplies )

                     =  $52,260 - ( $26,260 + $5460)

                     = $20,540

Now, putting the values into equation we get :-

operating\:leverage=\frac{20,540}{5,240}

                                          = 3.91

3 0
3 years ago
Suppose the price level reflects the number of dollars needed to buy a basket of goods containing one cup of coffee, one donut,
Anettt [7]

Answer:

From year one to year two, there is (Deflation,Inflation) at an annual rate of _12.5____%. In year one, $40.00 will buy ____5____ baskets, and in year two, $40.00 will buy ___5.7 (6)____ baskets. This example illustrates that, as the price level falls, the value of money:_increases___

Explanation:

a) Data and Calculations:

The price of a basket of goods in year one = $8.00

The price of the same basket of goods in year two = $7.00

Difference in price (reduction in price) = $1 ($8 - $7)

Percentage reduction in price = $1/$8 * 100 = 12.5%

With $40/8, 5 baskets were bought

With $40/7, 5.7 baskets will be bought

b) Economists are always wary of prolonged deflation or continuous general falling prices of goods because it depicts an economy that is seriously weakening at its foundation.  As a fallout, companies slow production, reduce output, lay off workers, and reduce salaries (earned income).

5 0
2 years ago
Make me laugh and ill give you brainly along with 15 points
N76 [4]

Answer:

Whats a lawyers favorite suit...

A lawsuit

Explanation:

6 0
2 years ago
Denver Corporation purchased a patent for $405,000 on September 1, 2016. It had a useful life of 10 years. On January 1, 2018, D
natita [175]

Answer:

amount that should be reported for patent amortization expense for 2018 will be $90000.27

Explanation:

given data

purchased patent = $405,000

useful life = 10 years

spent = $99,000

remaining useful life = 5 years

solution

first we get here amortization from September 1, 2016 - January 1, 2018 that is

September 1 - december 31 = \frac{4}{12}  = 0.333333

amortization = (1 + 0.333333) × (405000 ÷ 10)

amortization = $53998.65

and

now we get remaining value before defence

remaining value = $405,000 - $53998.65

remaining value = $351001.35

and

now we get here amount to be reported for patent amortization expense for 2018

amount = ( $351001.35 + $99,000 ) ÷ 5

amount = $90000.27

so amount that should be reported for patent amortization expense for 2018 will be $90000.27

7 0
2 years ago
Other questions:
  • Which of the following is an example of discrimination in the workplace? refusing to hire a person because another person is bet
    14·1 answer
  • What can the government of a relatively poor country do to promote economic prosperity? check all that apply. encourage transmis
    12·2 answers
  • Sebastian purchases two pieces of equipment for $100,000. Appraisals of the equipment indicate that the fair market value of the
    9·1 answer
  • Using your favorite search engine, the resources of your library, and information available on the Uber Web site, identify and e
    11·1 answer
  • Hair World Inc. is a wholesaler of hair supplies. Hair World uses a perpetual inventory system. The following transactions (summ
    5·1 answer
  • Marshall Officer is a stockholder in Endrun Investments, which is organized as a C Corporation. Endrun recently lost a major cou
    13·1 answer
  • revorrow Corporation manufactures and sells a single product. The company uses units as the measure of activity in its budgets a
    9·1 answer
  • Imprudential, Inc., has an unfunded pension liability of $750 million that must be paid in 17 years. To assess the value of the
    12·1 answer
  • Which is an example of a mandatory deduction on a pay stub?
    12·1 answer
  • How can I convince a friend to invest in a good manner
    13·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!