|
Instructions:
- Find the data set [#1, #2, #3, or #4] that you have been assigned.
- Use the mouse to highlight the data set headings [Month, Direct Labor
Hours, and Overhead Costs] and the three columns of data.
- Do a "Control-C"
- Open Excel
- Do a "paste special," then "Unicode text" to paste the data into an
Excel worksheet.
- Evaluate the use of the relationship between direct labor hours and
overhead costs as a predictor of future overhead costs using the data that
you have. Your analysis should consider measures of plots and measures of
goodness of fit as we have discussed in class.
Data set #1
|
Month |
DLH |
Overhead Costs |
|
1 |
14,000 |
$76,500 |
|
2 |
12,000 |
$69,000 |
|
3 |
25,000 |
$99,000 |
|
4 |
16,000 |
$71,500 |
|
5 |
23,000 |
$90,000 |
|
6 |
22,000 |
$92,500 |
|
7 |
19,000 |
$87,500 |
|
8 |
10,000 |
$64,500 |
|
9 |
20,000 |
$81,500 |
|
10 |
19,000 |
$78,000 |
|
11 |
20,000 |
$84,000 |
|
12 |
17,000 |
$75,000 |
Data set #2
|
Month |
DLH |
Overhead Costs |
|
1 |
24,130
|
$ 35,500 |
|
2 |
23,247
|
$ 36,250 |
|
3 |
14,038
|
$ 46,500 |
|
4 |
22,578
|
$ 37,500 |
|
5 |
14,116
|
$ 40,000 |
|
6 |
15,913
|
$ 43,500 |
|
7 |
16,085
|
$ 33,750 |
|
8 |
22,274
|
$ 36,750 |
|
9 |
13,502
|
$ 38,250 |
|
10 |
19,771
|
$ 40,000 |
|
11 |
21,301
|
$ 46,500 |
|
12 |
20,645
|
$ 35,500 |
Data set #3
|
Month |
DLH |
Overhead Costs |
|
1 |
21,000 |
$ 82,000 |
|
2 |
23,000 |
$ 84,000 |
|
3 |
16,000 |
$ 71,500 |
|
4 |
25,000 |
$ 84,000 |
|
5 |
18,000 |
$ 71,000 |
|
6 |
17,000 |
$ 71,000 |
|
7 |
20,000 |
$ 82,000 |
|
8 |
22,000 |
$ 82,000 |
|
9 |
19,000 |
$ 72,000 |
|
10 |
26,000 |
$ 84,000 |
|
11 |
15,000 |
$ 71,000 |
|
12 |
24,000 |
$ 84,000 |
Data set #4
|
Month |
DLH |
Overhead Costs |
|
1 |
15,500 |
$ 76,500 |
|
2 |
15,000 |
$ 75,000 |
|
3 |
16,000 |
$ 76,000 |
|
4 |
18,000 |
$ 78,000 |
|
5 |
17,900 |
$ 78,000 |
|
6 |
17,000 |
$ 77,000 |
|
7 |
8,000 |
$ 73,000 |
|
8 |
13,000 |
$ 75,500 |
|
9 |
10,000 |
$ 75,000 |
|
10 |
12,000 |
$ 72,500 |
|
11 |
16,500 |
$ 77,000 |
|
12 |
14,000 |
$ 74,000 |
|
