Inventory Tracker (Online)

Document Sample
Inventory Tracker (Online) Powered By Docstoc
					ABC, Inc.
Refresh when you first open Inventory ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Stock Unit

Name

Date

35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

nc.
Refresh when you first open the file and Save before exit. 2009/Q1 Current Qt. Transaction Qt. (negative if out) Final Qt. Safety Stock Level

C2
TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE

TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE

Date Inventory ID <= <= <= <= <= <= <= <= <= <= <= <= <= <= <= <= <= 0 Date Inventory ID Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <=

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID

<= <= <= <= <= <= <= <=

0 Date Inventory ID

Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <= Date Inventory ID <=

0 0 0 0 0 0 0 0

0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID 0 Date Inventory ID

SKU LIST
#
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Inventory ID

Name

Initial Stock

Stock Unit

Safety Stock Level
FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE

TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE

TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE

Follow the steps to enable your online Inventory Tracker.
1) 2) 3) 4) 5) >> Type the name of your company and period: Company: ABC, Inc. Period:
Yes

2009/Q1
No

Type the number of SKUs? (this template can be used for a number of SKUs up to 100) Do you want to add Safety Stock Level control? > > > Enter the short warning to be displayed when net inventory is under Safety Stock Level: You may leave unused lines blank. You may leave unused lines blank.

On the right you can see a list of sample stock units. You can make the necessary changes on the list. Provide the necessary information on the "Data" sheet. Your Inventory Tracker is ready to use. Only the white cells are to be filled. Further steps are for online use. Note that "Current Qt" and "Final Qt" columns are dynamic. Each time a transaction is entered, the latest inventory positions are displayed. Dynamic inventory positions are calculated according to the transaction date.

6)

Visit the site below: https://www4.spreadsheetweb.com/SpreadsheetWEB// Login to page with your new account information.

7) 8)

Click "Add Web Application" to upload this file. Check the "Single Record Application" line. Your online file will be created automatically. You can simply use the file from that link or place it on your website. Your online Inventory Tracker will look like: http://www1.spreadsheetweb.com/SpreadSheetWEB/Output.aspx?ApplicationId=53867f96-6473-4182-a428-65a0f0cfa4e2 Sample data in the above application contains Inventory Ids from 1001 to 1010, you can try these values to see the results.

>>

In order to see more online applications created with PSW you can check the link below: http://www.spreadsheetweb.com/demos.htm

Copyright (c) 2009 Pagos, Inc., http://www.pagos.com/

20 1 Place order. Stock Units Units Meters Rolls Packs TRUE

s entered, the latest inventory positions

line. Your online file will be created automatically.

d=53867f96-6473-4182-a428-65a0f0cfa4e2

an try these values to see the results.


				
DOCUMENT INFO
Description: This template is prepared for entering inventory in and out transactions. Each line represents a transaction entry and evaluates the inventory position of the selected item taking all previous transactions into account. PSW version of the template provides save and single record application features. This means, the template can be used as a desktop Excel file online; i.e. it brings the latest information and saves the new entries.