Build an interactive, shareable, inventory control spreadsheet

Budget

$517.24FIXED

Client

Ca Ankit India

Status

AwardedDec 31, 2017
We want to have a simple to use spreadsheet for inventory control that can be used on ipad and android tablet - Google sheets, maybe?

We 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 Excel 

Project closed for bidding!



Share this project with your friends


Similar Projects

Pan Card Data Entry Aadhar Card Dat...

Hello,

I have 8000 Pan Card Scanned PDF Images.I need Candidates details in excel sheet with Photo and Signature.

Candidates Name :

father's Name :read more

Fixed, $1,680.00

Pan Card Data Entry Aadhar Card Dat...

Hello,

I have 8000 Pan Card Scanned PDF Images.I need Candidates details in excel sheet with Photo and Signature.

Candidates Name :

father's Name :read more

Fixed, $1,680.00

Development of underwriting Process...

We are looking for someone to help with the underwriting and due diligence process for a distressed asset Investment vehicle.

We buy Non Performing Residential Mortgages, and are now wo...read more

Hourly, $27.00

Hiring skip tracer *Must have acces...

Looking for experienced skip tracer for long term partnership. You must have your own access to LexisNexis or TLO!!

1. Ability to gather contact info (Phone number primarily) after give...read more

Fixed, $51.75

Googe Names and Find Information

We have the names and email address of 35168 people that are most likely in software field. We need a data collector to

1) google their name
2) find their mobile no
3) fi...read more

Fixed, $86.21

Need Help Building Spreadsheet of P...

Need help building up excel spreadsheet of specifications of PC products/components from a number of websites, manually inputting into google docs/excel spreadsheet. Prior knowledge of PC components/i...read more

Hourly, $13.06