Reference no: EM13512952
The Ramon Company manufactures a wide range of products at several different plant locations. The Franklin plant, which manufactures electrical components, has been experiencing some difficulties with fluctuating monthly overhead costs. The fluctuations have made it difficult to estimate the level of overhead that will be incurred for any one month. Management wants to be better able to estimate overhead costs accurately in order to plan its operations and financial needs. A trade association publication to which Ramon Company subscribes indicates that for companies that manufacture electrical components, overhead tends to vary with direct labor hours. One member of the accounting staff proposes that the cost behavior pattern for overhead costs be determined. Then, overhead costs could be predicted from the budgeted direct labor hours. Another member of the accounting staff suggests that a good starting point for determining the cost behavior patterns of overhead costs would be an analysis of historical data. The historical cost behavior pattern would provide a basis for determining the cost behavior pattern. The methods proposed for this purpose are the high-low method and simple linear regression. Data on direct labor hours and the respective overhead costs incurred were collected for the past two years. The raw data follow:
|
19a
|
Direct Labor Hours x
|
Overhead Costs y
|
|
January
|
20,000 hours
|
$84,000
|
|
February
|
25,000
|
99,000
|
|
March
|
22,000
|
89,000
|
|
April
|
23,000
|
90,000
|
|
May
June
July
August
September
October
November
December
|
20,000
19,000
14,000
10,000
12,000
17,000
16,000
19,000
|
81,000
75,000
70,000
64,000
69,000
75,000
71,000
78,000
|
|
19b
|
Direct Labor Hours x
|
Overhead Costs y
|
|
January
|
21,000 hours
|
$86,000
|
|
February
|
24,000
|
93,000
|
|
March
|
23,000
|
87,000
|
|
April
|
22,000
|
80,000
|
|
May
June
July
August
September
October
November
December
|
20,000
18,000
12,000
13,000
15,000
17,000
15,000
18,000
|
76,000
67,000
71,000
73,000
72,000
71,000
75,000
78,000
|
Using linear regression, the following data were obtained:
Coefficient of determination (r2) 0.9109
Coefficient of regression equation
Constant 39,859
Independent variable 2.1549
Standard error of the estimate (s,) 2,840
Standard error of the regression coefficient for the independent variable (sb) 0.1437
Table t-statistic for a 95% confidence interval (when n -2 = 24 -2 = 22) 2.074
(a) Using the high-low method, determine the cost behavior pattern of the overhead costs for the Franklin plant.
(b) Using the results of the regression analysis, calculate the estimate of overhead costs for 22,500 direct labor hours.
(c)Of the two proposed methods, which one should Ramon Company employ to determine the historical cost behavior pattern of the Frankliin plant's overhead costs? Explain your answer completely, indicating the reasons why the other method should not be used.
(CMA, adapted)
Enrollment in local colleges, 2005
|
Find by what factor should you change them
: You want to double the resonance angular frequency of a series R-L-C circuit by changing only the pertinent circuit elements all by the same factor
|
|
The example of the samoan matai system
: The example of the Samoan matai system being used when two Samoans were killed by a policeman in Los Angeles shows
|
|
Recast the income statement in contribution format
: For the month of August 19A, Updike Co. presented the following income statement.
|
|
Find what is her total displacement
: Margaret walks to the store using the following path: .500 miles west, .200 miles north, .300 miles east. What is her total displacement
|
|
Determine the cost behavior pattern of the overhead costs
: The Ramon Company manufactures a wide range of products at several different plant locations. The Franklin plant, which manufactures electrical components, has been experiencing some difficulties with fluctuating monthly overhead costs.
|
|
Define a zinc oxide-chromium(iii) oxide catalyst
: A 2.0 L-reaction flask initially contains 0.17 mol CO, 0.15 mol H2, and 0.10 mol CH3OH (methanol). If this mixture is brought in contact with a zinc oxide-chromium(III) oxide catalyst, the equilibrium shown below is attained.
|
|
What is the average intensity of its signal
: A 58 kW radio station broadcasts its signal uniformly in all directions. What is the average intensity of its signal at a distance of 290 m from the antenna
|
|
Differences between core and periphery nations
: What did Robert Redfield study? Differences between core and periphery nations, Differences between health-care systems in foragers and agriculturalists, Differences between urban and rural communities
|
|
Find what is the total intensity level
: A loudspeaker is generating sound in a room. At a certain point, the sound waves coming directly from the speaker (without reflecting from the walls) create an intensity level of 75.1 dB. What is the total intensity level
|