In this activity, you will solve a case out of your textbook, Managerial Accounting. The intent of the Case Studies is to show how to analyze module related managerial accounting financial data in an organizations setting. For this case study, you will be able to demonstrate your ability to correctly calculate costs using the high-low method and least-square method. Your second Case Study will be Case 6-49: Comparing Multiple Cost Estimation Methods: Ethics. This case can be found at the end of Chapter 6. The primary focus of this case study is the understanding and application of fixed costs, variable costs, the least-squares method, and the high-low method. Your assignment is to complete the requirements identified for Case 6-49: 1-4.
1. High-low method: Variable administrative cost per patient =
Total cost at 1,500 patients=$16,100
Variable cost at 1,500 patients=15,000
Fixed cost per month=$1,100
Cost formula: Total monthly administrative cost = $1,100 + $10X, where X is the number of patients for the month. The variable cost per patient is $10.
2.
a. Variable cost per patient= .957909 or $10 rounded.
b. R2 or correlation of the coefficient is .91759. Since it is very close to one it means that my model is a good one.
3. Memorandum
Date: November 3, 2013
To: Jeffrey Mahoney, Administrator
From: Valerie Delarosa
Subject: Cost comparison of estimates for clinic administrative
Using three alternative cost-estimation methods to estimate the pediatric clinic's administrative cost behavior it is determined that in the first year the fluctuation was too great. The results of these three approaches are shown below. Be advised in each formula, X denotes the number of patients in a month.
(a) Least-squares regression method: Total monthly administrative cost = $2,671 + $7.81X
(b) High-low method: Total monthly administrative cost = $1,100 + $10X
(c) Scatter Diagram and Visual-fit method: Total monthly administrative cost =