pieces produced at time intervals

[Zimmerman]

I need some hwlp trying to figure out a formula. Here's my problem.
I have a set time in which we start and a set amount of how many we should produce in a day. How do i figure out how many i should have done at any given hour? Say i start at 6:00 and i can produce 20 an hour and i have 50 to produce. At 7:00 i should have 20 done and at 8:00 i should have another 20 done the how do i figure out that at 8:30 i should be done and should start on my next set up.

Windows XP
Excel 2003

 

[Special-K99]

=required amount / rate per hour (HOURS) + start time

e.g. 50 / 20 = 2.5 HOURS + 6:00 = 8:30

 

[Zimmerman]

Ok so say i have 5 different items to produce in the same day. How would i figure out at what time each item should be started on? Say it takes me 15 minutes to do each set up. Each different item has a different amount that could be produced in an hour.