CREATE AN EXCEL SHEET THAT CAN HELP US KEEP TRACK OF INVENTORY PROFIT
- or -
Post a project like this- Posted:
- Proposals: 20
- Remote
- #1997403
- Expired
Description
CURRENTLY THE INVENTORY INCLUDES:
names of products
quantity
cost of goods
cost of sales
profit
etc
But the excel sheet is a little complicated and right now when theres a sale, we have to manually add up the expenses and the items sold doesnt deduct from the inventory etc. Its all very messy so we are looking for someone who would look at the excel sheet, understand what we are trying to do and create a system that is both intuitive and insightful.
Please note that there are lots of things required that I may not have included in this post but upon looking at our database, you will be able to see what we are trying to keep record of.
George L.
97% (56)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
james, can you please attach your doc here , so that I get an idea of what you are trying to do and suggest a better solution
George L.08 May 2018https://docs.google.com/spreadsheets/d/1driFdJwDiyo2-Ey-DbQOP7P6ZpBX5PmnD8ZWkTUmaHQ/edit?usp=sharing
Nara G.09 May 2018Thanks James .I undestand what do need .I have attached my proposal for your review
-
James, for a full system that could automatically update the inventory, you might need to consider raising your budget by far, and also maybe even to have the system as macro-enabled (and better on a server as a shared file and outside Google Sheets). That's my personal opinion. If interested in that, let me know.
-
James,
What is the data entry mechanism?
Is it through a Google form?George L.08 May 2018https://docs.google.com/spreadsheets/d/1driFdJwDiyo2-Ey-DbQOP7P6ZpBX5PmnD8ZWkTUmaHQ/edit?usp=sharing
-
James, can you kindly share the doc please..
George L.08 May 2018https://docs.google.com/spreadsheets/d/1driFdJwDiyo2-Ey-DbQOP7P6ZpBX5PmnD8ZWkTUmaHQ/edit?usp=sharing
-
Hi James,
You say you already have a spreadsheet, is the job to create a new spreadsheet or create a replacement system to the spreadsheet using something else?George L.08 May 2018https://docs.google.com/spreadsheets/d/1driFdJwDiyo2-Ey-DbQOP7P6ZpBX5PmnD8ZWkTUmaHQ/edit?usp=sharing
-
Hi James, is it possible to have a quick look at the google doc to see exactly what needs doing? Thanks
George L.08 May 2018https://docs.google.com/spreadsheets/d/1driFdJwDiyo2-Ey-DbQOP7P6ZpBX5PmnD8ZWkTUmaHQ/edit?usp=sharing