Shrinkage formula?

[Wesleybrownlee91]

I know the formula that you enter if you to show retail shrinkage. Example: Col. A is how much of one product is supposed to be there. Col. B is how much is actually there. So Col. C would be C1=(A1-B1)/A1. The problem is I have paperwork that has to be filled out with each item that is removed from the shelf so I have to factor in if the paperwork is incorrect or if the paperwork was not done at all. How can I do this? Please and Thank you!!

 

[Oscar Cronquist]

What value do you expect if the paperwork is incorrect and if not done at all?

Can you provide some example values and the desired outcome?

 

[Wesleybrownlee91]

Ok I stock orthopedic products in hospitals. Whenever a product is used a prescription is to be filled with it. I have Product name in Col A, Product number in Col B, Manufactorer in Col C, Unit of Measure in Col D, How much is supposed to be there in Col E, How much is actually there in Col F, Correct Paperwork in Col G, Incorrect Paperwork in Col H, and Missing stock in Col I. Say I'm supposed to have 7 in Col E, have 3 in Col F, 2 in Col G, 1 in Col H, and 1 in Col I. Is there a formula that I can use to where I input this and total out Cols H and I at the end of a month or as I input they automatically total? Not sure if that was any help or not.

 

[Oscar Cronquist]

[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][th]

G​

[/th][th]

H​

[/th][th]

I​

[/th][th]

J​

[/th][th]

K​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]Product name[/td][td]Product Number[/td][td]Manufacturer[/td][td]Unit of measure[/td][td]Amount[/td][td]Correct amount[/td][td]Correct paperwork[/td][td]Incorrect paperwork[/td][td]Missing stock[/td][td][/td][td]Total incorrect paperwork[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td][/td][td][/td][td][/td][td][/td][td]

7​

[/td][td]

3​

[/td][td]

2​

[/td][td]

1​

[/td][td]

1​

[/td][td][/td][td]

1​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]Total missing stock[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

1​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet13[/td][/tr][/table]

I am not sure if this is what you are looking for.

Formula in cell K2:
=SUM(H1:H4000)

Formula in cell K5:
=SUM(I1:I4003)

You may have to adjust cell references if you have more rows in your worksheet.

 

[Wesleybrownlee91]

Ok Ill try that. Thanks for the help!!