i own a factory and i have a big storage area other than the warehouse to store raw materials. so i would like to find a way to create a database that could calculate how many pallets i could store in one area given the max capacity and total consumption of my factory
for example i have a pallet of Raw Material X (800 KG) and i have an area that stores up to 80 pallets of RM X. physically i can check it, but i want a dashboard whenever i place my data i will directly get the number of empty space, the quantity of raw materials and finally whether they are important or not.
based on this data i could either expedite some orders according to inventory availability, or decrease the orders.
P.S data are private and can’t be shared, so this would prove to be a headache.
[Removed by Freelancer.com Admin]
Skills: Excel, Microsoft Access, Data Processing, Data Entry
use zen cart build store csv file, attached word file excel, convert dat database file excel, attched word file excel, converting dat file excel, excel cost inventory, excel vba inventory projects, macro convert dat file excel file, create xml file excel vba, convert dat file excel free, convert quickbooks file excel, inventory file excel, upload amazon inventory file excel, automatically build graph text file excel, excel file video game inventory, want convert sql bak file excel, build dashboard excel social media analytics
Jeddah, Saudi Arabia
Project ID: #26754207