Ron Satter field's excavation company uses bothGantt scheduling charts and Gantt load charts.a) Today, which is the end of day 7, Ron is reviewing the Ganttchart depicting these schedules:• Job # 151 was scheduled to begin on day 3 and to ta ke6 days. As of now, it is I day ahead of schedule.• Job# 177 was scheduled to begin on day J and take 4 days.It is currently on time.• Job #1 79 was scheduled to start on day 7 and take 2 days. Itactually got started on day 6 and is progressing according toplan.• Job #211 was scheduled to begin on day 5, but missingequipment delayed it until day 6. It is progressing asexpected and should take 3 days.• Job #215 was scheduled to begin on day 4 and take 5 days.It got sta rted on time but has since fallen behind 2 days.Draw the Gantt scheduling chart for the activities described.b) Ron now wants to use a Ga ntt load chart to see how muchwork is scheduled in each of his three work teams: Able,Baker, and Charlie. Five jobs constitute the current workloadfor these three work teams: Job # 250, requiring 48 hours and#275 requiring 32 hours for Work Team Able; Jobs #210and #280, requiring J 6 and 24 hours, respectively, for TeamBaker; and Job # 225, requiring 40 hours, for Team Charlie.Prepare the Gantt load chart for these activities.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

Ron Satter field's excavation company uses both
Gantt scheduling charts and Gantt load charts.
a) Today, which is the end of day 7, Ron is reviewing the Gantt
chart depicting these schedules:
• Job # 151 was scheduled to begin on day 3 and to ta ke
6 days. As of now, it is I day ahead of schedule.
• Job# 177 was scheduled to begin on day J and take 4 days.
It is currently on time.
• Job #1 79 was scheduled to start on day 7 and take 2 days. It
actually got started on day 6 and is progressing according to
plan.
• Job #211 was scheduled to begin on day 5, but missing
equipment delayed it until day 6. It is progressing as
expected and should take 3 days.
• Job #215 was scheduled to begin on day 4 and take 5 days.
It got sta rted on time but has since fallen behind 2 days.
Draw the Gantt scheduling chart for the activities described.
b) Ron now wants to use a Ga ntt load chart to see how much
work is scheduled in each of his three work teams: Able,
Baker, and Charlie. Five jobs constitute the current workload
for these three work teams: Job # 250, requiring 48 hours and
#275 requiring 32 hours for Work Team Able; Jobs #210
and #280, requiring J 6 and 24 hours, respectively, for Team
Baker; and Job # 225, requiring 40 hours, for Team Charlie.
Prepare the Gantt load chart for these activities.

Expert Solution