A fictitious construction company was awarded four jobs in 2019. Each job only had five activities and they used the same unit prices for each job and are as follows: Concrete - $ 150/CY Steel - $1250/Ton Wood - $3/LF Roofing - $4.50/SF Windows - $250/EA The following table shows the quantities for each job Windows - EA 57 Job Name Swamps Brooks Springs Cricks Concrete - CY| Steel - Ton 100 25 250 20 50 565 125 125 Wood - LF 2500 500 45 125 Roofing - SF 10000 25000 26000 15000 28 50 75 Create an excel spreadsheet that calculates the total revenue the company earned in 2019. Each job will need to have 6% added for sales tax and then add 10% for profit and overhead. The file should have five separate tabs. Four of the tabs should calculate the revenue for each job and the fifth is a summary. Remember, you should not need to use a calculator to complete the assignment. That way if you need to change one of the values due to a mistake, the spreadsheet will automatically calculate the revised revenue. Also, the summary sheet should reference the cells from the job tabs. You will be graded on the A fictitious construction company was awarded four jobs in 2019. Each job only had five activities and they used the same unit prices for each job and are as follows: Concrete - $ 150/CY Steel - $1250/Ton Wood - $3/LF Roofing - $4.50/SF Windows - $250/EA The following table shows the quantities for each job Windows - EA 57 Job Name Swamps Brooks Springs Cricks Concrete - CY| Steel - Ton 100 25 250 20 50 565 125 125 Wood - LF 2500 500 45 125 Roofing - SF 10000 25000 26000 15000 28 50 75 Create an excel spreadsheet that calculates the total revenue the company earned in 2019. Each job will need to have 6% added for sales tax and then add 10% for profit and overhead. The file should have five separate tabs. Four of the tabs should calculate the revenue for each job and the fifth is a summary. Remember, you should not need to use a calculator to complete the assignment. That way if you need to change one of the values due to a mistake, the spreadsheet will automatically calculate the revised revenue. Also, the summary sheet should reference the cells from the job tabs. You will be graded on the