Question

In: Accounting

Month Machine Hours (hrs.) Maintenance Costs ($) 1 1,330 102,694 2 1,400 103,694 3 1,500 108,694...

Month Machine Hours (hrs.) Maintenance Costs ($)
1 1,330 102,694
2 1,400 103,694
3 1,500 108,694
4 1,470 108,694
5 1,620 116,694
6 1,690 115,694
7 1,490 107,694
8 1,310 102,694
9 1,450 106,694
10 1,580 113,694
11 1,300 100,694
12 1,600 113,694
13 1,650 114,694
14 1,440 109,694
15 1,340 102,694
16 1,670 114,694
17 1,480 106,694
18 1,360 103,694
19 1,340 103,694
20 1,540 112,694
Assume that the following relationship holds:
Maintenance Costs = (v * Machine Hours) + f
REQUIRED
Estimate the values of v and f and the cost equation, using,
1. the High-Low Method, and

2. the Linear Regression method.

Note, to use the linear regression method, you MUST use the Microsoft excel program.

Make sure to report:

1. the values of v and f;
2. a scatter plot of the data points, and
3. the adjusted R-square; explain what the adjusted R-square means.

4. The cost equation in the form of Y = vx + f, substituting the values for v and f from the regression output.

YOUR SUBMISSION MUST BE IN EXCEL. ONE WORKBOOK, WITH A WORKSHEET FOR EACH ANALYSIS (i.e., High-Low Method and Regression Analysis respectively). The regression analysis must include the output from the Analysis Datapak similar to Exhibit 6-15 on page 328.

Solutions

Expert Solution

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

