Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Start Date 12/28/20 begin{tabular}{|cc|c|} hline Project Phase & Days of Work Start Date Day of Week hline 1 3 & 8 hline 2

image text in transcribed
image text in transcribed
image text in transcribed
Start Date 12/28/20 \begin{tabular}{|cc|c|} \hline Project Phase & Days of Work Start Date Day of Week \\ \hline 1 3 & 8 \\ \hline 2 & 16 \\ \hline 3 & 6 \\ \hline 4 & 5 \\ 5 & 6 \\ 6 & 6 \\ 7 & 19 \\ 8 & 17 \\ \hline 9 & 21 \\ 10 & 25 \\ 11 & 4 \\ 12 & 8 \\ 13 & 20 & \\ \hline 14 & 18 & \\ \hline 15 & 6 & \\ 16 & 11 & \\ 17 & 17 & \\ \hline 18 & 9 & \\ \hline 19 & 12 & \\ 20 & 6 & \\ \hline \end{tabular} \begin{tabular}{|cl|} \hline The 10 Federal Holidays in 2021 \\ \hline 1/1/21 & New Year's Day \\ 1/18/21 & Martin Luther King Jr. Day \\ 2/15/21 & President's Day \\ 5/31/21 & Memorial Day \\ 7/4/21 & Independence Day \\ 9/6/21 & Labor Day \\ 10/11/21 & Columbus Day \\ 11/11/21 & Veterans Day \\ 11/25/21 & Thanksgiving Day \\ 12/25/21 & Christmas Day \\ \hline \end{tabular} Complete the table on the Next20WorkDays worksheet to calculate the start dates for the various phases of the project. Refer to "The 10 Federal Holidays in 2021" table when needed to determine when there are work holidays. 5.1) Calculate the start date for the project. a. Place your calculation in cell b. The start date for the project is the start date in cell (D2) unless the start date falls on a weekend (Saturday or Sunday) in which case if will be the next workday. (5.2) Calculate the start dates for the remaining phases of the project. a. Place your calculation for project Phase 2 in cell b. Use the WORKDAY function. c. References the start date and days of work values for the previous project phase in your calculation. d. Account for any holidays that might fall during the project. e. Reuse your formula to calculate the start date for the remaining project phases. (5.3) Calculate the day of the week for each of the project phase start dates. a. Place your calculation for the first project phase in cell E5. b. Use the CHOOSE function. c. In the same formula, use the WEEKDAY function to calculate the day of the week for the project phase 1 start date as the first argument of the CHOOSE function. d. Use "Sun", "Mon", "Tue", "Wed", "Thur", "Fri", and "Sat" as the names of the days. e. Reuse your formula to calculate the day of the week for the remaining project phase start dates

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Driven Web Sites

Authors: Mike Morrison, Joline Morrison

1st Edition

061901556X, 978-0619015565

More Books

Students also viewed these Databases questions

Question

What are the challenges associated with tunneling in urban areas?

Answered: 1 week ago

Question

What are the main differences between rigid and flexible pavements?

Answered: 1 week ago

Question

What is the purpose of a retaining wall, and how is it designed?

Answered: 1 week ago

Question

How do you determine the load-bearing capacity of a soil?

Answered: 1 week ago

Question

what is Edward Lemieux effect / Anomeric effect ?

Answered: 1 week ago