Contractor Pay Per Day Begin Date Ending Date Limit Days Actual Days Used Gross Total Payment Late Penalty Adjusted Payment

Allan $$2,000\mathrm{.}0021-$May$-049-$Jul$-044050$ $$100,000\mathrm{.}00$

Allison $$500\mathrm{.}0024-$Apr$-0417-$Jun$-046055$ $$27,500\mathrm{.}00$

Amanda $$2,000\mathrm{.}0028-$May$-045-$Jul$-046039$ $$78,000\mathrm{.}00$

Audrey $$1,200\mathrm{.}0021-$Mar$-0416-$May$-044057$ $$68,400\mathrm{.}00$

Cassandra $$2,500\mathrm{.}0027-$May$-043-$Jul$-044038$ $$95,000\mathrm{.}00$

Clint $$700\mathrm{.}001-$Apr$-0424-$Apr$-046024$ $$16,800\mathrm{.}00$

Collin $$450\mathrm{.}0015-$Apr$-0416-$May$-046032$ $$14,400\mathrm{.}00$

Katie $$1,000\mathrm{.}0012-$Apr$-0415-$May$-043534$ $$34,000\mathrm{.}00$

Roy $$2,000\mathrm{.}0028-$Apr$-0425-$Jun$-046059$ $$118,000\mathrm{.}00$

Wesley $$400\mathrm{.}0026-$Mar$-0421-$May$-046057$ $$22,800\mathrm{.}00$

Weslie $$2,000\mathrm{.}002-$May$-0429-$May$-046028$ $$56,000\mathrm{.}00$

Westley $$3,700\mathrm{.}0017-$Mar$-042-$May$-044047$ $$173,900\mathrm{.}00$

Instructions

$1.$ In this scenario, each contractor promises to complete the job within a specific day $($i$.$e$.,$ Limit Days$).$ However, sometimes, the actual days $($i$.$e$.,$ Actual Days Used$)$ they use to complete the job is more or less than what they promise. When they finish the job late, we will charge them a Late Penalty. Use If Function in cell I$6$ to compute the "Late Penalty" which is equal to $$200$ per day for day that they are late.

$2.$ Enter the formula in cell J$6$ to compute Adjusted Payment, which is equal to the "Gross Total Payment" $-$ "Late Penalty"

$3.$ Using the fill$-$handle to copy the function$/$formula in cells I$6$ and J$6$ to compute late penalty and adjusted payment for all employees.

$4.$ Please note that typing the answer $($i$.$e$.,$ a number$)$ directly into the cells will be graded as incorrect answers$)$