HW 4- All work must be completed in 1 excel file that, when necessary, includes cells that make calculations. 1) Information on a project's activities is shown in the following table: Activity Immediate Activity Time Total Predecessor (wks) Budgeted Cost 5e 25,000 Ae Be t 42 28,000 ce B2 12 16,000 De Ae 100 44,000 E 32 36,000 D, Ee 5e 50,000 D.Ee 4 80,000 He Ee 7 21,000 le Fe 5 36,000 je G, He 60,000 I, Je 32 30,000 L Le G, He 12 20,000 e a. Create a Gantt chart based on earliest start times. (20 pts) b. Create a budget cost chart, using earliest start times. (20 pts) 2) There are four jobs to be done and four machines with which to do them. Each resource will take a specific time, translated to operating costs, to do each job, as shown in the following table: 42 9 Jobe Ae Be ce De le $100 92 112 92 Machine 2e 13e 112 15e 9 3e 12e 12e 142 102 tttttt 12e a. What is the result of the row reduction? (10 pts) e b. What is the result of the column reduction? (10 pts) c. What is the result of modifying the row and column reductions table? (10 pts) d. What is the optimum assignment of jobs to machines? (5 pts) e. What is the total cost for the optimum assignment of jobs to machines? (5 pts) 3) Shoppers arrive at a retail store at an average of 10 per minute (Poisson) where the service rate is almost 207 per hour (Poisson). a. What is the average number of shoppers in the system with 3 cashiers? (10 pts) b. What is the minimum number of cashiers needed to keep the average time in the system under three minutes? (10 pts) HW 4- All work must be completed in 1 excel file that, when necessary, includes cells that make calculations. 1) Information on a project's activities is shown in the following table: Activity Immediate Activity Time Total Predecessor (wks) Budgeted Cost 5e 25,000 Ae Be t 42 28,000 ce B2 12 16,000 De Ae 100 44,000 E 32 36,000 D, Ee 5e 50,000 D.Ee 4 80,000 He Ee 7 21,000 le Fe 5 36,000 je G, He 60,000 I, Je 32 30,000 L Le G, He 12 20,000 e a. Create a Gantt chart based on earliest start times. (20 pts) b. Create a budget cost chart, using earliest start times. (20 pts) 2) There are four jobs to be done and four machines with which to do them. Each resource will take a specific time, translated to operating costs, to do each job, as shown in the following table: 42 9 Jobe Ae Be ce De le $100 92 112 92 Machine 2e 13e 112 15e 9 3e 12e 12e 142 102 tttttt 12e a. What is the result of the row reduction? (10 pts) e b. What is the result of the column reduction? (10 pts) c. What is the result of modifying the row and column reductions table? (10 pts) d. What is the optimum assignment of jobs to machines? (5 pts) e. What is the total cost for the optimum assignment of jobs to machines? (5 pts) 3) Shoppers arrive at a retail store at an average of 10 per minute (Poisson) where the service rate is almost 207 per hour (Poisson). a. What is the average number of shoppers in the system with 3 cashiers? (10 pts) b. What is the minimum number of cashiers needed to keep the average time in the system under three minutes? (10 pts)