+ Reply to Thread
Results 1 to 2 of 2

Small Retail Sales and Inventory Dashboard Template

  1. #1
    Registered User
    Join Date
    11-20-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    3

    Small Retail Sales and Inventory Dashboard Template

    Does anyone have a link to a template that would help me?

    Small Retail store, and the main things I am after are being being able to keep my stock with sub catgeories.

    Ie 80 jackets in 1 syle, 4 colours of 20 each and in various sizes. Have about 6 styles of jackets in total in various colours.


    I want to be able to simple add new stock without having to deal with adding fresh formulas each time. Every new month I currently have to link every item of stock in my inventory page to that new month. A PAIN!!!

    Some kind of dashboard to see sales results is also required.

    No need for tax, invoicing or customer details required.

    Any help appreciated. My current system is far too basic

    regards

    David

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Small Retail Sales and Inventory Dashboard Template

    Basic Inventory.xlsm

    Check the attached file for a starting point.. It displays current inventory, any amendments are automatically reflected in the current stock and a log of all amendments is kept on the transactions sheet.
    Elegant Simplicity............. Not Always

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 11-26-2013, 11:05 AM
  2. how do I set up a inventory sales template?
    By computer student in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-07-2005, 10:45 PM
  3. [SOLVED] Where do I find a template for a small office inventory/supplies
    By dleveau in forum Excel General
    Replies: 1
    Last Post: 09-28-2005, 05:05 PM
  4. Calculating Retail Price And Sales Tax Using The Round Function
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 07-10-2005, 01:25 AM
  5. [SOLVED] Computing Sales Tax and Retail Price from a number
    By Lani Jo in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-16-2005, 04:37 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1