Forecasting & Inventory Worksheet
Distributor
021000--AK, SEATTLE
010380--AL, ANNISTON
010385--AL, ATTALLA
010760--AL, BIRMINGHAM
012280--AL, DOTHAN
013040--AL, HUNTSVILLE
015320--AL, MOBILE
016085--AL, MOBILE
016080--AL, MONTGOMERY
016460--AL, MUSCLE SHOALS
016840--AL, OPELIKA
016845--AL, PHENIX CITY
019120--AL, TUSCALOOSA
040300--AR, BLYTHEVILLE
040600--AR, FAYETTEVILLE
040700--AR, FT. SMITH
040800--AR, HOT SPRINGS
040900--AR, LITTLE ROCK
047000--AR, NEWPORT
045400--AR, PINE BLUFF
043000--AR, TEXARKANA
049300--AR, WEST MEMPHIS
031600--AZ, FLAGSTAFF
032400--AZ, GLENDALE
034005--AZ, GLOBE
035200--AZ, KINGMAN
036400--AZ, PHOENIX
037200--AZ, PRESCOTT
034000--AZ, SHOW LOW
038800--AZ, TUCSON
039600--AZ, YUMA
057800--CA, ANAHEIM
051500--CA, ANTIOCH
050600--CA, BAKERSFIELD
050750--CA, BARSTOW
051050--CA, BISHOP
058400--CA, CAMARILLO
058858--CA, CHICO
051900--CA, EL MONTE
051950--CA, EUREKA
052200--CA, FRESNO
052450--CA, HEMET
052700--CA, IMPERIAL
052750--CA, INDIO
053000--CA, LANCASTER
053500--CA, LOS ANGELES
053900--CA, MODESTO
051650--CA, MONTCLAIR
054050--CA, NAPA
056450--CA, NOVATO
054360--CA, OAKLAND
054800--CA, REDDING
055100--CA, REDWOOD CITY
057805--CA, SAN BERNARDINO
052850--CA, SAN DIEGO
056000--CA, SAN FRANCISCO
056300--CA, SAN JOSE
056600--CA, SANTA BARBARA
056900--CA, SANTA MARIA
057350--CA, SONORA
057500--CA, STOCKTON
057650--CA, SUSANVILLE
058855--CA, TRUCKEE
054057--CA, UKIAH
058250--CA, VAN NUYS
058550--CA, VISALIA
056750--CA, WATSONVILLE
058700--CA, WEED
058850--CA, WEST SACRAMENTO
060500--CO, ALAMOSA
061500--CO, COLORADO SPGS
062250--CO, DENVER
062500--CO, DURANGO
062255--CO, GLENWOOD SPRINGS
065500--CO, GRAND JUNCTION
067000--CO, LA JUNTA
067500--CO, LEADVILLE
066000--CO, LOVELAND
065505--CO, MONTROSE
062000--CO, STEAMBOAT SPRINGS
069000--CO, STERLING
072400--CT, EAST HARTFORD
071700--CT, GOSHEN
074800--CT, NEW LONDON
071200--CT, WEST HAVEN
073600--CT, YALESVILLE
091900--DC, WASHINGTON
092000--DC, WASHINGTON
089005--DE, DOVER
089000--DE, WILMINGTON
105946--FL, AUBURNDALE
101980--FL, FT. MYERS
104626--FL, FT. PIERCE
103300--FL, JACKSONVILLE
104620--FL, MIAMI
105280--FL, OCALA
105940--FL, ORLANDO
101320--FL, ORMOND BEACH
106600--FL, PANAMA CITY
107260--FL, PENSACOLA
104625--FL, POMPANO BEACH
105945--FL, ROCKLEDGE
108580--FL, SARASOTA
107590--FL, ST. AUGUSTINE
105286--FL, TALLAHASSEE
109900--FL, TAMPA
110410--GA, ALBANY
110830--GA, ATHENS
112490--GA, ATLANTA
112600--GA, AUGUSTA
112900--GA, BRUNSWICK
113320--GA, COLUMBUS
114980--GA, LAGRANGE
115810--GA, MACON
117000--GA, ROME
117470--GA, SAVANNAH
112906--GA, VIDALIA
125005--HI, HILO
125000--HI, HONOLULU
125008--HI, KAILUA KONA
125007--HI, KAUAI
125006--HI, WAILUKU
160800--IA, AMES
169600--IA, CALMAR
162400--IA, CEDAR RAPIDS
163200--IA, COUNCIL BLUFFS
164000--IA, DAVENPORT
164800--IA, DES MOINES
166400--IA, MASON CITY
166800--IA, OSKALOOSA
167200--IA, OTTUMWA
167450--IA, PEOSTA
168000--IA, SIOUX CITY
168800--IA, SPENCER
169850--IA, WATERLOO
162406--IA, WEST BURLINGTON
134200--ID, IDAHO FALLS
133500--ID, KETCHUM
135600--ID, LEWISTON
131400--ID, MERIDIAN
137000--ID, POCATELLO
132800--ID, POST FALLS
138000--ID, SALMON
138200--ID, SANDPOINT
138400--ID, SODA SPRINGS
139800--ID, TWIN FALLS
140600--IL, BELLEVILLE
141200--IL, CARBONDALE
143005--IL, CENTRALIA
141800--IL, CHAMPAIGN
142000--IL, CICERO
146300--IL, CRESTWOOD
142400--IL, DANVILLE
143000--IL, EFFINGHAM
143300--IL, ELDORADO
143600--IL, FREEPORT
143900--IL, GALESBURG
144500--IL, JOLIET
149700--IL, LOMBARD
145700--IL, PEORIA
146000--IL, QUINCY
146600--IL, ROCK ISLAND
146900--IL, ROCKFORD
147200--IL, SPRING VALLEY
147500--IL, SPRINGFIELD
148100--IL, SYCAMORE
148400--IL, WAUKEGAN
149600--IL, WHEELING
150300--IN, EVANSVILLE
151000--IN, HUNTINGTON
152000--IN, INDIANAPOLIS
153000--IN, JASPER
153500--IN, NORTH VERNON
154000--IN, SOUTH BEND
155000--IN, TERRE HAUTE
156000--IN, VALPARAISO
170850--KS, COLBY
171700--KS, DODGE CITY
172550--KS, EMPORIA
172750--KS, GREAT BEND
173000--KS, HAYS
174250--KS, JUNCTION CITY
175200--KS, LEAWOOD
176800--KS, PARSONS
177650--KS, SALINA
178500--KS, TOPEKA
179350--KS, WICHITA
180909--KY, BARDSTOWN
181800--KY, ERLANGER
183600--KY, HAZARD
183900--KY, HENDERSON
186500--KY, LOUISVILLE
180900--KY, OWENSBORO
180908--KY, VERSAILLES
190800--LA, ALEXANDRIA
194606--LA, BATON ROUGE
197000--LA, BOSSIER CITY
194600--LA, LAFAYETTE
195200--LA, LAKE CHARLES
195500--LA, MONROE
195700--LA, MORGAN CITY
195750--LA, NEW IBERIA
195800--LA, NEW ORLEANS
198100--LA, THIBODAUX
220900--MA, CHICOPEE
221700--MA, DANVERS
223400--MA, LEOMINSTER
225100--MA, NORTH DARTMOUTH
229905--MA, PITTSFIELD
229900--MA, WEST BRIDGEWATER
210100--MD, BALTIMORE
210200--MD, CAPITOL HEIGHTS
210300--MD, CENTREVILLE
210400--MD, CUMBERLAND
210800--MD, FREDERICK
210900--MD, HAGERSTOWN
210600--MD, NORTHEAST
211700--MD, OAKLAND
211800--MD, PASADENA
210205--MD, ROCKVILLE
212300--MD, SALISBURY
210700--MD, TANEYTOWN
212500--MD, WALDORF
204800--ME, LEWISTON
205400--ME, PORTLAND
207200--ME, PRESQUE ISLE
209600--ME, WATERVILLE
231000--MI, ALPENA
231300--MI, ANN ARBOR
232200--MI, DEARBORN
232800--MI, ESCANABA
232505--MI, FLINT
233400--MI, IRON MOUNTAIN
233700--MI, IRONWOOD
234000--MI, ISHPEMING
234300--MI, JACKSON
234600--MI, KALAMAZOO
234900--MI, LANSING
235500--MI, MANISTEE
237900--MI, MENOMINEE
236400--MI, MT. PLEASANT
236700--MI, PETOSKEY
237000--MI, PORT HURON
237300--MI, SAGINAW
237600--MI, SAULT STE. MARIE
238200--MI, ST. JOSEPH
238800--MI, TRAVERSE CITY
236800--MI, WARREN
232500--MI, WATERFORD
239100--MI, WYOMING
240300--MN, ALEXANDRIA
241300--MN, BRAINERD
246800--MN, CROOKSTON
241800--MN, DETROIT LAKES
242300--MN, DULUTH
242800--MN, FAIRMONT
243500--MN, MANKATO
243800--MN, MARSHALL
244300--MN, MONTICELLO
240800--MN, ROCHESTER
243300--MN, ST. CLOUD
245800--MN, ST. PAUL
247800--MN, VIRGINIA
248300--MN, WINONA
248600--MN, WOODBURY
261000--MO, CARTHAGE
262200--MO, COLUMBIA
263400--MO, IMPERIAL
260600--MO, JACKSON
263600--MO, JEFFERSON CITY
263900--MO, KANSAS CITY
264600--MO, KIRKSVILLE
265400--MO, POPLAR BLUFF
267805--MO, ROLLA
268800--MO, SEDALIA
269600--MO, SPRINGFIELD
267000--MO, ST. JOSEPH
269700--MO, ST. LOUIS
267800--MO, WEST PLAINS
251900--MS, BILOXI
250200--MS, CLARKSDALE
251500--MS, GREENVILLE
251750--MS, GREENWOOD
255605--MS, HATTIESBURG
257000--MS, HERNANDO
253800--MS, JACKSON
259000--MS, KOSCIUSKO
254500--MS, MCCOMB
255600--MS, MERIDIAN
256500--MS, NATCHEZ
250400--MS, STARKVILLE
258000--MS, TUPELO
270800--MT, BILLINGS
271600--MT, BOZEMAN
273200--MT, BUTTE
274800--MT, GREAT FALLS
275600--MT, HAVRE
276400--MT, HELENA
277200--MT, KALISPELL
278000--MT, MILES CITY
278800--MT, MISSOULA
274000--MT, SIDNEY
340800--NC, ASHEVILLE
341600--NC, CHARLOTTE
342800--NC, ELIZABETH CITY
342900--NC, FAYETTEVILLE
343000--NC, GASTONIA
343600--NC, GOLDSBORO
343200--NC, GREENSBORO
344000--NC, HICKORY
344500--NC, JACKSONVILLE
342400--NC, MORRISVILLE
345000--NC, NEW BERN
346600--NC, ROCKY MOUNT
346800--NC, SALISBURY
346900--NC, TARBORO
347100--NC, WILMINGTON
347200--NC, WINSTON-SALEM
350900--ND, BISMARCK
352700--ND, DEVILS LAKE
353600--ND, DICKINSON
355400--ND, FARGO
356300--ND, GRAND FORKS
357200--ND, JAMESTOWN
358100--ND, MINOT
359900--ND, OAKES
280600--NE, BEATRICE
282000--NE, GERING
283000--NE, HASTINGS
283600--NE, KEARNEY
284200--NE, LINCOLN
285400--NE, NORFOLK
286000--NE, NORTH PLATTE
287200--NE, OMAHA
287800--NE, O`NEILL
306000--NH, BRENTWOOD
303000--NH, CONCORD
301500--NH, HOOKSETT
311000--NJ, ENGLEWOOD
313000--NJ, FREEHOLD
317000--NJ, LAWRENCEVILLE
315000--NJ, PLEASANTVILLE
319000--NJ, UNION
321000--NM, ALBUQUERQUE
322000--NM, CLOVIS
323000--NM, FARMINGTON
324000--NM, GALLUP
325000--NM, HOBBS
326000--NM, LAS CRUCES
327000--NM, LAS VEGAS
328000--NM, ROSWELL
329000--NM, SANTA FE
291505--NV, ELY
294500--NV, LAS VEGAS
296000--NV, SPARKS
291500--NV, WELLS
297500--NV, WINNEMUCCA
331000--NY, BATAVIA
331400--NY, BINGHAMTON
339000--NY, BRONX
331500--NY, BUFFALO
332500--NY, ELMIRA HEIGHTS
333000--NY, GLENS FALLS
338500--NY, LIVERPOOL (SYRACUSE)
333400--NY, MECHANICVILLE
339005--NY, MONROE
334000--NY, NEW YORK MLLS(UTICA)
335000--NY, NORWICH
335500--NY, OGDENSBURG
336000--NY, OLEAN
336500--NY, PLATTSBURGH
337000--NY, ROCHESTER
337500--NY, SARANAC LAKE
338000--NY, SENECA FALLS
335505--NY, WATERTOWN
339006--NY, WYANDANCH
365100--OH, ATHENS
365400--OH, BATAVIA
369200--OH, BELLAIRE
365600--OH, BROOKLYN
365700--OH, CANTON
366000--OH, CHILLICOTHE
368900--OH, CINCINNATI
366600--OH, COLUMBUS
367200--OH, DEFIANCE
367800--OH, LIMA
364800--OH, LORAIN
368100--OH, MANSFIELD
368700--OH, NEWARK
369000--OH, PAINESVILLE
369700--OH, PERRYSBURG
366900--OH, SPRINGBORO
369100--OH, SPRINGFIELD
369400--OH, TIFFIN
369900--OH, YOUNGSTOWN
375955--OK, ALTUS
375958--OK, ARDMORE
374285--OK, CLINTON
374250--OK, DURANT
374280--OK, EL RENO
375100--OK, ENID
375950--OK, LAWTON
376805--OK, MC ALESTER
371750--OK, MIAMI
376800--OK, MUSKOGEE
377750--OK, OKLAHOMA CITY
376806--OK, POTEAU
372000--OK, STILLWATER
377756--OK, TULSA
375107--OK, WOODWARD
381350--OR, BEND
381800--OR, BURNS
382700--OR, KLAMATH FALLS
383150--OR, LA GRANDE
382100--OR, MEDFORD
384050--OR, NORTH BEND
384500--OR, ONTARIO
386300--OR, OREGON CITY
384950--OR, PENDLETON
382250--OR, PORTLAND
386750--OR, ROSEBURG
387200--OR, SALEM
385700--OR, SPRINGFIELD
388100--OR, THE DALLES
388550--OR, TILLAMOOK
389350--OR, WARRENTON
391800--PA, ERIE
392700--PA, HARRISBURG
393600--PA, JOHNSTOWN
394500--PA, PAXINOS
395400--PA, PHILADELPHIA
396300--PA, PITTSBURGH
397200--PA, SCRANTON
398100--PA, SINKING SPRING
390900--PA, YORK
409000--RI, WEST GREENWICH
410090--SC, AIKEN
410200--SC, ANDERSON
410725--SC, BEAUFORT
410720--SC, CHARLESTON
410300--SC, COLUMBIA
410540--SC, FLORENCE
410600--SC, GREENVILLE
410990--SC, KINGSTREE
411260--SC, MYRTLE BEACH
411310--SC, ORANGEBURG
411500--SC, ROCK HILL
411600--SC, SPARTANBURG
411630--SC, SUMTER
420200--SD, ABERDEEN
421800--SD, HURON
422700--SD, PIERRE
423600--SD, RAPID CITY
424500--SD, SIOUX FALLS
425400--SD, WINNER
430250--TN, CHATTANOOGA
430400--TN, CLARKSVILLE
430500--TN, COLUMBIA
430750--TN, COOKEVILLE
435005--TN, JACKSON
433600--TN, JOHNSON CITY
433700--TN, KNOXVILLE
434000--TN, MEMPHIS
435000--TN, NASHVILLE
436900--TN, SWEETWATER
438800--TN, WOODLAND MILLS
449000--TX, ABILENE
442506--TX, ALICE
440400--TX, AMARILLO
444205--TX, ARLINGTON
440600--TX, AUSTIN
443500--TX, BAYTOWN
441000--TX, BEAUMONT
441600--TX, BORGER
442000--TX, BROWNWOOD
441100--TX, BRYAN
442450--TX, CONROE
442500--TX, CORPUS CHRISTI
443400--TX, DALLAS
443600--TX, DEL RIO
449905--TX, DENISON
443800--TX, EL PASO
444000--TX, FORT STOCKTON
444200--TX, FORT WORTH
444300--TX, GALVESTON
443605--TX, HONDO
445000--TX, HOUSTON
445200--TX, HOUSTON
442006--TX, KERRVILLE
442300--TX, LAGRANGE
449906--TX, LAKE DALLAS
446300--TX, LAREDO
442005--TX, LLANO
446500--TX, LONGVIEW
447000--TX, LUBBOCK
447200--TX, MCALLEN
447400--TX, MIDLAND
447600--TX, MINERAL WELLS
447700--TX, NACOGDOCHES
447800--TX, PALESTINE
448400--TX, SAN ANGELO
448600--TX, SAN ANTONIO
449200--TX, TEMPLE
449600--TX, VICTORIA
449800--TX, WACO
449900--TX, WICHITA FALLS
453000--UT, OGDEN
453006--UT, OREM
456000--UT, RICHFIELD
457500--UT, SALT LAKE CITY
459000--UT, VERNAL
471000--VA, ABINGDON
472000--VA, DANVILLE
473000--VA, FREDERICKSBURG
474500--VA, LYNCHBURG
475000--VA, NASSAWADOX
475250--VA, NORFOLK
475500--VA, PETERSBURG
476000--VA, RICHMOND
476500--VA, SALEM
472005--VA, SOUTH HILL
470500--VA, SPRINGFIELD
478000--VA, VERONA
478500--VA, WINCHESTER
463900--VT, BERLIN
469705--VT, COLCHESTER
469700--VT, NORTH CLARENDON
480250--WA, ABERDEEN
480500--WA, BELLINGHAM
485400--WA, BREMERTON
480750--WA, CLARKSTON
489000--WA, COLVILLE
481000--WA, EVERETT
487000--WA, KENNEWICK
482100--WA, LONGVIEW
483500--WA, MOSES LAKE
488100--WA, MOUNT VERNON
484650--WA, OMAK
485450--WA, PORT ANGELES
486000--WA, PULLMAN
482000--WA, SEATTLE
487500--WA, SPOKANE
488300--WA, TACOMA
484600--WA, TUMWATER
489100--WA, VANCOUVER
489200--WA, WALLA WALLA
489350--WA, WENATCHEE
489780--WA, YAKIMA
500180--WI, ANTIGO
503220--WI, AURORA
505300--WI, BROWN DEER
500940--WI, DEPERE
501700--WI, EAU CLAIRE
502130--WI, GERMANTOWN
502840--WI, HURLEY
503600--WI, KENOSHA
503980--WI, LACROSSE
504740--WI, MENOMONIE
505120--WI, MIDDLETON
505880--WI, OSHKOSH
506260--WI, PESHTIGO
506640--WI, PRAIRIE DU CHIEN
507020--WI, RACINE
507400--WI, RHINELANDER
507780--WI, SHEBOYGAN
508160--WI, SPARTA
508540--WI, STEVENS POINT
508920--WI, SUPERIOR
509540--WI, WAUSAU
490400--WV, BLUEFIELD
491200--WV, CLARKSBURG
491600--WV, ELKINS
492400--WV, HUNTINGTON
492600--WV, KINGWOOD
492650--WV, LOGAN
492800--WV, MABSCOTT
493200--WV, MARTINSBURG
493600--WV, MORGANTOWN
493800--WV, NEW MARTINSVILLE
494000--WV, PARKERSBURG
494400--WV, RAINELLE
494800--WV, RIDGELEY
495000--WV, S CHARLESTON
495200--WV, WEIRTON
495600--WV, WELCH
511000--WY, CASPER
512000--WY, CHEYENNE
512700--WY, JACKSON
513000--WY, LARAMIE
515000--WY, RIVERTON
516000--WY, ROCK SPRINGS
517000--WY, SHERIDAN
518000--WY, TORRINGTON
519000--WY, WORLAND
Sales Trend Comparison (% vs YAG)
Actual Weeks
Forecast Weeks
Last 52
Last 8
Next 4
Next 8
Commodity
0007--ACME Light, 24-12 6 PK NR LT REP
0015--ACME Brand, 24-12 12PK NR CR REP
0021--ACME Brand, 24-12 12PK CN CR REP
0025--ACME Light, 24-12 6 PK CN LT REP
0037--ACME Brand, 1/2 KEG STEEL CR REP
0041--ACME Light, 24-12 12PK CN LT REP
0043--ACME Light, 24-16 6 PK CN LT REP
0045--ACME Light, 1/2 KEG STEEL LT REP
0049--ACME Light, 24-12 DEP BTL LT REP
0067--ACME Light, 12-32 QUART LT REP
0094--ACME Light, 24-12 DEP BTL LT REP
0110--ACME Na, 24-12 6P LNNR NA 0.5
0265--White A, 24-12 6 LNNR BWA REP
0279--El Nino Harvest , 24-12 6 LNNR BHP REP
0280--El Nino Harvest , 1/2 KG STEEL BHP REP
0303--Ale, 24-12 12P CN KEY REP
0305--Ale, 24-12 24P CN KEY REP
0315--Ale, 24-16 6PK CN KEY REP
0347--Ale Light, 24-12 6PK LNNR KEL
0353--Ale Light, 24-12 12 PK CN KEL
0355--Ale Light, 24-12 24 PK CN KEL
0365--Ale Light, 24-16 6 PK CN KEL
0383--Ale Dry, 24-12 12P CN KED REP
0405--ACME Light, 24-12 24PK CN LT REP
0417--ACME Light, 18-12 18PK CN LT REP
0419--ACME Light, 24-07 6 PK NR LT REP
0425--ACME Light, 24-16 4P LNNR LT REP
0427--ACME Light, 24-12 6P LNNR LT REP
0429--ACME Light, 24-12 24 LNNR LT REP
0431--ACME Light, 12-40 OZ NR LT REP
0453--Ale Ice, 24-12 12P CN KYI REP
0455--Ale Ice, 24-12 24P CN KYI REP
0457--Ale Ice, 24-16 6PK CN KYI REP
0459--ACME Light, 24-12 12PK NR LT REP
0469--ACME Light, 12-22 OZ NR LT REP
0499--ACME Light, 12-24 OZ CAN LT REP
0505--ACME Brand, 24-12 24PK CN CR REP
0517--ACME Brand, 18-12 18PK CN CR REP
0524--ACME Brand, 12-24 OZ CAN CR REP
0527--ACME Brand, 24-12 6P LNNR CR REP
0529--ACME Brand, 24-12 24 LNNR CR REP
0627--Big Brew 99, 24-12 6P LNNR KL REP
0637--Big Brew 99, 1/2 KEG STEEL KL REP
0639--Big Brew 99, 24-12 12 LNNR KL REP
0677--Ned's Extra, 24-12 6P LNNR WF 4.5
0699--Honest Ale, 24-12 6 LNNR KIH REP
0739--90 Weight, 24-12 6 PK CN ZM REP
0747--90 Weight, 24-12 6P LNNR ZM REP
0757--90 Weight, 24-12 12 LNNR ZM REP
0759--90 Weight, 12-22 OZ NR ZM REP
0803--El Nino, 24-12 12PK CN EG REP
Calendar
Prior Year
Current Year Sales
Arrivals
Ending Inventory
Transfers
Other
wk
Monday
Date
Sales
Promo
Company
Forecast
Dist Act/
Forecast
Promo
Scheduled
SAQ
Requested
Actual/
Projected
DOI
DOI
Range
In
Out
Inventory
Variance
23
05/31
870
*
953
*
1,440
527
-
0
0
-959
24
06/07
1,150
*
1,021
*
1,315
2,261
-
0
0
1,440
25
06/14
860
*
699
*
0
2,162
-
0
0
600
26
06/21
829
*
1,087
*
1,440
1,914
-
0
0
-601
27
06/28
1,669
*
0
*
1,080
-
28
07/05
1,039
*
977
*
1,560
-
29
07/12
527
*
647
*
0
120
11-17
30
07/19
1,115
*
1,179
*
0
960
11-17
31
07/26
897
*
1,123
*
0
960
11-17
32
08/02
912
*
872
*
0
960
11-17
33
08/09
885
*
798
*
0
-
34
08/16
949
*
1,206
*
Green
=Orders
Blue
=Planned
35
08/23
1,174
*
1,282
*
XYZ Help: ned@csc.com
Return to XYZ Distributors Home Page
July 7, 1999
All Rights Reserved | Copyright 1999 | Computer Sciences Corporation