Monthly

Document Sample
Monthly Powered By Docstoc
					             Monthly Ops Report
                                                   Month of       Month of       Month of        Month of       Month of      Month of       Month of       Month of
                                                    June           July          August         September       October       November       December       January
              I. Order Management
Beginning Order Backlog                            948,913.00     981,532.49     830,130.63      437,608.66   556,642.05 1,496,563.03 1,558,820.10 1,333,320.47
+ Orders Received                                  725,331.00     489,205.86     319,115.10      452,754.59 1,239,324.80   340,241.36   299,028.90   246,489.44
- Orders Shipped                                  (692,711.51)   (640,607.72)   (711,637.07)    (333,721.20) (299,403.82) (277,373.39) (521,515.53) (536,119.52)
- Canceled Orders                                  (30,952.40)    (12,292.56)     (2,099.70)      (4,159.40)        0.00      (610.90)   (3,013.00)  (23,555.60)
Ending Order Backlog                               981,532.49     830,130.63     437,608.66      556,642.05 1,496,563.03 1,558,820.10 1,333,320.47 1,020,134.79
Current Month Order Backlog                                                                       38,322.00   206,527.00    27,116.00    15,199.00    10,601.00
Next Month Order Backlog                                                                         152,790.00   327,533.00   212,388.00   120,004.00   554,689.00
Future Months Order Backlog                                                                      330,945.00   962,503.00 1,319,927.00 1,198,117.00   454,903.00
% of Order Backlog due to Stockouts                                                                   5.37%        0.24%        0.14%        0.18%        0.23%
Customer Orders Beyond Due Date - Goal =10%       239,908.60     256,119.17     153,968.48       125,821.36   143,035.30   100,528.66    81,804.56    10,924.78
% of Orders Beyond Due Date -by Dollars               24.44%         30.85%         35.18%           22.60%        9.56%        6.45%        6.14%        1.07%
% of Orders Beyond Due Date -by No. of Orders                        22.50%         19.80%           11.70%       10.00%        8.10%        5.10%        5.10%

                 Calls Received
Customer                                                                                    0          109            177            104             52           136
Sales Rep                                                                                   0           75             82            100             49           100
Office                                                                                      0          411            653            600            262           696
 Total                                                                                                 595            912            804            363           932

Number of Orders Entered                                                                               240            435            260            410           309
Number of New Custom Projects                                                                            1              4              6              2             4


              II. Inventory Management
Beginning Open Purchase Orders                    188,698.00      244,657.00    168,500.00       171,003.00     224,888.00     382,552.00     416,143.00    373,521.43
+ Purchase Orders Placed                           98,321.00       80,402.51     76,097.55       175,199.78     289,616.09     150,664.19     166,609.00        78,153
- Inventory Received                              (43,886.00)    (158,201.48)   (79,690.34)     (118,460.15)   (118,282.85)   (119,831.90)   (220,854.89)     (215,948)
- P.O.'s Canc., or Incompl./Closed or Overages      1,524.00        1,641.97      6,095.79        (2,854.63)    (13,669.24)      2,758.71      11,624.32      3,351.51
Ending Open Purchase Orders                       244,657.00      168,500.00    171,003.00       224,888.00     382,552.00     416,143.00     373,521.43    239,077.00
Fulfillment shortages                               7,906.00       52,150.00     32,021.00        26,290.00      18,033.00      81,735.00     119,229.00       202,926

Ending Inventory - $'s                           1,690,676.00 1,536,050.00 1,326,420.58 1,256,835.87 1,245,022.24 1,241,027.00 1,249,734.04 1,296,569.74
Ending Inventory - Units                              388,082     332,113      298,935      283,843      290,078      312,687      308,907      309,646
Cost Per Unit                                            4.36         4.63         4.44         4.43         4.29         3.97         4.05         4.19

Total Inventory Plus On Order                    1,935,333.00 1,704,550.00 1,497,423.58 1,481,723.87 1,627,574.24 1,657,170.00 1,623,255.47 1,535,646.74
Weekly Average Sales Prior Month                   132,218.00   166,136.75   137,326.00   138,489.00    89,457.25    79,508.50    79,508.50    79,508.50
Annualized Cost of Sales                         5,497,461.00 5,634,346.67 5,900,094.00 5,863,356.00 5,595,070.00 6,244,750.00 5,500,729.00 5,500,729.00
Weekly Average COM Prior Month                      61,187.25    64,194.87    68,369.86    69,005.10    65,479.87    70,697.31    62,453.25    62,453.25
Number of Weeks Supply - Goal = 17                      31.63        26.55        21.90        21.47        24.86        23.44        25.99        24.59
Inventory Turnover - Goal = 6                            3.25         3.67         4.45         4.67         4.49         5.03         4.40         4.24


               III. Cash Management
          Accounts Receivable & Payable
