Docstoc

Cost estimator spreadsheet _Excel file_ - MarketingSherpa Home

Document Sample
Cost estimator spreadsheet _Excel file_ - MarketingSherpa Home Powered By Docstoc
					                                                    Please enter your fulfillment assumptions starting at cel D3--you can then
EFulfillment Service, Inc.                          view the resulting fulfillment cost estimate below. If you have more than
                                                    2,000 orders per month or have questions about the specifics of your project,
Cost Estimator Kit                                  please contact John Lindberg at 231-276-5057, #100 or email
                                                    jal@efulfillmentservice.com. Thank you!

             How many SKUs will we be managing for you?             15       Number of unique product #s that each require a pick/pack bin.
        About how many orders do you expect per month?             250       Enter Estimated Total Orders Per Month.
                  How many items will be in a typical order?       2.0       Enter Average Quantity Of Items Per Shipment.
     How many return shipments will you have per month?              5       Number Of Returns Per Month--Or Zero If Service Not Needed.
           How many items per each return-on average?              1.0       Enter Average Quantity Of Items Per Return--Or Zero.
   About how many assembly labor hours will be needed?                       To estimate your assembly labor hours per month, divide your
                                                                             monthly assembly requirement by your estimate of production
                                                                             per employee hour. For example, if you need 1,000 kits per
                                                                   5.0       month at 25 kits per employee hour, your assembly cost will be
                                                                             based on 1,000 divided by 25 per hour or 40 employee hours
                                                                             per month. Enter zero if assembly services are not needed.
About how many pallets will be needed to store your inventory?               Enter an estimate of the average number of 4'x4'x4' pallets
                                                                             required to store your products as of the last day of a typical
                                                                             month. At your option, we can convert to a storage fee based
                                                                     2       on individual items. For example, we store books based on
                                                                             $10 per pallet or based on $.01 per book. The per unit
                                                                             approach could save you considerable expense if you have a
                                                                             lot of SKUs with small quantities per SKU to be stored.

    What is your best estimate of per order shipping cost?                   Please note our shipping cost comparison chart below or visit
                                                                             www.ups.com , www.usps.com, www.fedex.com or
                                                                 $3.25       www.intershipper.com for additional details. Don't forget to use
                                                                             our warehouse zip code--49637--as your ship from location.

         What is your estimated per order packaging cost?                    You can supply your own packaging--we suggest
                                                                             www.ulline.com as a cost effective supplier--or we can supply
                                                                 $0.35       one of our stock Jiffy bags or boxes at discounted cost based
                                                                             on our volume purchasing. Call John Lindberg at 231-276-
                                                                             5057, #100 for cost savings suggestions.

                                                    Monthly Cost Per Cost Per
Projected Fulfillment Cost                                                                    Comment
                                                     Usage   Order    Month
        Shipping Fee Based On Number Of Orders          250     $2.00 $500.00                 Based On $1.20 or $2.00 Base Fee Per Order.
        Plus Shipping Fee Based On Items Packed         250     $0.60 $150.00                 Plus $.30 Per Item Shipped Each Order.
       Estimated UPS/USPS/FedEx Cost Per Order          250     $3.25 $812.50                 Projected Average Ship Cost Per Order.
                 Estimated Special Packaging Cost       250     $0.35  $87.50                 Use Your Packaging Or Ours.
                                                                                              This estimate is based on typical rates for books,
                                                                                              tapes, diet supplements, consumer electronics and
                             Estimated Fulfillment Cost           $6.20       $1,550          so forth. Call John Lindberg at 231-276-5057, #100
                                                                                              for a quotation specific to your project.

Projected Storage Cost Per Month                     Usage         Cost     Per Month
         Basic Monthly Storage/Administration Fee            1       $48.50     $48.50 Basic Administration Fee Per Month.
    Storage Fee-Based On Pallets At End Of Month             2       $10.00     $20.00 No Receiving Or Stock Moving Fees.
                                                                                              Storage fee can be charged on a per pallet
                                           Estimated Storage Cost                $69          basis(1 SKU per pallet) or as individual items
                                                                                              based on physical volume--at your option.

