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
Other questions on the subject: Business
Business, 22.06.2019 11:00, PanjiUR9220
What is the correct percentage of texas teachers charged with ethics violations each year?
Answers: 2
Business, 22.06.2019 12:30, bcarri4073
M. cotteleer electronics supplies microcomputer circuitry to a company that incorporates microprocessors into refrigerators and other home appliances. one of the components has an annual demand of 235 units, and this is constant throughout the year. carrying cost is estimated to be $1.25 per unit per year, and the ordering (setup) cost is $21 per order. a) to minimize cost, how many units should be ordered each time an order is placed? b) how many orders per year are needed with the optimal policy? c) what is the average inventory if costs are minimized? d) suppose that the ordering cost is not $21, and cotteleer has been ordering 125 units each time an order is placed. for this order policy (of q = 125) to be optimal, determine what the ordering cost would have to be.
Answers: 1
Business, 22.06.2019 16:20, tristan4233
Carlos hears juan and rita’s complaints about the new employees with whom they have to work with, as well as their threats to quit the company. if carlos were to reassign juan and rita to new, unique roles and separate them from the ronny and bill, it would signal that carlos has moved into the stage of managing resistance.
Answers: 3
Business, 22.06.2019 21:00, crazylogic963
China's new 5 percent tax on disposable wooden chopsticks, reflecting concerns about deforestation, has been praised by environmentalists. the move is hitting hard at the japanese, who consume 25 billion set of wooden chopsticks annually. almost all of the chopsticks used in japan come from china. the reuirements for chinese manufacturers of wooden chopsticks to pay the 5 percent tax is a factor in their external environment.
Answers: 3
You know the right answer?
The manager of the main laboratory facility at Elmhurst HealthElmhurst Health Center is interested i...
Questions in other subjects:
Health, 18.07.2019 10:00