Month Machine Hours (hrs.) Maintenance Costs ($) 1 1,330 102,694 2 1,400 103,694 3 1,500 108,694...
Month Machine Hours (hrs.) Maintenance Costs ($) 1 1,330 102,694 2 1,400 103,694 3 1,500 108,694 4 1,470 108,694 5 1,620 116,694 6 1,690 115,694 7 1,490 107,694 8 1,310 102,694 9 1,450 106,694 10 1,580 113,694 11 1,300 100,694 12 1,600 113,694 13 1,650 114,694 14 1,440 109,694 15 1,340 102,694 16 1,670 114,694 17 1,480 106,694 18 1,360 103,694 19 1,340 103,694 20 1,540 112,694 Assume that the following relationship holds: Maintenance Costs = (v * Machine Hours)...
Month Machine Hours (hrs.) Maintenance Costs ($) 1 1,330 102,694 2 1,400 103,694 3 1,500 108,694...
Month Machine Hours (hrs.) Maintenance Costs ($) 1 1,330 102,694 2 1,400 103,694 3 1,500 108,694 4 1,470 108,694 5 1,620 116,694 6 1,690 115,694 7 1,490 107,694 8 1,310 102,694 9 1,450 106,694 10 1,580 113,694 11 1,300 100,694 12 1,600 113,694 13 1,650 114,694 14 1,440 109,694 15 1,340 102,694 16 1,670 114,694 17 1,480 106,694 18 1,360 103,694 19 1,340 103,694 20 1,540 112,694 Assume that the following relationship holds: Maintenance Costs = (v * Machine Hours)...
Month Machine Hours (hrs.) Maintenance Costs ($) 1 1,330 102,694 2 1,400 103,694 3 1,500 108,694...
Month Machine Hours (hrs.) Maintenance Costs ($) 1 1,330 102,694 2 1,400 103,694 3 1,500 108,694 4 1,470 108,694 5 1,620 116,694 6 1,690 115,694 7 1,490 107,694 8 1,310 102,694 9 1,450 106,694 10 1,580 113,694 11 1,300 100,694 12 1,600 113,694 13 1,650 114,694 14 1,440 109,694 15 1,340 102,694 16 1,670 114,694 17 1,480 106,694 18 1,360 103,694 19 1,340 103,694 20 1,540 112,694 Assume that the following relationship holds: Maintenance Costs = (v * Machine Hours)...
Month Machine Hours (hrs.) Maintenance Costs ($) 1 1,330 102,694 2 1,400 103,694 3 1,500 108,694...
Month Machine Hours (hrs.) Maintenance Costs ($) 1 1,330 102,694 2 1,400 103,694 3 1,500 108,694 4 1,470 108,694 5 1,620 116,694 6 1,690 115,694 7 1,490 107,694 8 1,310 102,694 9 1,450 106,694 10 1,580 113,694 11 1,300 100,694 12 1,600 113,694 13 1,650 114,694 14 1,440 109,694 15 1,340 102,694 16 1,670 114,694 17 1,480 106,694 18 1,360 103,694 19 1,340 103,694 20 1,540 112,694 Assume that the following relationship holds: Maintenance Costs = (v * Machine Hours)...
Month Machine Hours (hrs.) Maintenance Costs ($) 1 1,330 102,694 2 1,400 103,694 3 1,500 108,694...
Month Machine Hours (hrs.) Maintenance Costs ($) 1 1,330 102,694 2 1,400 103,694 3 1,500 108,694 4 1,470 108,694 5 1,620 116,694 6 1,690 115,694 7 1,490 107,694 8 1,310 102,694 9 1,450 106,694 10 1,580 113,694 11 1,300 100,694 12 1,600 113,694 13 1,650 114,694 14 1,440 109,694 15 1,340 102,694 16 1,670 114,694 17 1,480 106,694 18 1,360 103,694 19 1,340 103,694 20 1,540 112,694 Assume that the following relationship holds: Maintenance Costs = (v * Machine Hours)...
Month # Machine Hours (X) Maintenance Costs (Y) Jan 3,000 $440 Feb 4,500 $690 Mar 8,000...
Month # Machine Hours (X) Maintenance Costs (Y) Jan 3,000 $440 Feb 4,500 $690 Mar 8,000 $510 Apr 7,000 $600 May 6,000 $550 Jun 9,000 $980 Jul 3,500 $840 Aug 5,500 $600 What does the slope represent? the rate at which the X variable changes as a result of the Y variable the rate at which the Y variable changes as a result of the X variable the rate at which the dependent variable changes as a result of the...
1.Nutt Industries electricity costs and machine hours over a six-month period follow: Machine Electricity Hours Cost...
1.Nutt Industries electricity costs and machine hours over a six-month period follow: Machine Electricity Hours Cost January 2000 $4,800 February 2500 5,200 March 3000 5,400 April 2400 5,000 May 2800 5,600 June 2200 5,000 Required: a. Using the high-low method, what is the estimated electricity cost per machine hour? b. Differentiate high-low method from other methods of inventory valuation.
Prior to installing a JIT system, Clarendon Company used machine hours to assign maintenance costs to...
Prior to installing a JIT system, Clarendon Company used machine hours to assign maintenance costs to its three products of 6-inch, 8-inch, and 11-inch insulation. The maintenance costs totaled $400,000 per year. The machine hours used by each product and the quantity produced of each product are as follows: Machine Hours Quantity Produced 6-inch 12,000 31,250 rolls 8-inch 20,000 25,000 rolls 11-inch 18,000 12,000 rolls After installing JIT, three manufacturing cells were created and the cell workers were trained to...
Data in hrs/week: Individual Hours/Week Spent on Social Media 1 8 2 8 3 15 4...
Data in hrs/week: Individual Hours/Week Spent on Social Media 1 8 2 8 3 15 4 9 5 5 6 10 7 4 8 5 9 14 10 20 11 16 12 7 13 6 14 8 15 10 16 4 17 9 18 18 19 13 20 12 21 8 22 6 23 11 24 20 25 9 26 5 27 7 28 19 29 8 30 6 31 16 32 7 33 16 34 9 35 4 36...
Eagle Manufacturing has incurred the following machine maintenance costs over the first half of 2018: Month...
Eagle Manufacturing has incurred the following machine maintenance costs over the first half of 2018: Month Machine Hours Cost ($) January 10,000 15,500 February 15,000 16,233 March 12,750 15,985 April 13,268 16,025 May 9,256 11,159 June 10,335 15,117 Required: Using the High – Low method compute: a. The variable cost component of the Maintenance Costs. b. The fixed cost component of the Maintenance Costs. c. The total Maintenance Costs for the month of July, which is projected to use 13,295...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT