X-Ray and Factory Overhead Cost Analysis
Uploaded by
thutran.31231022807X-Ray and Factory Overhead Cost Analysis
Uploaded by
thutran.31231022807Common questions
Powered by AIInaccurately estimating fixed and variable cost components may lead to erroneous cost projections, impacting budgeting, pricing decisions, and financial forecasting. If variable costs are underestimated, the firm might underprice services, leading to lower margins. Overestimating fixed costs could result in resource underutilization or excessive cost-cutting measures. Accurate cost analysis informs strategic decisions, ensuring competitive pricing through precise cost modeling, financial planning, and resource allocation .
Factory overhead costs are segregated into variable and fixed components using activity levels in the high-low method. By examining the total costs at the highest and lowest activity levels, variable costs (e.g., indirect materials) can be isolated. The difference in total overhead costs between high and low levels is attributable to variable cost fluctuations, calculated as the cost difference divided by the activity level difference (e.g., (80,000-60,000) machine-hours for $90,000 in indirect materials). Fixed costs such as rent remain constant across these activity levels. In the maintenance cost example, the fixed cost component was determined to be $30,000, with a variable component of $0.4 per machine-hour .
Using the high-low method cost formula, the expected X-ray costs for 4,600 X-rays taken is calculated as y = $8,000 + $3 * 4,600 = $21,800 .
The scattergraph plots the number of X-rays on the horizontal axis against X-ray costs on the vertical axis, helping visualize the relationship between these variables. By drawing a line through the data points, one can quickly identify whether costs increase consistently with the number of X-rays, indicating a variable cost component. Outliers or non-linear trends may suggest other cost behavior, but generally, this graph supports understanding how costs fluctuate with varying activity levels .
Regression analysis enhances understanding of cost structure by providing insights into the nuanced interactions between activity levels and costs, identifying patterns and predicting changes with higher precision. Unlike traditional methods like high-low, regression offers comprehensive analyses by leveraging entire datasets to uncover correlations, outliers, and influential factors affecting costs. This comprehensive view enables businesses to adapt strategies, optimizing resource allocation and cost management, ultimately fostering more informed and agile decision-making processes .
To calculate the total expected overhead costs for 65,000 machine-hours, first compute indirect materials as 1.5 pesos per machine-hour times 65,000, equaling 97,500 pesos. Rent remains fixed at 130,000 pesos. Maintenance cost is computed using the high-low derived equation y = 30,000 + 0.4 * 65,000, which equals 56,000 pesos. Adding these components gives a total overhead cost of 283,500 pesos for 65,000 machine-hours .
To estimate the variable cost per X-ray using the high-low method, identify the highest and lowest levels of activity and their corresponding costs. The variable cost per X-ray is calculated by dividing the change in total costs by the change in the number of X-rays. In this case, it is ($29,000 - $17,000) / (7,000 - 3,000) = $3 per X-ray. The total fixed cost is determined by subtracting total variable costs at either the high or low point from the total cost. Using the high activity level, the fixed cost is $29,000 - (7,000 x $3) = $8,000 .
The least-squares regression method provides a more precise estimate of the cost formula as it considers all data points to minimize the sum of squared errors, resulting in a slope and Y-intercept that can differ from the high-low method. For example, the least-squares regression estimates the Y-intercept as $6,529.41 and the variable cost as $3.29 per X-ray, compared to the high-low method's Y-intercept of $8,000 and variable cost of $3 per X-ray. These differences reflect the least-squares method's ability to account for variability in all data points rather than just using the extremes .
Comparing high-low and least-squares regression methods is crucial because each method has different merits; high-low is simple but overlooks data variability and might be skewed by outliers, while least-squares accounts for all data points, minimizing estimation errors. Sole reliance on one method could lead to biased cost assessments, affecting decision-making accuracy. Using both provides a more robust framework for understanding variances in cost behavior, crucial for effective financial management and operational planning .
With the least-squares regression formula y = $6,529.41 + $3.29 * x, the estimated cost for 4,600 X-rays would be calculated as y = $6,529.41 + $3.29 * 4,600 = $21,663.41 .