fastergcwanted said:
I think if we have case breakdown by year/month for all 250,000 cases (including RIR/NON-RIR/Regional/SWA all of them-remember initial analysis done by Zany only included regional cases), we probably can estimate approximate time assuming 200 analyst working on 250,000 cases. I need help from JustWatching, Icarus, Zany_Brainy, gp111 and other gurus to get to that. Thanks in advance.
Let me start with... this information does not exist...yet.
Here is a suggestion though....
1) Let's focus on RIR for now.
2) Before the whole BPC thing, this was the following status:
SWA processing 2004:
Illinois, Wisconsin, New Mexico, New Hampshire, Alabama, Harrisburg, Georgia, Guam, Ohio, Philadelphia, Iowa, South Dakota, Missouri, North Dakota, Wyoming, Florida, Tennessee, Pittsburgh, Louisiana, Minnesota, Rhode Island, South Carolina, Kansas, Idaho, North Carolina, Vermont, Montana, Kentucky, Mississippi, Nebraska, Maine, West Virginia, Arizona
SWA processing 2003:
Hawaii, Alaska, Connecticut, Oregon, Virginia, Michigan, Massachusetts, Delaware, Texas, Nevada, Utah, California.
SWA processing 2002:
Maryland, New Jersey, Washington, Oklahoma, Colorado
SWA processing 2001:
DC, Indiana, Arkansas, New York
3)
Zany, using the Access databases get me the following info:
# of Washington DC RIR cases with PD January 2001
# of Indiana RIR cases with PD January 2001
# of Arkansas RIR cases with PD May 2001
# of New York RIR cases with PD June 2001
This should give us an average number of cases each of these SWAs got in a normal month. If you want to do additional numbers to validate the average that would be even better.
4) Do the math:
# of Washington DC cases per month X 8 +
# of Indiana cases per month X 8 +
# of Arkansas cases per month X 6 +
# of New York cases per month X 3 =
# number of 2001 RIR cases in SWA
We would then do the same for 2002, 2003 and 2004 SWAs.