2. Using the figure below and the attached Excel file, perform resource-limited scheduling. 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. Within each apartment, the sequence of tasks is required to be as shown, for example, the walls in apartment A cannot begin to be painted until the ceiling is completed and dried to allow taping the edges of the ceiling. Painters can only paint and laborers can only move furniture, sand, and varnish floors. It is possible to increase the number of resources of a particular skill above what i indicated in the figure below to accelerate any task. However, keep in mind that you only have 3 painters and 3 laborers that can work on any given day. For example, the figure below indicates that it takes 2 painters 6 days to paint the walls of apartment A (2 painters * 6 days * 8 hours/day = 96 hours). You can add another painter to this task to shorten the duration to 4 days (3 painters * 4 days * 8 hours/day = 96 hours). If you need to shorten it further you need to add overtime hours. For example, If you added all of your available overtime hours to painting the walls in apartment A you could reduce it to 2 days (3 painters * 2 days * 8 hours/day = 48 hours plus 48 hours of overtime = 96 hours). You would adjust the excel sheet to indicate 3 painters; reduce the number of days; and then add 48 in the yellow cell for overtime. (This is just an example, it is not part of the answer ~). If you add overtime hours to a task please indicate that in the excel file for each task (add the number of 'overtime man hours' used for each task in the yellow highlighted cells out from each task) and at the bottom of the sheet indicate the total number of overtime hours across the project Use the Excel file provided in the assignment on Canvas to complete this question. You can cut and paste a task to move it around within the file to change the start date and you can add resources to a task to shorten the duration. Do this by adjusting the number in each cell. The excel file is setup to add down a column so that you can see how many people total you are using (see Totals). However for the total number of painters and laborers you will have to add those on your own (see orange shaded cells). Be sure to update these cells based on your final solution. Remember that you cannot use more than 3 painters at a time or 3 laborers at a time. Remove furniture 2 days/3 laborers in apartment A Paint ceiling of apartment A 3 days/2 painters Allow 1 day for ceiling to dry in apartment A Paint walls of apartment A-6 days/ 2 painters Sand & varnish Allow 2 days for hardwood floors 6 floors to dry/ days/1 laborers harden Replace furniture 3 days/ 2 laborers Start Project Finish Project Remove furniture 2 days/3 laborers in apartment B Paint ceiling of apartment B 3 days/2 painters Allow 1 day for ceiling to dry in apartment B Paint walls of apartment B - 6 days/ 2 painters Sand & varnish Allow 2 days for hardwood floors 6 floors to dry/ days/1 laborers harden Replace furniture 3 days/ 2 laborers AD AE AF AG AH AJ AJ AK D EFGHIJKLMNOPQRSTUVWX Y Z AA AB AC Note: the numbers in the 'blue' cells indicate the number of labores and in 'green' cells the number of painters' required per day for each task based on the original project Schedule. To complete this assignment shift the blue and peen cells to the left or right and adjust the number of laborers or painters' in the blue and peen' boxes to meet the resource constraints and 18 day schedule requirement. To'shift resources please adjust the cell shading and adjust the numbers in columns E-AA only, This spreadsheet auto calculates numbers in various lares. Do NOT add columne arme SCROW DO I SEE AMI PAGE Activity #freq. Enter 'overtime hours' in yellow cells for each day total overtime hours NOT per peson Activity Name hours to Days reduce length to 18 days) worker type) Total Hours for each activity complete 1234567B9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Regular 48 1 Remove Fumiture Apt A (laborers Overtime ) 0 [48 hours) Tot hour 28 2 Paint Ceilings Apt A REGUT Overtime: 148 hours) (painters U Tal hours: 48 TR NEUIG Paint Walls Apt A 90 Overtime: 0 196 hours) painters) Total houn 96 5 Sand & vamish floors Apt A Overtime: [48 hours) laborer) 0 Total hours 48 TE 4 7 (48 houn) 0 48 48 0 48 28 -- 8 148 hours) ) 9 148 hours) IU 11 196 hours) JUDI LI Replace fumiture Apt A (laborers) Overtime: Tot hours! TRU Remove Fumiture Apt B (laborers) Overtime: Total hours: Paint Ceilines Apt B Regu Overume: (painters) Tothous: na cong Paint Walls Apt B CREDIE Overtime (painters Total hours: Sand & vamish floor Apt B Kegular Overtime: laborer) for hours DRY na Regular Replace fumiture Apt B laborer) Owertime : Tot hours: UDI 12 148 hours) 13 14 48 hours) na - 96 0 90 28 a 18 na 28 a 40 DOLU These numbers below in green and blue are auto clculated and should not exceed 3' In any cell. (Project must be finished in 18 days! D 12345 Number of workers each day (auto totalled) Painten 00444 04444440 0 0 0 0 0 0 0 0 0 0 Labores 6 6 0 0 0 0 0 0 0 0 0 0 2 2 2 0 0 4 4 4 Total Overtime for painters This overtime total number is auto calculated for painters Total Overtime for laborers: This overtime total number is auto calculated for laborers Tot Overtime This overtime total number is auto calculated and should not exceed 48 hours 36 Total 'regular' days for painters 36 Total 'regular' days for labores Total 'overtime' days for painter Total 'avertime' days for painters 30 Total 'regular' and 'overtime' days for painters (this is auto calculated and should equal 36 days) 36 Total regular and overtime' days for laborers (this is auto calculated and should equal 36 days) 48 This assignment may require you to: shift some tasks to the right, add more workers to specific tasks to reduce the duration, add overtime to reduce the duration, add a break between tasks, etc For each apartment Hours This means if 3 people were working on each task it would take the following for each apartment: Removing fumiture takes 3+2+8 hours = 2 days (3 people 8 hours/day 2 days = 48 hours) Paint ceing takes 238 48 2 days 3 people 8 hours/day> days -48 hours Paint walls takes 29608 96 4 days (3 people 8 hours/day days = 96 hours) Sand and varnish floors takes 1958 48 2 days 3 people 8 hours/day*2 days = 48 hours) Replace furniture takes: 238 48 2 days 3 people 8 hours/day 2 days = 48 hours 2. Using the figure below and the attached Excel file, perform resource-limited scheduling. 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. Within each apartment, the sequence of tasks is required to be as shown, for example, the walls in apartment A cannot begin to be painted until the ceiling is completed and dried to allow taping the edges of the ceiling. Painters can only paint and laborers can only move furniture, sand, and varnish floors. It is possible to increase the number of resources of a particular skill above what i indicated in the figure below to accelerate any task. However, keep in mind that you only have 3 painters and 3 laborers that can work on any given day. For example, the figure below indicates that it takes 2 painters 6 days to paint the walls of apartment A (2 painters * 6 days * 8 hours/day = 96 hours). You can add another painter to this task to shorten the duration to 4 days (3 painters * 4 days * 8 hours/day = 96 hours). If you need to shorten it further you need to add overtime hours. For example, If you added all of your available overtime hours to painting the walls in apartment A you could reduce it to 2 days (3 painters * 2 days * 8 hours/day = 48 hours plus 48 hours of overtime = 96 hours). You would adjust the excel sheet to indicate 3 painters; reduce the number of days; and then add 48 in the yellow cell for overtime. (This is just an example, it is not part of the answer ~). If you add overtime hours to a task please indicate that in the excel file for each task (add the number of 'overtime man hours' used for each task in the yellow highlighted cells out from each task) and at the bottom of the sheet indicate the total number of overtime hours across the project Use the Excel file provided in the assignment on Canvas to complete this question. You can cut and paste a task to move it around within the file to change the start date and you can add resources to a task to shorten the duration. Do this by adjusting the number in each cell. The excel file is setup to add down a column so that you can see how many people total you are using (see Totals). However for the total number of painters and laborers you will have to add those on your own (see orange shaded cells). Be sure to update these cells based on your final solution. Remember that you cannot use more than 3 painters at a time or 3 laborers at a time. Remove furniture 2 days/3 laborers in apartment A Paint ceiling of apartment A 3 days/2 painters Allow 1 day for ceiling to dry in apartment A Paint walls of apartment A-6 days/ 2 painters Sand & varnish Allow 2 days for hardwood floors 6 floors to dry/ days/1 laborers harden Replace furniture 3 days/ 2 laborers Start Project Finish Project Remove furniture 2 days/3 laborers in apartment B Paint ceiling of apartment B 3 days/2 painters Allow 1 day for ceiling to dry in apartment B Paint walls of apartment B - 6 days/ 2 painters Sand & varnish Allow 2 days for hardwood floors 6 floors to dry/ days/1 laborers harden Replace furniture 3 days/ 2 laborers AD AE AF AG AH AJ AJ AK D EFGHIJKLMNOPQRSTUVWX Y Z AA AB AC Note: the numbers in the 'blue' cells indicate the number of labores and in 'green' cells the number of painters' required per day for each task based on the original project Schedule. To complete this assignment shift the blue and peen cells to the left or right and adjust the number of laborers or painters' in the blue and peen' boxes to meet the resource constraints and 18 day schedule requirement. To'shift resources please adjust the cell shading and adjust the numbers in columns E-AA only, This spreadsheet auto calculates numbers in various lares. Do NOT add columne arme SCROW DO I SEE AMI PAGE Activity #freq. Enter 'overtime hours' in yellow cells for each day total overtime hours NOT per peson Activity Name hours to Days reduce length to 18 days) worker type) Total Hours for each activity complete 1234567B9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Regular 48 1 Remove Fumiture Apt A (laborers Overtime ) 0 [48 hours) Tot hour 28 2 Paint Ceilings Apt A REGUT Overtime: 148 hours) (painters U Tal hours: 48 TR NEUIG Paint Walls Apt A 90 Overtime: 0 196 hours) painters) Total houn 96 5 Sand & vamish floors Apt A Overtime: [48 hours) laborer) 0 Total hours 48 TE 4 7 (48 houn) 0 48 48 0 48 28 -- 8 148 hours) ) 9 148 hours) IU 11 196 hours) JUDI LI Replace fumiture Apt A (laborers) Overtime: Tot hours! TRU Remove Fumiture Apt B (laborers) Overtime: Total hours: Paint Ceilines Apt B Regu Overume: (painters) Tothous: na cong Paint Walls Apt B CREDIE Overtime (painters Total hours: Sand & vamish floor Apt B Kegular Overtime: laborer) for hours DRY na Regular Replace fumiture Apt B laborer) Owertime : Tot hours: UDI 12 148 hours) 13 14 48 hours) na - 96 0 90 28 a 18 na 28 a 40 DOLU These numbers below in green and blue are auto clculated and should not exceed 3' In any cell. (Project must be finished in 18 days! D 12345 Number of workers each day (auto totalled) Painten 00444 04444440 0 0 0 0 0 0 0 0 0 0 Labores 6 6 0 0 0 0 0 0 0 0 0 0 2 2 2 0 0 4 4 4 Total Overtime for painters This overtime total number is auto calculated for painters Total Overtime for laborers: This overtime total number is auto calculated for laborers Tot Overtime This overtime total number is auto calculated and should not exceed 48 hours 36 Total 'regular' days for painters 36 Total 'regular' days for labores Total 'overtime' days for painter Total 'avertime' days for painters 30 Total 'regular' and 'overtime' days for painters (this is auto calculated and should equal 36 days) 36 Total regular and overtime' days for laborers (this is auto calculated and should equal 36 days) 48 This assignment may require you to: shift some tasks to the right, add more workers to specific tasks to reduce the duration, add overtime to reduce the duration, add a break between tasks, etc For each apartment Hours This means if 3 people were working on each task it would take the following for each apartment: Removing fumiture takes 3+2+8 hours = 2 days (3 people 8 hours/day 2 days = 48 hours) Paint ceing takes 238 48 2 days 3 people 8 hours/day> days -48 hours Paint walls takes 29608 96 4 days (3 people 8 hours/day days = 96 hours) Sand and varnish floors takes 1958 48 2 days 3 people 8 hours/day*2 days = 48 hours) Replace furniture takes: 238 48 2 days 3 people 8 hours/day 2 days = 48 hours