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 02:30

Acompany using the perpetual inventory system purchased inventory worth $540,000 on account with credit terms of 2/15, n/45. defective inventory of $40,000 was returned 2 days later, and the accounts were appropriately adjusted. if the company paid the invoice 20 days later, the journal entry to record the payment would be

Answers: 1

Answer

Business, 22.06.2019 08:50

Suppose that in an economy the structural unemployment rate is 2.2 percent, the natural unemployment rate is 5.3 percent, and the cyclical unemployment rate is 2 percent. the frictional unemployment rate is percent and the actual unemployment rate (in this economy) is percent.

Answers: 2

Answer

Business, 22.06.2019 10:10

conquest, inc. produces a special kind of light-weight, recreational vehicle that has a unique design. it allows the company to follow a cost-plus pricing strategy. it has $9,000,000 of average assets, and the desired profit is a 10% return on assets. assume all products produced are sold. additional data are as follows: sales volume 1000 units per year; variable costs $1000 per unit; fixed costs $4,000,000 per year; using the cost-plus pricing approach, what should be the sales price per unit?

Answers: 2

Answer

Business, 22.06.2019 16:20

The following information relates to the pina company. date ending inventory price (end-of-year prices) index december 31, 2013 $73,700 100 december 31, 2014 100,092 114 december 31, 2015 107,856 126 december 31, 2016 123,009 131 december 31, 2017 113,288 136 use the dollar-value lifo method to compute the ending inventory for pina company for 2013 through 2017.

Answers: 1

Answer

You know the right answer?

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

Questions