Question: Can you solve that in Google Sheets with the accurate answers? Thanks. Assessment #1 - Simple Project Accounting Please show your work for the questions

Can you solve that in Google Sheets with the accurate answers? Thanks.
Assessment \#1 - Simple Project Accounting Please show your work for the questions in a Google sheet. Outpost has a project that has a team of 5 contractors (from a vendor) assigned to it with the below allocations and hourly rates. Note, a regular work week is 40 hours, so someone at 100% allocation would work 40 hours a week. The project had a contract for 3 months (12 weeks). If all the contractors worked according to their allocation, did not take any work days off, and did not work any overtime, how much money should the project have cost at the end of the 3 months (12 weeks)? If the contract was originally booked for a total of $180,000, was the original contract total more or less than what was needed to pay the contractors for the time they worked during the three months? By how much was it short or over? If the project needs to be extended for another 3 months ( 12 weeks) but this time the Software Developer Lead will no longer be on the project (leaving just a team of 4), and it is assumed the contractors will not take any work days off and will not work any overtime - how much will the 3 month extension cost? If the overage or gap in funds from the first 3 months is to be applied to the extension, then how much should the 3 month extension actually cost
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
