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
Which statement is false?
Llana [10]

Answer:

The statement which is false is the no matter that whether perpetual inventory system or periodic system is used by company, but all the companies require to evaluate inventory quantities at the end of the accounting period.

Explanation:

The statement is false because the companies does not require to determine or assess the inventory quantities at each accounting period.

Therefore, the correct option is C.

5 0
3 years ago
Management moving production or other parts of the company's value chain to countries where wages are lower is an example of ___
noname [10]

Management moving production or other parts of the company's value chain to countries where wages are lower is an example of cost drivers.

<h3>What are cost drivers in business?</h3>

The cost drivers can be defined to be the direct cause of the expenses that may occur in a business. These are the activities that may cause a cost to happen in the business. For instance this could be the amount of water that is used monthly in a given area.

Hence we can say that management moving production or other parts of the company's value chain to countries where wages are lower is an example of cost drivers.

Read more on cost drivers here: brainly.com/question/14904453

#SPJ1

5 0
1 year ago
_____ is not a primary concern when writing menu copy.
NISA [10]

Cleverness is not a primary concern when writing menu copy.

6 0
3 years ago
You are evaluating the balance sheet for PattyCake’s Corporation. From the balance sheet you find the following balances:
goldenfox [79]

Answer:

Explanation:

Current Assets are those asset which will be liquidated within next one year.

cash and marketable securities        $360,000

accounts receivable                           $1,280,000

inventory                                             <u>$2,180,000</u>

Total Current Assets                          <u>$3,820,000</u>

Current Liabilities are those which is payable within next one year.

accrued wages and taxes                   $540,000

accounts payable                                $840,000

notes payable                                      <u>$680,000</u>

Total Current Liabilities                       <u>$2,060,000</u>

Current ratio measures the capability of a business to pay the current liabilities if it becomes due.

Current Ratio = Current Assets / Current Liabilities = $3,820,000 / $2,060,000 = 1.85 times

5 0
3 years ago
In general, how would your best friend describe you as a risk taker?
earnstyle [38]

Answer:

answer is B.............

6 0
2 years ago
Other questions:
  • ​________ is defined as the extent to which your authority is accepted on grounds of​ competence, vision, or other qualities. A.
    7·2 answers
  • Target's liabilities exceed owners' equity.<br> a) true<br> b) false
    15·1 answer
  • Cyclical unemployment is closely associated with Select one: a. long-term economic growth. b. short-run ups and downs of the eco
    6·2 answers
  • A company is expected to have free cash flows of $0.75 million next year. The weighted average cost of capital is WACC = 10.5%,
    10·1 answer
  • Restrictions on the quantity of goods that can enter a country
    5·1 answer
  • Assume the United States can use a given amount of its resources to produce either 20 airplanes or 8 automobiles and Japan can e
    6·2 answers
  • Cane Company manufactures two products called Alpha and Beta that sell for $135 and $95, respectively. Each product uses only on
    12·1 answer
  • Item 15Item 15If Beck's Bicycles, Inc.'s income statement shows gross profit of $350 million, with operating expenses of $120 mi
    6·1 answer
  • Bill wants to buy a bond whose face value is substantially higher than its market price. What kind of bond should he buy
    12·1 answer
  • The type of performance appraisal that judges specific, observable aspects of performance like being on time for work is a(n) __
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!