Build an interactive, shareable, inventory control spreadsheet
Budget
$517.24FIXEDClient
Ca Ankit IndiaStatus
AwardedDec 31, 2017We have around 60 products, which each have from one to six sizes. We purchase the raw product from numerous vendors, and sell within 24 hours. The inventory totals must be updated frequently during the workday. We will have 5,000 to 10,000 items on hand, available for sales to only 2 customers - not to general public.
We need a spreadsheet so that workers can keep track of current inventory, purchase orders pending receipt from vendors, orders from customers pending to fill and ship, and excess stock.
We have started keeping track using a spreadsheet, but this requires physical counts. We use Quickbooks for accounting, but inventory adjustments must be done in the office, not on the work floor, and require exporting to a spreadsheet, and must be formatted to be useful.
Spreadsheet needs to show: 1) pending orders, 2) pending receipts from vendors (purchase orders), 3) stock on hand.
Spreadsheet must be shareable and usable on ipad, android tablet, and windows 10 pc.
Every user must be able to: 1) add inventory, 2) delete inventory (unusable), 3) move inventory from one size to another size.
We use Microsoft Excel.
Skills & Expertise Required
Google Spreadsheets ExcelProject closed for bidding!
Share this project with your friends
Other jobs by this client
Electrical Engineer/Designer Needed for Commercial/Industrial Projects - FixedReal-time Web Scraping for a list of Large News Website (need scalability) - Fixed
Transalation - Fixed
Need help gathering URLs for a list of 700 companies - Hourly
Real-time Web Scraping for a list of Large News Website (need scalability) - Fixed
Transalation - Fixed
Looking for T-Shirt Graphic Designer - Fixed
Similar Projects
Convert MS Word and PDF to PAGES
I have 1600 of MS word and PDF files that I want to convert in .pages. I need a specific formatting and to remove a few picture from them, but it's basically a lot of copy and paste.
Internet Research: Data Entry / Exc...
I am looking for someone with great research skills, who is focused and has experience building lists.I have PDF files for each details. I am looking to build a list of all the independent and chai...read more
TLO/ LEXISNEXUS --SKIP TRACING
Looking for VA proficient in background checks with using TLO / NEXUS LEXUS/ Various other checking services. I have TLO but it is a GREAT bonus to have access to NEXUS LEXUS or any other comprehensi...read more
Google worksheet contract system co...
I have all definition to this project. In a nuthsell we need a system to control contract execution , add products, calculate margin , reports
TLO/ LEXISNEXUS --SKIP TRACING
Looking for VA proficient in background checks with using TLO / NEXUS LEXUS/ Various other checking services. I have TLO but it is a GREAT bonus to have access to NEXUS LEXUS or any other comprehensi...read more
Here are our top professional picks for you to hire