Beginning accounts receivable                    1,224,063.65 1,040,407.31       810,655.55      817,817.48     666,852.22     547,222.44     520,244.28    717,881.75
Invoices for week                                  718,441.37   656,093.00       547,921.56      339,759.38     306,465.34     282,787.27     521,585.01       542,139
Cash received                                     (832,071.81) (747,469.92)     (495,599.25)    (466,899.85)   (416,134.52)   (284,642.14)   (303,549.11)     (562,032)
Credits/discounts/finance charges                  (70,025.90) (138,374.84)      (45,160.38)     (23,824.79)     (9,960.60)    (25,123.29)    (20,398.43)        1,683
Ending accounts receivable                       1,040,407.31   810,655.55       817,817.48      666,852.22     547,222.44     520,244.28     717,881.75    699,672.33

Current                                           763,950.54     528,324.18     648,214.77      555,061.95     355,424.58     399,504.74     549,041.92     589,286.04
1 to 30 days past due                             224,473.95     231,942.97     101,665.24       88,615.01     144,977.40     104,833.54     150,073.83      45,736.49
31 to 60 days past due                             26,997.53      33,908.26      47,635.28        6,388.21      39,103.71      12,276.19      11,182.37      54,474.08
Over 60 days past due                              24,985.29      16,480.14      20,302.19       17,210.72       7,716.75       3,629.81       7,583.63      10,175.72
% over 60 days past due                                2.40%          2.03%          2.48%           2.58%          1.41%          0.70%          1.06%          1.45%




                                                                                   Page 1
                                                     Month of      Month of       Month of        Month of      Month of       Month of       Month of       Month of
                                                      June           July          August        September       October       November       December        January
Accounts Payable Balance                               165,068     228,652.00     177,865.00      254,430.00    177,339.00     283,202.00     302,207.00     328,535.87
Accounts Payable Days Outstanding                         10.9           14.6           11.0            16.0          11.5           18.3            20.1          21.8
              Profitability Management
Sales, Wholesale plus Retail                        739,648.00      789,791.14     578,037.98     354,362.48     320,171.44     287,949.53    540,386.41         558,626
Less: Discounts, returns & allowances                (8,527.00)      (9,756.14)     (1,513.01)     (3,327.16)     (2,136.67)     (3,467.45)    (5,507.60)           (593)
Cost of Merchandise                                 407,852.80      521,545.00     303,971.10     168,572.55     151,911.60     128,016.94    244,601.46         251,115
Direct Labor                                        106,982.00      123,472.00     106,415.00      84,587.75     108,288.20      99,890.00     99,059.00         134,770
Variable Costs                                       41,432.25       49,371.00      47,861.00      30,510.00      42,313.20      56,377.00     34,561.00          88,760
Variable Profit                                     174,853.95       85,647.00     118,277.87      67,365.02      15,521.77         198.14    156,657.35       83,387.96
Contribution Margin % - Goal = 40%                      23.37%          10.71%         20.41%         18.83%          4.82%          0.07%        28.70%          14.91%
Fixed Expenses                                      156,338.00      165,014.00     203,839.00     225,351.50     162,878.80     168,179.00    135,195.00      178,448.00
Interest Expense                                     22,371.00       29,629.00      20,323.00      16,735.00      22,533.40      23,316.00     20,721.00          26,090
Net Profit (Loss)                                    (3,855.05)    (108,996.00)   (105,884.13)   (174,721.48)   (169,890.43)   (191,296.86)       741.35     (121,150.04)
Principal repayment                                   8,679.75       27,146.25      21,912.07      16,830.63      30,195.90       4,023.15     17,221.28       30,892.55

Weighted Avg. Selling Price-Year-to-Date $8.50             7.50           7.54           7.66           7.73         10.42            9.37           8.98           8.92
                 Line of Credit
Beginning LOC balance                              1,494,340.87 1,217,037.86      785,079.96     664,667.96     626,461.64     777,248.84     793,317.16     952,860.43

