Excel & Inventory

[eman]

Hi,

I want to use Excel as inventory software! Is there any templates that I can
download or any suggestions from where I can begin?

Thanks in advance

 

[Gord Dibben]

Go to the Office Template Gallery and type "inventory" in the search dialog.

http://officeupdate.microsoft.com/templategallery/default.asp


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Attached files are frowned upon in these news groups and most likely won't get
any takers for opening.

Secondly, I am not running Excel 2007 and don't feel inclined to download a
compatibility pack to open your workbook in 2003.

From your description it looks like you need a few formulas.

Where is the unit price located that would be multiplied by 2 in H4 to return
$20?

Where does the QTY(stock) in C4 come from? Manually entered or derived from a
formula?

Why should B4 change to $100 when you enter a 2 in G4?


Gord

 

[eman]

Unit price is located in D4.

QTY(stock) in C4 is manually entered

In B4 I have cost of all 4 items that is 200 SO when 2 are sold then the qty
turns to 2 and cost turns to 100.

This is exactly what I have:

B4 (COST OF 4 ITEMS) $200
C4 (QTY) 4
D4 (COST OF 1 ITEM) $50
E4 (RETAIL PRICE OF 1 ITEM) $60
F4 (PPROFIT OF 1 ITEM) $10
G4 (QTY OF ITEMS SOLD) 0
H4 (TOTAL PROFIT) 0

What I am looking for is: that when I write 1 in G4 (meaning 1 item is sold)
then B4 turns to $150, C4 turns to 3,
and H4 turns to $10.

 

[David Biddulph]

You can't (with a simple formula) achieve what you've asked for. You are
trying to use C4 as a cell in which to insert the initial quantity, but then
use the same cell to display the quantity remaining. A cell can contain a
number or a formula, but not both. You'd be better putting your initial
quantity in one column, and calculating the number remaining in another
column. Then the job would be easy.