Forecasting Overtime Hours Required to Complete a Project

Hi all,

History: The Department I work for is converting its paper personnel files into electronic format.

Problem: We have 9000 files to prepare with an August 22 deadline. We are working in 6 hour shifts per workday. 6 hours/day; 5days/week. I need to predict the number of overtime hours we will need based on the number of files already complete, known hours remaining and known hours elapsed. We will continue the 6 hours/day in addition to the overtime. The project began June 12. Attached is the dataset I've compiled. The data is updated daily.

Here is the forecast formula I've used but it doesn't appear to be correct.

=FORECAST(C4,F4:F54,(IF(I4:I54>=1,I4:I54)))

Can someone please tell me where I'm going wrong?

Thank you

Pls check the attachment.

Forecast should be based on the number of hours...daily worked and Purged data daily...
It should not contain blank cells.

I have modified it...

Hope this is helpful..

Regards,
guru

That isn't exactly what I was looking for, but it did job my brain.
X = 9000
Known X = 60, 120, 214, 294 . . .(Total of files completed)
Known Y = 6, 12, 18, 24, 27 . . .(Total hours elapsed)

That gave me a total to complete the project. Subtract available (303) hours from the forecast hours (578) and that's what we need for overtime. Thanks for the slap to the back of the old brain housing group!!

Hi I am working on a file that would require an overtime forecast data with the following details

Outlet 1: 7:00-22:30 operation timing = 6 staffs
Outlet 2: 12:00-1:00 operation timing = 10 staffs
Outlet 3: 24 hours operation = 4 staffs
Outlet 4: Banquet operation (depend on # of events) = 9 staffs

How would I be able to forecast the required overtime in a month with these data?

Your help would be highly appreciated.


Thanks

Xeld