Deposits received                                    891,108.45   982,160.78       521,496.33     523,226.05     440,512.00     304,862.59     328,101.36     590,715.83
Beginning Uncollected Deposits & Dep. In Transit     320,894.51   367,361.37       183,672.63     167,732.09     152,277.80     106,326.10      59,383.83      52,042.53
Total deposits                                     1,212,002.96 1,349,522.15       705,168.96     690,958.14     592,789.80     411,188.69     387,485.19     642,758.36
Ending Ledger Balance                               (306,859.68) (300,554.77)     (143,955.19)   (163,487.51)   (118,032.08)    (90,856.43)    (91,766.63)    (50,677.15)
Deposits In-Transit                                  (13,711.83)  (60,552.55)      (23,743.11)    (13,307.34)     (8,221.43)    (12,018.99)    (12,569.48)          0.00
Deposits Collected                                  (843,176.66) (988,414.83)     (537,470.66)   (514,163.29)   (466,536.29)   (308,313.27)   (283,149.08)   (592,081.21)
Uncollected Deposits & Deposits In-Transit           368,826.30   361,107.32       167,698.30     176,794.85     126,253.51     102,875.42     104,336.11      50,677.15
Beginning Outstanding Checks                         (43,170.66)  (54,857.79)      (48,988.42)   (115,715.86)    (68,092.24)    (43,532.97)    (28,232.73)    (44,988.09)
Checks Issued:
 Payroll & benefits                                 (162,358.48)   (215,880.84)   (186,003.92)   (159,156.81)   (200,153.64)   (165,250.37)   (161,760.13)   (218,131.47)
 Inventory Purchases                                (179,775.58)    (55,092.03)   (139,251.86)    (91,617.47)   (144,784.88)    (85,175.10)   (197,482.62)   (208,167.24)
 Debt service - interest                              (2,528.67)    (47,739.50)    (10,700.47)    (18,095.14)    (37,736.91)     (1,941.79)    (21,330.94)    (29,127.58)
 Debt service - principal                               (772.55)    (79,154.43)     (3,935.20)    (13,646.43)    (30,195.90)       (786.43)    (17,194.32)    (20,781.68)
 Insurance                                                 0.00      (7,618.00)          0.00           0.00           0.00           0.00           0.00           0.00
 Utilities                                           (11,129.27)    (12,736.04)    (10,438.56)     (9,097.15)    (17,712.72)     (5,311.33)     (8,763.23)    (16,857.33)
 Royalties                                           (15,745.59)    (13,486.90)    (11,805.42)    (10,558.39)     (1,610.79)     (5,006.84)     (6,032.29)          0.00
 Commissions                                         (46,887.75)    (30,907.53)    (30,166.76)    (29,554.99)    (29,094.75)    (20,652.72)    (19,909.94)     (5,109.25)
 Other                                               (73,239.13)    (87,972.29)    (91,483.91)    (96,606.97)   (131,474.63)    (24,956.77)    (26,974.24)   (123,956.19)
Total checks issued                                 (492,437.02)   (550,587.56)   (483,786.10)   (428,333.35)   (592,764.22)   (309,081.35)   (459,447.71)   (622,130.74)
Total Payments                                      (535,607.68)   (605,445.35)   (532,774.52)   (544,049.21)   (660,856.46)   (352,614.32)   (487,680.44)   (667,118.83)
Less: Checks cleared                                 480,749.89     556,456.93     417,058.66     475,956.97     617,323.49     324,381.59     442,692.35     611,971.54
Ending outstanding checks                             54,857.79      48,988.42     115,715.86      68,092.24      43,532.97      28,232.73      44,988.09      55,147.29


Bank LOC balance (Beg. LOC, plus deps.
 collected, - checks cleared, +/- ledger bal.)     1,217,037.86    785,079.96     664,667.96     626,461.64     777,248.84     793,317.16     952,860.43     972,750.76
HGS LOC balance (Bank + o/s cks - uncoll. dep.)    1,222,164.81    790,591.59     752,881.36     657,988.66     810,240.88     814,459.64     945,805.99     977,220.90
Present Availability                                    296,930      487,721        523,809        414,838        195,940        220,291        193,335      129,888.67




                                                                                     Page 2
                                                  Month of       Month of       Month of        Month of    Month of     Month of     Month of     Month of
                                                   June           July          August         September    October      November     December     January
            IV. Productivity Management
Print Units Produced:
   Customer                                           67,253         64,897         46,091         28,332       20,165       30,400       41,228       60,297
   Proofing                                            1,076            852             85            161          262          624          648          266
   Samples                                                 0          1,753            263             42           25          241          625          300
Total Print Units Produced                            68,329         67,502         46,439         28,535       20,452       31,265       42,501       60,863
Total Labor Hours Worked - Print                    2,223.90       2,983.44       2,354.60       2,046.10     1,901.20     1,787.20     1,864.95     2,088.53
Total Units Produced Per Labor Hour                    30.72          22.63          19.72          13.95        10.76        17.49        22.79        29.14

