+1(978)310-4246 credencewriters@gmail.com
  

I’m working on a excel multi-part question and need an explanation and answer to help me learn.

First, open the spreadsheet and familiarize yourself with the data. What kind of data is there?

What information do the columns contain? What kind of trends could you see if you graphed

that data in various ways? What kinds of observations are relevant to understanding budget to

actuals? You could consider such questions as:

Which projects are over or under budgeted hours?

Which projects are over or under budgeted costs?

Which personnel are over or under budgeted hours?

Which personnel cost the most? The least?

But you don’t need to limit yourself to those. You could analyze the dataset on other variables

or trends, monthly cost variance, or which personnel is better at estimating their hours. Also,

how could you analyze the data to see if there are any personnel who are charging an

unrealistic number of hours in total? Does that tell you anything? Then, begin your formal

analysis of the data. For this task, you are going to analyze the data using pivot tables for the

questions above and any others you think are relevant or interesting about this data. You may

need to filter, sort, or modify the spreadsheet so that you can see data subsets for different

criteria and set up your pivot tables. You may need to use formulas to compute new variables

to pivot on, such as defined buckets or sums or differences for some data.

You may also consider other ways to analyze the data. As you chart the data, look for trends,

outliers, patterns, and other potential insights. What do your charts tell you about these

projects and their performance?

