Inventory Data Excel Spreadsheet with Pivot Tables
Budget: ₹750 – ₹1,250 INR
I'm looking for a freelancer who can create a detailed Excel spreadsheet for my inventory and production data for a screen printing/embroidery business. The sheet should have data of item number, description, count, cost per item, total cost, Then I need to take the item cost add markup to get price, then production area to add price then job (screen), then have sale price. The pivot table will combine then to get a good picture of the inventory. The spreadsheet should include pivot tables that provide specific views on:
- Current stock levels
- Sales and restocks
- Inventory cost and profit margin
- How long in stock
Furthermore, the pivot tables should also assist in calculating or analyzing:
- Cost
- Profit margin
- Restock frequency
Ideal skills and experience for this job include advanced proficiency in Excel, particularly in creating and manipulating pivot tables. Experience with inventory data is a plus. Essentially, I'm looking for someone who can help me better understand my inventory data through this spreadsheet.
- Current stock levels
- Sales and restocks
- Inventory cost and profit margin
- How long in stock
Furthermore, the pivot tables should also assist in calculating or analyzing:
- Cost
- Profit margin
- Restock frequency
Ideal skills and experience for this job include advanced proficiency in Excel, particularly in creating and manipulating pivot tables. Experience with inventory data is a plus. Essentially, I'm looking for someone who can help me better understand my inventory data through this spreadsheet.