Question

In: Accounting

Spark Electrical Company manufactures electrical components. The plant manager – Mr. Uptight, has experienced difficulties with...

Spark Electrical Company manufactures electrical components. The plant manager – Mr. Uptight, has experienced difficulties with fluctuating monthly overhead costs.

Mr. Uptight wants to be able to estimate overhead costs to plan its operations and financial needs. A trade association publication reports that for companies manufacturing electrical components, overhead tends to vary with machine hours.

Monthly data was gathered on machine hours and overhead costs for the past two years. There were no major changes in operations over this period of time. The raw data is in the chart below:

Month Numbers Machine Hours (1000) Overhead Cost ($), (1000)
1 20 84
2 25 99
3 22 89.5
4 23 90
5 20 81.5
6 19 75.5
7 14 70.5
8 10 64.5
9 12 69
10 17 75
11 16 71.5
12 19 78
13 21 86
14 24 93
15 23 93
16 22 87
17 20 80
18 18 76.5
19 12 67.5
20 13 71
21 15 73.5
22 17 72.5
23 15 71
24 18 75

A. Use the high-low method to estimate the overhead costs and write the cost estimation equation.

B. Use the regression analysis program in Excel to obtain the regression output and write the cost estimation equation.

C. Use the results (formulas) in A. and B. above separately, to prepare the cost estimate for 22,000 machine hours.

D. Explain the results obtained from C. above after comparing them, using statistical data obtained.

Solutions

Expert Solution


Related Solutions

Spark Ltd has two divisions, assembly and electrical. The assembly division transfers partially completed components to...
Spark Ltd has two divisions, assembly and electrical. The assembly division transfers partially completed components to the electrical division at a predetermined transfer price. The assembly division’s standard variable production cost per unit is $550. This division has spare capacity, and it could sell all its components to outside buyers at $680 per unit in a perfectly competitive market. Required: a) Determine a transfer price using the general rule. b) How would the transfer price change if the assembly division...
Spark Ltd has two divisions, assembly and electrical. The assembly division transfers partially completed components to...
Spark Ltd has two divisions, assembly and electrical. The assembly division transfers partially completed components to the electrical division at a predetermined transfer price. The assembly division’s standard variable production cost per unit is $550. This division has spare capacity, and it could sell all its components to outside buyers at $680 per unit in a perfectly competitive market Required: a) Determine a transfer price using the general rule. b) How would the transfer price change if the assembly division...
Mr. Zaid is an experienced cost accounting manager joined Oman Cement Company as a senior cost...
Mr. Zaid is an experienced cost accounting manager joined Oman Cement Company as a senior cost manager. After some days he came to know that the costing system of the company is not appropriate where semi-variable cost is not taken into consideration for cost control, due to which the production cost was too high. Hence he understood that this has to be brought in to notice of top-level managers and hence he prepared a report by taking one semi-variable cost...
MajorCables manufactures electrical and electronic components. The company expects to produce 4000 units of coaxial connectors...
MajorCables manufactures electrical and electronic components. The company expects to produce 4000 units of coaxial connectors each month. Budgeted costs are as follows: direct material RM28,000, direct labour RM20,000, variable overhead RM40,000 and fixed overhead RM3000. Actual production for the month of December is 4100 units. Actual costs incurred for December are as follows: direct material RM28,290, direct labour RM22,000, variable overhead RM44,000 and fixed overhead RM,3000. Required: Prepare a flexible budget showing comparisons with actual costs and variances.
Hartman Company's Lucas plant manufactures thermostatic controls. Plant management has experienced fluctuating monthly overhead costs and...
Hartman Company's Lucas plant manufactures thermostatic controls. Plant management has experienced fluctuating monthly overhead costs and wants to estimate overhead costs accurately to plan its operations and its financial needs. Interviews with plant personnel and studies reported in trade publications suggest that overhead in this industry tends to vary with labor-hours. A member of the controller's staff proposed that the behavior pattern of these overhead costs be determined to improve cost estimation. Another staff member suggested that a good starting...
Hartman Company's Lucas plant manufactures thermostatic controls. Plant management has experienced fluctuating monthly overhead costs and...
Hartman Company's Lucas plant manufactures thermostatic controls. Plant management has experienced fluctuating monthly overhead costs and wants to estimate overhead costs accurately to plan its operations and its financial needs. Interviews with plant personnel and studies reported in trade publications suggest that overhead in this industry tends to vary with labor-hours. A member of the controller's staff proposed that the behavior pattern of these overhead costs be determined to improve cost estimation. Another staff member suggested that a good starting...
Hartman Company's Lucas plant manufactures thermostatic controls. Plant management has experienced fluctuating monthly overhead costs and...
Hartman Company's Lucas plant manufactures thermostatic controls. Plant management has experienced fluctuating monthly overhead costs and wants to estimate overhead costs accurately to plan its operations and its financial needs. Interviews with plant personnel and studies reported in trade publications suggest that overhead in this industry tends to vary with labor-hours.      A member of the controller's staff proposed that the behavior pattern of these overhead costs be determined to improve cost estimation. Another staff member suggested that a good starting...
Hartman Company's Lucas plant manufactures thermostatic controls. Plant management has experienced fluctuating monthly overhead costs and...
Hartman Company's Lucas plant manufactures thermostatic controls. Plant management has experienced fluctuating monthly overhead costs and wants to estimate overhead costs accurately to plan its operations and its financial needs. Interviews with plant personnel and studies reported in trade publications suggest that overhead in this industry tends to vary with labor-hours. A member of the controller's staff proposed that the behavior pattern of these overhead costs be determined to improve cost estimation. Another staff member suggested that a good starting...
Bonadio Electrical Supplies distributes electrical components to the construction industry. The company began as a local...
Bonadio Electrical Supplies distributes electrical components to the construction industry. The company began as a local supplier 15 yrs ago and has grown rapidly to become a major competitor in the North central U.S. As the business grew and variety of components to be stocked expanded, Bonadio acquired a computer and implemented an inventory control system. Other applications such as accounts receivable, account payable, payroll, and sale analysis were gradually computerized as each function expanded. Because of its operational importance,...
Week 8 Spark Ltd has two divisions, assembly and electrical. The assembly division transfers partially completed...
Week 8 Spark Ltd has two divisions, assembly and electrical. The assembly division transfers partially completed components to the electrical division at a predetermined transfer price. The assembly division’s standard variable production cost per unit is $550. This division has spare capacity, and it could sell all its components to outside buyers at $680 per unit in a perfectly competitive market. Required: a) Determine a transfer price using the general rule. b) How would the transfer price change if the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT