Answered step by step
Verified Expert Solution
Question
1 Approved Answer
[Must use Tableau] Using this table please create graphs for real cost per person, budget cost per person, and a comparison graph. Submit a dashboard
[Must use Tableau] Using this table please create graphs for real cost per person, budget cost per person, and a comparison graph. Submit a dashboard screenshot of this in Tableau.
\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Resource & Crystal & Erica & Gail & George & Inigo & Jenny & Jim & Larry & Monique & Sarah & Sondra & Stanley & Tom \\ \hline Budget Hours & 900 & 960 & 930 & 960 & 960 & 960 & 960 & 960 & 960 & 960 & 960 & 720 & 960 \\ \hline Actual Hours & 900 & 900 & 1026 & 1200 & 660 & 1020 & 1050 & 480 & 1200 & 1020 & 960 & 864 & 990 \\ \hline% Dif. & 0% & 6% & 10% & 25% & 31% & 6% & 9% & 50% & 25% & 6% & 0% & 20% & 3% \\ \hline Hourly Cost & 120 & 140 & 50 & 60 & 95 & 50 & 90 & 88 & 105 & 75 & 45 & 50 & 35 \\ \hline Total Real Cost & 108,000 & 126,000 & 51,300 & 72,000 & 62,700 & 51,000 & 94,500 & 42,240 & 126,000 & 76,500 & 43,200 & 43,200 & 34,650 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Resource & Crystal & Erica & Gail & George & Inigo & Jenny & Jim & Larry & Monique & Sarah & Sondra & Stanley & Tom \\ \hline Budget Hours & 900 & 960 & 930 & 960 & 960 & 960 & 960 & 960 & 960 & 960 & 960 & 720 & 960 \\ \hline Actual Hours & 900 & 900 & 1026 & 1200 & 660 & 1020 & 1050 & 480 & 1200 & 1020 & 960 & 864 & 990 \\ \hline% Dif. & 0% & 6% & 10% & 25% & 31% & 6% & 9% & 50% & 25% & 6% & 0% & 20% & 3% \\ \hline Hourly Cost & 120 & 140 & 50 & 60 & 95 & 50 & 90 & 88 & 105 & 75 & 45 & 50 & 35 \\ \hline Total Real Cost & 108,000 & 126,000 & 51,300 & 72,000 & 62,700 & 51,000 & 94,500 & 42,240 & 126,000 & 76,500 & 43,200 & 43,200 & 34,650 \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started