Question: a. Create a project schedule in MS Excel ensuring that it reflects the predecessor/successor relationships identified in the table. b. How long will it take

a. Create a project schedule in MS Excel ensuring that it reflects the predecessor/successor relationships identified in the table.

b. How long will it take to complete the project?

c. Joan and Alcides are not fully dedicated to the project. Joan is only available for 4 hours each day, and Alcides is available for 6 hours per day. The original estimated duration (in 8-hour days) results in over-allocation of Joan and Alcides. Prepare a resource-leveled project schedule in MS Excel. How long will it take to complete the project in a resource-leveled environment?

Using the data below

Activity ID	Activity	Immediate Predecessor	Duration in days	Resource	Work Hours per Day
A	Evaluate freezers		2	Alcides	6
B	Chart temperatures		6	Joan	4
C	Review service record		2	Alcides
D	Consult with HVAC engineer	A, B, C	3	Alcides
E	Develop construction plan	D	10	Joan
F	Complete IC assignment	E	2	Alcides
G	Complete ROI analysis	E	5	Joan
H	Conduct regulatory review	E	4	Joan
I	Obtain construction approval	F, G, H	2	Alcides

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Using the data below (Assume normal workday =8 hours / day & normal workweek =40 hours / week) a. Create a project schedule in MS Excel ensuring that it reflects the predecessor/successor...

Part 3 Resource Leveling (40 points) Using the data below (Assume normal workday =8 hours / day \& normal workweek =40 hours/week) a. Create a project schedule in MS Excel ensuring that it reflects...

a. Create a project schedule in MS Excel ensuring that it reflects the predecessor/successor relationships identified in the table. b. How long will it take to complete the project? c. Joan and...

Assessment 1 - Context This assessment requires that you play the role of the project manager of a team assigned to develop a new product. You will be preparing for 2 separate meetings with the...

Here is the Activity Network Project Schedule for the Employee Training Management System project, including task relationships, durations, start dates, and end dates: Task ID Task Name...

At the end of the assignment, you will be submitting the following: Part 1: (30 points) MS Project File labeled Baseline Baseline questions: 1. When is the project estimated to be completed? 2. How...

USE MS PROJECT 1. Project A Company specializes in developing and selling a wide range of high-quality scooters. Sales representatives report that there is a growing demand for racing scooters. The...

Introduction Solar energy is a huge resource with the scope to power all of the worlds electricity generation. Pilot schemes elsewhere (particularly the USA and Spain) have proven the technology of...

Below is information about a project to implement a new manufacturing cell to assemble personal digital assistant devices Duration Predecessors ES EF LS LF Total Slack 2 4 A 1 B Activity A. Design...

Several stocks, such as Brinker International and Nathan's Famous, list "NA" for Price/Book ratio. Can you venture a guess as to why? Ticker Name TXRH Texas Roadhouse YUM YUM! Brands DRI Darden...

Question 2 Sheldon Cooper and Leonard Howard are partners in a partnership and they share in profits and losses as follows: Sheldon Cooper: 70% Leonard Howard: 30% The Bookkeeper has prepared and...

Under the provisions of the electronic transactions and recording acts, which statement would NOTbe accurate?

objective 2 : To examine whether respondents do have positive perceptions about Sumo Salad RQ.2: Do respondents think Sumo Salad is tasty? (One sample t-test of Q1.2) AutoSave O OFF 1 0 6 ... 3...