Optional Services Cost Per Month                     Usage         Cost     Per Month
                    Returns Processed Per Month              5        $2.00     $10.00 Optional Returns Fee-Per Return Order.
                Return Items Processed Per Month             5        $0.30      $1.50 Optional Returns Fee-Per Item Returned.
     Optional Assembly Employee Hours Per Month              5       $25.00   $125.00 Optional Assembly Service.
                                                                                              Returns can be directed to you or to us at your
                                Estimated Optional Services Cost                $137          option. Likewise, you can do your own pre-sale
                                                                                              assembly or we can do it for you.




                                                       Page 1 of 3
One-Time Project Set Up Cost                              Usage         Cost              Total
                                 Basic System Set Up             1        $99.00         $99.00 Basic One Time Fee
                           Additional Set Up Per SKU            15         $1.00         $15.00 Addl Per SKU

                                                  One-Time Set Up Cost                 $114

                                                        To begin the account set up process, please complete the following
Account Set Up                                          questionnaire including the above cost estimate section, then email

Questionnaire                                           the entire spreadsheet as an attachment to John Lindberg at
                                                        jal@efulfillmentservice.com.
                                Company Name            Please Overtype All Green Text
                                Billing Address         Enter Your Billing Address Here
                                     Billing City       Enter Your Billing City
                                    Billing State       Billing State
                                       Billing Zip      Billing Zip
                               Ship To Address          Ship To Address-Used If We Ship Product To You
                                    Ship To City        Ship To City
                                   Ship To State        Ship To State
                                     Ship To Zip        Ship To Zip
                                Contact Person          Primary Contact Person
                            Contact Person Title        Job Title
                             Contact Telephone          Phone Number
                            Contact Fax Number          Fax Number
                                 Company URL            Company URL Address Here.
                                  Contact Email         General Email Address Here.
                       Order Confirmation Email         Order Confirmation Email Address.
         Enter Your Company Credit Card Type:           Enter Visa, MasterCard, Discover or AmExpress Here.
          Name As Shown On Credit Card Face:            Enter Authorized Credit Card Holder Name Here.
      Enter Your Company Credit Card Number:            Enter Credit Card Number Here.
     Enter Your Company Credit Card Exp Date:           Enter Your Credit Card Exp Date Here.
          Enter Credit Card Address, If Different:      Enter CC Billing Address, If Different Than Above.
            How did you find us on the Internet?        Enter search engine or other referral source.
                Please describe your business?          What to you sell and how do you market your products? Which webstore or shopping
                                                        cart system do you use. Do you also sell via online auctions? Do you use pay-per-
                                                        click or broadcast email systems?
What will be the primary means of sending orders? Enter: Shopping Cart, Emails, Fax, Files--Combination?
Will you receive orders via a telephone cell center? Enter Yes or No
      If yes, how will these orders be processed? If yes, enter the call center name, contact person's name and phone number here.
                                                        Ask the call center to process your credit card payments and email ship instructions
                                                        to us at orders@efulfillmentservice.com.
  How many orders will we receive per month?            Enter Typical Number of Orders Per Month Here.
    How many items will be shipped per order?           Enter Average Number Of Items Per Order Here.
               Who will be the primary carrier?         Enter UPS, FedEx, USPS or Cheapest.
  What will be the primary shipping rate used?          Enter Media Mail, Priority Mail, UPS Ground, Etc.
    When will you ship your initial stock to us?        Enter Your Planned Stock Shipping Date Here.
  How Many SKUs will you send to us initially?          Enter Number Of SKUs In First Shipment Here.
