Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow:MonthMachine HoursElectricity CostsJanuary2,500$18,400 February2,900 21,000 March1,900 13,500 April3,100 23,000 May3,800 28,250 June3,300 22,000 July4,100 24,750 August3,500 22,750 September2,000 15,500 October3,700 26,000 November4,700 31,000 December4,200 27,750 Summary OutputRegression StatisticsMultiple R0.965R Square0.932Adjusted R20.925Standard Error1,425.18Observations12.00 CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Intercept3,726.881,682.822.210.05(22.69)7,476.45Machine Hours5.770.4911.70.004.676.87Based on the results
of the high-low analysis, the estimate of electricity costs in a month with 2,200 machine hours would be:
A. $15,375.
B. $15,180.
C. $22,825.
D. $16,427.
Answer: A
You might also like to view...
In attribute sampling, the risk of incorrect rejection deals with which of the following?
a. Effectiveness. b. Efficiency. c. Reliability. d. Both A and B.
If a business operates in an industry that experiences significant cost changes, should the business prepare its production cost report using the FIFO method or the weighted-average method?
Explain your answer.
Explain what action learning involves and why it is considered to be “self-managed learning.”
What will be an ideal response?
Answer the following statement(s) true (T) or false (F)
1. SCORE stands for Small Corporate and Organizational Resources. 2. SBIC’s have on-site counseling provided by SCORE. 3. The country is divided into 12 regional Small Business Development Centers. 4. Probably because of the “glass-ceiling” effect, a growing number of women have started their own small businesses. 5. The succession process is almost always a quick process.