Total Impressions                                    87,888         82,261         61,596          38,798      27,703       33,779       56,773       81,755
Average Impressions Per Unit                           1.29           1.22           1.33            1.36        1.35         1.08         1.34         1.34
Total Impressions Prod. Per Labor Hr.                 39.52          27.57          26.16           18.96       14.57        18.90        30.44        39.14
Average Impressions Per Order                                                                                   63.23       134.86       206.45       256.28
Number of Setups                                             0              0              0         279          323          254          298          333
Average Number of Units Per Setup                                                                  102.28       63.32       123.09       142.62       182.77

Screens Produced                                       2,250          2,772          2,107          2,318       2,112        1,622        1,821        2,336
Total Labor Hours Worked - Screen                   1,147.00       1,218.05       1,025.40         877.60      858.55       740.05       758.20       976.90
No. of Screens Prod. Per Labor Hour                     1.96           2.28           2.05           2.64        2.46         2.19         2.40         2.39

Total Print Machine Hours Scheduled                     785            916            564             527         441          428          550          625
Total Print Machine Hours - Customer                 583.15         634.50         458.90          429.60      321.99       267.06       350.67       462.92
% Print Machine Hours on Customer Orders             74.33%         69.26%         81.37%          81.55%      73.09%       62.35%       63.77%       74.04%

Embroidery Units Produced:
   Customer                                            7,922          8,284         5,354           5,011       5,812        2,947       10,821       12,723
   Proofing                                               81              9             1               1           0           17           60            0
   Samples                                                 0            525            92              43          87          201          331          114
Embroidery Units Produced                              8,003          8,818         5,447           5,055       5,899        3,165       11,212       12,837
Total Labor Hours Worked - Embroidery               1,423.90       1,436.88        947.20          726.90      765.80       623.95       890.55       997.02
Total Units Produced Per Labor Hour                     5.62           6.14          5.75            6.95        7.70         5.07        12.59        12.88

Total Stitches Produced                           46,421,773     64,015,926     45,672,454     40,421,364   53,193,916   23,801,347   85,244,290   98,439,922
Average Stitch Count                                   5,801          7,260          8,385          7,996        9,017        7,520        7,603        7,668
Total Stitches Produced Per Labor Hr.              32,601.85      44,552.03      48,218.38      55,607.87    69,461.89    38,146.24    95,720.95    98,734.15

Total Embroidery Machine Hours Scheduled                245            535            280             289         273          159          454          551
Total Embroidery Machine Hours - Customer            210.82         472.33         254.38          254.06      254.75       121.40       412.30       509.84
% Embr. Machine Hours on Customer Orders             86.05%         88.29%         90.72%          87.97%      93.47%       76.31%       90.81%       92.50%

Total Labor Hours Worked - Shipping & Finishing        1,570          1,847          1,585          1,338        1,288        1,351         755       822.05
Total Units Shipped Per Labor Hour                     62.46          47.61          35.22          27.27        22.70        27.63        73.64       91.94


                      V. Creative
Direct labor hours - Art
Direct labor sold
Ratio                                              #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!      #DIV/0!      #DIV/0!      #DIV/0!

Reimbursement invoiced - Art                           65.00        933.00        2,410.00          65.00        75.00      975.00          0.00     1,350.00




                                                                                  Page 3
              Weekly Ops Report
                                                     W/E            W/E            W/E              W/E             W/E            W/E
                                                   1/1/1999       1/8/1999      1/15/1999        1/22/1999       1/29/1999       2/6/1999
              I. Order Management
Beginning Order Backlog                          1,333,320.47 1,320,228.28 1,311,389.08 1,291,519.02 1,350,517.22 1,020,134.79
+ Orders Received                                    9,038.73    29,292.27    43,691.57   102,722.82    61,744.05    66,141.14
- Orders Shipped                                   (16,630.92)  (33,204.47)  (63,561.63)  (43,719.02) (379,003.48)  (38,498.50)
- Canceled Orders                                   (5,500.00)   (4,927.00)        0.00        (5.60)  (13,123.00)        0.00
Ending Order Backlog                             1,320,228.28 1,311,389.08 1,291,519.02 1,350,517.22 1,020,134.79 1,047,777.43
Current Month Order Backlog                        120,328.00   398,033.00   342,731.00   319,951.00    10,601.00   585,234.00
Next Month Order Backlog                           822,078.00   519,281.00   546,989.00   589,174.00   554,689.00   202,244.00
Future Months Order Backlog                        377,822.00   394,075.00   401,799.00   441,392.00   454,903.00   260,299.00
% of Order Backlog due to Stockouts-Cur. Mo.            0.27%        0.17%        0.12%        0.12%        0.23%        0.41%
Customer Orders Beyond Due Date - Goal =10%         33,918.99    42,035.57    39,731.63     8,603.86    10,924.78    26,595.83
% of Orders Beyond Due Date-by Dollars                  2.57%        3.21%        3.08%        0.64%        1.07%        2.54%
% of Orders Beyond Due Date-by No. of Orders            3.90%        3.70%        4.30%        2.70%        5.10%        4.50%

                  Calls Received
