Jsing Excel for Contract Transaction Pricing

PROBLEM

i Corp. enters into a contract with a customer to build an apartment building. The customer hopes to rent apartments at the beginning of the school year and offers a performance bonus to be paid if the building is ready for rental beginning August $1,2023.$ The bonus is reduced each week that completion is delayed.

$\backslash$table$[[$Contract amount,$$1,000,000$