Explore BrainMass
Share

Regression Coefficient Mixed Costs at a Hospital

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Mixed costs are very common in business and consist of fixed cost element and a variable cost element. Fixed costs are a recurring, constant cost that does not vary when business activity varies. Variable costs are added costs associated with each unit of business activity the organization experiences. The relationship can be characterized by the following equation:

Total costs = Fixed Cost + (cost per unit) x (number of units of business activity)

In a leading managerial accounting textbook, the authors discuss a hospital's total maintenance costs, and use regression analysis to estimate the fixed cost element of maintenance and the variable cost associated with the number of patient-days. The hospital's total maintenance costs and number of patient-days for seven months are listed in the following table and stored in the file (MixedCosts).

Problem:

A. Using total maintenance costs as the dependent variable and patient-days as the independent variable, use the least-squares method to find the regression coeffiecients bo and b1.

B. Which regression coefficient represents fixed cost?

C. Which regression coefficient represents the variable cost per each patient-day?

D. Predict total maintenance costs for a month with 7,500 patient-days.

© BrainMass Inc. brainmass.com October 16, 2018, 7:15 pm ad1c9bdddf
https://brainmass.com/statistics/regression-analysis/regression-coefficient-mixed-cost-hospital-520745

Attachments

Solution Preview

a) mean of patient days: ux=(5600+7100+5000+6500+7300+8000+6200)/7=6528.571
Sx=sqrt(((5600-6528.571)^2+(7100-6528.571)^2+...+(6200-6528.571)^2)/(7-1))=1032.334
mean of costs: ...

Solution Summary

A regression coefficient mixed costs at a hospital are examined.

$2.19
Similar Posting

Bio-Statistics: Select the Appropriate Statistical Test for Analysis of Hospital Costs

Select the appropriate statistical test that allows you to conduct an analysis of the factors affecting hospital costs. You will have to select the correct statistical test and conduct that test in Excel.

1. Analyze your data and produce a summary describing the major findings of your analysis.

2. The variables that most affect hospital cost.

3. An overview of the P and F values in your Excel tables.

4. A discussion of the degrees of freedom and the sample size.

5. Discuss any significant relationships that present themselves in the Excel files produced from your statistical analysis
please be as detailed as possible.

View Full Posting Details