Contest Excel service i need

Discussion in 'Design Contests' started by fl0w, Nov 1, 2012.

  1. #1
    I need someone with excel service to help me.

    I need a stock and invetory excel spread-sheet for a small retail-shop.

    It will record all stock currently in the retail shop when someone buys something everything is auotmatically update (e.g the inventory list is reduced significantly).

    The spreadsheet will also alert me when to place order for new stock when i reach a threshold quantity.

    It should also calculate profiit etc...

    any excell experts PM with your offer ?
     
    fl0w, Nov 1, 2012 IP
  2. GFX2

    GFX2 Well-Known Member

    Messages:
    764
    Likes Received:
    80
    Best Answers:
    8
    Trophy Points:
    125
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    Sent you a PM :)
     
    GFX2, Nov 2, 2012 IP
  3. fl0w

    fl0w Active Member

    Messages:
    113
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    53
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #3
    Basically what i need the spreadsheet will be something as i described below:

    VLookup will connect the quantity with the warnings in second worksheet for inventory.

    I need to data validate the item sold in the daily sales worksheet, instead for me to type the word i will only click on the drop-down list,

    e.g when someone buys butter instead of me typing butter i will just click the drop-down list and it will automatically bring the name of the item (butter) and I will enter the quantity sold which is 1 , as soon as i enter the quantity it will automatically calculate the amount and the profit. This calculation will also connect to sheet 2 of the inventory which it will also be updated.

    I need the layout to be like this below, it is the daily sales record spreadsheet.

    SHEET1
    [​IMG]


    The second worksheet layout should at least contain these below, it is the worksheet which contains the inventory list which will alert if need to re-order stock (re-stock). When item 1 butter is sold as recorded in sheet one the sheet 2 also is updated. Quantity left will be subtracted with Quantity sold so that we know if we need to re-stock. Obviously there will be a threshold amount of quantity that should be always left in stock.

    In Sheet2 the column wholesale price is there to calculate the profit in sheet1 Wholesale price less Retail Price = Profit

    [​IMG]
     
    fl0w, Nov 7, 2012 IP