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
Livingston Co. uses process costing to account for the production of elastic bands. Direct materials are added at the beginning
madam [21]

Answer:

The total cost per unit using the weighted average method would be:

$15,97  

Explanation:

                Materials   Conversion Costs  

Begining  $ 14,000         $ 8,000  

APRIL          $ 72,000        $ 80,000  

TOTAL          $ 86,000 $ 88,000  

Units               8,000   8,000  

                       100% 50%  

WIP                4,000   2,000  

TOTAL              12,000   10,000  

USD/Unit          7,17              8,80   $15,97  

3 0
3 years ago
Motives, objectives, participants, means used, level of violence, scope of war, and asymmetry are all examples of:
allochka39001 [22]
Elements of War is the answer.
4 0
3 years ago
Which of the following statements is true? a) You will always pay less interest with a 15-year mortgage than with a 30-year mort
horrorfan [7]
<span>b) With an adjustable rate mortgage, the interest rate always increases after the first five years 

</span>
4 0
3 years ago
PLEASE HELPPP 50 pts!
soldi70 [24.7K]

Answer:

Her investing plan is saving up by finding a place to keep money you should probably worry on other things save up then spend if not you'll probably lose more money than needed find a place where they dont change much based on your money find a place where theres no scams you need to research to find a plan and a safe place.

3 0
2 years ago
Which of the following is a problem associated with the rational method of developing questionnaire items?
7nadin3 [17]

Answer:

2. Participants might give socially desirable or false answers rather than honest ones because the questions are transparent.

Explanation:

A questionnaire comprises of questions in open-ended or closed-ended formats used to effectively get informations from a selected sample size in a specific period of time. When designed correctly or properly, questionnaires can be used to gather user data(thoughts, views, opinions) in a short period of time.

The problem associated with the rational method of developing questionnaire items is that participants might give socially desirable or false answers rather than honest ones because the questions are transparent.

8 0
2 years ago
Other questions:
  • Choose an advertisement that you found to be especially memorable. Describe the advertisement and explain how effective it is. D
    7·1 answer
  • Andy assumed the character of jude in order to confront the
    6·1 answer
  • On January 1, 2019, Broker Corp. issued $3,700,000 par value 10%, 12-year bonds which pay interest each December 31. If the mark
    12·1 answer
  • Smitty Museum purchased the copyright to a piece of artwork for $925,000. Smitty plans to reproduce 2.1 million posters of the a
    8·1 answer
  • Herb Company manufactured more product than it was able to sell during the current year. If the salaries of the sales staff of H
    13·1 answer
  • The old Soviet Union devoted enormous resources exclusively to increasing its physical capital​ stock, and yet eventually the in
    7·1 answer
  • The state of competition is an industry, according to porter, depends on ______ basic forces.
    5·1 answer
  • According to the traditional approach to capital​ structure, the value of a firm will be maximized when​ ________. A. the financ
    6·2 answers
  • Natalia's role with her new team was to produce periodic reports on the team's progress. Her reports were not in the preferred f
    13·1 answer
  • The bank statement reveals an eft payment made to one of the company's suppliers that has not yet been recorded in the journal.
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!