Assume the following:

• Your company has been hired to paint two apartments - the owner is in a hurry to get them done by the first of the month, so that the tenants can move in and start paying rent. In order to achieve this goal the total project duration cannot exceed 18 days.
• The owner has offered a bonus to you if you get both done within 18 days. Your initial schedule is considerably longer than that.
• You have searched your work-force and found 3 painters and 3 laborers who can be assigned to the project, and all have indicated a willingness to work overtime. Due to a labor shortage you will notice in the Excel file that the current schedule is not possible as it currently requires you to have 4 painters at a time for several days and 4 laborers at a time for a few days. You must adjust the schedule so that you never exceed 3 painters and 3 laborers on any given day.
• Looking at the bonus, you conclude that it is worth investing up to 48 hours of overtime (6 man days) to assure that you get the bonus, which is worth twice the cost of the overtime.

Assume that the duration estimates for all tasks are based on 8 hours/day. If you add overtime to the project you should assume any hours over 8 per day for any individual are considered overtime.

Note: the numbers in the blue oells indicate the number laborers'and in'green' cells the number of painters' required per day for each task based an the original project schedule. To complete this assianment 'shift the blue and ereen cells to the left or right and adiost the 'mumber laborers or nainters in the blue and ereen' boxes to meet the 'rescorce coestraints' and 18 day schedule requarement To shift reo dng and adjuast the mbcts o RAGEL 'overtime hoursin vellow oells for cach day (totall aventime hours NOT Per Activity # (rog Activity Name Tatal Hours for each activity an Days (reduce length to 18 days (worker type) Regular 1 Remove Furniture Apt A 48 hours) (laborers) Tata Lbours mla Ouertit .2 8 hours Paint Ceilings Apt A (painters) Total hours Regular 4 Paint Walls Apt A 96 bours) (painters) mlsr KogL Sand & vamish floors Apt A 48 bours) Qaborer) Total hours Renlace furniture Apt A 7 48 hours) (laborers) Total hours Resular 8 Remove Fumiture Apt B (laborens) (48 hours) Total hours kealar 4- Paint Ceilings Apt B (48 hours) (painters) Total hours Regular Paint Walls Apt H (painters) 11 Tota bour 96 bouns) ular 12 Sand & vamish floars Apt B (aborur) bours) Tatal hours Regular 14 Replace furniture Apt B Overtime 8 hours) (laborers) These numbers below in green and blue are Days Number of workers each day (auto totalled) 36 Tatal 'reaular davs for lahorurs is auto calculated for alne l Overtime naint laberen is overtime total er This overtime tntal mumber is auto calculated Taigl Yourantime days for painters Total Overtimes This overtime total mumber is auto caleulated and shonld not exomed hours tal 'regular and overtime days for painters (this is auto calculated and sbould cqual 36 days) tal 'regular and lovertime days for labarers (this is auto calculated and should equal 36 days) d overtime to reduce the dumtion, add a breas between tasks, ete. This assignment amay requre you to: shift some tasks to the right dd more workers to spocilie tasks to roduce the duration, urs For ench apar Remyine feminure takes 3 28 hours= e (neole* hourr lea davs43 h would takes 2 days (3 people*8 hoursay 2 days- each apartment following t Faint celings takes 238- 48 hours) Sand and vash floers takes 168 boura 2 days (3 people * 8 hoursday 2 dayu -- 48 hours; dour ( nooplo hours eav days a Replace faraiture talkes: 2*3 8- 43 Note: the numbers in the blue oells indicate the number laborers'and in'green' cells the number of painters' required per day for each task based an the original project schedule. To complete this assianment 'shift the blue and ereen cells to the left or right and adiost the 'mumber laborers or nainters in the blue and ereen' boxes to meet the 'rescorce coestraints' and 18 day schedule requarement To shift reo dng and adjuast the mbcts o RAGEL 'overtime hoursin vellow oells for cach day (totall aventime hours NOT Per Activity # (rog Activity Name Tatal Hours for each activity an Days (reduce length to 18 days (worker type) Regular 1 Remove Furniture Apt A 48 hours) (laborers) Tata Lbours mla Ouertit .2 8 hours Paint Ceilings Apt A (painters) Total hours Regular 4 Paint Walls Apt A 96 bours) (painters) mlsr KogL Sand & vamish floors Apt A 48 bours) Qaborer) Total hours Renlace furniture Apt A 7 48 hours) (laborers) Total hours Resular 8 Remove Fumiture Apt B (laborens) (48 hours) Total hours kealar 4- Paint Ceilings Apt B (48 hours) (painters) Total hours Regular Paint Walls Apt H (painters) 11 Tota bour 96 bouns) ular 12 Sand & vamish floars Apt B (aborur) bours) Tatal hours Regular 14 Replace furniture Apt B Overtime 8 hours) (laborers) These numbers below in green and blue are Days Number of workers each day (auto totalled) 36 Tatal 'reaular davs for lahorurs is auto calculated for alne l Overtime naint laberen is overtime total er This overtime tntal mumber is auto calculated Taigl Yourantime days for painters Total Overtimes This overtime total mumber is auto caleulated and shonld not exomed hours tal 'regular and overtime days for painters (this is auto calculated and sbould cqual 36 days) tal 'regular and lovertime days for labarers (this is auto calculated and should equal 36 days) d overtime to reduce the dumtion, add a breas between tasks, ete. This assignment amay requre you to: shift some tasks to the right dd more workers to spocilie tasks to roduce the duration, urs For ench apar Remyine feminure takes 3 28 hours= e (neole* hourr lea davs43 h would takes 2 days (3 people*8 hoursay 2 days- each apartment following t Faint celings takes 238- 48 hours) Sand and vash floers takes 168 boura 2 days (3 people * 8 hoursday 2 dayu -- 48 hours; dour ( nooplo hours eav days a Replace faraiture talkes: 2*3 8- 43