Scribd
Upload
43 views3 pages

Calender Formula 2

This Gantt chart schedules 5 jobs over a 2 week period, recognizing that the first job may not start at the beginning of the first day. It shows the start and end times of each job, along with set-up times, production rates, and total hours. The first job runs from 10:00 AM to 12:00 PM on the first day and takes 0.375 hours to complete.

Uploaded by

sahilsahni20
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
43 views3 pages

Calender Formula 2

This Gantt chart schedules 5 jobs over a 2 week period, recognizing that the first job may not start at the beginning of the first day. It shows the start and end times of each job, along with set-up times, production rates, and total hours. The first job runs from 10:00 AM to 12:00 PM on the first day and takes 0.375 hours to complete.

Uploaded by

sahilsahni20
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Applying Calendar Formula 2

Here is the Gantt Chart from Section 17 again, but this time it recognises that the first job may not start at the beginning of the f

Start of first job: 14/3 10:00 AM 14/3 12:00 AM 0.375

Calc 4 Calc 5 Calc 6


6 0.375 7

Set-up Units per Run Total


W/C Seq Product Qty hours hour hours Hours Start hr Stop hr
2.00
2 1 Prod D 650 0.00 110 5.91 5.91 2.00 7.91
2 2 Prod B 1200 4.50 105 11.43 15.93 12.41 23.84
2 3 Prod A 2350 4.25 140 16.79 21.04 28.09 44.87
2 4 Prod B 300 1.25 105 2.86 4.11 46.12 48.98
2 5 Prod C 4500 1.75 135 33.33 35.08 50.73 84.06
not start at the beginning of the first day.

0 9 18 27 35 35 35 44 53 62

14/3 15/3 16/3 17/3 18/3 19/3 20/3 21/3 22/3 23/3
Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu

9 9 9 8 0 0 9 9 9 9

650
587 613
968 0 0 1260 122
300
306 1215 1215
71 79 79 79 88

24/3 25/3 26/3 27/3 28/3


Fri Sat Sun Mon

8 0 0 9

1080 0 0 684

You might also like