How many units will you send in first shipment?         Enter Total Quantity Of Items In First Shipment Here.
  How will you send your first shipment to us?          Enter UPS, USPS or Prepaid Truck Freight Here. If you are using truck freight and
                                                        your carrier offers less than a 30% discount, use our free discount service as
                                                        described at www.efulfillmentservice.com/setup.htm.



                                                           Page 2 of 3
                When will orders begin to arrive ?                Enter Order Start Up Date Here--Estimate OK.
   Will you provide your own special packaging?                   Enter Yes or No
   If you are providing special packaging, please                 If yes, please enter a description and initial quantities for each special packaging
                                        describe:                 item here. If you want us to purchase packaging for you at cost plus 10%, please list
                                                                  vendors, item numbers and costs.
                        Will EFS process your returns? Enter Yes or No
                    If yes, please provide instructions: If yes, please provide any special return processing instructions such as sorting,
                                                                  disposal of damaged stock, refurbishing of damaged stock, your return contact
                                                                  person for issuance of return credits, plus email address, fax and phone numbers.

                       If no, enter your return address: If no, enter the address that customers should return to, if not to EFS--list a phone
                                                                  number or email address to be used for a return authorization, if desired.

     Do you want EFS to assemble your product? Enter Yes or No
      If yes, please provide assembly instructions Please outline your assembly requirements here and send us a master sample of
                                             here. each assembled item. Typical assembly projects include tape/literature kits,
                                                                  repacking from bulk to boxes, inspection and testing, and refurbishing of damaged
                                                                  products. Initial service billing is based on $25 per employee-hour, however when we
                                                                  have time studied your project, we will convert to a price per piece. Send your master
                                                                  sample(s) to EFS Assembly Department, 6893 Sullivan Road, Grawn, MI 49637.

              Any general instructions or comment? Please enter any general instructions or comments here.




Click on red arrow cell below for details about the SKU set up process.

Product Database
                                                                  USE UPPER CASE ONLY         Size-Color-Comment Field
Enter Product Description Below -- Limit To 30 Characters Only.
                                                                  20 CHARACTERS               Limit To 30 Characters Only.

DESCRIPTION LINE 1-30 CHARACTER LIMIT                             SKU NUMBER                  DESCRIPTION LINE 2-30 CHARACTERS
DESCRIPTION LINE 1-30 CHARACTER LIMIT                             SKU NUMBER                  DESCRIPTION LINE 2-30 CHARACTERS
DESCRIPTION LINE 1-30 CHARACTER LIMIT                             SKU NUMBER                  DESCRIPTION LINE 2-30 CHARACTERS
DESCRIPTION LINE 1-30 CHARACTER LIMIT                             SKU NUMBER                  DESCRIPTION LINE 2-30 CHARACTERS
DESCRIPTION LINE 1-30 CHARACTER LIMIT                             SKU NUMBER                  DESCRIPTION LINE 2-30 CHARACTERS
DESCRIPTION LINE 1-30 CHARACTER LIMIT                             SKU NUMBER                  DESCRIPTION LINE 2-30 CHARACTERS
DESCRIPTION LINE 1-30 CHARACTER LIMIT                             SKU NUMBER                  DESCRIPTION LINE 2-30 CHARACTERS
DESCRIPTION LINE 1-30 CHARACTER LIMIT                             SKU NUMBER                  DESCRIPTION LINE 2-30 CHARACTERS
DESCRIPTION LINE 1-30 CHARACTER LIMIT                             SKU NUMBER                  DESCRIPTION LINE 2-30 CHARACTERS
DESCRIPTION LINE 1-30 CHARACTER LIMIT                             SKU NUMBER                  DESCRIPTION LINE 2-30 CHARACTERS
DESCRIPTION LINE 1-30 CHARACTER LIMIT                             SKU NUMBER                  DESCRIPTION LINE 2-30 CHARACTERS
DESCRIPTION LINE 1-30 CHARACTER LIMIT                             SKU NUMBER                  DESCRIPTION LINE 2-30 CHARACTERS
DESCRIPTION LINE 1-30 CHARACTER LIMIT                             SKU NUMBER                  DESCRIPTION LINE 2-30 CHARACTERS
DESCRIPTION LINE 1-30 CHARACTER LIMIT                             SKU NUMBER                  DESCRIPTION LINE 2-30 CHARACTERS
DESCRIPTION LINE 1-30 CHARACTER LIMIT                             SKU NUMBER                  DESCRIPTION LINE 2-30 CHARACTERS
Insert additional lines above--if needed--or attach a separate spreadsheet.


Contract Terms We function as your fulfillment service provider on a month to month basis--meaning you can terminate at
any time. We bill for our fees and shipping reimbursement weekly with payment via credit card or electronic funds transfer.
Complete details about the account set up process plus a complete summary of our policies and procedures are posted at
www.efulfillmentservice.com/setup.htm.




                                                                     Page 3 of 3

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:19
posted:2/25/2011
language:English
pages:3