cost estimation

excel and as much math and detail shown for each step to show work, as well as understand the process. My document attached is the assignment and there is a diagram provided as well as the supplemental information necessary to answer the question