Customer                                                  20             27                              37              52             51
Sales Rep                                                 12             27                              29              32             35
Office                                                    87            151                             205             253            224
 Total                                                   119            205                 0           271             337            310

Number of Orders Entered                                  23             43             87                 95            61             59
Number of New Custom Projects                              0              2              2                  0             0              6


              II. Inventory Management
Beginning Open Purchase Orders                    373,521.43     355,511.00     364,507.00       314,281.00      287,992.00     239,077.00
+ Purchase Orders Placed                                0.00      20,324.60      11,591.83        26,852.14       19,383.96      21,362.12
- Inventory Received                              (18,671.16)    (11,686.22)    (63,992.43)      (53,432.58)     (68,166.08)    (41,811.29)
- P.O.'s Canc., or Incompl./Closed or Overages        660.73         357.62       2,174.60           291.44         (132.88)      1,647.17
Ending Open Purchase Orders                       355,511.00     364,507.00     314,281.00       287,992.00      239,077.00     220,275.00
Fulfillment shortages                               63,698.00      62,288.00      44,423.00        27,030.00        5,487.00       7,939.00

Ending Inventory - $'s                           1,284,760.66   1,308,318.35   1,349,693.80     1,428,486.61    1,296,569.74   1,347,824.25
Ending Inventory - Units                             315,470        315,519        325,502          332,797         309,646        309,462
Cost Per Unit                                            4.07           4.15           4.15             4.29            4.19           4.36

Total Inventory Plus On Order                    1,640,271.66   1,672,825.35   1,663,974.80     1,716,478.61    1,535,646.74   1,568,099.25
Weekly Average Sales Prior Month                    79,508.50      79,508.50      79,508.50        79,508.50       79,508.50      79,508.50
Annualized Cost of Sales                         5,500,729.00   5,500,729.00   5,500,729.00     5,500,729.00    5,500,729.00   5,500,729.00
Weekly Average COM Year-to-Date                     62,453.25      62,453.25      62,453.25        62,453.25       62,453.25      62,453.25
Number of Weeks Supply - Goal = 17                      26.26          26.79          26.64            27.48           24.59          25.11
Inventory Turnover - Goal = 6                            4.28           4.20           4.08             3.85            4.24           4.08




                                                                                                  Page 4                                      4/18/2010 11:53 PM
                                                      W/E            W/E             W/E             W/E             W/E            W/E
                                                    1/1/1999       1/8/1999       1/15/1999       1/22/1999       1/29/1999       2/6/1999
               III. Cash Management
          Accounts Receivable & Payable
Beginning accounts receivable                      717,881.75     667,425.03      635,581.68       642,258.45      462,184.12    699,672.33
Invoices for week                                   16,353.69      34,714.88       56,937.03        52,625.20      381,508.68     37,215.10
Cash received                                      (66,810.41)    (66,691.09)     (54,216.14)     (230,768.81)    (143,545.77)   (60,800.67)
Credits/discounts/finance charges                        0.00         132.86        3,955.88        (1,930.72)        (474.70)       (56.04)
Ending accounts receivable                         667,425.03     635,581.68      642,258.45       462,184.12      699,672.33    676,030.72

Current                                            500,003.47     462,833.52      458,087.95      236,997.37      589,286.04     599,140.43
1 to 30 days past due                              144,691.29     149,330.78      152,068.81      158,333.64       45,736.49      46,120.38
31 to 60 days past due                              13,796.57      12,231.11       22,122.68       57,095.85       54,474.08      19,334.36
Over 60 days past due                                8,934.00      11,186.27        9,979.01        9,757.26       10,175.72      11,435.55
% over 60 days past due                                 1.34%          1.76%           1.55%           2.11%           1.45%          1.69%

Accounts Payable Balance                              249,912        293,624         302,331         257,616         328,536        303,288
Accounts Payable Days Outstanding                        16.6           19.5            20.1            17.1            21.8           20.1
              Profitability Management
