.

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 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

1. (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.)
2. (5 pts.) What is the sum of squared value difference before and after the adjustment?
3. (3 pts.) What is the advantage of evenly distributed resource usage?

Hint: Table A does not have the weekly total included. It is also necessary to calculate the activity level total to configure the Solver correctly. To calculate the sum of squared (ss) value difference, the ss for both tables (Table A and B) should be calculated first. The ss difference will tell us how much variability has reduced due to the adjustment. The Solver will likely return non-integer values for the solution. If you know how to specify integer constraints from Solver, you may do so. Otherwise, you can just use the non-integer solution.

Please provide your answers in the space below. Please number each answer correctly.