Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

[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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbook Of Quantitative Finance And Risk Management

Authors: Cheng-Few Lee, John Lee

2010th Edition

0387771166, 978-0387771168

More Books

Students also viewed these Finance questions