Sales, Wholesale plus Retail                         18,427.10      34,164.85       77,077.11       49,953.16     379,003.48       38,498.50
Less: Discounts, returns & allowances                   (26.51)       (563.55)         160.12            0.00        (163.10)           0.00
Cost of Merchandise                                   8,280.27      15,120.59       34,756.75       22,478.92     170,478.17       17,324.33
Direct Labor                                         26,954.00      26,954.00       26,954.00       26,954.00      26,954.00       26,954.00
Variable Costs                                       17,752.00      17,752.00       17,752.00       17,752.00      17,752.00       17,752.00
Variable Profit                                     (34,585.68)    (26,225.29)      (2,225.52)     (17,231.76)    163,656.21      (23,531.83)
Contribution Margin % - Goal = 40%                    -187.42%        -75.52%          -2.89%         -34.50%         43.16%         -61.12%
Fixed Expenses                                       35,689.60      35,689.60       35,689.60       35,689.60      35,689.60       35,689.60
Interest Expense                                      5,218.00       5,218.00        5,218.00        5,218.00       5,218.00        5,218.00
Net Profit (Loss)                                   (75,493.28)    (67,132.89)     (43,133.12)     (58,139.36)    122,748.61      (64,439.43)
Principal repayment                                   6,178.51       6,178.51        6,178.51        6,178.51       6,178.51        6,178.51

Weighted Avg. Selling Price-Year-to-Date $8.50            9.00           9.00            8.83            8.81            8.92           8.92
                  Line of Credit
Beginning LOC balance                              952,860.43     937,823.36     1,027,285.99    1,058,918.94    1,092,374.92    972,750.76

Deposits received                                    68,147.22      67,596.05       71,859.71      238,717.93      144,394.92      61,087.45
Beginning Uncollected Deposits & Dep. In Transit     52,042.53       6,903.23       13,038.92       29,911.82      172,537.97      50,677.15
Total deposits                                      120,189.75      74,499.28       84,898.63      268,629.75      316,932.89     111,764.60
Ending Ledger Balance                                (6,037.09)    (12,956.72)     (19,697.64)    (172,537.97)     (50,677.15)     (2,937.77)
Deposits In-Transit                                    (866.14)        (82.20)     (10,214.18)           0.00            0.00           0.00
Deposits Collected                                 (113,286.52)    (61,460.36)     (54,986.81)     (96,091.78)    (266,255.74)   (108,826.83)
Uncollected Deposits & Deposits In-Transit            6,903.23      13,038.92       29,911.82      172,537.97       50,677.15       2,937.77
Beginning Outstanding Checks                        (44,988.09)   (106,254.70)     (55,526.84)    (111,262.30)    (107,171.85)    (55,147.29)
Checks Issued:
 Payroll & benefits                                 (34,262.11)    (54,749.95)     (46,995.12)     (49,436.95)     (32,687.34)    (31,357.60)
 Inventory Purchases                                (51,362.01)    (34,684.91)     (65,843.71)     (48,120.43)      (8,156.18)    (76,377.38)
 Debt service - interest                            (19,530.85)                       (407.16)                      (9,189.57)    (12,425.04)
 Debt service - principal                           (16,698.74)                       (792.06)                      (3,290.88)    (13,374.55)
 Insurance
 Utilities                                           (5,590.68)                     (3,704.56)      (1,469.11)      (6,092.98)
 Royalties                                           (1,500.00)      1,500.00
 Commissions                                                                                                        (5,109.25)
 Other                                              (30,571.67)    (12,260.27)     (24,612.61)     (26,430.82)     (30,080.82)     (7,410.06)
Total checks issued                                (159,516.06)   (100,195.13)    (142,355.22)    (125,457.31)     (94,607.02)   (140,944.63)
Total Payments                                     (204,504.15)   (206,449.83)    (197,882.06)    (236,719.61)    (201,778.87)   (196,091.92)
Less: Checks cleared                                 98,249.45     150,922.99       86,619.76      129,547.76
                                                                                                    Page 5         146,631.58      95,409.65    4/18/2010 11:53 PM
                                                     W/E             W/E            W/E            W/E            W/E           W/E
                                                   1/1/1999        1/8/1999      1/15/1999      1/22/1999      1/29/1999      2/6/1999
Ending outstanding checks                          106,254.70       55,526.84    111,262.30     107,171.85      55,147.29     100,682.27
Bank LOC balance (Beg. LOC, plus deps.
 collected, - checks cleared, +/- ledger bal.)      937,823.36   1,027,285.99   1,058,918.94   1,092,374.92    972,750.76      959,333.58
HGS LOC balance (Bank + o/s cks - uncoll. dep.)   1,037,174.83   1,069,773.91   1,140,269.42   1,027,008.80    977,220.90    1,057,078.08
Present Availability                                  166,926          15,182          7,028       (123,327)     129,889         145,168
Availability Per Bank                                                118,909          87,276         53,820      173,444         186,861
             IV. Productivity Management
Print Units Produced:
   Customer                                             8,548         12,804          7,155         12,526        19,264          15,565
   Proofing                                                51             45             29             96            45               0
   Samples                                                168            104              7              7            14              40
