Navigation
Search
|
How Do I Solve This Inventory Issue In Numbers?
Sunday May 2, 2021. 01:58 AM , from MacMost
I just finished your Numbers course and it was great! Unfortunately, I don’t think what I’m looking for was included(probably wrong on that one). Also, i am still trying to understand the language and logic of the formulas, so that’s why I’m asking for a bit of assistance.
I hope its not too convoluted! I am trying to make a monthly inventory spreadsheet for my brewery. The front facing table (orders) will have separate pull down columns for client, beer and package (1/2 keg, 1/6 keg, case and 4 pack), with a column at the end for actual amount ordered of that particular beer and package. So an example would be: Client Beer Package Amount Brett Pilsner 1/2 keg 2 I have another table with the actual inventory. Our Beers in the header column and 3 columns for for each package (i.e. 1/2 keg Begin (for begin of month), 1/2 Keg Add (for any beer made that month) and 1/2 keg current (which would be the subtracted total of all orders pertaining to that beer and package size): BEER 1/2 Keg Begin 1/2 Keg Add 1/2 Keg Current Pilsner 10 10? That’s where my problem starts. From the Orders table, I would like the add all the order amounts of a particular beer and package size, to be added together then subtracted from the sum of the 1/2 keg begin and 1/2 keg Add. I realize this is a bit insane and understand if you cant make heads or tails of it. I tried to include screen shots here, but no go. —– Brett Blau
https://macmost.com/forum-how-do-i-solve-this-inventory-issue-in-numbers.html
|
46 sources
Current Date
Apr, Fri 26 - 16:20 CEST
|