Row Labels
Count of Project
$
35.00
2
$
45.00
1
$
50.00
20
$
60.00
8
$
75.00
5
$
88.00
1
$
90.00
2
$
95.00
1
$
105.00
4
$
120.00
5
$
140.00
4
Grand Total
53
Task 1 – Data Analysis
Hypothetical Project Cost – Budget vs. Actual
Project
Project A
Project A
Project A
Project A
Project A
Project A
Project A
Project A
Project A
Project B
Project B
Project B
Project B
Project B
Project B
Project B
Project B
Project B
Project C
Project C
Project C
Project C
Project C
Project C
Project C
Project C
Project C
Project C
Project C
Project C
Project C
Project C
Project D
Project D
Project D
Project D
Project D
Task
AT1
AT1
AT1
AT1
AT1
AT2
AT2
AT3
AT3
BT1
BT1
BT1
BT2
BT2
BT2
BT3
BT3
BT3
CT1
CT1
CT1
CT1
CT2
CT2
CT2
CT3
CT3
CT3
CT4
CT4
CT5
CT5
DT1
DT1
DT1
DT1
DT2
Resource
Gail
Tom
Jenny
Monique
Jim
Gail
Monique
Gail
Stanley
Gail
Jenny
Stanley
Gail
Monique
Erica
Stanley
George
Erica
Gail
Tom
Jenny
George
Monique
Stanley
George
Gail
Stanley
Erica
Stanley
George
Erica
Stanley
Jim
Inigo
George
Crystal
Sarah
Budget Hours
Cost $ / hr
Month 1 Month 2 Month 3
Month 4
$
50.00
20
20
20
20
$
35.00
80
80
80
80
$
75.00
40
40
40
40
$
105.00
20
20
20
20
$
90.00
140
140
140
140
$
50.00
10
10
10
10
$
105.00
20
20
20
20
$
50.00
20
20
20
20
$
50.00
10
10
10
10
$
50.00
20
20
20
20
$
75.00
40
40
40
40
$
50.00
10
10
10
10
$
50.00
5
5
5
5
$
105.00
40
40
40
40
$
140.00
40
40
40
40
$
50.00
10
10
10
10
$
60.00
20
20
20
20
$
140.00
40
40
40
40
$
50.00
10
10
10
10
$
35.00
80
80
80
80
$
75.00
80
80
80
80
$
60.00
20
20
20
20
$
105.00
80
80
80
80
$
50.00
10
10
10
10
$
60.00
20
20
20
20
$
50.00
30
30
30
30
$
50.00
10
10
10
10
$
140.00
40
40
40
40
$
50.00
10
10
10
10
$
60.00
20
20
20
20
$
140.00
40
40
40
40
$
50.00
10
10
10
10
$
90.00
20
20
20
20
$
95.00
160
160
160
160
$
60.00
20
20
20
20
$
120.00
30
30
30
30
$
75.00
80
80
80
80
Project D
Project D
Project D
Project D
Project D
Project D
Project D
Project D
Project D
Project E
Project E
Project E
Project E
Project E
Project E
Project E
DT2
DT2
DT2
DT3
DT3
DT3
DT4
DT4
DT4
ET1
ET1
ET1
ET2
ET2
ET2
ET2
Stanley
George
Crystal
Sarah
Stanley
Crystal
Stanley
George
Crystal
Gail
Stanley
Crystal
Sondra
Larry
Stanley
George
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
50.00
60.00
120.00
75.00
50.00
120.00
50.00
60.00
120.00
50.00
50.00
120.00
45.00
88.00
50.00
60.00
10
20
30
80
10
30
10
20
30
40
10
30
160
160
10
20
10
20
30
80
10
30
10
20
30
40
10
30
160
160
10
20
10
20
30
80
10
30
10
20
30
40
10
30
160
160
10
20
10
20
30
80
10
30
10
20
30
40
10
30
160
160
10
20
Month 5
20
80
40
20
140
10
20
20
10
20
40
10
5
40
40
10
20
40
10
80
80
20
80
10
20
30
10
40
10
20
40
10
20
160
20
30
80
Month 6
Actual Hours
Month 1
Month 2
Month 3
Month 4
Month 5
Month 6
20
24
24
24
30
30
30
80
80
80
80
90
90
90
40
40
40
40
40
40
40
20
20
20
20
20
20
20
140
160
160
160
160
160
160
10
10
10
10
10
10
10
20
20
20
20
20
20
20
20
20
20
20
20
20
20
10
12
12
12
12
12
12
20
24
24
24
24
24
24
40
50
50
50
50
50
50
10
12
12
12
12
12
12
5
5
5
5
5
5
5
40
40
40
40
40
40
40
40
50
50
50
25
25
25
10
12
12
12
12
12
12
20
25
25
25
25
25
25
40
50
50
50
25
25
25
10
5
5
5
5
5
5
80
80
80
80
80
80
80
80
80
80
80
80
80
80
20
25
25
25
25
25
25
80
120
120
120
120
120
120
10
12
12
12
12
12
12
20
25
25
25
25
25
25
30
30
30
30
30
30
30
10
12
12
12
12
12
12
40
50
50
50
25
25
25
10
12
12
12
12
12
12
20
25
25
25
25
25
25
40
50
50
50
25
25
25
10
12
12
12
12
12
12
20
15
15
15
15
15
15
160
110
110
110
110
110
110
20
25
25
25
25
25
25
30
30
30
30
30
30
30
80
80
80
80
80
80
80
10
20
30
80
10
30
10
20
30
40
10
30
160
160
10
20
10
20
30
80
10
30
10
20
30
40
10
30
160
160
10
20
12
25
30
90
12
30
12
25
30
50
12
30
160
80
12
25
12
25
30
90
12
30
12
25
30
50
12
30
160
80
12
25
12
25
30
90
12
30
12
25
30
50
12
30
160
80
12
25
12
25
30
90
12
30
12
25
30
50
12
30
160
80
12
25
12
25
30
90
12
30
12
25
30
50
12
30
160
80
12
25
12
25
30
90
12
30
12
25
30
50
12
30
160
80
12
25
Budget Cost
Actual Cost
Month 1
Month 2
Month 3
Month 4
Month 5
Month 6
Month 1
$
1,000.00 $ 1,000.00 $ 1,000.00 $
1,000.00 $ 1,000.00 $ 1,000.00 $ 1,200.00
$
2,800.00 $ 2,800.00 $ 2,800.00 $
2,800.00 $ 2,800.00 $ 2,800.00 $ 2,800.00
$
3,000.00 $ 3,000.00 $ 3,000.00 $
3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00
$
2,100.00 $ 2,100.00 $ 2,100.00 $
2,100.00 $ 2,100.00 $ 2,100.00 $ 2,100.00
$ 12,600.00 $ 12,600.00 $ 12,600.00 $ 12,600.00 $ 12,600.00 $ 12,600.00 $ 14,400.00
$
500.00 $
500.00 $
500.00 $
500.00 $
500.00 $
500.00 $
500.00
$
2,100.00 $ 2,100.00 $ 2,100.00 $
2,100.00 $ 2,100.00 $ 2,100.00 $ 2,100.00
$
1,000.00 $ 1,000.00 $ 1,000.00 $
1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00
$
500.00 $
500.00 $
500.00 $
500.00 $
500.00 $
500.00 $
600.00
$
1,000.00 $ 1,000.00 $ 1,000.00 $
1,000.00 $ 1,000.00 $ 1,000.00 $ 1,200.00
$
3,000.00 $ 3,000.00 $ 3,000.00 $
3,000.00 $ 3,000.00 $ 3,000.00 $ 3,750.00
$
500.00 $
500.00 $
500.00 $
500.00 $
500.00 $
500.00 $
600.00
$
250.00 $
250.00 $
250.00 $
250.00 $
250.00 $
250.00 $
250.00
$
4,200.00 $ 4,200.00 $ 4,200.00 $
4,200.00 $ 4,200.00 $ 4,200.00 $ 4,200.00
$
5,600.00 $ 5,600.00 $ 5,600.00 $
5,600.00 $ 5,600.00 $ 5,600.00 $ 7,000.00
$
500.00 $
500.00 $
500.00 $
500.00 $
500.00 $
500.00 $
600.00
$
1,200.00 $ 1,200.00 $ 1,200.00 $
1,200.00 $ 1,200.00 $ 1,200.00 $ 1,500.00
$
5,600.00 $ 5,600.00 $ 5,600.00 $
5,600.00 $ 5,600.00 $ 5,600.00 $ 7,000.00
$
500.00 $
500.00 $
500.00 $
500.00 $
500.00 $
500.00 $
250.00
$
2,800.00 $ 2,800.00 $ 2,800.00 $
2,800.00 $ 2,800.00 $ 2,800.00 $ 2,800.00
$
6,000.00 $ 6,000.00 $ 6,000.00 $
6,000.00 $ 6,000.00 $ 6,000.00 $ 6,000.00
$
1,200.00 $ 1,200.00 $ 1,200.00 $
1,200.00 $ 1,200.00 $ 1,200.00 $ 1,500.00
$
8,400.00 $ 8,400.00 $ 8,400.00 $
8,400.00 $ 8,400.00 $ 8,400.00 $ 12,600.00
$
500.00 $
500.00 $
500.00 $
500.00 $
500.00 $
500.00 $
600.00
$
1,200.00 $ 1,200.00 $ 1,200.00 $
1,200.00 $ 1,200.00 $ 1,200.00 $ 1,500.00
$
1,500.00 $ 1,500.00 $ 1,500.00 $
1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00
$
500.00 $
500.00 $
500.00 $
500.00 $
500.00 $
500.00 $
600.00
$
5,600.00 $ 5,600.00 $ 5,600.00 $
5,600.00 $ 5,600.00 $ 5,600.00 $ 7,000.00
$
500.00 $
500.00 $
500.00 $
500.00 $
500.00 $
500.00 $
600.00
$
1,200.00 $ 1,200.00 $ 1,200.00 $
1,200.00 $ 1,200.00 $ 1,200.00 $ 1,500.00
$
5,600.00 $ 5,600.00 $ 5,600.00 $
5,600.00 $ 5,600.00 $ 5,600.00 $ 7,000.00
$
500.00 $
500.00 $
500.00 $
500.00 $
500.00 $
500.00 $
600.00
$
1,800.00 $ 1,800.00 $ 1,800.00 $
1,800.00 $ 1,800.00 $ 1,800.00 $ 1,350.00
$ 15,200.00 $ 15,200.00 $ 15,200.00 $ 15,200.00 $ 15,200.00 $ 15,200.00 $ 10,450.00
$
1,200.00 $ 1,200.00 $ 1,200.00 $
1,200.00 $ 1,200.00 $ 1,200.00 $ 1,500.00
$
3,600.00 $ 3,600.00 $ 3,600.00 $
3,600.00 $ 3,600.00 $ 3,600.00 $ 3,600.00
$
6,000.00 $ 6,000.00 $ 6,000.00 $
6,000.00 $ 6,000.00 $ 6,000.00 $ 6,000.00
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
500.00
1,200.00
3,600.00
6,000.00
500.00
3,600.00
500.00
1,200.00
3,600.00
2,000.00
500.00
3,600.00
7,200.00
14,080.00
500.00
1,200.00
$
500.00
$ 1,200.00
$ 3,600.00
$ 6,000.00
$
500.00
$ 3,600.00
$
500.00
$ 1,200.00
$ 3,600.00
$ 2,000.00
$
500.00
$ 3,600.00
$ 7,200.00
$ 14,080.00
$
500.00
$ 1,200.00
$
500.00 $
$ 1,200.00 $
$ 3,600.00 $
$ 6,000.00 $
$
500.00 $
$ 3,600.00 $
$
500.00 $
$ 1,200.00 $
$ 3,600.00 $
$ 2,000.00 $
$
500.00 $
$ 3,600.00 $
$ 7,200.00 $
$ 14,080.00 $
$
500.00 $
$ 1,200.00 $
500.00
1,200.00
3,600.00
6,000.00
500.00
3,600.00
500.00
1,200.00
3,600.00
2,000.00
500.00
3,600.00
7,200.00
14,080.00
500.00
1,200.00
$
500.00 $
500.00
$ 1,200.00 $ 1,200.00
$ 3,600.00 $ 3,600.00
$ 6,000.00 $ 6,000.00
$
500.00 $
500.00
$ 3,600.00 $ 3,600.00
$
500.00 $
500.00
$ 1,200.00 $ 1,200.00
$ 3,600.00 $ 3,600.00
$ 2,000.00 $ 2,000.00
$
500.00 $
500.00
$ 3,600.00 $ 3,600.00
$ 7,200.00 $ 7,200.00
$ 14,080.00 $ 14,080.00
$
500.00 $
500.00
$ 1,200.00 $ 1,200.00
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
600.00
1,500.00
3,600.00
6,750.00
600.00
3,600.00
600.00
1,500.00
3,600.00
2,500.00
600.00
3,600.00
7,200.00
7,040.00
600.00
1,500.00
Month 2
Month 3
Month 4
Month 5
Month 6
$
1,200.00 $
1,200.00 $
1,500.00 $
1,500.00 $ 1,500.00
$
2,800.00 $
2,800.00 $
3,150.00 $
3,150.00 $ 3,150.00
$
3,000.00 $
3,000.00 $
3,000.00 $
3,000.00 $ 3,000.00
$
2,100.00 $
2,100.00 $
2,100.00 $
2,100.00 $ 2,100.00
$ 14,400.00 $ 14,400.00 $
14,400.00 $ 14,400.00 $ 14,400.00
$
500.00 $
500.00 $
500.00 $
500.00 $
500.00
$
2,100.00 $
2,100.00 $
2,100.00 $
2,100.00 $ 2,100.00
$
1,000.00 $
1,000.00 $
1,000.00 $
1,000.00 $ 1,000.00
$
600.00 $
600.00 $
600.00 $
600.00 $
600.00
$
1,200.00 $
1,200.00 $
1,200.00 $
1,200.00 $ 1,200.00
$
3,750.00 $
3,750.00 $
3,750.00 $
3,750.00 $ 3,750.00
$
600.00 $
600.00 $
600.00 $
600.00 $
600.00
$
250.00 $
250.00 $
250.00 $
250.00 $
250.00
$
4,200.00 $
4,200.00 $
4,200.00 $
4,200.00 $ 4,200.00
$
7,000.00 $
7,000.00 $
3,500.00 $
3,500.00 $ 3,500.00
$
600.00 $
600.00 $
600.00 $
600.00 $
600.00
$
1,500.00 $
1,500.00 $
1,500.00 $
1,500.00 $ 1,500.00
$
7,000.00 $
7,000.00 $
3,500.00 $
3,500.00 $ 3,500.00
$
250.00 $
250.00 $
250.00 $
250.00 $
250.00
$
2,800.00 $
2,800.00 $
2,800.00 $
2,800.00 $ 2,800.00
$
6,000.00 $
6,000.00 $
6,000.00 $
6,000.00 $ 6,000.00
$
1,500.00 $
1,500.00 $
1,500.00 $
1,500.00 $ 1,500.00
$ 12,600.00 $ 12,600.00 $
12,600.00 $ 12,600.00 $ 12,600.00
$
600.00 $
600.00 $
600.00 $
600.00 $
600.00
$
1,500.00 $
1,500.00 $
1,500.00 $
1,500.00 $ 1,500.00
$
1,500.00 $
1,500.00 $
1,500.00 $
1,500.00 $ 1,500.00
$
600.00 $
600.00 $
600.00 $
600.00 $
600.00
$
7,000.00 $
7,000.00 $
3,500.00 $
3,500.00 $ 3,500.00
$
600.00 $
600.00 $
600.00 $
600.00 $
600.00
$
1,500.00 $
1,500.00 $
1,500.00 $
1,500.00 $ 1,500.00
$
7,000.00 $
7,000.00 $
3,500.00 $
3,500.00 $ 3,500.00
$
600.00 $
600.00 $
600.00 $
600.00 $
600.00
$
1,350.00 $
1,350.00 $
1,350.00 $
1,350.00 $ 1,350.00
$ 10,450.00 $ 10,450.00 $
10,450.00 $ 10,450.00 $ 10,450.00
$
1,500.00 $
1,500.00 $
1,500.00 $
1,500.00 $ 1,500.00
$
3,600.00 $
3,600.00 $
3,600.00 $
3,600.00 $ 3,600.00
$
6,000.00 $
6,000.00 $
6,000.00 $
6,000.00 $ 6,000.00
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
600.00
1,500.00
3,600.00
6,750.00
600.00
3,600.00
600.00
1,500.00
3,600.00
2,500.00
600.00
3,600.00
7,200.00
7,040.00
600.00
1,500.00
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
600.00
1,500.00
3,600.00
6,750.00
600.00
3,600.00
600.00
1,500.00
3,600.00
2,500.00
600.00
3,600.00
7,200.00
7,040.00
600.00
1,500.00
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
600.00
1,500.00
3,600.00
6,750.00
600.00
3,600.00
600.00
1,500.00
3,600.00
2,500.00
600.00
3,600.00
7,200.00
7,040.00
600.00
1,500.00
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
600.00
1,500.00
3,600.00
6,750.00
600.00
3,600.00
600.00
1,500.00
3,600.00
2,500.00
600.00
3,600.00
7,200.00
7,040.00
600.00
1,500.00
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
600.00
1,500.00
3,600.00
6,750.00
600.00
3,600.00
600.00
1,500.00
3,600.00
2,500.00
600.00
3,600.00
7,200.00
7,040.00
600.00
1,500.00

Purchase answer to see full
attachment

  
error: Content is protected !!