Total Print Units Produced                              8,767         12,953          7,191         12,629        19,323          15,605
Total Labor Hours Worked - Print                       385.98         434.00         280.30         463.25        525.00          493.40
Total Units Produced Per Labor Hour                     22.71          29.85          25.65          27.26         36.81           31.63

Total Impressions                                      10,345         15,406         10,036         18,021        27,947          18,147
Average Impressions Per Unit                             1.18           1.19           1.40           1.43          1.45            1.16
Total Impressions Prod. Per Labor Hr.                   26.80          35.50          35.80          38.90         53.23           36.78
Average Impressions Per Order                          164.21         173.10         156.81         305.44        481.84          283.55
Number of Setups                                        63.00          89.00          64.00          59.00         58.00           64.00
Average Number of Units Per Setup                         139            146            112            214           333             244

Screens Produced                                         388            739            434            415           360             418
Total Labor Hours Worked - Screen                      158.55         171.60         177.25         220.65        248.85          253.85
No. of Screens Prod. Per Labor Hour                      2.45           4.31           2.45           1.88          1.45            1.65

Total Print Machine Hours Scheduled                      103.2            152            116            124            130            112
Total Print Machine Hours - Customer                     81.26         110.87          77.98          86.81            106          89.27
% Print Machine Hours on Customer Orders               78.74%         72.94%         67.22%         70.01%         81.54%         79.71%

Embroidery Units Produced:
   Customer                                             2,156          2,884          2,227           2,651         2,805          2,099
   Proofing                                                 0              0              0               0             0              0
   Samples                                                 71              6              0              37             0              0
Embroidery Units Produced                               2,227          2,890          2,227           2,688         2,805          2,099
Total Labor Hours Worked - Embroidery                   163.77         166.95          280.3             179           207          193.3
Total Units Produced Per Labor Hour                     13.60          17.31           7.95           15.02         13.55          10.86

Total Stitches Produced                            12,237,723     23,332,643     19,828,245     25,430,783     17,610,528     20,327,723
Average Stitch Count                                    5,495          8,074          8,904          9,461          6,278          9,684
Total Stitches Produced Per Labor Hr.               74,725.06     139,758.27      70,739.37     142,071.41      85,075.01     105,161.53

Total Embroidery Machine Hours Scheduled                  91.2            120            100            120            120            104
Total Embroidery Machine Hours - Customer                80.13         118.25          95.59         115.33         100.54             96
% Embr. Machine Hours on Customer Orders               87.86%         98.54%         95.59%         96.11%         83.78%         92.31%

Total Labor Hours Worked - Shipping & Finishing          119.8         139.45         195.85         176.40        190.55          191.35
Total Units Shipped Per Labor Hour                      92.45         114.19          50.01          86.93        116.22           92.62

Preproduction Labor Hours Worked                         61.45          92.95          117.3         107.05         109.1           101.7




                                                                                                 Page 6                                     4/18/2010 11:53 PM
                                         W/E           W/E            W/E           W/E           W/E           W/E
                                       1/1/1999      1/8/1999      1/15/1999     1/22/1999     1/29/1999      2/6/1999
Raw Goods Units Received                     7,324        10,278        15,476        12,039        10,919          5,866
Garment units pulled & transferred          10,340        16,143         7,134        25,023        15,877         14,186
Garment units audited                         119           205           117           369            78            702
Embroidery units pre-inspected                945           655           661              0             0             0
Total units handled                        18,728        27,281        23,388        37,431        26,874         20,754
Total Labor Hours Worked - Receiving       110.25        121.80        160.00        117.40        120.40         120.50
Total Units Handled Per Labor Hour         169.87        223.98        146.18        318.83        223.21         172.23

                      V. Creative
Direct labor hours - Art
Direct labor sold
Ratio                                  #DIV/0!       #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!

Reimbursement invoiced - Art                 0.00          0.00          0.00      1,350.00          0.00           0.00

                    VI. Retail
Sales Dollars                           1,796.18        960.38      13,515.48      6,234.14          0.00          0.00
Sales Units                                 176             81          2,206         1,016             0             0
Average Selling Price                      10.21         11.86           6.13          6.14     #DIV/0!       #DIV/0!

Retail Labor Hours Worked                  81.73         55.29          79.42         87.86         11.05          0.00
Sales Dollars per Labor Hour               21.98         17.37         170.18         70.96          0.00     #DIV/0!

Units on Hand                             18,049        18,174         16,083        15,097               0             0




                                                                                 Page 7                                     4/18/2010 11:53 PM
           WEEKLY CASH FLOW                                                         HAS NOT BEEN UPDATED SINCE FOR P & I CHANGES
           FY99 Operating Budget

                                              12/4/1998 12/11/1998    12/18/1998     12/25/1998     DEC        1/1/1999    1/8/1999    1/15/1999 1/22/1999 1/29/1999
                                                                                                                                                   4/18/2010 11:53 PM     JAN
                  Receipts
