App-OA-COGS

Dashboard - Overhead Allocation Based on COGS

Project ID	Contract Total (estimated)	Direct Costs (estimated)	Overhead (estimated)	Profit (estimated)	Start Date	Percent Complete
							Adjusted for percentage completion of project.
							Adjusted for percentage completion of project.
							Contract Completed YTD

							Adj. Est. Direct Costs YTD

							Adj. Est. Overhead YTD

							Adj. Est. Profit YTD


							Actual results from inputs
							Actual results from inputs
							Actual Direct Costs YTD

							Actual Overhead YTD

							Actual Profit YTD


































File Management
PRINT:Landscape, Margins=Default, Scale=Default

Load

JANUARY Overhead Allocation - Based on COGS

Total Job Costs this month:				Total Overhead Costs this month:
Total Job Costs YTD:				Total Overhead Costs YTD:
	Adjusted Overhead Allocation Factor:
Line	Job ID	Job Costs This Month	Job Costs YTD	Job Costs as % of COGS This Month	Job Costs as % of COGS YTD	OH Costs Allocated to Job Previous Months	OH Costs to be Allocated This Month

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

FEBRUARY Overhead Allocation - Based on COGS

Total Job Costs this month:				Total Overhead Costs this month:
Total Job Costs YTD:				Total Overhead Costs YTD:
	Adjusted Overhead Allocation Factor:
Line	Job ID	Job Costs This Month	Job Costs YTD	Job Costs as % of COGS This Month	Job Costs as % of COGS YTD	OH Costs Allocated to Job Previous Months	OH Costs to be Allocated This Month
					Total:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

MARCH Overhead Allocation - Based on COGS

Total Job Costs this month:				Total Overhead Costs this month:
Total Job Costs YTD:				Total Overhead Costs YTD:
	Adjusted Overhead Allocation Factor:
Line	Job ID	Job Costs This Month	Job Costs YTD	Job Costs as % of COGS This Month	Job Costs as % of COGS YTD	OH Costs Allocated to Job Previous Months	OH Costs to be Allocated This Month
					Total:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

APRIL Overhead Allocation - Based on COGS

Total Job Costs this month:				Total Overhead Costs this month:
Total Job Costs YTD:				Total Overhead Costs YTD:
	Adjusted Overhead Allocation Factor:
Line	Job ID	Job Costs This Month	Job Costs YTD	Job Costs as % of COGS This Month	Job Costs as % of COGS YTD	OH Costs Allocated to Job Previous Months	OH Costs to be Allocated This Month
					Total:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

MAY Overhead Allocation - Based on COGS

Total Job Costs this month:				Total Overhead Costs this month:
Total Job Costs YTD:				Total Overhead Costs YTD:
	Adjusted Overhead Allocation Factor:
Line	Job ID	Job Costs This Month	Job Costs YTD	Job Costs as % of COGS This Month	Job Costs as % of COGS YTD	OH Costs Allocated to Job Previous Months	OH Costs to be Allocated This Month
					Total:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

JUNE Overhead Allocation - Based on COGS

Total Job Costs this month:				Total Overhead Costs this month:
Total Job Costs YTD:				Total Overhead Costs YTD:
	Adjusted Overhead Allocation Factor:
Line	Job ID	Job Costs This Month	Job Costs YTD	Job Costs as % of COGS This Month	Job Costs as % of COGS YTD	OH Costs Allocated to Job Previous Months	OH Costs to be Allocated This Month
					Total:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

JULY Overhead Allocation - Based on COGS

Total Job Costs this month:				Total Overhead Costs this month:
Total Job Costs YTD:				Total Overhead Costs YTD:
	Adjusted Overhead Allocation Factor:
Line	Job ID	Job Costs This Month	Job Costs YTD	Job Costs as % of COGS This Month	Job Costs as % of COGS YTD	OH Costs Allocated to Job Previous Months	OH Costs to be Allocated This Month
					Total:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

AUGUST Overhead Allocation - Based on COGS

Total Job Costs this month:				Total Overhead Costs this month:
Total Job Costs YTD:				Total Overhead Costs YTD:
	Adjusted Overhead Allocation Factor:
Line	Job ID	Job Costs This Month	Job Costs YTD	Job Costs as % of COGS This Month	Job Costs as % of COGS YTD	OH Costs Allocated to Job Previous Months	OH Costs to be Allocated This Month
					Total:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

SEPTEMBER Overhead Allocation - Based on COGS

Total Job Costs this month:				Total Overhead Costs this month:
Total Job Costs YTD:				Total Overhead Costs YTD:
	Adjusted Overhead Allocation Factor:
Line	Job ID	Job Costs This Month	Job Costs YTD	Job Costs as % of COGS This Month	Job Costs as % of COGS YTD	OH Costs Allocated to Job Previous Months	OH Costs to be Allocated This Month
					Total:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

OCTOBER Overhead Allocation - Based on COGS

Total Job Costs this month:				Total Overhead Costs this month:
Total Job Costs YTD:				Total Overhead Costs YTD:
	Adjusted Overhead Allocation Factor:
Line	Job ID	Job Costs This Month	Job Costs YTD	Job Costs as % of COGS This Month	Job Costs as % of COGS YTD	OH Costs Allocated to Job Previous Months	OH Costs to be Allocated This Month
					Total:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

NOVEMBER Overhead Allocation - Based on COGS

Total Job Costs this month:				Total Overhead Costs this month:
Total Job Costs YTD:				Total Overhead Costs YTD:
	Adjusted Overhead Allocation Factor:
Line	Job ID	Job Costs This Month	Job Costs YTD	Job Costs as % of COGS This Month	Job Costs as % of COGS YTD	OH Costs Allocated to Job Previous Months	OH Costs to be Allocated This Month
					Total:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

DECEMBER Overhead Allocation - Based on COGS

Total Job Costs this month:				Total Overhead Costs this month:
Total Job Costs YTD:				Total Overhead Costs YTD:
	Adjusted Overhead Allocation Factor:
Line	Job ID	Job Costs This Month	Job Costs YTD	Job Costs as % of COGS This Month	Job Costs as % of COGS YTD	OH Costs Allocated to Job Previous Months	OH Costs to be Allocated This Month	Total OH Allocations for Year
						Total:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40