deli/bakery operations tobacco accountability accountable inventories cms deca west doris...
DESCRIPTION
Common IG Findings –Weekly Inspections Not Done –Expired Deli/Bakery Products –Products Without Date Label Deli/Bakery Sales ComparisonTRANSCRIPT
Deli/Bakery Operations
Tobacco Accountability
Accountable Inventories
CMS – DeCA West
Doris Lowenstrom
Deli/Bakery
Deli/Bakery
• Common IG Findings– Weekly Inspections Not
Done– Expired Deli/Bakery
Products– Products Without Date Label
• Deli/Bakery Sales Comparison
DELI/BAKERY SALES
COMPARISON
Zone 6 Deli/Bakery Sales Comparison
StoreDeli (16,41)
%Change from LY - Month
Bakery (14) %Change from LY
- Month
Sushi (34) %Change from
LY - Month
Hot Foods (32) %Change from
LY - Month
CORPUS CHRISTI NAS 16.89 % 0.59 %
DYESS 1.92 % 10.44 %
FORT HOOD I 13.90 % 21.32 % 9.52 % 37.90 %
FORT HOOD II 8.84 % 30.88 %
FORT SAM HOUSTON -9.80 % -15.52 % -14.42 % 24.37 %
GOODFELLOW AFB -6.84 % -8.77 %
KINGSVILLE NAS
LACKLAND AFB -8.72 % 1.38 % 16.09 % 46.30 %
LAUGHLIN AFB -0.63 % 5.77 %
RANDOLPH AFB -9.72 % 10.61 % -18.86 % 25.00 %
Zone 8 Deli/Bakery Sales Comparison
StoreDeli (16,41)
%Change from LY - Month
Bakery (14) %Change from LY
- Month
Sushi (34) %Change from
LY - Month
Hot Foods (32) %Change from
LY - Month
ALTUS AFB 9.63 % 0.12 %
CANNON AFB 0.92 % 0.72 %
FORT BLISS -3.71 % -6.50 % -0.93 % -72.82 %
FORT SILL 44.70 % 42.95 %
HOLLOMAN AFB 2.62 % -4.17 %
KIRTLAND AFB -3.67 % -21.24 %
MCCONNELL AFB 8.32 % -44.69 %
SHEPPARD AFB -4.30 % -20.16 % 28.26 %
TINKER AFB -3.10 % -26.10 % -9.18 % -15.33 %
VANCE AFB 2.10 %
WHITE SANDS MR -29.51 %
Zone 9 Deli/Bakery Sales Comparison
StoreDeli (16,41)
%Change from LY - Month
Bakery (14) %Change from LY
- Month
Sushi (34) %Change from
LY - Month
Hot Foods (32) %Change from
LY - Month
BUCKLEY AFB 0.15 % 29.74 %
ELLSWORTH AFB -1.02 % -8.82 %
F. E. WARREN -11.93 % -3.50 % 28.50 %
FORT CARSON -8.97 % 0.03 % 16.26 %
FORT LEAVENWORTH -2.01 % -2.88 %
FORT RILEY -5.90 % 11.17 %
GRAND FORKS AFB -15.23 % -18.82 % -14.71 %
MINOT AFB -2.69 % -3.53 % -24.61 %
OFFUTT AFB -5.76 % -1.51 %
PETERSON AFB 2.41 % 10.92 %
U. S. AIR FORCE ACADEMY -11.80 % -2.00 % -0.74 %
Tobacco Accountability
Tobacco Accountability
• Accountable Inventory Results– Not released by AAFES
• New Document Log and Reconciliation Report
• AAFES will provide training
Tobacco Document LogDeCA TOBACCO DOCUMENT LOG (Revised Feb 2007)
STORE: MONTH:(1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) (12) (13) (14) (15) (16)
Control No. Ref. No. Date
STO/VES Receipt Amount
Warehouse Manifest
Price Adj Increase
Price Adj Decrease
Transfers To Exchange
Transfers From -
Exchange VPR Other
Adj VCMs Sales Balance
Date of Merch Report
Amt Agrees with Merch
+ + + (-) (-) + (-) +/(-) (-) (-) Y/NTransaction Code 491/414 431 441 442/473 529 530 510/444 412 419 427
0
TE-01 0
TE-02 0
TE-03 0
TE-04 0
TE-05 0
TE-06 0
TE-07 0
TE-08 0
TE-09 0
TE-10 0
TE-11 0
TE-12 0
TE-13 0
TE-14 0
TE-15 0
TE-16 0
TE-17 0
TE-18 0
TE-19 0
TE-20 0
TE-21 0
TE-22 0
TE-23 0
TE-24 0
TE-25 0
TE-26 0
TE-27 0TE-28 0TE-29 0TE-30 0
Page Total $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
JANUARY 2008
Book Inventory Brought Forward- 31 DECEMBER 2007
Tobacco Document LogDeCA TOBACCO DOCUMENT LOG (Revised Feb 2007)
STORE: MONTH: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) (12) (13) (14) (15) (16)
Control No. Ref. No. Date
STO/VES Receipt Amount
Warehouse Manifest
Price Adj Increase
Price Adj Decrease
Transfers To Exchange
Transfers From -
Exchange VPR Other
Adj VCMs Sales Balance
Date of Merch Report
Amt Agrees with Merch
+ + + (-) (-) + (-) +/(-) (-) (-) Y/N
Transaction Code 491/414 431 441 442/473 529 530 510/444 412 419 427Brought Forward $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Physical Inv 02 FEBRUARY 2008
DIFFERENCE BETWEEN BOOK INVENTORY AND PHYSICAL INVENTORY $0
PERCENT OF GAIN/LOSS #DIV/0!
INVENTORY TO SALES RATIO #DIV/0!
CUMMULATIVE TOTALS FOR AAFES ACCOUNTING YEAR:
PRIOR TOTALS $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
TOTAL FOR ACCTG YEAR $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
0 JANUARY 2008
Tobacco Reconciliation Worksheet
TOBACCO RECONCILIATION WORKSHEET
ACCOUNTING PERIOD ENDING 02 FEBRUARY 2008
Remarks:
PREPARER: STORE DIRECTOR:
(Name) (Date) (Name) (Date)
15. PERCENTAGE OF GAIN/LOSS #DIV/0! #DIV/0!14. GAIN/LOSS FOR ACCOUNTING PERIOD $013. PHYSICAL INVENTORY $0 $0
$0
11. SALES $0 $010. TOTAL $0
12. ENDING BOOK INVENTORY $0 $0
$0
From 01 JANUARY to 02 FEBRUARY 2008 a. Directly from Vendors $0 $0 b. From Exchange Distribution Center
8. OTHER ADJUSTMENTS $0 $09. VCMs $0 $0
6. TRANSFERS FROM EXCHANGE $0 $07. VPRs $0 $0
4. PRICE CHANGE DECREASE $0 $05. TRANSFERS TO EXCHANGE $0 $0
$0 $03. PRICE CHANGE INCREASE $0 $0
1. BEGINNING INVENTORY $0(Inventory Conducted Feb 3, 2007) $0
2. RECEIPTS
COMMISSARY NAME 0
MONTH YEAR TO DATE
ACCOUNTABLEINVENTORIES
Zone 6 Grocery/Meat/Produce
GAIN/ BOOK ADJ. 2007 GAIN/ BOOK ADJ. 2007 GAIN/ BOOK ADJ. 2007STORE NAME LOSS ADJ. GN/LS % LOSS ADJ. GN/LS % LOSS ADJ. GN/LS %
CORPUS CHRISTI (72,410) (72,410) (0.94) 527 527 0.05 782 782 0.13DYESS (77,149) (77,149) (0.89) 1,860 1,860 0.26 1,881 1,881 0.31FORT HOOD I (574,910) (574,910) (1.49) 4,259 4,259 0.11 (5,385) (5,385) (0.24)FORT HOOD II (746,554) (746,554) (3.52) 2,725 2,725 0.13 1,091 1,091 0.09FT SAM HOUSTON (691,051) (691,051) (1.36) 930 930 0.02 13,277 13,277 0.34GOODFELLOW 3,373 3,373 0.05 1,350 1,350 0.21 (4,804) (4,804) (0.94)KINGSVILLE (33,608) (33,608) (3.39) 774 774 0.36 (5,907) (5,907) (11.46)LACKLAND (242,974) (242,974) (0.76) 7,942 302 7,640 0.27 12,332 12,332 0.56LAUGHLIN (45,669) (45,669) (1.43) 613 613 0.17 732 732 0.30RANDOLPH (644,453) (644,453) (1.58) 8,215 8,215 0.22 2,765 2,765 0.08
ZONE TOTALS: (3,125,406) 0 (3,125,406) (1.48) 29,196 302 28,894 0.14 16,765 0 16,765 0.11GROCERY MEAT PRODUCE {Produce +/-4%-Kingsville)
10 10 10 NUMBER OF STORES COMPLETED INVENTORY6 1 3 NUMBER OF STORES OUT OF TOLERANCE
60% 10% 30% PERCENT OF STORES OUT OF TOLERANCE
GROCERY MEAT PRODUCE
Zone 8Grocery/Meat/Produce
GAIN/ BOOK ADJ. 2007 GAIN/ BOOK ADJ. 2007 GAIN/ BOOK ADJ. 2007STORE NAME LOSS ADJ. GN/LS % LOSS ADJ. GN/LS % LOSS ADJ. GN/LS %
ALTUS (18,639) (18,639) (0.29) 1,724 1,724 0.28 1,180 1,180 0.49CANNON (60,784) (103) (60,681) (0.81) 320 320 0.05 (133) 0 (133) (0.03)FORT BLISS 0 0 0.00 0 0 0.00 0 0 0.00FORT SILL (182,482) (182,482) (0.57) 1,970 1,970 0.06 3,863 3,863 0.15HOLLOMAN (155,002) (155,002) (1.22) 1,002 1,002 0.08 71 71 0.01KIRTLAND 1,043 1,043 0.00 2,050 2,050 0.07 7,796 7,796 0.30MC CONNELL (10,321) (169) (10,152) (0.06) 2,942 2,942 0.18 5,539 5,539 0.45SHEPPARD (213,515) (213,515) (1.39) 1,662 1,662 0.15 4,495 4,495 0.38TINKER (309,535) (309,535) (0.80) 2,994 2,994 0.09 869 869 0.03VANCE (14,836) (14,836) (0.32) 1,078 1,078 0.24 1,643 1,643 0.39WHITE SANDS (11,597) (11,597) (0.43) 1,834 1,834 0.53 314 314 0.18
ZONE TOTALS: (975,667) (271) (975,396) (0.57) 17,577 0 17,577 0.11 25,637 0 25,637 0.20GROCERY MEAT PRODUCE (Meat- +/-2% White Sands, Produce +/-2%-White Sands)
10 10 10 NUMBER OF STORES COMPLETED INVENTORY2 0 1 NUMBER OF STORES OUT OF TOLERANCE
20% 0% 10% PERCENT OF STORES OUT OF TOLERANCE
GROCERY MEAT PRODUCE
Zone 9Grocery/Meat/Produce
GAIN/ BOOK ADJ. 2007 GAIN/ BOOK ADJ. 2007 GAIN/ BOOK ADJ. 2007STORE NAME LOSS ADJ. GN/LS % LOSS ADJ. GN/LS % LOSS ADJ. GN/LS %
AIR FORCE ACDEMY 47,556 47,556 0.23 2,185 2,185 0.12 1,015 1,015 0.05BUCKLEY (3,433) (3,433) (0.01) 4,120 4,120 0.17 8,318 8,318 0.33ELLSWORTH (86,137) (120) (86,017) (0.76) 873 873 0.10 205 205 0.02FE WARREN (11,217) (110) (11,107) (0.09) 1,793 1,793 0.15 2,290 2,290 0.24FORT CARSON (216,223) (418) (215,805) (0.59) 8,251 8,251 0.23 9,138 9,138 0.30FT LEAVENWORTH (185,180) (185,180) (0.72) 2,311 2,311 0.11 1,227 1,227 0.06FORT RILEY (118,818) 200 (119,018) (0.55) (9,904) (9,904) (0.45) 8,665 8,665 0.58GRAND FORKS (93,327) (93,327) (1.24) 498 498 0.08 2,058 2,058 0.40MINOT (51,425) (51,425) (0.48) 1,202 1,202 0.16 1,259 1,259 0.15OFFUTT (41,302) (41,302) (0.11) 1,743 1,743 0.06 7,072 7,072 0.23PETERSON 96,307 (17,980) 114,287 0.41 1,306 1,306 0.05 91 91 0.00
ZONE TOTALS: (663,200) (18,429) (644,771) (0.27) 14,378 0 14,378 0.07 41,340 0 41,340 0.21GROCERY MEAT PRODUCE
11 11 11 NUMBER OF STORES COMPLETED INVENTORY1 1 NUMBER OF STORES OUT OF TOLERANCE9% 9% 0% PERCENT OF STORES OUT OF TOLERANCE
GROCERY MEAT PRODUCE
Maintaining Accountability
• Reconcile Summary Audit Log (SAL)
• Verify Corrections
• Monitor Closing Book Inventory
Monthly Accountability ReportSTORE DATE VRGC DIFFERENCE SALES YEAR TO 1% MAXIMUM 2006 BASED
Store1 23-Jan-06 $613,530 $8,079,033 $80,790 $603,253 -0.13%Store1 Jan-06 $639,816 $156,115 $156,115 $1,561 $641,377 $603,253 -23.42%Store1 Feb-06 $642,830 $3,014 $594,303 $750,418 $7,504 $650,334 $603,253 -5.27%Store1 Mar-06 $639,195 ($3,635) $636,709 $1,387,127 $13,871 $653,066 $603,253 -2.59%Store1 Apr-06 $623,302 ($15,893) $606,278 $1,993,405 $19,934 $643,236 $603,253 -1.01%Store1 May-06 $642,921 $19,619 $601,171 $2,594,576 $25,946 $668,867 $603,253 -1.53%Store1 Jun-06 $619,567 ($23,354) $610,714 $3,205,291 $32,053 $651,620 $603,253 -0.51%Store1 Jul-06 $645,238 $25,671 $567,456 $3,772,746 $37,727 $682,966 $603,253 -1.11%Store1 Aug-06 $717,630 $72,391 $623,015 $4,395,761 $43,958 $761,587 $603,253 -2.60%Store1 Sep-06 $688,618 ($29,012) $647,341 $5,043,102 $50,431 $739,049 $603,253 -1.69%Store1 Oct-06 $681,507 ($7,111) $567,587 $5,610,689 $56,107 $737,614 $603,253 -1.39%Store1 Nov-06 $708,971 $27,464 $602,090 $6,212,779 $62,128 $771,099 $603,253 -1.70%Store1 Dec-06 $653,919 ($55,053) $610,127 $6,822,906 $68,229 $722,148 $603,253 -0.74%Store1 Jan-07 $646,731 ($7,188) $555,150 $7,378,056 $73,781 $720,512 $603,253 -0.59%Store1 5-Feb-07 $538,415 ($108,316) $133,371 $7,512,599 $75,126 $477,632 -0.81%
Store2 24-Apr-06 $2,451,126 $65,621,933 $656,219 $1,724,931 -1.11%Store2 Apr-06 $1,689,115 ($762,010) $769,564 $769,564 $7,696 $1,696,811 $1,724,931 0.00%Store2 May-06 $1,859,468 $170,352 $3,695,842 $4,465,406 $44,654 $1,904,122 $1,724,931 -3.01%Store2 Jun-06 $1,942,179 $82,711 $3,558,622 $8,024,028 $80,240 $2,022,419 $1,724,931 -2.71%Store2 Jul-06 $1,917,838 ($24,341) $3,546,639 $11,570,667 $115,707 $2,033,545 $1,724,931 -1.67%Store2 Aug-06 $1,980,145 $62,307 $3,593,685 $15,164,352 $151,644 $2,131,788 $1,724,931 -1.68%Store2 Sep-06 $2,065,075 $84,930 $3,838,488 $19,002,840 $190,028 $2,255,103 $1,724,931 -1.79%Store2 Oct-06 $2,272,422 $207,347 $3,679,610 $22,682,450 $226,825 $2,499,247 $1,724,931 -2.41%Store2 Nov-06 $2,286,570 $14,148 $3,819,163 $26,501,613 $265,016 $2,551,586 $1,724,931 -2.12%Store2 Dec-06 $2,089,867 ($196,703) $3,980,766 $30,482,380 $304,824 $2,394,691 $1,724,931 -1.20%Store2 Jan-07 $2,179,461 $89,593 $3,570,885 $34,053,265 $340,533 $2,519,993 $1,724,931 -1.33%Store2 Feb-07 $2,303,950 $124,489 $3,530,030 $37,583,295 $375,833 $2,679,783 $1,724,931 -1.54%Store2 Mar-07 $2,151,478 ($152,472) $3,885,174 $41,468,469 $414,685 $2,566,162 $1,724,931 -1.03%Store2 Apr-07 $2,208,704 $57,226 $3,541,443 $45,009,912 $450,099 $2,658,803 $1,724,931 -1.07%
しつもん