Wholesale Sales Receipts                        87,041     54,000         70,757         73,296    285,094     109,987       67,265      76,045     66,539    103,816    430,000
Retail Sales Receipts                            4,600      6,250          6,250          6,250     23,350       1,440        1,440       1,440      1,440      1,440     23,000
 Total Receipts                                 91,641     60,250         77,007         79,546    308,444     111,427       68,705      77,485     67,979    105,256    453,000

                Disbursements
Garment Inventory                              105,680     13,000         40,008              0    158,688       84,914      45,000      55,000     71,000     23,000    230,000
Principal Payments- Notes & Leases                                                                       0       19,075          31         751                           19,857
Interest Payments-Notes & Leases                36,996        483          1,529              0     39,008       18,354         451         778                 6,229     25,812
Capital Expenditures                                                                                     0                                                                     0
Payroll & Employee Benefits                     46,871     32,000         52,000         32,000    162,871       33,000      66,200      34,000     53,000     34,000    220,200
Operating Supplies/Expenses - Print (Other)      3,613      9,200         10,000          2,000     24,813        8,000       8,000       6,000      8,000     10,000     80,000
Operating Supplies/Expenses - Art                                         26,253                    26,253                               22,300
Operating Supplies/Expenses - Sales & Mkt.                                                1,500      1,500                                1,000      1,500
Operating Supplies/Expenses - Admin.                                       1,200                     1,200                                7,500
Operating Supplies/Expenses - Retail                                                      6,812      6,812        3,051
Property Taxes                                                                                           0
Property & Casualty Insurance                                                                            0        6,408                                                    6,408
Restructuring                                               3,000                                    3,000                                                                13,000
  Total Disbursements                          193,160     57,683        130,990         42,312    424,145     172,802     119,682      127,329    133,500     73,229    595,277


Net Increase (Decrease) in Cash               (101,519)      2,567       (53,983)        37,234    (115,701)    (61,375)    (50,977)    (49,844)   (65,521)    32,027    (142,277)

LOC Advances (Payments)                         59,011      (2,567)       53,983        (37,234)   115,701       61,375      50,977      49,844     65,521    (32,027)   142,277

Ending LOC Balance                             852,328    849,761        903,744        866,510    952,860 1,014,235 1,065,212 1,115,056 1,180,577 1,148,550 1,095,137


A/R                                            361,600                                            564,496                                                               572,000
Inventory                                      592,486                                            600,211                                                               540,175
Borrowing Base                                 954,086                                          1,164,707                                                             1,112,175
Net Availability                               101,758    104,325         50,342         87,576   211,847      150,472       99,495      49,651    (15,870)    16,157    17,038
           WEEKLY CASH FLOW
           FY99 Operating Budget

                                              2/5/1999     2/12/1999 2/19/1999 2/26/1999      FEB         MAR        4/18/2010 11:53 PM
                  Receipts
Wholesale Sales Receipts                        59,060       25,546    244,770      83,311    560,000    268,000
Retail Sales Receipts                            3,200        3,200      3,200       3,200                48,000
 Total Receipts                                 62,260       28,746    247,970      86,511    560,000    316,000

                Disbursements
Garment Inventory                                                                             180,000    183,000
Principal Payments- Notes & Leases                                                             18,288     18,743
Interest Payments-Notes & Leases                27,274                                         26,798     24,525
Capital Expenditures                                                                                0
Payroll & Employee Benefits                                                                   157,400    146,300
Operating Supplies/Expenses - Print (Other)                                                    80,000     51,000
Operating Supplies/Expenses - Art                                                                   0
Operating Supplies/Expenses - Sales & Mkt.       3,400                                              0     30,000
Operating Supplies/Expenses - Admin.                                                                0
Operating Supplies/Expenses - Retail                                                                0
Property Taxes                                                                                      0
Property & Casualty Insurance                                                                       0          0
Restructuring                                                                                  11,570      5,000
  Total Disbursements                           30,674            0           0          0    474,056    458,568


Net Increase (Decrease) in Cash                 31,586       28,746    247,970      86,511     85,944    (142,568)

LOC Advances (Payments)                         (31,586)    (28,746)   (247,970)   (86,511)   (85,944)   142,568

Ending LOC Balance                            1,063,551 1,034,805      786,835     700,324 1,009,193 1,151,761


A/R                                                                                          692,000   917,600
Inventory                                                                                    501,925   488,750
Borrowing Base                                                                             1,193,925 1,406,350
Net Availability                                48,624       77,370    325,340     411,851   184,732   254,589

				
DOCUMENT INFO