Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

questionaire

VIEWS: 0 PAGES: 1

									          Stocklink Distribution Logistics Model
                                             Client Name              Sample
                                            Date Modelled                        21-Mar-01
Product profile
                         Number of live products on hand                              2,000
                        Number of lines split case picking                            1,200
                   Average number of stock units on hand                             40,000                                   133 pallets
                   Highest number of stock units on hand                             60,000                                   200 pallets
                    Average number of shippers per pallet                                30
                     Average number of units per shipper                              10.00
                                                                                                 -3 different than product profile
        Number of pallet spaces on average (1.2 -1.5 m3)                                 130 figures calculate
                           Typical Pick face length (MM)                                 390
                            Typical Pick face width (MM)                                 450
                           Typical Pick face height (MM)                                 400                                  0.07 m3
                                                Stockturn                                4.00
                                                                                                                                                                       Stocklink insure
                                   Average value per item                            $17.50                          $2,800,000 annual sales                             product? Y/N          N
                                                                                                                       160,000 annual sales units
Sales and Purchase Order
                                                                     Sales Orders                        Purchase Orders                          Sales                Purchases
    Average number of orders / purchase orders per week                                   420                                    25
                                                                                                                                                                                           lines per
  Average number of line items per order / purchase order                                    1                                       1                      420                    25 week
                                                                                                                                                                                           units per
      Average number of units per order / purchase order                                     7                                 122                        2,940                3,050 week
                                                                                                                                                                   split case parcels to
              What % orders shipped / received split case                                60%                                  10%                           504   pack per week
                                                                                                                                                                   full case parcels to
                What % orders shipped / received full case                               20%                                  70%                           168   ship per week
                                                                                                                                                                   pallets to pack per
              What % orders shipped / received full pallet                               10%                                  10%                           -     week
                                                                                                                                                                   ugly orders to wrap
                 What % orders shipped / received "ugly"                                  10%                                 10%                            42   per week
           Avergae number of containers (TEU) per week                                      1                                   1
                  Proportion of orders shipped in parcels                                100%
                  Proportion of orders shipped on pallets                                  0%
                                                                                                                                          Measurement (m3 for
                                                                        Number                      Weight (kgs for total order)              total order)
Average number and wt/m3 of parcels in parcel shipments                                   2.0                                7.90                         0.025
 Average number and wt/m3 of pallets in pallet shipments                                  -                                   -                             -
Sales Profile
                                                                                                                                                                    1,400 imbalance
                                                                                                 0 imbalance against stock turn           7,120 imbalance          against wkly receipt
                  Average number of units sold per annum                            160,000 figure                                       against wkly sales figure figures
                                                                                                 0 imbalance against stock turn
                                Annual sales $ per annum                         $2,800,000 figure
                                                                  Monthly Sales splits
                                                   January                               5.0%                              July                            9.0%
                                                  February                               7.0%                           August                             9.0%
                                                    March                                9.0%                        September                             9.0%
                                                      April                              9.0%                          October                             9.0%
                                                       May                               9.0%                        November                              9.0%
                                                      June                               9.0%                        December                              7.0%             100.00%
                                                                  Weekly sales splits
                                                   Week 1                               40.0%
                                                   Week 2                               25.0%
                                                   Week 3                               15.0%
                                                   Week 4                               20.0%                             100.0%
                                                               Distribution demographics
                                                 Auckland                               40.0%
                              North Island North of Taupo                               15.0%
                              North Island South of Taupo                               25.0%
                                   South Island Overnight                                4.0%
                                        South Island 2 day                              16.0%                             100.0%
General
                            Dedicated floor space required                                  0 m2
                                     Current staffing levels                                0
                Building leased or owned and lease expiry                                   0
                          Estimated annual packaging cost                                  $0




          cece2086-e2bb-4a3d-b13a-1a9c8ceced5e.xls                               Key Assumptions                                                                                           3/7/2012

								
To top