Question

In: Accounting

The controller of Blossom Industries has collected the following monthly expense data for analyzing the cost...

The controller of Blossom Industries has collected the following monthly expense data for analyzing the cost behavior of electricity costs. Total Electricity Costs Total Machine Hours January $1,720 210 February 2,990 320 March 3,560 500 April 4,800 695 May 3,220 500 June 4,930 770 July 4,040 635 August 3,800 570 September 5,050 660 October 4,350 630 November 3,360 320 December 6,150 790

Determine the fixed- and variable-cost components using regression analysis

Solutions

Expert Solution

Step-1:

Step-2:

Step-3:

Step-4:


Related Solutions

The controller of Blossom Production has collected the following monthly expense data for analyzing the cost...
The controller of Blossom Production has collected the following monthly expense data for analyzing the cost behavior of electricity costs. Total Electricity Costs Total Machine Hours January $2,660 230 February 3,050 330 March 3,520 460 April 4,770 690 May 3,190 420 June 4,960 790 July 4,030 650 August 3,870 590 September 5,040 670 October 4,270 610 November 3,260 330 December 8,460 810 (a) Determine the fixed- and variable-cost components using the high-low method. Fixed-costs $ Variable-costs $ eTextbook and Media...
The controller of Blossom Production has collected the following monthly expense data for analyzing the cost...
The controller of Blossom Production has collected the following monthly expense data for analyzing the cost behavior of electricity costs. Total Electricity Costs Total Machine Hours January $2,660 230 February 3,050 330 March 3,520 460 April 4,770 690 May 3,190 420 June 4,960 790 July 4,030 650 August 3,870 590 September 5,040 670 October 4,270 610 November 3,260 330 December 6,720 810 What electricity cost does the cost equation estimate for a level of activity of 790 machine hours? Electricity...
he controller of Blossom Industries has collected the following monthly expense data for use in analyzing...
he controller of Blossom Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs. Month Total Maintenance Costs Total Machine Hours January $2,912 3,860 February 3,309 4,412 March 3,971 6,618 April 4,963 8,714 May 3,530 5,515 June 5,894 8,830 Determine the variable-cost components using the high-low method. Determine the fixed cost components using the high-low method.
The controller of Hall Industries has collected the following monthly expense data for use in analyzing...
The controller of Hall Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs. Month Total Maintenance Costs Total Machine Hours January $9,500 5,250 February 10,840 6,000 March 15,360 9,000 April 19,984 11,850 May 13,000 7,500 June 20,300 12,000. 1. Determine the variable-cost components using the high-low method. (Round variable cost to 2 decimal places e.g. 12.25.) Variable cost per machine hour= 2. Determine the fixed cost components using the high-low method....
The controller of Oriole Industries has collected the following monthly expense data for use in analyzing...
The controller of Oriole Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs. Month Total Maintenance Costs Total Machine Hours January $2,860 320 February 3,160 370 March 3,760 520 April 4,660 670 May 3,360 520 June 5,260 720 Determine the variable cost components using the high-low method. (Round answer to 2 decimal places e.g. 2.25.) Variable cost per machine hour $ Determine the fixed cost components using the high-low method. Total...
The controller of Hall Industries has collected the following monthly expense data for use in analyzing...
The controller of Hall Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs. Month Total Maintenance Costs Total Machine Hours January $2,640 3,500 February 3,000 4,000 March 3,600 6,000 April 4,500 7,900 May 3,200 5,000 June 4,620 8,000 Determine the variable-cost components using the high-low method. (Round answer to 2 decimal places e.g. 2.25.) Variable cost per machine hour $enter the variable cost per machine hour in dollars rounded to 2...
The controller of Dousmann Industries has collected the following monthly expense data for use in analysing...
The controller of Dousmann Industries has collected the following monthly expense data for use in analysing the cost behavior of maintenance cost. Month Total Maintenance costs Total Machine Hours January 2,750 3,500 February 3,000 4,000 March 3,600 6,000 April 4,500 7,900 May 3,200 5,000 June 5,000 8,000 A) Determine the fixed and variable cost components using the high low method. B) Prepare a graph showing the behavior of maintenance costs, and identify the fixed and variable elements. Use 2,000- hour...
Cost of Quality Analysis The ABC Company has collected the following cost data for the year:  ...
Cost of Quality Analysis The ABC Company has collected the following cost data for the year:             Receiving Inspection $ 15,232 Production Scrap $   32,150 Rejected Products $ 6,200   Product Design $ 25,422 Customer Adjustment Credit $ 85,654 Online Inspection $ 17,248 Quality Team Meeting $ 7,540 Downgrading Products $ 1,125,328 Customer Need survey $ 3,250 Final test $         25,758 Prototyping $ 136,802   Organize these costs in COQ categories and put any non-QOC data in the NQ category. Compute the...
Shirley industries is analyzing an average risk project, and the following data has been developed. Annual...
Shirley industries is analyzing an average risk project, and the following data has been developed. Annual unit sales will be constant but the sales price will increase with inflation which is to be 5%. Fixed costs will also be constant but variable costs will rise with inflation. The project involved buying a $100,000 piece of equipment that will last for 3 years and be straight lined depreciated to zero. At the end of of the project there will be a...
In reviewing activity for July, the controller of Mathis, Inc., collected the following data concerning direct...
In reviewing activity for July, the controller of Mathis, Inc., collected the following data concerning direct materials. Actual production 103,000 units Direct materials purchased (actual) $ 1,642,800 Standard cost of materials purchased 1,554,000 Standard direct materials costs per unit produced 14 Standard price times actual amount of materials used 1,405,950 Assume that Mathis Company had no beginning finished goods inventory and only produced one product. Mathis sold 90,640 units during the period. Required: a. Assume Mathis writes off all variances...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT