Business, 20.02.2020 00:22 kkwolfcityouwc96

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 Excelregression).

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

Answers: 1

Show answers

Another question on Business

Business, 22.06.2019 18:10

Find the zeros of the polynomial 5 x square + 12 x + 7 by factorization method and verify the relation between zeros and coefficient of the polynomials

Answers: 1

Answer

Business, 22.06.2019 19:30

Anew firm is developing its business plan. it will require $615,000 of assets, and it projects $450,000 of sales and $355,000 of operating costs for the first year. management is reasonably sure of these numbers because of contracts with its customers and suppliers. it can borrow at a rate of 7.5%, but the bank requires it to have a tie of at least 4.0, and if the tie falls below this level the bank will call in the loan and the firm will go bankrupt. what is the maximum debt ratio the firm can use? (hint: find the maximum dollars of interest, then the debt that produces that interest, and then the related debt ratio.)a. 41.94%b. 44.15%c. 46.47%d. 48.92%e. 51.49%

Answers: 3

Answer

Business, 22.06.2019 21:30

Which is cheaper: eating out or dining in? the mean cost of a flank steak, broccoli, and rice bought at the grocery store is $13.04 (money.msn website, november 7, 2012). a sample of 100 neighborhood restaurants showed a mean price of $12.75 and a standard deviation of $2 for a comparable restaurant meal. a. develop appropriate hypotheses for a test to determine whether the sample data support the conclusion that the mean cost of a restaurant meal is less than fixing a comparable meal at home. b. using the sample from the 100 restaurants, what is the p-value? c. at a = .05, what is your conclusion? d. repeat the preceding hypothesis test using the critical value approach

Answers: 3

Answer

Business, 22.06.2019 23:20

You work as the sales manager for a company that sells office supplies to businesses of all sizes. because the profit margins are razor-thin, you need to ensure that you are getting the very best prices on paper, pencils, pens, post-it notes, and other office supplies from the manufacturers. when reviewing the quarterly profit statement, you realize that your costs are higher than they should be, and you trace the higher costs back to an employee who has been lax about getting competitive bids to ensure the lowest prices. when you conduct your research to determine the reason for the higher costs, and take action to bring those costs back down, in which of the key management processes are you taking part?

Answers: 3

Answer

You know the right answer?

The manager of the main laboratory facility at Elmhurst HealthElmhurst Health Center is interested i...

Questions