Inventory Data Excel Spreadsheet with Pivot Tables

Job ID: 39280033

Budget: $30 – $250 USD

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.