Activity Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 A 10 30 40 20 60 30 30 B 30 30 30 C 40 30 10 However, after assessing the project's priority, the PMO has suggested that the allocation plan should be adjusted to conform to the following constraint table The table contains the weekly maximum and the activity week level maximum person hours constraints Activity Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 A 40 40 40 40 40 40 40 B 0 0 40 40 40 40 0 C 40 40 40 0 0 0 0 Maximum 60 60 60 60 60 60 60 (5 pts ) Please use the Excel Solver to update the allocation plan such that the weekly total person hours are smoothly allocated Please paste the updated allocation plan table in the space below (It will be Table B ) (5 pts ) What is the sum of squared value difference before and after the adjustment (3 pts ) What is the advantage of evenly distributed resource usage

The Answer is in the image, click to view ...

Question: Activity Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 A 10 30 40 20 60 30 30 B 30

Activity	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7
A	10	30	40	20	60	30	30
B			30	30	30
C	40	30	10

However, after assessing the project's priority, the PMO has suggested that the allocation plan should be adjusted to conform to the following constraint table. The table contains the weekly maximum and the activity-week level maximum person-hours constraints.

Activity	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7
A	40	40	40	40	40	40	40
B	0	0	40	40	40	40	0
C	40	40	40	0	0	0	0
Maximum	60	60	60	60	60	60	60

(5 pts.) Please use the Excel Solver to update the allocation plan such that the weekly total person-hours are smoothly allocated. Please paste the updated allocation plan table in the space below. (It will be Table B.)

(5 pts.) What is the sum of squared value difference before and after the adjustment?

(3 pts.) What is the advantage of evenly distributed resource usage?

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!

. Table A. Before Adjustment Activity Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 A 10 30 40 20 60 30 30 B 30 30 30 C 40 30 10 However, after assessing the project's priority, the PMO has...

Project Management The following details are from a project to develop a Digital Camera Activity Durations( weeks) Immediate Predecessor Total Planned Cost A- Design Specs B- Shell & Power C-...

You are the sponsor for project XY. The project manager has provided you the following three status reports. The project started on 2/1 and it is now the end of the 4th week. For this assignment,...

Project BT506 has six activities and a completion time of 8 weeks. The weekly budgeted cost (in $1000s) of the project is shown below. Weekly Budgeted Cost (in $1000s) Activity Week 1 Week 2 Week 3...

Project QA701 has seven activities and a completion time of 8 weeks. The weekly budgeted cost (in $1000s) of the project is shown below. Weekly Budgeted Cost (in $1000s) Activity Week 1 Week 2 Week 3...

2. (12) The baseline planned budget for a project has been scheduled on a weekly basis as follows Activity Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 A 10 10 B 12 12 12 C 8 8 8 D 10 10 E 11 Total per...

(12) The baseline planned budget for a project has been scheduled on a weekly basis as follows Activity Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 A 10 10 B 12 12 12 C 8 8 8 D 10 10 E 11 Total per...

Here are the number (in millions) of viewers of the 10 most-watched TV series finales: a. Construct a boxplot. b. Given that the distribution is unimodal, determine whether it is skewed left,...

What is the minimum number of shareholders a corporation must have?

Standard costs are not compared to actual amounts. Group of answer choices True False

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...