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
jim root company operates four bowling alleys. the business just received the ​, ​, bank statement from city national​ bank, and
Damm [24]

Listed on the statement are an EFT rent collection of $440, a service charge of $7, NSF checks totaling $50, and a $23 charge for printed checks.

<h3>What is statement?</h3>

Frequently used in the field of project management is a statement of work (SOW). The work demand for a project is described in narrative form. For a vendor offering services to the client, it specifies project-specific tasks, products, and deadlines. Standard regulatory and governance terms and conditions, together with specific criteria and price, are usually included in the SOW. A master service agreement or request for proposals frequently have it as an essential annex (RFP).

For the hardware or software solutions outlined in the request for proposals, numerous statement of work document template formats and styles have been developed. Many businesses develop their own specialized or generalist SOWs that are specifically tailored to meet the requests and proposals they typically receive.

To learn more about statement from the given link:

brainly.com/question/25938417

#SPJ4

6 0
1 year ago
Echota Corporation has the following capital stock outstanding at December 31, 2020: 7% Preferred stock, $100 par value, cumulat
Sunny_sXe [5.5K]

Answer:

$6,700,000

Explanation:

Preparation of the paid-in capital section of the balance sheet at December 31, 2020.

Paid-in capital section of the balance sheet at December 31, 2020

7% Preferred stock, $100 par value, cumulative15,000 shares issued and outstanding $1,500,000

Add Common stock, no par, $10 stated value, 500,000 shares authorized, 350,000 shares issued andoutstanding 3,500,000

Total capital stock5,000,000

($1,500,000+3,500,000)

Add Additional paid-in capitalIn excess of par—preferred stock$ 300,000

(15,000 shares × $20 )

Add In excess of stated value—common stock1,400,000

(350,000 shares × $4)

Total paid-in capital$6,700,000

Therefore the paid-in capital section of the balance sheet at December 31, 2020 is $6,700,000

4 0
2 years ago
Bailey, Inc., is considering buying a new gang punch that would allow them to produce circuit boards more efficiently. The punch
KengaRu [80]

Answer:

initial investment $100,000

useful life 15 years

cash flow per year = -$2,000 + $12,000 = $10,000

discount rate 5%

discounted cash flow:

1                $10,000/1.05 = $9,524

2               $10,000/1.05² = $9,070

3               $10,000/1.05³ = $8,638

4               $10,000/1.05⁴ = $8,227

5               $10,000/1.05⁵ = $7,835

6               $10,000/1.05⁶ = $7,462

7               $10,000/1.05⁷ = $7,101

8               $10,000/1.05⁸ = $6,768

9               $10,000/1.05⁹ = $6,446

10              $10,000/1.05¹⁰ = $6,139

11               $10,000/1.05¹¹ = $5,847

12              $10,000/1.05¹² = $5,568

13              $10,000/1.05¹³ = $5,303

14              $10,000/1.05¹⁴ = $5,051

15              $10,000/1.05¹⁵ = $4,810

A) discounted pay back period = 14.2 years

B) if the decision rule is a discounted payback period of 3 years, then the project should be rejected

C) the decision rule should be the NPV, which is actually positive since the DPBP is less than 15 years. Only companies that fear premature obsolescence should base their decision on the pay back period. Since this is an electronics company, it is sound to use the pay back period as a decision parameter besides the NPV.

6 0
3 years ago
WILL GIVE BRAILIEST
Korvikt [17]
C. Current status and intermediate goals
5 0
3 years ago
Please subscribe to my mom channel please<br><br>I need 100 subscribe​​
Contact [7]
Ok i will subscribe too!!
8 0
3 years ago
Other questions:
  • Maxim manufactures a cat food product called Green Health. Maxim currently has 10,000 bags of Green Health on hand. The variable
    6·1 answer
  • Human capital is
    14·1 answer
  • Hector Company gathered the following reconciling information in preparing its March bank reconciliation: Cash balance per books
    8·1 answer
  • How is the value of a product determined? A. By the amount a consumer is willing to pay for it B. By how much it cost the produc
    11·2 answers
  • Which of the following statements summarizes the incidence of the tax?
    8·1 answer
  • Milton Snoeyenbos argues that:_____.
    7·1 answer
  • What are the Business Activities ?​
    7·2 answers
  • Which of the following is not a level of control
    6·2 answers
  • Cameron visits a sporting goods store to buy a new set of golf clubs. He is willing to pay $750 for the clubs but buys them on s
    5·1 answer
  • The wage gap refers to
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!