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
Another question on Business
Business, 21.06.2019 23:30
Afinancial institution, the thriftem bank, is in the process of formulating its loan policy for the next quarter. a total of $12 million is allocated for that purpose. being a full-service facility, the bank is obligated to grant loans to different clientele. the following table provides the types of loans, the interest rate charged by the bank, and the possibility of bad debt as estimated from past experience.type of loaninterest rateprobability of bad debtpersonal.140.10car.130.07home.120.03farm.125.05commercial.100.02 bad debts are assumed unrecoverable and hence produce no interest revenue either. competition with other financial institutions in the area requires that the bank allocate at least 40% of the total funds to farm and commercial loans. to assist the housing industry in the region, home loans must equal at least 50% of the personal, car, and home loans. the bank also has a stated policy specifying that the overall ratio for bad debts on all loans may not exceed .04. formulate this problem as a linear program. define your variables clearly and write all the constraints explaining the significance of each.
Answers: 1
Business, 22.06.2019 07:00
For the past six years, the price of slippery rock stock has been increasing at a rate of 8.21 percent a year. currently, the stock is priced at $43.40 a share and has a required return of 11.65 percent. what is the dividend yield? 3.20 percent 2.75 percent 3.69 percent
Answers: 3
Business, 22.06.2019 08:40
Exercise 18-15 sheffield appliance center is an experienced home appliance dealer. sheffield appliance center also offers a number of services for the home appliances that it sells. assume that sheffield appliance center sells ovens on a standalone basis. sheffield appliance center also sells installation services and maintenance services for ovens. however, sheffield appliance center does not offer installation or maintenance services to customers who buy ovens from other vendors. pricing for ovens is as follows. oven only $790 oven with installation service 850 oven with maintenance services 970 oven with installation and maintenance services 990 in each instance in which maintenance services are provided, the maintenance service is separately priced within the arrangement at $180. additionally, the incremental amount charged by sheffield appliance center for installation approximates the amount charged by independent third parties. ovens are sold subject to a general right of return. if a customer purchases an oven with installation and/or maintenance services, in the event sheffield appliance center does not complete the service satisfactorily, the customer is only entitled to a refund of the portion of the fee that exceeds $790. assume that a customer purchases an oven with both installation and maintenance services for $990. (b) indicate the amount of revenue that should be allocated to the oven, the installation, and to the maintenance contract.
Answers: 3
You know the right answer?
The manager of the main laboratory facility at Elmhurst HealthElmhurst Health Center is interested i...
Questions
Mathematics, 07.04.2020 15:49
Mathematics, 07.04.2020 15:49
