Log In
Register
Home
New Member
July 15, 2020
Offline
Good evening,
Trust you are well.
I am look for some assistance with a formula which I can use to return the value of stock available to sell on the given day that I am using the system.
I manufacture cement products, these take between 7 and 10 days to cure. Once cured only then is the product ready to sell.
I have made a "manufactured sheet", "caps", "columns" and "sales" sheets.
On the manufactured sheet I record the units made, based on this "caps" and "columns" sheets will return the quantity made and the date the stock will be ready to be sold.
Caps and columns sheets numbers will constantly update based on what is manufactured.
I need to be able to record my sale of the units while keeping a true value of what stock is available to sell based on the date that it ready to sell.
If there is a post I missed please share the link or alternatively recommend a course on mytraininghub.com which would cover this situation.
Thank you in advance,
Kind regards,
Craig
VIP
Trusted Members
December 7, 2016
Offline
Hello Craig,
In attached file you will see an example of, in my view, a better approach to handle the data. This is just an example aimed to show how easier it is to get the information you need and different ways to get it. I have gathered it all in one sheet, so it looks a bit messy.
The main source of data is the table in columns A to E, called Table1. In this table I have structered the manufacturing and sales data in a tabular data format, which makes it very easy to get whatever data I want from it using formulas or Pivot Table. All you need to do is to continue feed the table with new data. The Pivot Table needs then to be updated, right click any cell in the Pivot Table and Refresh.
Take a look and try it out. I do think you will see the benifits of this approach.
Regarding a suitable course, I think the Excel Experts would be a good starting point.
Br,
Anders
1 Guest(s)
